A fix is available
APAR status
Closed as program error.
Error description
Potential data loss after installing PTF UI71324 for APAR PH27992 on any replicated table on IBM Db2 Analytics Accelerator or IBM Db2 for z/OS Data Gate after the asynchronous log reader task in Db2 for z/OS has TIMED OUT indicated by DSNT376I PLAN=DSNILGRT WITH CORRELATION-ID=014.LGRTSKxx (where xx is any numeric value) or has experienced a dead lock as indicated by DSNT375I PLAN=DSNILGRT WITH CORRELATION-ID=014.LGRTSKxx ... IS DEADLOCKED WITH PLAN=... Additional keywords: MSGDSNT375I MSGDSNT376I DEADLOCK TIMEOUT IDAAV7R5/K DATAGATE/K
Local fix
n.a.
Problem summary
**************************************************************** * USERS AFFECTED: * * All Db2 12 for z/OS users with PTF UI71324 * * for APAR PH27992 installed who either use * * IBM Db2 Analytics Accelerator with IBM * * Integrated Synchronization or IBM Db2 for * * z/OS Data Gate with compressed tables. * **************************************************************** * PROBLEM DESCRIPTION: * * Potential data loss after installing * * PTF UI71324 for APAR PH27992 on any * * replicated table on IBM Db2 Analytics * * Accelerator or IBM Db2 for z/OS Data * * Gate after the asynchronous log reader * * task in Db2 for z/OS has TIMED OUT * * indicated by DSNT376I PLAN=DSNILGRT * * WITH CORRELATION-ID=014.LGRTSKxx * * (where xx is any numeric value) or * * has experienced a dead lock as * * indicated by DSNT375I PLAN=DSNILGRT * * WITH CORRELATION-ID=014.LGRTSKxx ... * * IS DEADLOCKED WITH PLAN=... * **************************************************************** * RECOMMENDATION: * * Apply corrective PTF when available * **************************************************************** When the asynchronous log reader task for IBM Integrated Synchronization retries to read a log record that was returned compressed after access to the decompression dictionary failed with a lock time out or dead lock, some log records following the compressed log record may be skipped on the read retry operation when the compressed log record was in the last log read operation for the currently active log read scope. An indication that some log records may have been skipped could be message DSNX881I with text "Transaction with URID xxxx from member id yyyy is open since zzzz minutes, this exceeds the current max open warn age of 30 minutes". Other indications could be the failure to apply log records on IBM Db2 Analytics Accelerator or IBM Db2 for z/OS Data Gate because the rows to be updated can not be found. An example for such a kind of failure would be message DSNX881I with text "Message: nn rows parsed, but apply changed mm rows. Table XYZ (dbid: aaa, obid: bbb) is inconsistent, set table state to ERROR." Additional keywords: MSGDSNT375I MSGDSNT376I DEADLOCK TIMEOUT IDAAV7R5/K DATAGATE/K ZSA2
Problem conclusion
Code has been changed to correctly return all log records when a retry for compressed log records is performed.
Temporary fix
********* * HIPER * *********
Comments
APAR Information
APAR number
PH37808
Reported component name
DB2 OS/390 & Z/
Reported component ID
5740XYR00
Reported release
C10
Status
CLOSED PER
PE
YesPE
HIPER
YesHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2021-06-02
Closed date
2021-06-16
Last modified date
2021-07-02
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
UI75930
Modules/Macros
DSNILGRT
Fix information
Fixed component name
DB2 OS/390 & Z/
Fixed component ID
5740XYR00
Applicable component levels
RC10 PSY UI75930
UP21/06/24 P F106
Fix is available
Select the PTF appropriate for your component level. You will be required to sign in. Distribution on physical media is not available in all countries.
[{"Type":"MASTER","Line of Business":{"code":"LOB10","label":"Data and AI"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSEPEK","label":"Db2 for z\/OS"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"All Versions"}]
Document Information
Modified date:
03 July 2021