Table of Contents

Search

  1. Preface
  2. Summary of PowerExchange New Features and Changes
  3. PowerExchange Installation and Upgrade
  4. PowerExchange Agent
  5. PowerExchange Client for PowerCenter
  6. PowerExchange Condense
  7. PowerExchange Listener
  8. PowerExchange Logger for Linux, UNIX, and Windows
  9. PowerExchange Navigator
  10. PowerExchange Monitoring and Tuning
  11. PowerExchange Utilities
  12. PowerExchange for Adabas
  13. PowerExchange for CA Datacom
  14. PowerExchange for DB2 for i
  15. PowerExchange for DB2 for Linux, UNIX, and Windows
  16. PowerExchange for DB2 for z/OS
  17. PowerExchange for CA IDMS
  18. PowerExchange for IMS
  19. PowerExchange for Microsoft SQL Server
  20. PowerExchange for MySQL
  21. PowerExchange for Oracle
  22. PowerExchange for PostgreSQL
  23. PowerExchange for VSAM and Flat Files
  24. PowerExchange ODBC

PowerExchange Condense Configuration File Parameter

PowerExchange Condense Configuration File Parameter

In PowerExchange 10.1, you can add the following new parameter to the PowerExchange Condense CAPTPARM configuration member on z/OS or i5/OS:
OPER_WTOR_ENABLED={N|
Y
}
Controls whether PWX-06449 WTOR messages are issued when PowerExchange Condense detects that a record is missing from the CDCT file after synchronization of the checkpoint file to the CDCT file. This message requires a user reply of Y or N.
Synchronization occurs at PowerExchange Condense initialization, after a warm start of a PowerExchange Condense job. During synchronization, if any record in the checkpoint file does not match a record in the CDCT file based on the key fields, the checkpoint file record is not added to the CDCT file. The CDCT file is then missing a record that points to a condense file from which to extract change data for a registered source object and time stamp. For each record that is missing from the CDCT file, PowerExchange issues the following PWXX-06446 warning message followed by the optional PWX-06449 WTOR message:
PWX-06446 Checkpoint to CDCT synchronization not done for time stamp "
time_stamp
" tag "
registration_tag
" number
record_count
reason
. PWX-06449 The CDCT cannot be fully synchronized with the checkpoint file because of missing resources. Continue? (Y/N)
You must respond Y or N to the PWX-06449 message to indicate whether to continue or end PowerExchange Condense processing. Use this parameter to suppress these WTOR messages if you want PowerExchange Condense to continue and if the loss of some change data during extraction processing is tolerable for the reported time stamps and registrations.
Valid values:
  • Y
    . When PowerExchange Condense detects missing records in the CDCT file after
    checkpoint-to-CDCT
    synchronization, PWX-06449 messages are displayed as WTOR messages and written to the PowerExchange message log. You must reply Y or N to each of these messages to indicate whether PowerExchange Condense processing should continue without the CDCT records or stop.
    • If you reply Y, PowerExchange Condense continues processing. In this case, extraction processes will not be able to find some condense files based on the CDCT file for data extraction. Skipping some change data might be acceptable if the condense files contain old data or if the CDC workflow already processed these condense files. Use the time stamps reported in the PWX-06446 messages to determine if the data is old. If you need to extract the data, you must cold start the CDC session from an earlier point in time.
    • If you reply N, PowerExchange Condense stops.
  • N
    . When PowerExchange Condense detects missing records in the CDCT file, PWX-06449 messages are suppressed. PowerExchange Condense processing continues uninterrupted without the PWX-06449 WTOR messages.
Default is Y.
For more information, see the "PowerExchange Condense" chapter in the
PowerExchange CDC Guide for z/OS
or
PowerExchange CDC Guide for i5/OS
.
This parameter is also available in 9.6.1 HotFix 4. It is not available in 10.0.

0 COMMENTS

We’d like to hear from you!