IBM Support

Download DB2 LUW bind files for v10.1, v9.7, v9.5, v9.1 and v8 fix packs

Question & Answer


Question

How can I acquire the bind files (.bnd) that are included for a specific version and fix pack?

Cause

Included in every DB2 install image are bind files (sqllib/bnd/*.bnd) containing the packages for various database and CLI utilities. Many of these bind files correspond to utilities that are incorporated into the Runtime client. If you are using a Runtime client with a different release or fixpack version then the database server, then it is often necessary to bind the .bnd files associated with that Runtime client version to the database before it can be used.

When creating a new database that may accept connections from various remote clients which may run these utilities, it is often difficult to track down the .bnd files from each client version.

For example:
Suppose you deploy a new database created on DB2 10.5fixpack8, An application that is executing on a remotely connected client may be running a DB2 Runtime client of version 9.7 fixpack4. If the application attempts to use a utility (such as CLP, Import, Export, etc...) it could generate an SQL0805N error because the package associated with this version of the utility was not bound to the new database. You will have to bind the packages using the bind files from client version.
With this technote, you can download the bind files for any version.

Answer

Included in this technote are tar files that contain the .bnd files for the fix packs from DB2 11.1, 10.5, 10.1, 9.7, 9.5, 9.1, and 8.2

How to use the tar file:

  1. Download the tar file to your computer.
  2. Extract or untar the files to use them using the command:

    tar -xvf <tarfilename>
     
  3. Locate the subdirectory for the fix pack you wish to bind
  4. Identify the bind files required and use the DB2 BIND command to bind the packages to your database.


The Related Information section contains a link to the BIND Command syntax.

Related Information

BIND command syntax

(For bind files for v10.5, v11.1, or newer releases, see http://www-01.ibm.com/support/docview.wss?uid=swg21501302).

DB2 Version 10.1 for Linux, UNIX, and Windows
Tar file with all bind files for all fix packs of DB2 V10.1		 DB2LUW_v10.1_bindfiles_fp00_through_fp05.tar.gzDB2LUW_v10.1_bindfiles_fp00_through_fp05.tar.gz
DB2 Version 9.7 for Linux, UNIX, and Windows
Tar file with all bind files for all fix packs of DB2 V9.7		 DB2LUW_v9.7_bindfiles_fp00_through_fp11.tar.gzDB2LUW_v9.7_bindfiles_fp00_through_fp11.tar.gz
DB2 Version 9.5 for Linux, UNIX, and Windows
Tar file with all bind files for all fix packs of DB2 V9.5		 DB2LUW_v9.5_bindfiles_fp00_through_fp10.tar.gzDB2LUW_v9.5_bindfiles_fp00_through_fp10.tar.gz
DB2 Version 9.1 for Linux, UNIX, and Windows
Tar file with all bind files for all fix packs of DB2 V9.1		 DB2LUW_v9.1_bindfiles_fp00_through_fp12.tar.gzDB2LUW_v9.1_bindfiles_fp00_through_fp12.tar.gz
DB2 UDB Version 8.2 for Linux, UNIX, and Windows
Tar file with all bind files for all fix packs of DB2 V8		 DB2LUW_v8.2_bindfiles_fp7_through_fp18.tar.gzDB2LUW_v8.2_bindfiles_fp7_through_fp18.tar.gz

 

[{"Product":{"code":"SSEPGG","label":"Db2 for Linux, UNIX and Windows"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Component":"Programming Interface - Bind","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF010","label":"HP-UX"},{"code":"PF016","label":"Linux"},{"code":"PF027","label":"Solaris"},{"code":"PF033","label":"Windows"}],"Version":"9.7;9.5;9.1;8.2;10.1;10.5;11.1","Edition":"Advanced Enterprise Server;Enterprise Server;Express;Personal;Workgroup Server","Line of Business":{"code":"LOB10","label":"Data and AI"}},{"Product":{"code":"SSEPDU","label":"Db2 Connect"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Component":" ","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF010","label":"HP-UX"},{"code":"PF016","label":"Linux"},{"code":"PF027","label":"Solaris"},{"code":"PF033","label":"Windows"}],"Version":"9.7;9.5;9.1;10.1;10.5;11.1","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}},{"Product":{"code":"SSSNY3","label":"IBM Data Server Client Packages"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Component":" ","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF010","label":"HP-UX"},{"code":"PF016","label":"Linux"},{"code":"PF027","label":"Solaris"},{"code":"PF033","label":"Windows"}],"Version":"9.7;9.5;9.1;10.5;10.1;11.1","Edition":"All Editions","Line of Business":{"code":"","label":""}}]

Document Information

Modified date:
01 October 2018

UID

ibm10733623

Page Feedback