-
Replicator (SQDRPL) Engine:
Fix serialization bug that leaves Replicator connected to the publisher but all worker threads idle and no data written to the Target.
-
Db2/z Capture:
-
Add dynamic Unit-of-work (UOW) tracker with operation threshold filter. Intended for diagnostic use by Precisely Support. Given its additional overhead, it is recommended for use in test environments only.
The UOW tracker is dynamically enabled and disabled with the SQDCONF tune command. If not disabled the trace will persists until the Db2/z Capture is unmounted. Setting the threshold is optional and can be done independently or in conjunction with enabling or disabling the trace. The threshold limits trace output to units of work with greater than or equal to the specified number of operations (inserts, updates, deletes). If not specified, the default is to trace all units of work. Output is written to SQDLOG and consists of two lines plus one additional line per table in the Unit of Work.
Note: This trace can produce large volumes of output to SQDLOG that depend on transaction volume, number of tables per transaction, and the tracker threshold. Special planning and preparation may be required to avoid S722 ABEND.
-
//MOD1 EXEC PGM=SQDCONF,REGION=32M
//STEPLIB DD DISP=SHR,DSN=SQDATA.LOAD
//SYSPRINT DD SYSOUT=*
//SYSOUT DD SYSOUT=*
//SQDLOG DD SYSOUT=*
//SQDPARMS DD *
tune --enable-uow-tracker
--uow-tracker-threshold=200
/u/wwcvca/sqdata/db2/dbd0.cab
/*//SQDPARMS DD *
tune --disable-uow-tracker
/u/wwcvca/sqdata/db2/dbd0.cab
/*