IBM - Informix Dynamic Server 11 Replication

KURSZIEL
IBM - Informix Dynamic Server 11 Replication: This is an advanced course for Informix Dynamic server administrators._x000D_

_x000D_

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.

ZIELGRUPPE
This is an advanced course for Informix Dynamic server administrators._x000D_

_x000D_

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.

KURSINHALT
Kursziele

• 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

Themenübersicht
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

Hinweise
Course material will be in English.


VORRAUSSETZUNG
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.