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

Manipulating the Log Catalog

Manipulating the Log Catalog

During normal IDMS log processing, PowerExchange updates the Log Catalog, LOGSCAT, to add the next available log by using the PowerExchange DTLULCAT and DTLULOGC log catalog utilities.
If you need to add, change, or remove log entries in the Log Catalog, run the DTLULOGC utility standalone with hand-coded input. Use the sample DTLULOGC JCL in the RUNLIB library.
Customize the DTLULOGC JCL to perform any of the following tasks:
  • Add a LOGSID instance.
  • Add a log entry to the Log Catalog.
  • Update a log entry.
  • Delete a log entry.
  • Export a log entry to another data set for offloading.
Then specify the DTLULOGC file as input in the SYSIN DD card.
The following table describes the keywords and parameters that you can code in the 80-byte DTLULOGC JCL file:
Keyword
Description
Parameters
ADD_INSTANCE
Add a LOGSID instance to the catalog. Each LOGSID requires an instance to be added to the log catalog.
  • INSTANCE_IDENTIFIER. A LOGSID value.
  • VERSION. A version number of the entry.
ADD_ENTRY
Adds a specific log to the log catalog.
  • BLOCK_SIZE. The block size of the log. Required if the logs are to be shipped to another platform.
  • ENTRY_NUMBER. A sequential number, which should be incremented by 1 for each new log added to the log catalog.
  • FILE_TYPE. One of the following values:
    • C
      . Central or Shared Service Log or Journal.
    • L
      . Local Mode or Unshared Service Log or Journal.
  • FIRST_RECORD_SEQUENCE_NUMBER. The sequence number of the first record in the block.
  • FIRST_RECORD_TIME_STAMP. The time stamp of the first record in the block.
  • IDMS_VERSION. The version number of IDMS. Specified as an integer.
  • INSTANCE_IDENTIFIER. A LOGSID value.
  • LAST_RECORD_IDENTIFIER. The record ID of the last record in the block or zeros if a non-data record.
  • LAST_RECORD_OFFSET. The offset of last valid offset in the block.
  • LOG_DATA_TYPE. "IDL" for MVS IDMS log data.
  • LOG_FILE_NAME. The name of IDMS log file.
  • MEDIA_CONTENT. One of the following values:
    • AI
      . Only contains After images.
    • BI
      . Only contains Before images.
    • BA
      . Contains both Before and After images.
  • MEDIA_TYPE. One of the following values:
    • D
      . Disk.
    • T
      . Tape.
  • NUMBER_OF_BLOCKS. The number of blocks in the log.
  • SERVICE. The CV name or Local Mode job name.
  • STATUS. One of the following values:
    • A
      . Active.
    • S
      . Skip.
    • T
      . Terminate.
  • ENTRY_TYPE. One of the following values:
    • 1
      . File entry.
    • 2
      . Reserved for future use.
  • VERSION. The version number of the entry.
UPDATE_ENTRY
Updates a log entry.
Valid parameters are those listed for ADD_ENTRY.
Use the following parameters to identify the entry:
  • INSTANCE_IDENTIFIER
  • ENTRY_NUMBER
