[DB2 for iSeries source] Maximum number of tables for using the R4I UDTF

[iti-attunity-sup]

Hello support team.

[Info]
Source : IBM DB2 for iSeries

[Question]
About "Using the R4I UDTF for Change Capture",
Following limitations is descrypted.
>The R4I UDTF can capture up to 300 tables. If you need to capture more than 300 tables, do not use this option
https://help.qlik.com/en-US/replicate/May2024/Content/Replicate/Main/IBM%20DB2%20for%20iSeries/advan...

Is this for each task or sum of all task ?

For example,
If source database has 900 tables, is it possible to separate for 3 task every 300 tables with using the R4I UDTF?

Best Regards.

[sureshkumar]

Hello @iti-attunity-sup 

Kindly refer the below article

Qlik Replicate Db2i Source: E: Error parsing - Qlik Community - 2135926

Regards,

Suresh

[iti-attunity-sup]

Hello Suresh.
Thank you for your reply.

So,
if MaxTablesInJournalFilter parameter value changed,
is it possible that The R4I UDTF capture over 300 tables, right?

Best regards.

[john_wang]

Hello @iti-attunity-sup ,

You are right. The MaxTablesInJournalFilter can be over 300 however the maximum value is 2000.

Regards,

John.

[iti-attunity-sup]

Hello John
Thank you for your reply.

Is MaxTablesInJournalFilter value for all task or each task?
If create 2 task, the R4I UDTF can capture maximum 4000 tables ?

Best Regards.

[john_wang]

Hello @iti-attunity-sup ,

In my notes the maximum value is 2000 (for an old version of Replicate) however in Replicate 2023.11, the GUI limit the value to 10000 (10K). You may have a try and let me know if it works for you.

Regards,

John.

[iti-attunity-sup]

Hello John
Thank you for your reply.

Do you know which MaxTablesInJournalFilter value is for sum of all task or separated for each individual task?

Best regards.

[john_wang]

Hello @iti-attunity-sup ,

The parameter is in Endpoint, it takes effective for an individual task. Certainly it works for all tasks which utilize this endpoint.

Regards,

John.

[iti-attunity-sup]

Hello John.

Thank you for your reply.

So,
if MaxTablesInJournalFilter parameter value is set 2000,
is it possible to create following task?(use same source endpoint)

task1：2000tables
task2：2000tables

Is it OK that sum of tables count in all task is over MaxTablesInJournalFilter parameter value?(even if MaxTablesInJournalFilter parameter value is 10000)

Best regards.

[john_wang · Accepted solution]

Hello @iti-attunity-sup ,

You are right. Both task1 and task2 can contain 2000 tables.

Regards,

John.