Using DB2 on zOS as a target endpoint

[aoph]

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

[Steve_Nguyen · Accepted solution]

that is correct :

https://help.qlik.com/en-US/replicate/May2022/Content/Replicate/Main/Support%20Matrix/supported_targ...

[john_wang · Accepted solution]

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 e... .

Hope this helps.

Regards,

John.

[aoph]

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 

[Steve_Nguyen]

ODBC endpoint support both Windows and Linux

https://help.qlik.com/en-US/replicate/May2022/Content/Replicate/Main/Support%20Matrix/supported_targ...

[john_wang]

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.

[aoph]

Thanks a lot for your help !

Best regards

Arnt

[john_wang]

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.