Replicating the LOB column table from DB2 zOS to DB2 LUW

[PriQlikDBA]

Team,

I 'm trying to replicate a table which has 2 XML columns from DB2 zOS v12.1 to DB2 LUW v11.5.8 on Ubuntu (BLU Database) on  using Qlik Replicate.

Below is the DDL description

CREATE TABLE "DB2PROD "."IUW_UNDERWRITE_XML" (

"POLICY_COMPANY_NUM" VARGRAPHIC(2 CODEUNITS16) NOT NULL ,

"POLICY_NUM" VARGRAPHIC(8 CODEUNITS16) NOT NULL ,

"PERSON" VARGRAPHIC(2 CODEUNITS16) NOT NULL ,

"REQ_TYPE" VARGRAPHIC(3 CODEUNITS16) NOT NULL ,

"REQ_SEQ" VARGRAPHIC(3 CODEUNITS16) NOT NULL ,

"TYPE" VARGRAPHIC(1 CODEUNITS16) NOT NULL ,

"VENDOR_ID" VARGRAPHIC(4 CODEUNITS16) NOT NULL ,

"SEND_TS" TIMESTAMP NOT NULL ,

"SEND_XML" CLOB(2147483647 OCTETS) NOT LOGGED NOT COMPACT ,

"RETURN_TS" TIMESTAMP ,

"RETURN_XML" CLOB(2147483647 OCTETS) NOT LOGGED NOT COMPACT ,

"WEB_SERVICE_MSG" VARGRAPHIC(256 CODEUNITS16) NOT NULL )

IN "PRODTBSPACE1" INDEX IN "PRODIXSPACE1" LONG IN "PRODLXSPACE1" NOT LOGGED INITIALLY

ORGANIZE BY COLUMN;

CREATE UNIQUE INDEX "DB2PROD "."IUWUXML2" ON "DB2PROD "."IUW_UNDERWRITE_XML"

("POLICY_COMPANY_NUM" ASC,

"POLICY_NUM" ASC,

"PERSON" ASC,

"REQ_TYPE" ASC,

"REQ_SEQ" ASC,

"SEND_TS" ASC,

"RETURN_TS" ASC)

Change Processing Mode : Transaction Apply

Batch Tuning

Minimum number of changes per transaction:

Maximum time to batch transactions before applying (seconds):

Transaction Offload Tuning

Offload transactions in progress to disk if:

Total transactions memory size exceeds (MB):

Transactions duration exceeds (seconds):

Enabled Verbose logging setting for Target component to capture more details

Issue:

Once the task is started for CDC activity, it stops immediately by throwing an exception error. Tweaked the Task settings for LOB and Change Processing Tuning. Nothing helped.

What would be the recommended settings for LOB tables with XML columns.

Your inputs are very much appreciated.

Thank you,

Raghavan Sampath

[Dana_Baldwin]

Hi @PriQlikDBA 

DB2 LUW target is only supported via an ODBC target endpoint. This necessitates working with our Professional Services team to implement it. Please contact your Account Manager if you are not already working with Professional Services. If it is a POC, they may also be able to help you connect with presales if this involves adding to your license.

"The ODBC target endpoint can be used to access targets that are not included in Qlik Replicate’s extensive Support Matrix. However, unless enabled through Professional Services and approved by your Account Manager, the ODBC target endpoint should not be used."

Copied from:

Using ODBC to connect to a target #Using ODBC to connect to a target | Qlik Replicate Help

The log seems to indicate that there is a duplicate value caused by an insert or update for table DB2PROD.IUW_UNDERWRITE_XML.

There also are log entries consistent with a process crash.

For general information regarding the types of issues Support handles compared to Professional Services, please see:

https://community.qlik.com/t5/Official-Support-Articles/How-and-when-to-contact-Qlik-s-Professional-...

https://community.qlik.com/t5/Official-Support-Articles/How-to-contact-Qlik-Support/ta-p/1837529

Thanks,

Dana

[john_wang]

Hello @PriQlikDBA ,

In addition to @Dana_Baldwin 's comment:

1. I’ve removed the attached task log file since it may contain sensitive information.

2. Please decrypt the verbose task log file — you’ll find the exact cause around line #532.

Regards,

John.