00C90111

Explanation

The data manager detected an inconsistent data condition. In this case, the OBD for the requested OBID does not exist. This may be caused by an inconsistency in either the Db2 catalog or the Db2 directory. Specifically, the OBDDMAP(OBID) entry is zero rather than an offset to an OBD within the DBD.

To prevent further damage and possible loss of data, the inconsistency must be corrected before any further SQL access is attempted to this database.

System action

A record is written to SYS1.LOGREC, and an SVC dump is requested.

Operator response

Notify the system programmer.

System programmer response

Determine which databases were being used when the error occurred. Prevent further SQL access to the databases. If you suspect an error in Db2, you might need to report the problem. For information about identifying and reporting the problem, see Collecting diagnostic data.

Problem determination

Since the Db2 directory does not agree with the Db2 catalog, either of these may be inconsistent. Since the nature and extent of the inconsistency between the Db2 catalog the DBD is not immediately known, an analysis of the entire DBD must be done.

The inconsistency may be due to:
  • Incomplete recovery of Db2 catalog and/or Db2 directory.
  • Invalid restore of Db2 catalog and/or Db2 directory to a prior point in time.
  • A conditional restart that bypassed recovery of a Db2 catalog page set or a Db2 directory page set.
  • A Db2 internal error.
Collect the following diagnostic items:
  • Console output from the system on which the job was run, and a listing of the SYSLOG data set for the period of time that spans the failure.
  • A listing of the SYS1.LOGREC data set, obtained by executing IFCEREP1.
  • Unformatted DSN1PRNT output of the DSNDB01.DBD01 page set. Locate the inconsistent DBD in the DSNDB01.DBD01 page set by using the method described in Finding a DBD in a dump.
  • The results of the following SQL statements, where dbid is the DBID of the damaged DBD: 
    SELECT * FROM SYSIBM.SYSINDEXES 
   WHERE DBID=dbid ORDER BY OBID; 
SELECT * FROM SYSIBM.SYSINDEXES 
   WHERE DBID=dbid ORDER BY ISOBID;

SELECT * FROM SYSIBM.SYSTABLES 
   WHERE DBID=dbid ORDER BY OBID;
SELECT * FROM SYSIBM.SYSTABLESPACE 
   WHERE DBID=dbid ORDER BY OBID;
SELECT * FROM SYSIBM.SYSTABLESPACE 
   WHERE DBID=dbid ORDER BY PSID;

    Use the results to compare the information in the Db2 catalog with the DBD. Determine which OBDs are inconsistent with the Db2 catalog. Analyze the DBD by using the procedure in Analyzing a DBD.

  • DSN1LOGP output with DBID (1) OBID (1F) covering the period of time in which the DBD inconsistency might have occurred. This period of time is approximately from the time of the abend back to the time when the Db2 catalog and DBD were believed to be consistent.
  • Copy of the log for this period, so that additional DSN1LOGP reports can be produced for problem determination.