IDB2:RECORD WILL BE DISCARDED DUE TO 'DEADLOCK' CONVERSION ERROR FOR INSIGHT2.APPL_PGM_DETAIL
book
Article ID: 256157
calendar_today
Updated On:
Products
SYSVIEW Performance Management Option for DB2 for z/OSDatabase Management for DB2 for z/OS - Administration SuiteDatabase Management for DB2 for z/OS - Performance SuiteDatabase Management for DB2 for z/OS - Recovery SuiteDatabase Management for DB2 for z/OS - SQL Performance SuiteDatabase Management for DB2 for z/OS - Utilities Suite
Issue/Introduction
SMF load job is discarding records from INSIGHT2.APPL_PGM_DETAIL
RECORD WILL BE DISCARDED DUE TO 'DEADLOCK' CONVERSION ERROR FOR INSIGHT2.APPL_PGM_DETAIL
Deadlock column CNTL is "DEADLOCK DECIMAL NULLIF(NULLS_81_FIELDS='Y'),"
Environment
Release : 20.0
Resolution
The problem was caused by using HGHLVL.REQUESTS to run load job. The ARCLACDP and ARCIACDP was not using the updated versions. Copying the two members out of the HGHLVL.SOURCE and rerunning the load resolved the problem.