skip to main content
DataDirect Connect Drivers : DB2 Driver : DB2 Packages : Creating DB2 Packages Using Package Creation List Files
  
Creating DB2 Packages Using Package Creation List Files
Note: The user ID creating the DB2 packages must have BINDADD privileges on the database. Consult with your database administrator to ensure that you have the correct privileges.
To explicitly create DB2 packages, bind the appropriate package creation list files for your operating system on your database server (see the following table). When you bind the list files, if any DB2 packages exist, they will be replaced by the new packages. The list files create DB2 packages that contain 200 dynamic sections and are created in the NULLID collection.
Table 23. DB2 Package Creation List Files/Location
File
Location
DDJDBC_LUW.lst
installdir /DB2/bind/LUW
DDJDBC_400.lst
installdir /DB2/bind/iSeries
DDJDBC_MVS.lst
installdir /DB2/bind/zOS
To explicitly create DB2 packages:
1. Copy the appropriate list (*.lst) and bind (*.bnd) files to a directory on the database server.
2. From the directory on the database server where you placed the list and bind files, start the DB2 command-line utility.
3. Using the DB2 command-line utility, connect to the database where you want to bind the packages 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.
4. Execute the DB2 bind command:
bind @ list_file grant public
where list_file is the name of the list file you want to bind.