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

Formatting Log Data Sets

Formatting Log Data Sets

You must format the log data sets as you create them. PowerExchange CDC provides a utility, EDMLUTL0, that you can use to format the log data sets.
Use the following sample JCL in the #EDMLFMT member of the
hlq
.SAMPLIB library. This JCL formats four log data sets: two primary data sets and two secondary data sets.
//*-------------------------------------------------------------------* //* PowerExchange CDC - FORMAT ACTIVE LOG DATA SETS FOR LOGGER //*-------------------------------------------------------------------* //* REPLACE THE FOLLOWING ITEMS WITH PROPER INSTALLATION VALUES //* 1. JCL DATA SET NAMES //*-------------------------------------------------------------------* //DEFLOGP1 EXEC PGM=EDMLUTL0 //STEPLIB DD DISP=SHR,DSN=HLQ.LOAD <=== PWX LOAD //PRILOG DD DISP=SHR,DSN=YOUR.????.PRILOG.DS01 <=== PRI LOG #1 //*-------------------------------------------------------------------* //DEFLOGS1 EXEC PGM=EDMLUTL0 //STEPLIB DD DISP=SHR,DSN=HLQ.LOAD <=== PWX LOAD //PRILOG DD DISP=SHR,DSN=YOUR.????.SECLOG.DS01 <=== SEC LOG #1 //*-------------------------------------------------------------------* //DEFLOGP2 EXEC PGM=EDMLUTL0 //STEPLIB DD DISP=SHR,DSN=HLQ.LOAD <=== PWX LOAD //PRILOG DD DISP=SHR,DSN=YOUR.????.PRILOG.DS02 <=== PRI LOG #2 //*-------------------------------------------------------------------* //DEFLOGS2 EXEC PGM=EDMLUTL0 //STEPLIB DD DISP=SHR,DSN=HLQ.LOAD <=== PWX LOAD //PRILOG DD DISP=SHR,DSN=YOUR.????.SECLOG.DS02 <=== SEC LOG #2
In this JCL, HLQ and YOUR represent high-level qualifiers that you specified during installation. The question marks represent the PowerExchange Logger ID associated with the log data sets.
To format log data sets:
  1. Make a copy of the sample #EDMLFMT JCL procedure, and edit the copy as required.
    The following table describes the statements that you must specify for each log data set:
    JCL Statement
    Description
    EXEC
    Specify the utility EDMLUTL0. This utility processes the log data sets so that they are formatted for change capture.
    STEPLIB DD
    Include the PowerExchange CDC load library. If you added the load library to your system's LNKLST concatenation, you do not need to add it to the STEPLIB statement.
    PRILOG
    Specify one of the log data set names that you used when you created the log data sets.
    For example, if your system uses dual logging and two active logs, include four job steps in the utility JCL, one for each primary log and one for each secondary log. Include the subsystem name in a log data set name to distinguish between the log data sets.
  2. Repeat Step 1 until you have defined all of the log data sets that you want to format.
  3. Run the job.
    The utility processes each data set, formatting it for change capture. The utility formats the data sets according to the following conditions:
    • If the data set is empty when the format utility processes it, the utility formats the entire data set, from the beginning of the data set to the highest-allocated RBA for the log.
    • If the data set contains data when the format utility processes it, the utility formats the data set from the highest used log RBA to the highest allocated log RBA. The utility does not format the existing data in the log data set. This is useful if you want to format a data set when you move or copy it to a different physical location.

0 COMMENTS

We’d like to hear from you!