Previous Topic: Estimating Virtual Storage RequirementsNext Topic: Using the CADB2SY0 Reports


Using the Catalog Synchronization Utility Reports

The synchronization utility produces several reports that help you track and fix errors as you run the utility. Two types of reports are available. Each CADB2SYx component, when executed, produces standard reports by default. In addition, the CADB2SY2 component produces trace reports that are generated only when TRACE is specified as an option in the OPTIONS keyword. Listed below are the reports that the synchronization utility generates. The following sections describe these reports in detail.

The CADB2SY0 component produces these standard reports:

CADB2S0A

The input data preprocessor report

CADB2IV0

The input control statement report

CADB2SY0

The input data preprocessor report.

The CADB2SY1 component produces these standard reports:

CADB2S0A

The input data preprocessor report

CADB2IV1

The input control statement report

CADB2SY1

The incremental function report.

The CADB2SY2 component produces the following reports. The standard reports are generated by default, the trace reports are generated when TRACE is specified in the OPTIONS keyword. The trace reports consist of diagnostic information used for debugging purposes. The reports are generated and printed in the following order:

CADB2SSV

The synchronization control statement report (standard report)

CADB2SEU

The userid exception report (standard report)

CADB2SGP

The input GRANT TO PUBLIC report (standard report)

CADB2SCP

The extract exception report (trace report)

CADB2SCP

The userid extract report (trace report)

CADB2SCP

The resource extract report (trace report)

CADB2SED

The DB2 resource status report (trace report)

CADB2SUA

The security validation report (trace report)

CADB2SGS

The DB2 SQL generated statement report(standard report).

The CADB2SSV, CADB2SEU, and CADB2SGP reports are produced once for each job. CADB2SCP, CADB2SED, CADB2SUA, and CADB2SGS reports are produced once for each batch.

The CADB2SY3 component produces this standard report:

CADB2SES

The DB2 SQL statement report.

These reports are written to the ddname SYSOUT.