Qlik Replicate reading from DB2i Source has RRN values being the same as already processed

[Bill_Steinagle]

Qlik  Replicate is reading from the DB2i Source environment and the data that is being written to the Target is showing the RRN column which is defined as the Primary Key is being duplicated in the Source.

Resolution

The issue as it relates to the RRN value from the DB2i Source environment is due to the definition of the File/Table on the Source. The REUSEDLT(*YES) on the Create Physical File (CRTPF) for this Table is setup to REUSE the RRN should be confirmed if this is set as this will recycle the RRN to be reused.

Cause

There is a setting on the DB2i File Definition of Table REUSEDLT(*YES) this allows the DB environment to reuse the RRN that may have been used already which would cause the behavior.

Environment

Qlik Replicate all versions

Related Content

https://www.ibm.com/docs/en/i/7.2?topic=options-reusing-deleted-records