Installing the DB2 Database Client

1. Ensure db2 is installed. Ensure that the installation directory is in the PATH.

2. Locate and Install DB2 utility "IBM Data Server Runtime Client" from the IBM Support area. See Client Packages or https://www.ibm.com/support/pages/download-initial-version-115-clients-and-drivers

   1. Untar the download file: tar zxvf <tar_file>

   2. Run setup:

      1. cd <untar_dir>

      2. ./db2setup (may need to update OS libraries by running "yum update")

3. Verify db2 client setup

   • At the command prompt, run:
     

     db2 ?

On success
Db2 displays the version number of the db2 client

On error
SQL10007N Message "-1390" could not be retrieved. Reason code: "3"

• Your db2 client is not setup correctly. To fix this error, run the db2icrt command as documented at https://www.ibm.com/support/knowledgecenter/en/SSEPGG_11.1.0/com.ibm.db2.luw.admin.cmd.doc/doc/r0002057.html
  

  DB2DIR/instance/db2icrt -s ese -u < user> <db2 instance>