Qlik Replicate task error

[Megha_More]

Hi Team,

Got the below error while using IBM DB2 for iseries as source and big query as a target in a task.

Task 'LogStream_Parent_Task' failed
Build tables list failed 
Cannot get captured tables list
Failed to get the capture list from the endpoint
RetCode: SQL_ERROR  SqlState: HY000 NativeError: -666 Message: [IBM][System i Access ODBC Driver][DB2 for i5/OS]SQL0666 - SQL query exceeds specified limit or threshold.
Failed (retcode -1) to execute statement: 'select TABLE_SCHEMA,TABLE_NAME from QSYS2.SYSTABLES where ( 
( /* Explicit */ 

Can you please suggest any solution on this?

Thanks,

Megha

[sureshkumar]

Hello @Megha_More 

DB2 server configuration
In rare situations, the following error might be encountered when using the IBM DB2 for iSeries endpoint in a replication task:

SQL0666N SQL query exceeds specified time limit or storage limit

To prevent this error from occurring, set the following attributes for the Replicate Job/UserID(s):

QRYSTGLMT=*NOMAX

QRYTIMLMT=*NOMAX

For more information, see

https://www.ibm.com/docs/en/i/7.4?topic=ssw_ibm_i_74/cl/chgqrya.htm

Solved: DB2 - SQL0666 SQL query exceeds specified time lim... - Qlik Community - 1735877

ODBC Query Timeout Property: SQL0666 Estimated Query Processing Time Exceeds Limit (ibm.com)

Regards,
Suresh

[Megha_More]

Hi @sureshkumar ,

Thank you for the respond,

I wanted to know that, is there any limit for adding table in log stream task ?

because in our scenario there are total 184 tables, so is it affecting a task in any manner in future ?

Thanks,

Megha

[sureshkumar]

Hello @Megha_More 

Its not related to number of tables in Log stream task. We have seen the customer replicating 1000 tables in a single task without any issue.

As its coming from DB2, your DBA can help you on this.

Regards,
Suresh

[SushilKumar]

Hello team,

I addition to previous Tse comment. Try to add Table in small batches. 

segregate the table. in multiple task like tables Have PK. separate table which have LOBS

following this you may have better control over the task and it 1s easy for QR replicate to get the info from the database in timely manner 

Regards,

Sushil Kumar

[Megha_More]

Hi @SushilKumar ,

We will try with mentioned solution.

Thank you for the responed.

Regards,

Megha