DB001036 C-4M321: Table <TABLE NAME> definition/DB out of sync
Article ID: 131799
Updated On:
Products
CA IDMS
CA IDMS - Database
CA IDMS - ADS
Issue/Introduction
For SQL defined databases, CA-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.
A DB001036 error is an indication that this consistency has been broken.
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.
However, it can also be the result of not being CONNECTed to the correct catalog when running various utilities.
Environment
CA-IDMS, all supported releases.
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.
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.
Additional Information
Feedback
Yes
No
Powered by
