IDMS: Database replication in IDMS


Article ID: 196233


Updated On:


CA IDMS CA IDMS - Database


Does IDMS provide any built-in support for database replication?


Release : All supported releases.
Component : CA IDMS


There is no built-in support for replication in IDMS.

Some suggestions:
1. Database procedures: Although issuing database DML inside a database procedure is strongly discouraged.
2. Table procedures: Create a table procedure, and code the update SQL DML verbs such that they maintain all the required record types.
3. Depending on the time scales required, write a program to read the archive journals and issue the required DML to complete the replication.

There are also third-party tools out there the provide for replication in IDMS. Google IDMS and REPLICATION.