topic Re: Using DB2 on zOS as a target endpoint in Qlik Replicate

Using DB2 on zOS as a target endpoint

aoph — Wed, 16 Nov 2022 13:05:43 GMT

Hi !

My understanding reading the docomentation is that it's not possible to use DB2 on zOS as a TARGET endpoint for Qlik replicate.

Can you please confirm if my understanding is correct.

Thanks in advance !

Arnt

Re: Using DB2 on zOS as a target endpoint

Steve_Nguyen — Wed, 16 Nov 2022 13:29:41 GMT

that is correct :

https://help.qlik.com/en-US/replicate/May2022/Content/Replicate/Main/Support%20Matrix/supported_target_endpoints.htm#ar_app_supported_dbversions_993761142_1341803

Re: Using DB2 on zOS as a target endpoint

john_wang — Wed, 16 Nov 2022 13:45:11 GMT

Hello @aoph , copy @Steve_Nguyen ,

Agree with Steve. DB2z is not supported as target endpoint in current Replicate versions as no native driver provided yet. However, we may config DB2z as a regular 64-bit ODBC DSN, and access the DSN by generic ODBC target endpoint.

Please take note there are limitations in generic ODBC target endpoint, and we maybe hit performance tuning boundary etc, we need involve PS team, see user guide

unless enabled through Professional Services and approved by your Account Manager, the ODBC target endpoint should not be used .

Hope this helps.

Regards,

John.

Re: Using DB2 on zOS as a target endpoint

aoph — Wed, 16 Nov 2022 14:30:25 GMT

Thanks for your answer ! We are already running DB2 as a target endpoint by the ODBC option, but then our DB2 target endpoint is running on a Red Hat linux. In documentatin only Windws and Red Hat Linux listed as valid endpoints using ODBC. But you think zOS also supported under the ODBC option ?

Arnt

Re: Using DB2 on zOS as a target endpoint

Steve_Nguyen — Wed, 16 Nov 2022 14:38:56 GMT

ODBC endpoint support both Windows and Linux

https://help.qlik.com/en-US/replicate/May2022/Content/Replicate/Main/Support%20Matrix/supported_target_endpoints.htm#ODBC

Re: Using DB2 on zOS as a target endpoint

john_wang — Wed, 16 Nov 2022 14:41:17 GMT

Hello @aoph ,

In documentatin only Windws and Red Hat Linux listed as valid endpoints using ODBC.

The two platforms are meaning where Qlik Replicate is running.

On the Replicate Server (Windows, or Red Hat Linux), the IBM DB2 client should be installed, and the DSN point to DB2 on z/OS mainframe. Replicate access the DB2z via IBM DB2 client/server communication thru TCP/IP.

In summary, your current settings are supported.

Hope this helps.

Regards,

John.

Re: Using DB2 on zOS as a target endpoint

aoph — Thu, 17 Nov 2022 07:22:39 GMT

Thanks a lot for your help !

Best regards

Arnt

Re: Using DB2 on zOS as a target endpoint

john_wang — Sat, 03 Dec 2022 11:25:03 GMT

Hello @aoph ,

Thank you for the feedback.

Help users find answers! Don't forget to mark a solution that worked for you! If already marked, give it a thumbs up!

Regards,

John.