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/OSDatabase Management for DB2 for z/OS - Performance SuiteInsight 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