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

[rahulkokane]

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 :

• Cannot connect to DB2 zOS Server
• RetCode: SQL_ERROR SqlState: 01000 NativeError: 0 Message: [unixODBC][Driver Manager]Can't open lib '/odbc_cli/clidriver/lib/libdb2.so' : file not found

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

[Dana_Baldwin]

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]

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]

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

[rahulkokane]

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]

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.

[rahulkokane]

hi @john_wang 

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

[rahulkokane]

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

thanks

[john_wang]

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.