CBR7541I DB2 SQL -205, -206: Column missing from OAM table. For new releases refer to migration guide otherwise refer to any new PTFs applied, new column added to tables.
Explanation
OAM encountered an error when running a bind job or during OAM execution.
This SQL code is one of a few common SQL errors that have been experienced by OAM users. The verbiage in the System Programmer Response section below is to provide the System Programmer more OAM specific guidance than would be found looking up the SQL code in the DB2® information center at http://publib.boulder.ibm.com/infocenter/imzic.
System action
The operation in progress fails.
System programmer response
These errors indicate that a migration job (not a bind job) that was supposed to add a column to a table did not run. The -205 or -206 SQL error indicates that there is missing column. See High-Level Installation and Migration Checklists in z/OS DFSMS OAM Planning, Installation, and Storage Administration Guide for Object Support for a list of OAM the jobs. Note that certain jobs are z/OS® installation specific. Again, note that this error is related to a migration job rather than a bind job.
- DSNT408I SQLCODE = -206, ERROR: EPI IS NOT A COLUMN OF AN INSERTED TABLE, UPDATED TABLE, OR ANY TABLE IDENTIFIED IN A FROM CLAUSE
- DSNX200I -DBD1 BIND SQL ERROR USING DB2ADM AUTHORITY PLAN=CBROAM DBRM=CBRKCMT STATEMENT=257 SQLCODE=-206 SQLSTATE=42703 TOKENS=EPI CSECT NAME=DSNXORSO RDS CODE=-100
For information on SQL error reason codes, visit the DB2 information center at http://publib.boulder.ibm.com/infocenter/imzic.
Source
Object Access Method (OAM)
Routing Code
2
Descriptor Code
4