IBM Support

Download bind files for Db2 11.5, 11.1, and 10.5 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 your runtime client is of a different release or fix pack level than the database server, then you first need to bind the .bnd files associated with your runtime client to the database.

A new Db2 database server can accept connections from various remote clients, with each client able to run utilities that are associated with specific bind files. This situation makes it difficult to track down the bind files for each version of remote client that is connecting to your server.

For example, suppose you deploy a new database created on Db2 11.5.5.1. An application that is executing on a remotely connected client can be running an older version of the Db2 runtime client, such as Db2 11.1.4.4. If the application attempts to use a utility like CLP, Import, or Export, the application might generate an SQL0805N error. This error can occur because the package associated with the older version of the utility was not bound to the new database. You need to bind the packages using the bind files from the client version.

Links are provided in the Related information section of this page for downloading the BIND files that you need.

Answer

Included in this tech note are .tar files that contain the bind files for all Db2 11.5, 11.1, and 10.5 fix packs

How to use the tar file:

  1. Download the .tar file to your computer.
  2. Extract the files:

    tar -xvf <tarfilename>
     
  3. Locate the sub-directory for the fix pack that you want to bind.
  4. Identify the bind files that you need and run the DB2 BIND command to bind the packages to your database.


The needed BIND Command syntax is included in each .tar file.

Related Information

DB2 11.5 for Linux, UNIX, and Windows.
Tar file with all bind files for all fix packs of Db2 V11.5.
 
DB2LUW_v11.5_bindfiles_fp00_through_m8fp00.tar.gz
Db2 11.1 for Linux, UNIX, and Windows.
Tar file with all bind files for all fix packs of Db2 V11.1.
 
DB2LUW_v11.1_bindfiles_fp00_through_m4fp05.tar.gz
Db2 10.5 for Linux, UNIX, and Windows.
Tar file with all bind files for all fix packs of Db2 V10.5.
 
DB2LUW_v10.5_bindfiles_fp00_through_fp11.tar.gz

[{"Type":"MASTER","Line of Business":{"code":"LOB10","label":"Data and AI"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSEPGG","label":"Db2 for Linux, UNIX and Windows"},"ARM Category":[{"code":"a8m500000008PkiAAE","label":"Administrative Tools"}],"ARM Case Number":"","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF010","label":"HP-UX"},{"code":"PF016","label":"Linux"},{"code":"PF027","label":"Solaris"},{"code":"PF033","label":"Windows"}],"Version":"10.5.0;11.1.0;11.5.0;11.5.1;11.5.2;11.5.3;11.5.4;11.5.5;11.5.6;11.5.7;11.5.8"},{"Type":"MASTER","Line of Business":{"code":"LOB10","label":"Data and AI"},"Business Unit":{"code":"BU053","label":"Cloud \u0026 Data Platform"},"Product":{"code":"SSEPDU","label":"Db2 Connect"},"ARM Category":[{"code":"a8m3p000000Go7xAAC","label":"Installation"}],"Platform":[{"code":"PF002","label":"AIX"},{"code":"PF010","label":"HP-UX"},{"code":"PF016","label":"Linux"},{"code":"PF027","label":"Solaris"},{"code":"PF033","label":"Windows"}],"Version":"10.5.0;11.1.0;11.5.0"},{"Type":"MASTER","Line of Business":{"code":"","label":""},"Business Unit":{"code":"BU053","label":"Cloud \u0026 Data Platform"},"Product":{"code":"SSSNY3","label":"IBM Data Server Client Packages"},"ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"11.5.0"}]

Document Information

Modified date:
03 February 2023

UID

swg21501302