You can bind the following list files on your database server to create Db2 packages:

  • DDODBC_LUW.lst (Db2 for Linux/UNIX/Windows, Db2 Hosted, and Db2 Warehouse on Cloud)
  • DDODBC_MVS.lst (Db2 for z/OS)
  • DDODBC_400.lst (Db2 for i)

The list files are located in the \bind\LUW, \bind\zOS, and \bind\iSeries directories, respectively, in your installation directory. When you bind the list files, if any DataDirect Db2 packages exist, they will be replaced by the new packages. The list files create Db2 packages that, by default, contain 200 dynamic sections and are created in the NULLID collection. You can override the default number of dynamic sections and the collection in which the packages are created by changing the appropriate connection option in the data source, as described previously.

To create Db2 packages by binding list files:

  1. Copy the appropriate list (*.lst) file and bind (*.bnd) files located in the /bind directory to a directory on the database server.
  2. From the database server directory where you placed the list and bind files, start the Db2 command-line utility. Use the utility to connect to the database where you want to bind the packages. Connect using the following command:

    connect to database_name user authorization_name using password

    where:

    database_name is the name of the database to which you are connecting.

    authorization_name is the name of the user you are authenticating to the server.

    password is the user’s password.

  3. Execute the Db2 bind command:

    bind @ list_file grant public

    where list_file is the name of the list file you want to bind.