Support DB2 DPF (Clustered database) as source

caifeng123 — Thu, 03 Nov 2022 10:51:11 GMT

Hi, I am trying to work with DB2 DPF as a source. This is from the Qlik doc:

Qlik: Clustered database is not supported
Users can define a separate IBM DB2 for LUW database for each of the endpoints in the cluster.

For DB2 DPF, there are 2 options:
1. Each endpoint runs on its own server (hostname is different), which makes separate endpoint easy

2. Endpoints(instance) run on the same server.

Let us say the server has 4 instances running, each instance has a different node number.

In JDBC connection, CONNECTNODE determines which instance to connect

-) My driver is com.ibm.db2.jcc.DB2Driver;
-) My Url is "jdbc:db2://<hostname>:<port>/<dbname>"
-) Connect method is "con = DriverManager.getConnection( url, props )" where props is
props.setProperty("user", "MY_USR");
props.setProperty("password", "MY_PWD");
props.setProperty("CONNECTNODE", "0");

How do I set CONNECTNODE for db2 luw endpoint?

Re: Support DB2 DPF (Clustered database) as source

Bill_Steinagle — Fri, 04 Nov 2022 15:34:31 GMT

Hi,

Thank you for the post to the QDI Forums. For the CONNECTNODE for the DB2 LUW DB to connect to is outside the support of the DB2 LUW Endpoint as we connect to a single instance of DB2 LUW as you define in the Endpoint with Replicate. In order to connect to a partitioned node, you would need to add the following internal parameter on the DB2 LUW endpoint "connectNode". Once you add this internal parameter, you can then amend the value to reflect the node number (PFA example). This will allow you to access all DB2 LUW instances on this Partitioned environment. I do hope this helps and confirms this post.

Example of the Internal Parameter as its default is -1 which means its not set and you would have to set for each Partition of the DB2 LUW Instance:

Regards,

Bill

topic Support DB2 DPF (Clustered database) as source in Qlik Replicate

Support DB2 DPF (Clustered database) as source

Re: Support DB2 DPF (Clustered database) as source