Connect CDC SQData

Requests an Apply Engine to Terminate and produce a report of final source and target record statistics. These commands provide an alternative to the sqdmon STOP 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 QTERM | QTERMI <engine_name>@SHM

 

Parameter

QTERM | QTERMI - the QTERM command instructs the Engine to complete the current unit-of-work (UOW) before stopping while QTERMI specifies immediate termination which will result in the last UOW being reprocessed upon restart.

<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:

JOBNAME %(ENGINE)

cdc://[<host_name_or_address>[:<port_number>]]/<agent_name>/%(ENGINE)

Notes:

1.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.

2.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.

3.QTERM | QTERMI must be capitalized.

 

Example 1

Request an Apply Engine named IMSTODB2 on zOS to Stop immediately before completing the current UOW.

//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 *                                                      

QTERMI IMSTODB2@SHM

/*

//

 

Example 2

Request an Apply Engine named DB2TOKAF on linux to Stop after completing the current UOW.

sqdcopyq QTERM DB2TOKAF@SHM