topic Re: How to execute full load while locked ? (AS400) in Qlik Replicate

How to execute full load while locked ? (AS400)

iti-attunity-sup — Fri, 29 Aug 2025 01:34:16 GMT

Hello

source : AS400

When full load, error like following output.(log edit)

[SOURCE_UNLOAD ]E: RetCode: SQL_ERROR SqlState: 07005 NativeError: -227 Message: [IBM][System i Access ODBC Driver][DB2 for i5/OS]SQL0227 - FETCH xxxxxxxxxx. [1022502] (ar_odbc_stmt.c:3435)
[SOURCE_UNLOAD ]E: UNSUCCESSFUL EXECUTION CAUSED BY DEADLOCK OR TIMEOUT error encountered while FETCH-ing data from table 'schema.table' [1020439] (db2i_endpoint_unload.c:490)
[TASK_MANAGER ]W: Table 'schema'.'table' (subtask 1 thread 0) is suspended. RetCode: SQL_ERROR SqlState: 07005 NativeError: -227 Message: [IBM][System i Access ODBC Driver][DB2 for i5/OS]SQL0227 - FETCH xxxxxxxxxxxx.; UNSUCCESSFUL EXECUTION CAUSED BY DEADLOCK OR TIMEOUT error encountered while FETCH-ing data from table 'schema.table' (replicationtask.c:3231)

We would like to execute full load while locked (load data which is before locked ).

Would you tell me how to do ?

Best Regards.

Re: How to execute full load while locked ? (AS400)

Dana_Baldwin — Fri, 29 Aug 2025 15:54:44 GMT

Hi @iti-attunity-sup

Please try the suggestion on this Community post and let us know if this helps:

How to Filter Table that has heavy updates and loc... - Qlik Community - 1781768

Thanks,

Dana

Re: How to execute full load while locked ? (AS400)

iti-attunity-sup — Mon, 01 Sep 2025 03:05:38 GMT

Hello Dana.
Thank you for your reply.

Is it able to set this filter by Global Rules ?

Best Regards.

Re: How to execute full load while locked ? (AS400)

john_wang — Mon, 01 Sep 2025 15:34:47 GMT

Hello @iti-attunity-sup ,

The filter is not meant to exclude rows; rather, it is used to pass the read isolation statement to DB400. You do not need to apply it to all tables in the Global Rules. Instead, it is intended for use with only a few very large tables, and should be applied at the individual table level only.

Regards,

John.

Re: How to execute full load while locked ? (AS400)

iti-attunity-sup — Tue, 02 Sep 2025 00:37:21 GMT

Hello John.
Thank you for your reply.

So, is what you mean that it is possible to set by Global Rules, but you recommend to set for individual table ?

Best Regards.

Re: How to execute full load while locked ? (AS400)

john_wang — Tue, 02 Sep 2025 00:41:07 GMT

Hello @iti-attunity-sup ,

Not really. The Global Filter cannot pass the read isolation SQL statement to backend database.

Regards,

John.

Re: How to execute full load while locked ? (AS400)

john_wang — Tue, 16 Sep 2025 03:25:03 GMT

Thank you for your support! @iti-attunity-sup