Informix Dynamic Server 11.5 Replication IX421CZ

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.

Kurz je určen pro:

This is an advanced course designed for Informix Dynamic Server Administrators.

Předpokládané znalosti:

You should have:

• IBM Informix Dynamic Server Systems Administration
• or equivalent experience

Co se u nás naučíte:

• 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

Obsah:

• 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