DELETE_ENTRY
Deletes the last log for the specified INSTANCE_IDENTIFIER.
INSTANCE_IDENTIFIER
REPORT_INSTANCE
Lists catalog entries for the specified INSTANCE_IDENTIFIER.
INSTANCE_IDENTIFIER
EXPORT_INSTANCE
Exports all information for a specified INSTANCE_IDENTIFIER to a file.
INSTANCE_IDENTIFIER
Keywords are separated by a semicolon (;). Parameters are separated by a comma (,).
The following sample input adds two instances (LOGSIDs), adds log entries, deletes a log entry, reports instance LOGSIDA, exports instance LOGSIDA to a file (dtlulgce.txt), and deletes instance LOGSIDA:
ADD_INSTANCE INSTANCE_IDENTIFIER=LOGSIDA, VERSION=224; ADD_ENTRY INSTANCE_IDENTIFIER=LOGSIDA, ENTRY_NUMBER=777, VERSION=0, ENTRY_TYPE=1, STATUS=A, LOG_DATA_TYPE=IDL, IDMS_VERSION=15, FILE_TYPE=C, MEDIA_TYPE=D, MEDIA_CONTENT=BI, SERVICE=IDMSE150, LOG_FILE_NAME=XXXXXXXXXXXXXXXXXXXXXXXXXXXX, BLOCK_SIZE=29000, NUMBER_OF_BLOCKS=445, LAST_RECORD_OFFSET=1119, LAST_RECORD_IDENTIFIER=3, FIRST_RECORD_SEQUENCE_NUMBER=4, FIRST_RECORD_TIME_STAMP="05/03/03 10:55:01"; ADD_ENTRY INSTANCE_IDENTIFIER=LOGSIDA, ENTRY_NUMBER=778, VERSION=0, ENTRY_TYPE=1, STATUS=A, LOG_DATA_TYPE=IDL, IDMS_VERSION=15, FILE_TYPE=C, MEDIA_TYPE=D, MEDIA_CONTENT=BI, SERVICE=IDMSE150, LOG_FILE_NAME=MMMMMMMMMMMMMMMMMMMMMMMMMM, BLOCK_SIZE=29000, NUMBER_OF_BLOCKS=445, LAST_RECORD_OFFSET=1119, LAST_RECORD_IDENTIFIER=3, FIRST_RECORD_SEQUENCE_NUMBER=4, FIRST_RECORD_TIME_STAMP="05/03/03 12:55:01"; ADD_ENTRY INSTANCE_IDENTIFIER=LOGSIDA, ENTRY_NUMBER=779, VERSION=0, ENTRY_TYPE=1, STATUS=A, LOG_DATA_TYPE=IDL, IDMS_VERSION=15, FILE_TYPE=C, MEDIA_TYPE=D, MEDIA_CONTENT=BI, SERVICE=IDMSE150, LOG_FILE_NAME=ZZZZZZZZZZZZZZZZZZCCCCCCCCCCCC, BLOCK_SIZE=29000, NUMBER_OF_BLOCKS=333, LAST_RECORD_OFFSET=1119, LAST_RECORD_IDENTIFIER=3, FIRST_RECORD_SEQUENCE_NUMBER=4, FIRST_RECORD_TIME_STAMP="05/03/03 14:55:01"; ADD_INSTANCE INSTANCE_IDENTIFIER=ABCDE, VERSION=0; ADD_ENTRY INSTANCE_IDENTIFIER=ABCDE, ENTRY_NUMBER=1, VERSION=0, ENTRY_TYPE=1, STATUS=A, LOG_DATA_TYPE=IDL, IDMS_VERSION=15, FILE_TYPE=C, MEDIA_TYPE=D, MEDIA_CONTENT=BI, SERVICE=IDMSE15P, LOG_FILE_NAME=BBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBB, BLOCK_SIZE=29000, NUMBER_OF_BLOCKS=444, LAST_RECORD_OFFSET=1112, LAST_RECORD_IDENTIFIER=2, FIRST_RECORD_SEQUENCE_NUMBER=3, FIRST_RECORD_TIME_STAMP="05/04/03 08:55:01"; ADD_ENTRY INSTANCE_IDENTIFIER=ABCDE, ENTRY_NUMBER=2, VERSION=0, ENTRY_TYPE=1, STATUS=A, LOG_DATA_TYPE=IDL, IDMS_VERSION=15, FILE_TYPE=C, MEDIA_TYPE=D, MEDIA_CONTENT=BI, SERVICE=IDMSE15P, LOG_FILE_NAME=CCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCC, BLOCK_SIZE=29000, NUMBER_OF_BLOCKS=445, LAST_RECORD_OFFSET=1119, LAST_RECORD_IDENTIFIER=3, FIRST_RECORD_SEQUENCE_NUMBER=4, FIRST_RECORD_TIME_STAMP="05/04/03 10:55:01"; UPDATE_ENTRY INSTANCE_IDENTIFIER=LOGSIDA, ENTRY_NUMBER=779, VERSION=0, ENTRY_TYPE=1, STATUS=A, LOG_DATA_TYPE=IDL, IDMS_VERSION=15, FILE_TYPE=C, MEDIA_TYPE=D, MEDIA_CONTENT=BI, SERVICE=DTLXXXXX, LOG_FILE_NAME=AAAAAAAAAAAAAAKKKKKKKKKKKKKKK, BLOCK_SIZE=29000, NUMBER_OF_BLOCKS=111, LAST_RECORD_OFFSET=1119, LAST_RECORD_IDENTIFIER=3, FIRST_RECORD_SEQUENCE_NUMBER=4, FIRST_RECORD_TIME_STAMP="05/04/03 12:55:01"; DELETE_ENTRY INSTANCE_IDENTIFIER=LOGSIDA; REPORT_INSTANCE INSTANCE_IDENTIFIER=LOGSIDA; EXPORT_INSTANCE INSTANCE_IDENTIFIER=LOGSIDA; DELETE_INSTANCE INSTANCE_IDENTIFIER=LOGSIDA;

0 COMMENTS

We’d like to hear from you!