IDB2 'DEADLOCK', INVALID FOR 'DIDB20C.APPL_PGM_DETAIL'
search cancel

IDB2 'DEADLOCK', INVALID FOR 'DIDB20C.APPL_PGM_DETAIL'

book

Article ID: 203973

calendar_today

Updated On:

Products

SYSVIEW Performance Management Option for DB2 for z/OS Database Management for DB2 for z/OS - Performance Suite Database Management for DB2 for z/OS - SQL Performance Suite Insight Performance Monitor for DB2 UDB for z/OS

Issue/Introduction

After applying maintenance(BM PTF UI65711 on Db2 V12 )daily load job failed with the following message:                                                                      DSNU334I +DD0A 317 17:11:13.03 DSNURCON-INPUT FIELD 'DEADLOCK', INVALID FOR 'DIDB20C.APPL_PGM_DETAIL'

 

 

Environment

Release : 20.0

Component : CA SYSVIEW Performance Management Option for DB2 for z/OS

Resolution

The problem was caused by column RLIMIT_MATCH remaining CHAR(20) instead of CHAR(50). Updating RLIMIT_MATCH from 20 to 50 resolved the problem