DB001036 C-4M321: Table <TABLE NAME> definition/DB out of sync
Article ID: 131799
Updated On:
Products
Issue/Introduction
For SQL defined databases, IDMS uses synchronization stamps to ensure consistency between the data and the catalog definition that describes the data. A DB001036 error is an indication that this consistency has been broken.
Environment
Release: All supported releases.
Component: SQL Option.
Cause
The most typical cause of DB001036 is that in an SQL-defined database, either the database or the catalog has been backed and up restored independently of the other, resulting in the synchronization stamps in the two clashing.
However, it can also be the result of not being CONNECTed to the correct catalog when running various utilities.
Resolution
If a program is issuing DC001036 messages, make sure that any involved utilities, for example FORMAT, LOAD, INSTALL STAMPS, SYNCHRONIZE STAMPS, have been run while CONNECTed to the correct catalog. It is not necessarily SYSTEM and in most cases it won't be. Also, note that if the database has been FORMATted BY FILE, a manual INSTALL STAMPs must be run.
When the SQL commands are issued, a CONNECT TO a DBNAME must be performed, that contains both the SQL catalog segment (where the definitions reside) and the SQL data segment. Make sure both are pointing to the correct catalog and data areas/files.
In one case where this error occurred, it was noted that the DMCL being used in a local mode IDMSBCF job pointed to DSNs for the wrong database files. When the correct DD/DSNs were added to the JCL to point to the correct database files that matched the definitions in the catalog, the error did not occur. The DMCL file DSNs had to be corrected.
Additional Information
Feedback
