Details of Installation of ODBC client package for DB2/zOS

[Hide_Taira]

Hi Team

Now our team is trying to setup the Qlik Replicate to perform the replication between DB2/zOS (source) and Postgres DB (target), and now we are trying to install ODBC driver on Linux env so have 1 question as below.

>3.Install v11.5.8_linuxx64_server_dec.tar.gz and choose the “CLIENT” option.
https://help.qlik.com/en-US/replicate/May2024/Content/Global_Common/Content/SharedReplicateHDD/IBM4D...

We couldn't find the detailed information about how to install above v11.5.8_linuxx64_server_dec.tar.gz on Linux, so we don't have any idea about our file downloaded would be correct or the valid step of these installation.
So could you please let us know any guide or tips about above installing ODBC driver on Linux if possible? I found the following guide but not sure if this page is valid.

https://www.ibm.com/support/pages/db2-odbc-cli-driver-download-and-installation-information

Best Regards

[john_wang]

Hello @Hide_Taira ,
Thanks for reaching out to Qlik Community!

The IBM Data Server Client installation is simple and straight, below is a sample:

1. ftp upload v11.5.6_linuxx64_server_dec.tar.gz to a temporary folder
   The temporary folder can be purged after installation done, in this sample the folder name is "/kit"
2. Uncompress the tar file and startup the installation program by
   

   # cd /kit
   # tar zxvf v11.5.6_linuxx64_server_dec.tar.gz
   # cd server_dec
   # ./db2_setup

3. Follow the wizard to complete the installation:
   
4. Complete the post installation steps in Qlik Replicate User Guide.

Hope this helps.

John.

[Hide_Taira]

Hi John

Thank you for your quick reply and information. I'll follow your steps but have 1 more question.

I guess it's necessary to update the Linux library path and also site_ arep_login.sh file as below, but it seems that gskit couldn't be found. If you know, could you let me know if we should install gskit to Linux separately and which gskit would be preferred? 

>Example (with db2clnt1 as the instance name):

>export >LD_LIBRARY_PATH=$LD_LIBRARY_PATH:/home/db2clnt1/sqllib/lib:/home/db2clnt1/sqllib/lib64/gskit

 
Best Regards

[john_wang]

Hello @Hide_Taira ,

Thanks for the update. The module "gskit" is useful if you want to setup the SSL connection. Otherwise you may ignore it.

Regards,

John.

[Vegy]

If you don't need the gskit then you can actually survive with the drivers package alone. The drivers package is 35.6MB as opposed to the ~1.5GB client package or the ~1.8GB? server package.

As John mentioned though, if you're intending on using certificate/ssl encryption then you'll need gskit to store the certificates in an IBM keystore.

I have had the drivers only working in a containerised version, will try and dig out config changes required

[john_wang]

thank you so much for your great support @Vegy !

[Vegy]

Apologies been some time but I had cleared away the feature branch containing using Qlik with just the CLI ODBC package instead of the client package. This package is 35MB instead of 635MB (both compressed)

In my example I install the rpm to

/opt/db2_odbc_driver/

The base folder for the db2 CLI and drivers then becomes

/opt/db2_odbc_driver/odbc_cli/clidriver/

This means my odbc.ini and odbcinst.ini reference /opt/db2_odbc_driver/odbc_cli/clidriver/lib/ for the library file

libdb2o.so

I add the export LD_LIBRARY_PATH=/opt/db2_odbc_driver/odbc_cli/clidriver/lib:$LD_LIBRARY_PATH

and thats it, for a container image this is pretty huge because it chops over 1GB down on file size