Troubleshooting
Problem
All DB2 commands fail with the following error db2: symbol lookup error: db2: undefined symbol: clp_api
Cause
This is caused due to use of non-DB2 version of libdb2.so.1 library
Diagnosing The Problem
Check which libdb2.so.1 is being used by running the following command
ldd ~/sqllib/bin/db2
Resolving The Problem
Any one of the below options
Remove the libdb2.so.1 library path in LD_LIBRARY_PATH so the path is not checked and DB2 libdb2.so.1 library is used
Remove the non DB2 libdb2.so.1 library
Copy the DB2 version of libdb2.so.1 library to the path specified in LD_LIBRARY_PATH
[{"Product":{"code":"SSEPGG","label":"Db2 for Linux, UNIX and Windows"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Component":"DB2 Tools - Troubleshooting","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"Version Independent","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Was this topic helpful?
Document Information
Modified date:
16 June 2018
UID
swg21670399