The Storage Agent maintains statistics about the logs that have been mined as well as Transient Storage Pool utilization. These statistics can help to determine if the Storage Agent is sized correctly. These statistics are also accessed with the display action of SQDCONF and the Storage Agent configuration .cab file:
//*----------------------------------------
//*- DISPLAY CONFIG FILE
//*----------------------------------------
//DISPLAY EXEC PGM=SQDCONF
//SYSPRINT DD SYSOUT=*
//STOREOUT DD SYSOUT=*
//SQDPARMS DD *
display /home/sqdata/db2cdc_store.cab --stats --sysout=STOREOUT
//*
SQDC017I sqdconf(pid=0x99) terminated successfully
SQDF801I Configuration name : cdcstore
SQDF802I Configuration key : cab_964960E67A564AA3
SQDF850I Session Statistics -
SQDF851I Txn Max Record : 44
SQDF852I Txn Max Size : 42386124
SQDF853I Txn Max Log Range : 8207
SQDF855I Max In-flight Txns : 0
SQDF856I # Txns : 608
SQDF857I # Effective Txns : 104
SQDF861I # Commit Records : 82
SQDF858I # Rollbacked Txns : 21
SQDF859I # Data Records : 2775
SQDF860I # Orphan Data Records : 0
SQDF862I # Rollbacked Records : 924
SQDF863I # Compensated Records : 0
SQDF866I # Orphan Txns : 0
SQDF867I # Mapped Blocks : 0
SQDF868I # Accessed Blocks : 2
SQDF869I # Logical Blocks : 0
SQDF870I Life Statistics -
SQDF871I Max Txn Record : 44
SQDF872I Max Txn Size : 42386124
SQDF873I Max Txn Log Range : 24582
SQDF875I Max In-flight Txns : 0
SQDF876I # Txns : 76576
SQDF877I # Effective Txns : 27701
SQDF881I # Commit Records : 22154
SQDF878I # Rollbacked Txns : 5546
SQDF879I # Data Records : 752586
SQDF880I # Orphan Data Records : 0
SQDF882I # Rollbacked Records : 243513
SQDF883I # Compensated Records : 0
SQDF886I # Orphan Txns : 0
SQDF887I # Mapped Blocks : 48
SQDF888I # Accessed Blocks : 2006
SQDF889I # Logical Blocks : 48
SQDC017I sqdconf(pid=0x99) terminated successfullyNote:
The following fields give an indication of the storage need for the current workload.
- Txn Max Record :This indicates the maximum number of records contained in any given transaction. Here the biggest transaction had 44 records.
- Txn Max Size: This is the maximum size of the payload associated with any given transaction. Here the total amount of data carried by the biggest transaction we’ve seen was a little more than 40MB.
- Txn Max Log Range: This indicates the largest difference in LSN from start to the end of a transaction.