Table of Contents

Search

  1. Preface
  2. Part 1: PowerExchange Change Data Capture Introduction
  3. Part 2: CDC Components Configuration and Management
  4. Part 3: CDC Sources Configuration and Management
  5. Part 4: Change Data Extraction
  6. Part 5: Monitoring and Tuning
  7. Appendix A: CDC for z/OS Troubleshooting
  8. Appendix B: DTL__CAPXTIMESTAMP Time Stamps

Configuring IDMS Log Catalog Procedures

Configuring IDMS Log Catalog Procedures

Develop procedures for running the DTLULCAT and DTLULOGC utilities in a manner that adds IDMS logs to the Log Catalog in the correct sequence.
The preferred method of operation is to include DTLULCAT and DTLULOGC JCL in an archive log job. Use the DTLULCAU JCL to run DTLULCAT followed by DTLULOGC. You can submit the job by using a WTOEXIT that intercepts a WTO message.
Include the following steps in the job:
  1. Offload the active journal to an archive log.
  2. Write the archive log to a data set by using a utility such as IEBGENER.
    You can use a unique data set name and a GDG data set structure.
    Retain this copy of the log until PowerExchange has captured all changes.
  3. Add the data set to the PowerExchange Log Catalog by running the following jobs:
    • Run DTLULCAT to generate input statements for DTLULOGC.
    • Run DTLULOGC to update the PowerExchange Log Catalog.
To add logs to the Log Catalog, use the following rules:
  • A local mode journal must not be added to the Log Catalog if the last available timestamp in the journal is later than the timestamp of the previously added CV mode journal.
  • If Central Versions (CVs) are varied offline to run in Local Mode, ensure that Local Mode logs are added to the Log Catalog before any CV logs. If a database is varied offline and then back online again and the Local Mode log is not added immediately, a subsequent attempt to add the Local Mode log might fail.
  • Add logs in the correct sequence.
    If you add logs in the incorrect sequence, PowerExchange issues messages such as the following message:
    51007 162240 MVS 1 PWX-19862 IDMS CATLG FILE: Add Entry Failure - Timestamp not greater than previous for key XYLOGSID000000000000000000001AIDL15CDBAIDMSE150DTLUSR.IDMS.D15SP0.OFF.J4

0 COMMENTS

We’d like to hear from you!