DB2 Replication Guide and Reference

Troubleshooting: Problems Using the Capture Program

This section describes commonly known issues with the Capture for VSE program. Before running the Capture program, ensure that you have applied all PTFs for your level of DB2.

Problem

Capture for VSE does not start.

Ensure that:

• Access has been given for the database log and directory minidisks by specifying the DLBLs in the Capture program startup JCL.

• Access has been given to the C Run Time Library.

• The ASNLMAIN package file has been loaded to the database.

Problem

The Capture program is not capturing updates.

Any of the following could prevent the Capture for VSE program from capturing updates:

• DATA CAPTURE CHANGES was not specified on the base tables to be captured.

• The proper order for starting the Capture and Apply programs was not used:

  1. Define replication sources and subscriptions before starting the Capture program.

  2. Start the Capture program and look for message number ASN0100I (initialization completed) on the virtual machine console or in the ASN.IBMSNAP_TRACE table.

  3. Start the Apply program.

Check the ASN.IBMSNAP_TRACE table for possible error messages.

Problem

I'm not sure if the Capture program is running successfully.

The first time you start the Capture and Apply programs, the Apply program performs a full refresh to populate the target tables. Then the Capture program writes message ASN0104I to the ASN.IBMSNAP_TRACE table, providing information related to table owner name, table name, and starting log sequence number value. This provides a point from which the Capture program starts to capture updates.

Updates captured from then on are placed in CD tables. They are eventually applied to target tables and pruned from the CD tables. After the Capture program runs for some time, you should see rows in the CD tables if changes are made to the sources. Periodically, check the ASN.IBMSNAP_TRACE table to see the progress made by the Capture program. If it encounters errors, it sends them to the console and also logs them in the trace table. Similarly, the Apply program logs its information in the ASN.IBMSNAP_TRAIL table.

Problem

Capture for VSE issued message ASN0000E instead of the proper message number.

Capture for VSE issued a generic message instead of a proper message. This happens if the specified VSAM message file in the Capture startup JCL was not found. See the Capture for VSE program directory for information on installing the VSAM message file.

Problem

Capture for VSE terminates.

The Capture for VSE program terminates either because of a severe error, or when you issue the STOP command. The Capture program terminates with a return code that indicates successful or unsuccessful completion. Return codes are:

0

STOP command issued

8

Error during initialization

12

Any other severe error

See Capture Program Messages for an explanation of this message.

[ DB2 List of Books | Search the DB2 Books ]