DSNU318I  IDB2 RECORD DISCARDED DUE TO INVALID 'LOCATION' COLUMN SPECIFICATION FOR TABLE
search cancel

DSNU318I  IDB2 RECORD DISCARDED DUE TO INVALID 'LOCATION' COLUMN SPECIFICATION FOR TABLE

book

Article ID: 139720

calendar_today

Updated On:

Products

Subsystem Analyzer for DB2 for z/OS Database Management for DB2 for z/OS - Performance Suite Database Management for DB2 for z/OS - SQL Performance Suite Detector for DB2 for z/OS

Issue/Introduction

Detector Batch job to laod the PDT produced the following messages after latest maintenance was applied.

DSNU318I  GM2D 289 00:49:37.08 DSNURCON - RECORD (1) WILL BE DISCARDED DUE TO INVALID 'LOCATION' COLUMN SPECIFICATION FOR PTI.PDT_HST01_OBJECT

What would cause this?

Environment

Release : 20.0

Component : CA Detector for DB2 for z/OS

Resolution

The problem is caused when the object(tables) were altered during the application of the maintenance. Dropping and recreating the objects will resolve this problem.