CBR7540I   DB2 SQL -204: DB2 object not defined in the DB2 subsystem. Verify OAM binds and grants have been properly and successfully executed.

Explanation

OAM encountered an error when running an OAM bind job. See the System Programmer's Response to resolve the problem.

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

This problem typically occurs when OAM Object users run bind jobs and use an invalid user ID. Often this means that the original userid created in the DB2 tables is no longer valid. Review the "OSMC Application Plans" section in Creating DB2 Databases for Object Tables and Directories in z/OS DFSMS OAM Planning, Installation, and Storage Administration Guide for Object Support. As the information in this section indicates, the USERID associated with the bind job must be the same as the USERID associated with the CBRSAMPL job that creates the OAM configuration database because the SQL statements in the plans contain unqualified DB2 table names. DB2 assumes the unqualified table name is also the authorization ID of the binder.

To correct this problem, use the following DB2 bypass that adds the following to the migration and bind jobs, where CBRADMIN is the sample ID used:
DSN SYSTEM(xxxx)
DSN SET CURRENT SQLID='CBRADMIN' <----- ID
DSN BIND....

After correcting the USERID, you must run the OAM binds. Run CBRPBIND, again with correct USERID, followed by the CBRABIND and CBRHBIND bind jobs. You must also run the CBRHGRNT SAMPLIB job to grant authority to use the application plans, as mentioned in the "OSMC Application Plans" in Creating DB2 Databases for Object Tables and Directories in z/OS DFSMS OAM Planning, Installation, and Storage Administration Guide for Object Support. After running all the OAM jobs, binds, and grants, you must also run the application binds.

Note that in an OAMPLEX, it is crucial that the OAM CBRPBIND job is run from the highest level system in the plex.

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