Archive process to load SMF data into APPLICATION_DETAIL table fails with the error code 04 - INPUT PACKED DECIMAL IS IN ERROR.
search cancel

Archive process to load SMF data into APPLICATION_DETAIL table fails with the error code 04 - INPUT PACKED DECIMAL IS IN ERROR.

book

Article ID: 137668

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

Issue/Introduction

The Sysview Performance Option for Db2 for z/OS (IDB2) archive process to load SMF data into the APPLICATION_DETAIL table fails with the error:

INVALID FOR 'INSIGHT.APPLICATION_DETAIL',   ERROR CODE '04 - INPUT PACKED DECIMAL IS IN ERROR'     

Environment

Release : 20.0
Component : Sysview Performance Management Option for Db2 for z/OS

Cause

The DDL and Load IQL (ARCLACDfor the APPLICATION_DETAIL table were obsolete with two of the table columns missing.

Resolution

Following the prescribed HOLDDATA to run the IDB2 Post Install steps to create new table DDL and Load IQL resolved the load failure.