topic Re: Qlik Replicate support IBM DB2 Warehouse in Qlik Replicate

Qlik Replicate support IBM DB2 Warehouse

MTRETMSLTP — Tue, 20 Feb 2024 01:32:23 GMT

May I check with Qlik's support that can Qlik Replicate support IBM DB2 Warehouse (version 11.5). We found Qlik Replicate support IBM DB2 LUW (version 11.5) in Qlik official site, but we are not sure that it's support IBM DB2 Warehouse.

Re: Qlik Replicate support IBM DB2 Warehouse

john_wang — Tue, 20 Feb 2024 01:56:33 GMT

Hello @MTRETMSLTP ,

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

I'm assuming you are talking about the IBM DB2 Warehouse as source endpoint. Qlik Replicate CDC depends upon transaction logging of the captured tables (DATA CAPTURE CHANGES). This feature is standard for DB2 row-organized tables, but not for column-organized tables. In the current Qlik Replicate versions it's not supported yet. The good news is Qlik PM and R&D are looking into supporting it. Please open Feature Request to vote the function if you like.

Hope this helps.

John.

Re: Qlik Replicate support IBM DB2 Warehouse

MTRETMSLTP — Tue, 20 Feb 2024 09:25:21 GMT

Hi John,

The IBM DB2 warehouse in Maximo, and Maximo requires DB2WH in row-organized tables. We will deploy DB2WH to row-organized table mode in the first task.

So, can Qlik Replicate support DB2WH in row-organized table mode?

Best regards,

Terry.

Re: Qlik Replicate support IBM DB2 Warehouse

john_wang — Tue, 20 Feb 2024 12:35:19 GMT

Hello Terry, @MTRETMSLTP ,

Thank you so much for the feedback. I'm afraid I have not too much information this time. I'd like suggest you go ahead with DB2WH in row-organized table mode and report any issue you may hit.

Good luck,

John.

Re: Qlik Replicate support IBM DB2 Warehouse

SushilKumar — Thu, 22 Feb 2024 10:57:55 GMT

Hello team,

If our response has been helpful, please consider clicking "Accept as Solution". This will assist other users in easily finding the answer.

Regards,

Sushil Kumar