IDMS: Database replication in IDMS

book

Article ID: 196233

calendar_today

Updated On:

Products

CA IDMS CA IDMS - Database

Issue/Introduction

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

Environment

Release : All supported releases.
Component : CA IDMS

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