DB001036 C-4M321: Table <TABLE NAME> definition/DB out of sync

book

Article ID: 131799

calendar_today

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.

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.
 

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.

Additional Information

Maintaining Identically-Defined Entities