DB2 Version 10.1 for Linux, UNIX, and Windows

Binding utilities to the database

When a database is created, the database manager attempts to bind the utilities in db2ubind.lst and in db2cli.lst to the database. These files are stored in the bnd subdirectory of your sqllib directory.

About this task

Binding a utility creates a package, which is an object that includes all the information needed to process specific SQL and XQuery statements from a single source file.

Note: If you want to use these utilities from a client, you must bind them explicitly. You must be in the directory where these files reside to create the packages in the sample database. The bind files are found in the bnd subdirectory of the sqllib directory. You must also bind the db2schema.bnd file when you create or upgrade the database from a client. See "DB2 CLI bind files and package names" for details.

Procedure

To bind or rebind the utilities to a database, from the command line, invoke the following commands:

   connect to sample
   bind @db2ubind.lst

where sample is the name of the database.