Trying to issue a SELECT against system tables give this error:
SELECT * FROM SYSTEM.TABLE;
*+ Status = -4 SQLSTATE = 5000J Messages follow:
*+ DB001036 T50 C-4M321: Table TABLE definition/DB out of sync
In general, IDMS does not use synchronization stamps for system tables, so how is this error possible?
Release : 19.0
Component : CA IDMS/DB SQL Option
The cause of this problem is most likely that the STAMP BY settings on the catalog definition are incorrect.
DDLCAT and DDLCATLOD should be STAMP BY AREA.
DDLCATX should be STAMP BY TABLE.
This is documented in Defining New Catalog Components.