Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
rahulkokane
Contributor II
Contributor II

Unable to connect to db2/zos server using endpoint for Areplicate 2023 May

Hi,

 

we are testing new Areplicate version of 2023 May on our development environment.

We are using db2 driver with version v11.5.9

We are getting error :

But on checking the same, the file /odbc_cli/clidriver/lib/libdb2.so is present inside the directory.


Is there any compatibility issue with the driver version?

Any input would be much appreciated.

 

Thanks,

Rahul

Labels (1)
8 Replies
Dana_Baldwin
Support
Support

Hi @rahulkokane 

Yes Replicate 2023.5 supports driver versions 11.5.6 and 11.5.8 only for DB2 on z/OS. The error message isn't related to this however, the driver file isn't in the file system path.

Please follow all the setup guidance in the User Guide here: Prerequisites #Prerequisites | Qlik Replicate Help

Thanks,

Dana

Yadunandan
Employee
Employee

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,
Yadunandan

DesmondWOO
Support
Support

Hi @rahulkokane ,

Please make sure that the driver is defined in the LD_LIBRARY_PATH within site_arep_login.sh file. Execute arep_login.sh file before starting Replicate service.

Regards,
Desmond

Help users find answers! Do not forget to mark a solution that worked for you! If already marked, give it a thumbs up!
rahulkokane
Contributor II
Contributor II
Author

Hi,

Thank you, we do have LD_LIBRARY_PATH defined and also libdb2.so file present under mentioned directory path.

Also went through the documentation you shared.

What else can we look for/ missing things?

Regards,

Rahul

 

john_wang
Support
Support

Hello @rahulkokane ,

Please make sure you are installing 64-bit driver for example v11.5.8_linuxx64_server_dec.tar.gz, 32-bit ODBC Driver are not supported.

Regards,

John.

Help users find answers! Do not forget to mark a solution that worked for you! If already marked, give it a thumbs up!
rahulkokane
Contributor II
Contributor II
Author

hi @john_wang 

we have installed 64-bit driver and tried using the same.

rahulkokane
Contributor II
Contributor II
Author

Can you please try replicating the same scenario at your side with Amazon Linux once?

thanks

john_wang
Support
Support

Hello @rahulkokane ,

Could you please make sure the "isql" works? It accesses the DB2z predefined DSN via ODBC APIs, as similar as Replicate. If it works then Replicate should work as well.

Troubleshooting the DB2z connection issue by using "isql" is much easier than within Replicate.

Hope this helps,

John.

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