DB2 LUW source Full Load works but Apply Changes fails with db2ReadLog error

[steveosog]

Error reported:

Error loading DB2 CLI library
Error Initializing endpoint. Failed to load libdb2o.so
<Failed to get symbol <db2ReadLog>: No such file or directory> and the dll name: <libdb2o.so>
Failed to get symbol <db2ReadLog>: /opt/ibm/db2/odbc_cli/clidriver/lib/libdb2o.so: undefined symbol: db2ReadLog

Qlik Replicate 7.0.0.402 using DB2 LUW v11.5.5_linuxx64_odbc_cli.tar.gz driver package.

Do I need to use a different driver for CDC?

[john_wang · Accepted solution]

Hello @steveosog ,

I'm guessing you are using a wrong ODBC Client. Please do not use ODBC CLI (it's not Replicate prerequisites) , we need IBM Data Server Client. In Replicate user guide:

1. Install v10.5fp9_linuxx64_server_t.tar.gz;choose to install "client".

if you are using DB2 v11.x then replace 10.5 with 11.1 (please do not use v11.5.5 as it's not certified yet) in the instructions above. There are more detailed info in user guide. 

Hope this helps.

Regards,

John.

[steveosog]

That works!

For other viewers: follow the documentation, install the recommended driver & you should be fine.

Thank you.

[john_wang]

Hello  @steveosog ,

Thanks for your update.

Can you let us know what's your DB2 client and server versions ? it's a good sample for other viewers and support.

Regards,

John.

[steveosog]

I am using the  v11.1.4fp5_linuxx64_server_t.tar.gz driver against a v11.1.4.5 DB2 on AIX server.

Here is my Qlik Replicate environment install script snippet:

# IBM Support Fix Central <https://www.ibm.com/support/fixcentral>
# Qlik Replicate using IBM DB2 for LUW as a Source - Client Prerequisites <https://help.qlik.com/en-US/replicate/November2020/Content/Replicate/Main/IBM%20DB2%20for%20LUW/prer...>

sudo tar -xzvf "${REPLICATESUPPORTDIR}/ec2/v11.1.4fp5_linuxx64_server_t.tar.gz" -C "${REPLICATESUPPORTDIR}/ec2"
sudo "${REPLICATESUPPORTDIR}/ec2/server_t/db2_install" -b /opt/ibm/db2/V11.1 -p CLIENT -f sysreq -y
sudo /opt/ibm/db2/V11.1/instance/db2icrt attunity