Connect CDC SQData

The REPORT command specifies the name of the file where the Apply Engine Engine Runtime Report and statistics are written. It optionally specifies the interval (record count) used to determine the report frequency.

If the REPORT command is not specified then the following defaults are used, depending on the operating system in which the Engine is executing:

•For Multiplatform, the Runtime Report/statistics will be displayed on the screen/terminal or the report can be redirected to a file (i.e. > runtime.rpt).

•On the z/OS platform, the Runtime Report/statistics will be written to the SYSPRINT DD statement.

Syntax

REPORT [<report_file>] [EVERY <interval>];

 

Keyword and Parameter Descriptions

[<report file>]  Optional name of the file designated to contain the report output. In the z/OS environment, DD:ddname must be specified, where ddname is the name of the DD statement that references the report file.

[EVERY <interval>]  Optional interval count that when specified, will display message SQD0028I along with the number of records processed at each interval threshold.

Example 1:  Multiplatform

Specify that the Engine Runtime Report is to be written to the file IMSTODB2.rpt and that the number of records processed message (SQD0028I) is to be written to the report output for every 10,000 source records processed.

REPORT /home/sqdata/IMSTODB2.rpt EVERY 10000;

 

 

Example 2:  z/OS Platform

Specify that the Engine Runtime Report is to be written to the file identified by DD name SQDRPT.

REPORT DD:SQDRPT;

 

Note, Apply Engines running under an Engine Controller SQDaemon can be instructed to output a snapshot of total source and target records processed using the SQDmon Utility. Apply Engines running on zOS as well as Apply Engines running on other platforms with or without an Engine Controller SQDaemon can also be requested to produce the same snapshot report using a special SQDUTIL option, QREPORT. See the SQDMON Display and SQDUTIL QREPORT utility references.