Skip to main content

Course description: Informix Dynamic Server 11 Replication

This course is not scheduled. Inquire about Onsite training at your facility.

Overview

List of course details in a data table
Course code IX421 Skill level Advanced
Duration 4.0 days Delivery type Classroom
(Hands-on labs)
Course type Public or Private on-site    
Public price USD $2,600.00 plus tax  

This is the classroom version of Instructor Led Online (ILO) course 3X421

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. 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 course replaces Informix Dynamic Server Replication (IX420).

View this course in other countries

Back to top

Special note

IBM Education Advantage Program Eligibility:

  • Yes - IBM Education Pack - online account

Back to top

Audience

This is an advanced course for Informix Dynamic server administrators.

Back to top

Prerequisites

In order to attend this course, you must have the following skills or completed the following courses:

  • IBM Informix Dynamic Server Systems Administration (IX810)

or equivalent experience.

Back to top

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
  • Set up your database server as an Entity Resolution (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
  • Set up a Remote Standalone Secondary server
  • Configure a Shared Disk Secondary server

Back to top

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 and Row Information Spooling (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

Back to top

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.

Student center

Find the right course

Offers and more