topic Re: Error while loading XML data from DB2 z/OS to Postgres(AWS) in Qlik Replicate

Error while loading XML data from DB2 z/OS to Postgres(AWS)

MJSC3006 — Tue, 04 Jun 2024 09:20:06 GMT

Hi Team,

we were facing issues while loading the XML table from Db2 z/OS to RDS Postgres using Attunity (Qlik Replicate). The tables have around 2Million rows, and the max record length is of 47MB. We are receiving below error when we try the load:

RetCode: SQL_ERROR SqlState: 40003 NativeError:
-1224 Message: [IBM][CLI Driver] SQL1224N
The database manager is not able to accept new requests,
has terminated all requests in progress,
or has terminated the specified request because of an error or a forced interrupt. SQLSTATE=55032

=> We tried to break the data into chunks like in 20 different tables each table has around 13k rows. but still we are receiving the same error and we tried to option in the tool like "ALLOW UNLIMITED LOB" and "Limit LOB size to (KB) to 50MB" and breaking still further will be tedious task what if the table has millions of data more? We wanted to understand where the actual issue is? and is there any other option we need to consider for loading XML/LOB data .Kindly review above issue and let us know if further info is required from my end.

Some more info :

Datatype : XML

Source : DB2 zOS V12 and Target : Postgres RDS

Re: Error while loading XML data from DB2 z/OS to Postgres(AWS)

john_wang — Tue, 04 Jun 2024 10:34:48 GMT

Hello @MJSC3006 ,

Welcome to Qlik Community forum and thanks for reaching out here!

There are several different reasons may lead the same error, probably it is from the DB2 environment. Please review DB2 logs for the exact cause.

https://www.ibm.com/support/pages/sql1224n-while-applications-try-connect-database

BTW, how about if you (just for troubleshooting purpose):

1- Exclude the XML (or other LOBs columns) from the replication, or

2- If you replace the target DB by NULL Device.

Hope this helps.

John.

Re: Error while loading XML data from DB2 z/OS to Postgres(AWS)

MJSC3006 — Wed, 05 Jun 2024 08:40:11 GMT

Hi John_wang ,

Please check below response in bold.

1- Exclude the XML (or other LOBs columns) from the replication

=> We are trying to migrate an entire DB2 schema where this XML table is part of .and we need the XML column data to be migrated from Db2 zOS to RDS PG. So, the above point is not appropriate or valid.

2- If you replace the target DB by NULL Device.

=> We are trying to migrate an entire DB2 schema where this XML table is part of .and we need the XML column data to be migrated from Db2 zOS to RDS PG. we don't want to discard any data we need entire data to be loaded.

Let us know if we can setup a quick call and discuss further on this issue

Re: Error while loading XML data from DB2 z/OS to Postgres(AWS)

john_wang — Fri, 07 Jun 2024 14:21:58 GMT

Hello @MJSC3006 ,

The above 2 suggestions are used for troubleshooting purpose only, we went to understand the root cause of the error.

If you require assistance, please open a support ticket and attach the diagnostic packages. Our support team will be more than happy to assist you.

Regards,

John.