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/OSDatabase Management for DB2 for z/OS - Performance SuiteDatabase Management for DB2 for z/OS - SQL Performance SuiteDetector 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.