Field PACKAGE-PROGRAM-LONG truncated after upgrade to DB2 version 12
search cancel

Field PACKAGE-PROGRAM-LONG truncated after upgrade to DB2 version 12

book

Article ID: 139235

calendar_today

Updated On:

Products

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

Issue/Introduction

After upgrading to  Db2V12 FL100, the field PACKAGE-PROGRAM-LONG in ARCIACDP is being truncated to 18 characters.
Example: 
DATE            PROGRAM
2019-09-07  REQ03023_CHECK_FOR_EXSTNG_REC
2019-09-09  REQ03023_CHECK_FOR           





Environment

Release : 20.0

Component : CA Insight Database Performance Monitor for DB for z/OS

Resolution

After analyzing user  SMF data and it was discovered that all long fields offsets from the IFCID 239 are wrong.
IDB2 code identifies the bad offsets for long fields name and just copy the short name to the long one.
This is an IBM bug introduced recently in this year for DB2 12.
Here is the link the IBM fix:
https://www-01.ibm.com/support/docview.wss?crawler=1&uid=swg1PH14037