Database replication in IDMS

Products

• IDMS
• IDMS - Database

Issue/Introduction

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

Environment

Release: All supported releases.

Resolution

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 that provide for replication in IDMS. Google IDMS and REPLICATION.