Requests an Apply Engine to produce a snapshot report of current source and target record statistics. This command provides an alternative to the sqdmon DISPLAY command for Engines not running under an Engine Controller SQDaemon as well as similar functionality on zOS where Engines cannot run under a Controller SQDaemon.
Syntax
sqdcopyq QREPORT <engine_name>@SHM
Keyword and Parameter Descriptions
| Keyword | Description |
|---|---|
| <engine_name>@SHM | The "name" assigned to an Apply Engine by the JOBNAME statement in the Apply Engine script. This name appears in both the Parser report and the Engine runtime report. The JOBNAME command normally specifies the same value as the "Subscriber name" passed by the Apply Engine when requesting connection to a Capture/Publisher. A Substitution parameter such as %(ENGINE) is typically used to supply the value when the script is parsed and that value is typically used by both the JOBNAME and the cdc:// connection URL: |
Note:
- Connect CDC SQData originally provided certain functionality using IBM MQ that has been deprecated. At this time backwards compatibility however requires execution of SQDCOPYQ, an alias of SQDUTIL to be executed.
- Uses a shared memory area and therefore must be run on same system where the Engine is running. SQDMON should be used when a local SQDaemon task is used to manage Engines on the system.
- QREPORT must be capitalized.
Example 1
Display a snapshot of an Apply Engine named IMSTODB2 on zOS.
//SQDCOPYQ EXEC PGM=SQDCOPYQ
//SQDPUBL DD DSN=&SYSUID.NACL.PUBLIC,DISP=SHR
//SQDPKEY DD DSN=&SYSUID.NACL.PRIVATE,DISP=SHR
//SYSPRINT DD SYSOUT=*
//SYSOUT DD SYSOUT=*
//SQDPARMS DD *
QREPORT IMSTODB2@SHM
/*
//Example 2
Display a snapshot of an Apply Engine named DB2TOKAF on Linux
sqdcopyq
QREPORT DB2TOKAF@SHM