This is an old revision of the document!
If you are going to connect to a localhost IBM DB2 database you do not need to setup any additional libraries to use SQLines Data tool as they are already supplied with IBM DB2 server.
If you need to connect to a remote IBM DB2 database, you need to have DB2 Runtime Client or IBM Data Server Driver Package installed in your system.
First check if you already have the IBM DB2 library:
Before running sqldata command, add the DB2 library location to LD_LIBRARY_PATH:
export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:<db2_client_lib>
For example:
export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:/opt/ibm/db2/V11.1/lib64
If you get “Error allocating environment handle” error during connection to IBM DB on Linux host due to lack of permissions. Try ti run ./sqldata tool under sudo su - db2inst or other appropriate user from DB2ADMIN group.