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

CONDF_PART_LRECL Parameter

CONDF_PART_LRECL Parameter

The logical record length (LRECL) for PowerExchange Condense partial condense files.
CONDF_PART_LRECL=
bytes
For the
bytes
variable, enter a number of bytes from 4044 to 147444. Default is one of the following values:
  • 32756 if a value for the CONDF_PART_BLKSZ parameter is not specified
  • The difference that results from
    CONDF_PART_BLKSZ-4
    if CONDF_PART_BLKSZ is specified.
If you enter 32756 or less, PowerExchange Condense uses RECFM=VB to create the condense files. You can then read the condense files by using the Interactive System Productivity Facility (ISPF) and standard IBM utilities such as IDCAMS.
If you enter a value greater than 32756, PowerExchange Condense uses RECFM=VS to create the condense files. You can then read the condense files only by using specialized utilities such as the IBM Data Interfile Transfer, Testing and Operations Utility (DITTO) with the DB command.
  • Although the maximum value for this parameter is 147444, Informatica recommends that you use a value less than 32756. Record lengths less than 32 KB are optimal for reading and writing data on disk. This strategy works because PowerExchange is able to split row data into multiple physical records.
  • If you have 3390 disks, you can usually achieve efficient disk space usage by 1) setting CONDF_PART_BLKSZ=27998 to write two blocks per track and 2) setting the CONDF_PART_LRECL parameter to 27994 or a value greater than 32756.
  • Informatica recommends the following additional guidelines for setting the parameter based on the maximum record size:
    • If the maximum record size is 27994 bytes or less, set the CONDF_PART_LRECL parameter to 27994. This value causes RECFM=VB to be used.
    • If the maximum record size is greater than 32756 bytes, which might occur with Adabas spanned data, set the CONDF_PART_LRECL parameter to 147444. This value causes RECFM=VS format to be used.
    • If the maximum record size is a value from 27995 to 32756 bytes, use one of the following settings:
      • Set CONDF_PART_LRECL=32764 to use RECFM=VS.
      • Set CONDF_PART_LRECL=27994 and CONDF_PART_BLKSZ=27998 to use RECFM=VB. With this setting, PowerExchange handles spanned records.

0 COMMENTS

We’d like to hear from you!