Db2/z log capture - connect_cdc_sqdata

Precisely recommends using either Started Tasks or the z/OS Master Controller for large numbers of Apply Engines.

Example

Execute the Daemon and Db2 Log Capture Agent and one Apply Engine under the Master Controller.

Note: The Daemon and DB2 Capture Agent run as started tasks in separate address spaces, while the Apply Engine runs as a subtask under the Master.

MASTIMSB Parmlib member included in the distribution

-------------------------------------------------------------      
-- Sample Parm for Running Daemon and Db2 Log Capture
-------------------------------------------------------------      
QMGR=N/A                                                          
CMDQUE=DUMMY                                                      
TASKDD=SQDFILE                                                    
WTOR=N                                                            
WTORMSG=SQDATA DB2 CAPTURE                                        
FAILJOB=N                                                          
FAILMAX=1                                                          
----------------------
-- Listener Daemon
----------------------
NAME=SQDAEMON                -- NAME OF PROCLIB MEMBER            
PGM=SQDAEMON                 -- NAME OF PGM TO EXECUTE            
AUTOSTART=Y                  -- AUTO START WHEN MASTER STARTS (Y/N)
NEWADDRSP=Y                  -- EXECUTE IN SEPARATE ADDR SPACE (Y)
SCRIPT=                      -- SET TO SPACES                      
QUEUE=host_name -s port_number                                    
----------------------                                            
-- Db2 Log Capture                                                
----------------------                                            
NAME=DB2CDCT                 -- NAME OF PROCLIB MEMBER            
PGM=SQDDB2C                  -- NAME OF PGM TO EXECUTE            
AUTOSTART=Y                  -- AUTO START WHEN MASTER STARTS (Y/N)
NEWADDRSP=Y                  -- EXECUTE IN SEPARATE ADDR SPACE (Y)
SCRIPT=                      -- SET TO SPACES                      
QUEUE=/home/sqdata/db2cdc.cab

Note: The program name of the DB2 Capture Agent is SQDDB2C, and the name of the PROC for the associated started task is DB2CDCT.

Master Controller JCL SQDAMAST sample included in the distribution

//*--------------------------------------------------------------------
//*   Sample JCL to Run the SQData Master Controller SQDAMAST          
//*                                                                    
//*   Add additional DD statements or Libraries as required            
//*--------------------------------------------------------------------
//*********************************************************************
//*                                                                    
//JOBLIB  DD DISP=SHR,DSN=SQDATA.V400.LOADLIB                          
//        DD DISP=SHR,DSN=DB2.SDSNLOAD                                
//*                                                                    
//*
//SQDATA  EXEC PGM=SQDAMAST
//SQDPARM  DD DISP=SHR,DSN=SQDATA.V400.PARMLIB(MASTERD)
//SYSPRINT DD SYSOUT=*
//DB2CDC1  DD SYSOUT=*
//ENGINE1  DD SYSOUT=*
//*
//FAILJCLI DD DISP=SHR,DSN=SQDATA.V400.CNTL
//FAILJCLO DD SYSOUT=(H,INTRDR)                    
//*
//**** PARM WORK FILE - REQUIRED IF UPSTATE=Y
//SQDPWRK  DD DISP=SHR,DSN=SQDATA.V400.PARMLIB(PARMWORK)

Db2/z log capture - connect_cdc_sqdata - Latest

Connect CDC (SQData) Utilities