DB2 Version 9.7 for Linux, UNIX, and Windows

Replication tools

The replication tools consist of the ASNCLP command-line program, the Replication Center, and the Replication Alert Monitor tool.

ASNCLP command-line program

You can use the ASNCLP program to administer SQL replication, Q replication, Classic replication, relational event publishing, and the Replication Alert Monitor .

You can use the ASNCLP commands to create, modify, and remove information in control tables of the replication programs. You can also use the ASNCLP commands to generate SQL scripts to create, modify, and remove information about replication sources, targets, queues, and other options in control tables.

Replication Center

You can use the Replication Center to set up and administerg the replication components for Q replication and SQL replication. The Replication Center is only supported in Linux and Windows operating systems.

Use the Replication Center to perform the following tasks:
  • Define registrations, subscriptions, publications, queue maps, alert conditions, and other objects
  • Start, stop, suspend, resume, and reinitialize the replication programs
  • Specify the timing of automated copying
  • Specify SQL enhancements to the data
  • Define relationships between the source and the target tables
The following wizards and launchpads are available from the Replication Center:
  • Replication Center launchpad
  • Add Capture Control Server wizard
  • Add Apply Control Server wizard
  • Add Monitor Control Server wizard
  • Add Q Capture Server wizard
  • Add Q Apply Server wizard
  • Add Server Information wizard
  • Create Monitor wizard
  • Create Q Capture Control Tables wizard
  • Create Q Apply Control Tables wizard
  • Create Q Subscriptions wizard
  • Create Publications wizard

The Replication Center is installed by default as part of the replication tools component in typical or custom installations. The compact installation no longer installs the replication tools component, which includes the Replication Center.

Replication Alert Monitor

The Replication Alert Monitor is a utility that checks the health of the Q Capture, Q Apply, Capture, and Apply programs. It checks for situations in which a program terminates, issues a warning or error message, reaches a threshold for a specified value, or performs a certain action, and then issues notifications to an email server, pager, or the z/OS® console.