IBM Books

Quick Beginnings for UNIX


Binding Database Utilities

You must bind the database utilities (import, export, reorg, the command line processor) and DB2 CLI bind files to each database before they can be used with that database. In a network environment, if you are using multiple clients that run on different operating systems or are at different versions or service levels of DB2, you must bind the utilities once for each operating system and DB2-version combination.

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

The bind files are grouped together in different .lst files in the bnd directory, under the installation directory (typically sqllib). Each file is specific to a server.

Binding to Host Databases

To bind the utilities and applications to the DRDA server, connect to the DRDA server and use commands similar to the following:

   connect to dbalias user userid using password
   bind path/bnd/@ddcsmvs.lst blocking all sqlerror continue
           messages mvs.msg grant public
   connect reset

where path corresponds to the DB2PATH registry value. These commands are described in detail in the DB2 Connect User's Guide.


[ Top of Page | Previous Page | Next Page | Table of Contents | Index ]

[ DB2 List of Books | Search the DB2 Books ]