APPL_DDF_DETAIL input field PREPARES_SENT invalid in Sysview for Db2
Article ID: 92769
Updated On: 10-10-2023
Products
SYSVIEW Performance Management Option for DB2 for z/OS
Issue/Introduction
Loading the Sysview Performance Management for Db2 for z/OS (IDB2) APPL_DDF_DETAIL table the job failed with the following message:
DSNU334I 089 10:19:14.11 DSNURCON - INPUT FIELD 'PREPARES_SENT', INVALID FOR 'INSIGHT.APPL_DDF_DETAIL',
ERROR CODE '04 - INPUT PACKED DECIMAL IS IN ERROR' DB2 V11 NFM
Resolution
Modifying the following field definition in the ARCLACDD file resolve the problem:
From: REQ_PRDID CHAR(8) NULLIF(NULLS_61_FIELDS='Y'),
To: REQ_PRDID POSITION(1015) CHAR(8) NULLIF(NULLS_61_FIELDS='Y'),
Feedback
Was this article helpful?
Yes
No
Powered by
