Skip to main content

Official Support Articles

Search or browse our knowledge base to find answers to your questions ranging from account questions to troubleshooting error messages. The content is curated and updated by our global Support team

Announcements
QlikWorld 2023, a live, in-person thrill ride. Save $300 before February 6: REGISTER NOW!

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

cancel
Showing results for 
Search instead for 
Did you mean: 
Bill_Steinagle
Support
Support

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

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

 

Labels (2)
Version history
Last update:
‎2022-12-06 08:14 AM
Updated by: