Table of Contents

Search

  1. Preface
  2. Introduction to PowerExchange Utilities
  3. createdatamaps - Data Map Creation Utility
  4. DTLCCADW - Adabas PCAT Utility
  5. DTLCUIML - IMS Log Marker Utility
  6. DTLINFO - Release Information Utility
  7. DTLREXE - Remote Execution Utility
  8. DTLUAPPL - Restart Token Utility
  9. DTLUCBRG - Batch Registration Utility
  10. DTLUCDEP - CDEP Maintenance Utility
  11. DTLUCSR2 - IDMS SR2 and SR3 Records Utility
  12. DTLUCUDB - DB2 for Linux, UNIX, and Windows CDC Utility
  13. DTLULCAT and DTLULOGC - IDMS Log Catalog Utilities
  14. DTLURDMO - Data Map Utility
  15. DTLUTSK - Task Control Utility
  16. EDMLUCTR - Log Scan and Print Utility
  17. EDMUOPTS - Service Aid Utility
  18. EDMXLUTL - Event Marker Utility
  19. HOSTENT - TCP/IP Address Reporter Utility
  20. PWXCATMY - MySQL Catalog Utility
  21. PWXUCCLPRT - Print Log Summary Utility
  22. PWXUCDCT - Logger for Linux, UNIX, and Windows Utility
  23. PWXUCREG - Capture Registration Suspend Utility
  24. PWXUMAP - Map List Utility
  25. PWXUCRGP - Capture Registrations Print Utility
  26. PWXUDMX - Data Maps Update Time ECSA Memory Utility
  27. PWXUGSK - SSL Reporting Utility
  28. PWXUSSL - PowerExchange SSL Reporting Utility
  29. WRKJRNLCKE- Journal Lock Table Utility for IBM i

Registration Statuses

Registration Statuses

In the CCT file, the status code determines whether a registration is available for use. The CCT file can contain the following status codes:
  • A
    . Active. The registration is available for use by the PowerExchange Logger for Linux, UNIX, and Windows, the PowerExchange Logger for z/OS, Condense, or a z/OS ECCR.
  • H
    . History. The registration was active but now it is no longer in use because its status was changed to History.
  • I
    . Inactive or "not yet used." You can create registrations with the Inactive status and then change them to an Active status later.
  • S
    . Suspended. This status applies only to certain z/OS database types such as Adabas, Datacom, IDMS, and log-based IMS. The registration is temporarily disabled for change capture use. The ECCRs ignore updates for the registered source during the suspension window. Typically, registrations are suspended when you perform database maintenance or large cascade-delete operations. The PowerExchange Logger for Linux, UNIX, and Windows and PowerExchange Condense continue to read any change data that the ECCRs already captured before the suspension started. After the suspension window ends, you must restore the status back to A for the registrations to be used for change data capture again.
Also, PowerExchange uses the following status codes in PWXUCREG parameters and messages but not in the CCT file:
  • C
    . Cancel Suspend. This value is passed in SQL when a PWXUCREG CANCEL_SUSPEND_REGISTRATION command has been issued to cancel a prior request to suspend registrations for certain z/OS database types.
  • D
    . Drop Old Data. This value is passed in SQL when a PWXUCREG DROP_OLD_REGISTRATION_DATA command has been issued to set a special suspension window for certain z/OS database types.
  • L
    . Live. This value is passed in SQL when registrations with the status A or S are retrieved from the PowerExchange Logger for Linux, UNIX, or Windows or from PowerExchange Condense. It can also be used in the PWXUCREG DISPLAY_REGISTRATION command that displays registration status information.
  • N
    . Not Live. This value is passed in SQL with the PWXUCREG DELETE_INACTIVE_REGISTRATION command that deletes inactive registrations from the capture environment and the DISPLAY_REGISTRATION command so that registrations with status H and I are retrieved and processed.
  • R
    . Reset timestamp. This value is passed in SQL when a PWXUCREG RESET_SUSPENSION_WINDOW command is issued to clear any activation and suspension timestamps that define the current suspension window for certain z/OS database types.

0 COMMENTS

We’d like to hear from you!