Error: PKLess Table Received UPDATE Without Before-Image

Issue

Syncs fail with the following error:

PKLess table <schema>.<table> received UPDATE without before-image

Environment

Connector: High-Volume Agent Db2 for i

Resolution

To resolve this issue:

1. In Db2 for i, verify the journal configuration.

   i. Confirm that the table from the error is correctly journaled.

   ii. Confirm that the IMAGES attribute is set to *BOTH to capture both before and after images.

   iii. Use the following command to update the journal configuration:

   CHGJRNOBJ OBJ((<schema>/<table> *FILE)) ATR(*IMAGES) IMAGES(*BOTH)
   

2. In Fivetran, go to your High-Volume Agent Db2 for i connection page.

3. In the top right, click Sync.

Cause

This issue occurs when Db2 for i is not configured to maintain both before and after images for table journal entries. Change data capture requires these images to process updates correctly.