topic Re: R4I UDTF function working on DB2 in Qlik Replicate

R4I UDTF function working on DB2

Naveedahmed — Thu, 17 Aug 2023 09:06:38 GMT

Hi All,

Can any one please tell me how this UDTF fucntion works on DB2 iseries machine. Also want to understand why this R4I need to install on Iseries server.

Re: R4I UDTF function working on DB2

john_wang — Thu, 17 Aug 2023 09:36:04 GMT

Hello @Naveedahmed ,

Welcome to Qlik Community forum and thanks for reaching out here.

By default, changes captured from IBM DB2 for iSeries are filtered on the Replicate Server using the standard display_journal function. When there is a high volume of changes, this may impact Change Processing performance because all the changes will be retried from journal and transferred to Replicate Server.

Installing the R4I UDTF on IBM DB2 for iSeries enables captured changes to be filtered on IBM DB2 for iSeries instead of on the Replicate Server, significantly improving CDC performance.

More detailed information can be found at Using the R4I UDTF for Change Capture.

The pros and cons about R4I UDTF :

Pros: it may improve CDC performance significantly, depends on the percentage of the monitored table changes in all the journal changes

Cons: it's not zero-footprint architecture, maybe you need upgrade UDTF component if the Replicate major version is updated, and the 2 versions UDTF are incompatible.

Hope this helps.

Regards,

John.

Re: R4I UDTF function working on DB2

stephensukumara — Wed, 10 Apr 2024 19:17:27 GMT

What is the impact with CPU or resource allocation by having this package installed on the ISeries server?

Re: R4I UDTF function working on DB2

john_wang — Thu, 11 Apr 2024 01:20:42 GMT

Hello @stephensukumara ,

It depends on the change data volume, I have not an exact number however I think the CPU and other resource allocation can be controlled by iSeries subsystem definition if it's a concern.

Hope this helps.

John.

Re: R4I UDTF function working on DB2

stephensukumara — Thu, 11 Apr 2024 12:24:59 GMT

"all the changes will be retried from journal and transferred to Replicate Server" - What does transferred to replicate server actually mean. The replicate does not store any physical data, are you referring to sequences being parsed from logstream ?

Re: R4I UDTF function working on DB2

stephensukumara — Thu, 11 Apr 2024 12:26:53 GMT

Also please recommend the exact path on where this needs to be installed on iSeries server for optimal performance.

Re: R4I UDTF function working on DB2

john_wang — Fri, 12 Apr 2024 13:25:07 GMT

Hello @stephensukumara ,

The difference of the 2 approaches can be found in the oldest comments of mine in this article, and more detailed information can be found in User Guide, including the installation steps.

Hope this helps.

John.