Not Found

Page Not Found

The page or file you are looking for has been moved or no longer exists.

The following links might help you find the content you need:


You can also search the Documentation Portal or visit the home page.

Table of Contents

Search

  1. Preface
  2. PWX-00000 to PWX-00099
  3. PWX-00100 to PWX-00999
  4. PWX-01000 to PWX-01999
  5. PWX-02000 to PWX-04999
  6. PWX-05000 to PWX-06999
  7. PWX-07000 to PWX-09999
  8. Abend, Return, and Reason Codes in PowerExchange Messages

Message Reference Volume 1

Message Reference Volume 1

PWX- 06818

PWX-
06818

DB2 for i5/OS CDC ended because i5/OS job
job_identifier
performed a TRUNCATE operation on the DB2 table
schema
.
table_name
.
The i5/OS job performed a SQL TRUNCATE operation on the specified DB2 table, which is registered for PowerExchange DB2 for i5/OS CDC. DB2 writes only a single journal entry for the truncation. As a result, PowerExchange CDC has no means of identifying the records that the TRUNCATE operation deleted from the table.
CDC processing ends.
Specify a new restart token for the truncated table. The restart token must identify a position in the change stream that occurs after the TRUNCATE operation. Informatica recommends that you do not use a TRUNCATE statement to delete records from i5/OS tables that are registered for CDC.

0 COMMENTS

We’d like to hear from you!