R4I UDTF function working on DB2

[Naveedahmed]

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.

[john_wang]

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.

[stephensukumara]

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

[john_wang]

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.

[stephensukumara]

"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 ?

[stephensukumara]

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

[john_wang]

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.