Determining Your Replication Goals
- Identify the five primary uses of replication
- Differentiate between primary-target and update-anywhere replication
- Differentiate between synchronous and asynchronous data transfer
- Outline your personal replication goals
Selecting a Tool for Replication
- Select the Informix replication tool that achieves your replication goals
- Select an Informix replication tool that suits your technical environment
Enterprise Replication Data Flow
- Describe Enterprise Replication data flow
- Describe the purpose of various Enterprise Replication components
- List Enterprise Replication fault tolerance features
Enterprise Replication Configuration Parameters
- Identify the Enterprise Replication configuration parameters
- Modify Enterprise Replication configuration parameters
- Understand the impact of configuration parameter modification
Preparing for Fully Connected Replication
- Identify an Enterprise Replication server
- Describe a fully connected Enterprise Replication network topology
- Modify connectivity files for a fully connected Enterprise Replication network topology
- Configure a trusted environment between Enterprise Replication host machines
Configuring an Enterprise Replication Server
- Configure an Informix database server for Enterprise Replication
- Declare an Informix database server as a Enterprise Replication server
Defining Replicates
Define a replicate
- Provide the participant definition
- Configure ATS and RIS error spooling, canonical message format, and idle time-out
- Select the conflict resolution rule
- Select the conflict resolution scope
- Set the replication frequency
View and interpret replicate information
Administering Replicates
View a replicate definition
Determine the state of a replicate
Change the state of a replicate
Modify the replicate definition
Modify replicate participants:
- Add and remove participants
- Modify a participant from primary to target
- Modify a participant from target to primary
Delete a replicate
Replicate Sets
- Identify the advantages of replicate sets
- Create replicate sets
- View replicate set properties
- Change the replicate set state
- Delete a replicate set
- Modify a replicate set
Replicate Templates
Explain the purpose of templates
Work with templates:
View template information
Diagnosing Replicate Errors
- Analyze ATS error spooling files
- Analyze RIS error spooling files
Administering the Replication Server
- View Enterprise Replication server properties
- Suspend and resume replication for an Enterprise Replication server
- Start and stop replication for an Enterprise Replication server
- Disconnect from and connect to an Enterprise Replication server
- Remove a database server from Enterprise Replication
Working With Replicates and Servers
- Manually synchronize servers
- Initially synchronize servers
- Resynchronize servers
- Create and run repair jobs
- Perform alter operations
Database Design Issues
Correct database design issues that can negatively impact replication:
- Serial keys
- Cascading deletes
- Triggers
- Accumulators
Describe issues with distributed transactions
Provide a timestamp table for troubleshooting
Determine how to execute large transactions
Monitoring Enterprise Replication
- Monitor Enterprise Replication for your database server
High Availability Data Replication
- Configure two database servers for data replication
- Access the primary and secondary server from a client application
- Recover the primary and secondary database servers in case of a failure
Introduction to Continuous Availability
- Explain the features of continuous availability
- Describe the supporting components of continuous availability
- Explain why index page logging must be enabled to support continuous availability
Remote Standalone Secondary Server Replication
- Describe the features of replicating using a Remote Standalone Secondary (RSS) server
- Perform the steps to set up replication using an RSS server
- Describe the different options available for RSS failover
Shared Disk Secondary Server Replication
- Describe the features of replicating using a Shared Disk Secondary (SDS) server
- Set up temporary space on an SDS server
- Set up an SDS node
- Describe the different options available for SDS failover
Agenda
Day 1
- Welcome
- Unit 1: Determining Your Replication Goals
- Exercise 1
- Unit 2: Selecting a Tool for Replication
- Exercise 2
- Unit 3: Enterprise Replication Data Flow
- Unit 4: Enterprise Replication Configuration Parameters
- Unit 5: Preparing for Fully Connected Replication
- Unit 6: Configuring an Enterprise Replication Server
- Exercise 3
Day 2
- Unit 7: Defining Replicates
- Exercise 4 li>
- Unit 8: Administering Replicates
- Exercise 5
- Unit 9: Replicate Sets
- Exercise 6
- Unit 10: Replicate Templates
- Exercise 7
- Unit 11: Diagnosing Replicate Errors
- Exercise 8
- Unit 12: Administering the Replicate Server
- Exercise 9
Day 3
- Unit 13: Working with Replicates and Servers
- Exercise 10
- Unit 14: Database Design Issues
- Exercise 11
- Unit 15: Monitoring Enterprise Replication
- Unit 16: High Availability Data Replication
- Exercise 12
Day 4
- Unit 17: Introduction to Continuous Availability
- Unit 18: Remote Standalone Secondary (RSS) Replication
- Exercise 13
- Unit 19: Shared Disk Secondary (SDS) Server Replication
- Exercise 14
