CBR7544I   DB2 SQL -818: Inconsistent time stamps on modules from DBRM. Verify OAM Grants and Binds have been properly and successfully executed.

Explanation

OAM encountered an error while processing an OAM table. This error indicates that you need to run OAM bind jobs.

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 error indicate that OAM encountered a problem with one or more bind job, often requiring that bind jobs be run or re-run. Do the following to find and fix the problem:
  • If you are migrating to a new z/OS® level, ensure that you run the correct bind jobs for the z/OS level you are migrating to. This also includes any application bind jobs (supplied by the applications).
  • If you are applying maintenance, run all applicable binds if needed for the maintenance and as any HOLDDATA in APARs suggests.
  • Look at the OAM bind jobs programs for new syntax or other requirements you might have overlooked and that might cause changes. For example, the CBRABIND that shipped with APARs OW42134 and OW46082 requires that you put a ".*" after every DBRM. 
    PKLIST(CBRKCMR.*, CBRKCMD.*, CBRKCMI.*, CBRKCME.*, CBRKCMF.*, ...............
CBRKCMT.*)
  • Look for accompanying message DSNT408I indicating that the error is due to a timestamp discrepancy in the bind job: 
    DSNT408I SQLCODE = -818, ERROR: THE PRECOMPILER-GENERATED
TIMESTAMP 16862E761A2ED30C IN THE LOAD MODULE IS DIFFERENT FROM
THE BIND TIMESTAMP 16862E2A0EC25B5B BUILT FROM THE DBRM CBRKCMT
X'00000000' SQL DIAGNOSTIC.....................
.
    In this example, the message indicates that member (CBRKCMT) has a timestamp discrepancy associated with it. You must rerun any application and OAM binds using that member.
  • When you run a bind job, ensure that the job runs successfully by looking for system message DSNT200I: 
    DSNT200I BIND FOR PLAN CBROAM SUCCESSFUL
DSNT200I BIND FOR PLAN CBRISMF SUCCESSFUL
    An unsuccessful bind job results in the following message showing the plan and member causing the error: 
    DSNX200I - BIND SQL ERROR
    USING SYSADM1 AUTHORITY
    PLAN=CBRIDBS
    DBRM=CBRKCMF
    STATEMENT =677
    TOKENS=SYSADM1.DELOBJT
    CSECT NAME=dsnxotl
    RDS=-500
DSNT201I - BIND FOR PLAN CBRIDBS NOT SUCCESSFUL
OAM ships the bind jobs in SYS1.SAMPLIB.

For general information on SQL -818 errors, refer to the information in APAR II05367.

For information on other SQL error reason codes, visit the in the DB2 information center at http://publib.boulder.ibm.com/infocenter/imzic.

Source

Object Access Method (OAM)

Routing Code

2

Descriptor Code

4

Parent topic: CBR messages