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.

Messages DSNT408I and DSNX200I with information about the missing column may accompany this one. The following sample messages accompany a case in which the EPI column that was to have been added with the SAMPLIB job CBRSMB2 is missing:
  • 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