Display capture agent status - connect_cdc_sqdata - Latest

Capture agents keep track of statistical information for the last session and for the lifetime of the configuration file. These statistics can be accessed with the display action of SQDCONF.

//*----------------------------------------
//*- DISPLAY CONFIG FILE
//*----------------------------------------
//DISPLAY EXEC PGM=SQDCONF
//SYSPRINT DD SYSOUT=*
//SYSOUT DD SYSOUT=*
//SQDPARMS DD *
 display /home/sqdata/db2cdc/db2cdc.cab 
//*
SQDF901I Configuration file : /home/sqdata/db2cdc/db2cdc.cab
SQDF902I Status : MOUNTED,STARTED
SQDF903I Configuration key : cab_9A4A9EB10ECCB679
SQDF904I Allocated entries : 31
SQDF905I Used entries : 3
SQDF906I Active Database : DB9G
SQDF907I Start Log Point : 0x0
SQDF908I Last Log Point : 0x1aff2621f
SQDF940I Last Log Timestamp :
SQDF987I Last Commit Time : 2013-01-07 21:03:12.617536 (1eb45bf000000000)
SQDF981I Safe Restart Point : 0x1aff2569b
SQDF986I Safe Remine Point : 0x1aff1d000
SQDF910I Active User :
SQDF913I Fix Flags : RETRY
SQDF914I Retry Interval : 30
SQDF919I Active Flags : CDCSTORE,RAW LOG
SQDF915I Active store name : /home/sqdata/db2cdc/db2cdc_store.cab
SQDF916I Active store id : cab_964960E67A564AA3
SQDF920I Entry : # 0
SQDF930I Key : SQDATA.DEPT
SQDF923I Active Flags : ACTIVE
SQDF928I Last Log Point : 0x1af474000
SQDF950I session # insert : 0
SQDF951I session # delete : 0
SQDF952I session # update : 0
SQDF960I cumul # of insert : 0
SQDF960I cumul # of insert : 0
SQDF961I cumul # of delete : 0
SQDF962I cumul # of update : 27
SQDF925I Active Datastore : cdc:///db2cdc/DB2TODB2
SQDF920I Entry : # 1
SQDF930I Key : SQDATA.EMP
SQDF923I Active Flags : ACTIVE
SQDF928I Last Log Point : 0x1aff1f000
SQDF950I session # insert : 544
SQDF951I session # delete : 544
SQDF952I session # update : 35811
SQDF960I cumul # of insert : 544
SQDF961I cumul # of delete : 544
SQDF962I cumul # of update : 35919
SQDF925I Active Datastore : cdc:///db2cdc/DB2TODB2
SQDF920I Entry : # 2
SQDF930I Key : cdc:///db2cdc/DB2TODB2
SQDF842I Is connected : Yes
SQDF932I Ack Log Point : 0x1aff2309e
SQDF843I Last Connection : 2013-01-07 21:03:33
SQDF844I Last Disconnection : 2013-01-04 19:34:35
SQDF987I Last Commit Time : 2013-01-07 21:03:12.482800 (cabc970f621f0000)
SQDF953I session # records : 24936
SQDF954I session # txns : 1086
SQDF963I cumul # records : 25026
SQDF964I cumul # txns : 1098
SQDF794I Storage Usage
SQDF795I Used : 5 MB
SQDF796I Free : 59 MB
SQDF797I Unallocated : 0 MB
SQDF798I Memory Cache : 8 MB
SQDC017I sqdconf(pid=0x30) terminated successfully