Qlik Replicate source db2 iseries record images *after

[lguevara]

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.

[john_wang]

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:

1. Set SOURCE_CAPTURE and TARGET_APPLY to Verbose.

2. Reproduce the issue.

3. Attach the diagnostics packages, making sure to decrypt the verbose task log files.

4. If possible, replace the target endpoint with another database or File target for comparison.

Hope this helps.

John.

[DesmondWOO]

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

[lguevara · Accepted solution]

Hi @DesmondWOO,

I have this header__stream_position

Please in the header__stream what value take to find using dspjrn

Thanks

[DesmondWOO]

Hi @lguevara ,

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

Regards,
Desmond