IBM Books

DB2 Replication Guide and Reference


Capture Program Problem Determination Facilities

The Capture program has a trace table, a log file, and trace file generated when the trace invocation parameter is used to start the Capture program.

Capture Program Trace Control Table (ASN.IBMSNAP_TRACE)

The trace control table is located in source server databases where the Capture program maintains change tables for replication sources. The trace control table, ASN.IBMSNAP_TRACE, contains basic information about the activities of the Capture program instance. For a description of the ASN.IBMSNAP_TRACE table, see Chapter 19. Table Structures.

You can query the ASN.IBMSNAP_TRACE table with normal SQL (such as SELECT) or query tools. For example:

SELECT * FROM ASN.IBMSNAP_TRACE 

Capture Program Trace File

The Capture program can be started with the trace invocation parameter. This parameter specifies that problem determination records be recorded in standard output to the screen or to a file, which contains the Capture program internal logic flows. When starting the Capture program, on workstation systems, precede the output file name with a pipe symbol (>).

To start the Capture program with trace on a workstation system:

\CAPTURE>asnccp mysrcdb x x trace > cap.trc

Where:

mysrcdb
is the source server database for this Capture program instance.

x x
indicates that no parameters are provided for the type of start (WARM, WARMNS, COLD) and pruning (PRUNE or NOPRUNE) so the defaults are assumed.

trace
indicates that the Capture program traces all error and flow information.

cap.trc
is the file to which the output is directed.

The trace file is located in the same directory from which the Capture program is started.

Capture Program Log

The Capture program creates a log file, named by the source database that is specified when the Capture program is started; the file extension is *.CCP. If the Capture program is started with asnccp mysrcdb, the log file is named mysrcdb.ccp. The Capture Program log file is located in the same directory from which the Capture program is started.


[ Top of Page | Previous Page | Next Page | Table of Contents | Index ]

[ DB2 List of Books | Search the DB2 Books ]