Replication Overview

The following steps provide an example of the most common way to use DATABridge to access DMSII data.

  1. Run the Lister Accessory to determine which DMSII data sets you want to clone or replicate with DATABridge.
  2. From the Lister report, make a list of the data sets you want to replicate.
  3. Edit and compile the DBGenFormat file for the record formats and filters that you want to use.
  4. Select the replication method (for example, using the Span Accessory or Snapshot Accessory).
  5. Run the accessory against the DMSII database. (Both accessories generate a default parameter file the first time you run them.)
  6. Edit the parameter file by selecting the data sets you want to replicate, the formatting and filtering routines to use, etc.
  7. Replicate the DMSII data by running the Span or Snapshot Accessory to write data files.
  8. Transport the data files for the replicated data sets to the secondary database system. This is site dependent. You might use a file transfer program, for example, or you might physically carry tapes to another location.
  9. Update the replicated DMSII data.

    If you use the Span Accessory to replicate your DMSII database, update the secondary database by running the Span Accessory to write data files that contain changes gathered from the audit trail. Then, use one of your user-written programs to read these data files and update the secondary database.

    If you use the Snapshot Accessory to clone your DMSII database, update the secondary database in one of two ways:

    • Run the Snapshot Accessory again. The entire collection of data sets is recloned and the old secondary database is reloaded by running one of your user-written programs with the new data files.
    • Insert the Snapshot audit location into a Span Accessory parameter file and then run the Span Accessory.

      Note: DATABridge accessories do not permanently reside in the mix. Instead, initiate the accessory for the task you want to complete. DATABridge then initiates and subsequently terminates any other programs, libraries, or utilities needed to complete the task. As long as you installed DATABridge so it has visibility to your DMSUPPORT Library and DMSII DESCRIPTION and CONTROL files, you can run the DATABridge accessories whenever necessary.