How to execute full load while locked ? (AS400)

[iti-attunity-sup]

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.

[Dana_Baldwin]

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

[iti-attunity-sup]

Hello Dana.
Thank you for your reply.

Is it able to set this filter by Global Rules ?

Best Regards.

[john_wang]

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.

[iti-attunity-sup]

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.

[john_wang]

Hello @iti-attunity-sup ,

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

Regards,

John.