topic Re: Qlik Replicate source db2 iseries record images *after in Qlik Replicate

Qlik Replicate source db2 iseries record images *after

lguevara — Mon, 11 Aug 2025 21:36:45 GMT

Hi,

We have a source db2 i series and the parameter record images is only *after configured.

When in the source has inserted a new record, then in the target that is aws s3, we view 2 records an insert and an update for the same record.

This is posibble and caused by the parameter record images?

thanks.

Re: Qlik Replicate source db2 iseries record images *after

john_wang — Tue, 12 Aug 2025 01:55:02 GMT

Hello @lguevara ,

We have not encountered this issue in the past. In theory, the *AFTER image should not affect an INSERT operation — it is relevant only for UPDATE and DELETE operations:

UPDATE: Only the AFTER IMAGE is recorded in the DB400 journal.
DELETE: No record is written to the DB400 journal, so the change will be missed.

For reference, I could not reproduce the problem in my lab environment when testing a DB400-to-S3 task.

I recommend opening a support ticket and including the following information:

Set SOURCE_CAPTURE and TARGET_APPLY to Verbose.
Reproduce the issue.
Attach the diagnostics packages, making sure to decrypt the verbose task log files.
If possible, replace the target endpoint with another database or File target for comparison.

Hope this helps.

John.

Re: Qlik Replicate source db2 iseries record images *after

DesmondWOO — Tue, 12 Aug 2025 02:13:28 GMT

Hi @lguevara ,

In addition to John's reply, I wonder if your user inserts a record through an application that performs an INSERT followed by an UPDATE.

Based on your screenshot, the 'store changes' feature is enabled. Please check the header__stream_position to find the corresponding journal receiver and sequence number. Then, you can ask your AS400 administrator to run DSPJRN to verify if both the INSERT and UPDATE are recorded in the journal.

Regards,
Desmond

Re: Qlik Replicate source db2 iseries record images *after

lguevara — Wed, 13 Aug 2025 20:30:19 GMT

Hi @DesmondWOO,

I have this header__stream_position

Please in the header__stream what value take to find using dspjrn

Thanks

Re: Qlik Replicate source db2 iseries record images *after

DesmondWOO — Thu, 14 Aug 2025 04:03:13 GMT

Hi @lguevara ,

The sequence number follows VISION3309, which is 7292xxxxx. You can check with your AS400 administrator using this sequence number.

Regards,
Desmond