ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

IDB2 Load job to SUBSYTEM_DETAIL fails with INPUT FIELD 'WKFILE_NONSORT_ACT',  INVALID FOR 'DMRS.SUBSYSTEM_DETAIL',

book

Article ID: 197087

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

Data load job to SUBSYTEM_DETAIL fails with the below error message 

DSNU334I  -D783 212 00:31:49.26 DSNURCON - INPUT FIELD 'WKFILE_NONSORT_ACT',
                      INVALID FOR 'DMRS.SUBSYSTEM_DETAIL',
                      ERROR CODE '04 - INPUT PACKED DECIMAL IS IN ERROR'


Environment

Release : 20.0

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

Resolution

The first recommendation is to modify the IQL that generates the load file by creating a declared field that would test if the value is reasonable and supply zero if not.

The second recommendation was to open a PMR with IBM to have them analyze the raw SMF file due to the 'strange' values in the QIST section from the subsystem D852 in field QISTIMAC-QISTIMSH.