This course is not scheduled. Inquire about Onsite training at your facility.
Overview
| Course code | 3X421 | Skill level | Advanced |
|---|---|---|---|
| Duration | 4.0 days | Delivery type | Instructor Led - Online Training
(Hands-on labs) |
| Course type | Public or Private on-site | ||
| Public price | USD $2,600.00 plus tax | ||
This is an online course. Please do not make travel arrangements for this course. After you receive confirmation that you are enrolled, you will be sent further instructions to access audio, video and remote labs.
In this course, you will learn the process of generating multiple copies of data at one or more sites through the planning, implementing, and administering of IBM Informix Dynamic Server Enterprise Replication. You will also learn how to configure remote server that can be used for hot-site backup using High Availability Data Replication (HDR) and by configuring Remote Standalone Secondary and Shared Disk Secondary servers. This is the Instructor Led Online (ILO) version of classroom course IX421.
Prerequisites
In order to attend this course, you must have the following skills or completed the following courses:
- IBM Informix Dynamic Server Systems Administration
- or equivalent experience
Skills taught
After completing this course, you should be able to:
- Define replication goals and plan a replication system
- Select a replication method and tool
- Configure different replication topologies
- Configure your database server as an ER server
- Create and administer replicates
- Create and administer replicate sets and templates
- Diagnose replication errors
- Administer an Enterprise Replication server
- Alter database and table structures for replication
- Monitor Enterprise Replication
- Configure the server to pair with an HDR secondary server
- Configure a Remote Standalone Secondary server
- Configure a Shared Disk Secondary server
Course outline
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:
- Define
- Realize
- Change
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
- 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
Remarks
For this Instructor Led On Line course your system should have a microphone and speakers for interfacing with the instructor and other students. After you receive confirmation that you are enrolled, you will be sent further instructions to access audio, video and remote labs. All Instructor Led On Line US courses start at 9:00 am Central time. Materials are not guaranteed to be delivered to you, if registration is received three business days before class start date.
My IBM
We're here to help
Easy ways to get the answers you need.
or call us at
Call 1-800-426-8322
Open M-F 9AM-7PM ET.
