Compression dictionary delays - connect_cdc_sqdata - Latest

Connect CDC (SQData) Troubleshooting

Product type
Software
Portfolio
Integrate
Product family
Connect
Product
Connect > Connect CDC (SQData)
Version
Latest
Language
English
Product name
Connect CDC (SQData)
Title
Connect CDC (SQData) Troubleshooting
Copyright
2024
First publish date
2000
Last updated
2024-11-25
Published on
2024-11-25T15:16:52.503000
The Db2/z Log Capture often requires access to Db2's compression dictionary. There can be delays introduced due to the table space is stopped or another utility claim that prevents its access. Db2 will issue a C90063 return code, echoed by the Capture when this occurs:
[ DB2C] :undecompressed record at rba:000000019B1607BF33AD rc=8 reason=0xc90063 diag=0xc90082

The capture will by default retry 5 times with a 5 second wait interval before terminating. The Capture can be restarted immediately or if known after the condition causing contention has been resolved.

If this occurs frequently, both the number of retrys and the retry interval can be specified for the capture using the following two parameters in addition to the others already present in your configuration:
// SQDPARMS DD *
... existing parameters

[--log-retry-count=<number of retrys>]
[--log-retry-interval=<seconds>]