50 DB2 Nuggets #20 : Tech Tip - The IBM Data Server Driver Package does not come with traditional BIND command. How can I bind packages then?

Body

Hey there!

 Traditional BIND command is not part of the IBM Data Server Driver Package.

You can use the DB2BINDER utility to bind packages from the IBM Data Server Driver Package.

You can follow the below steps:

Open the DOS command window. Change the directory to your IBM Data Server Driver Package's bnd directory. e.g. C:\Program Files\IBM\IBM DATA SERVER DRIVER\bnd

Run the DB2Binder command from that directory.
e.g.
C:\Program Files\IBM\IBM DATA SERVER DRIVER\bnd>java com.ibm.db2.jcc.DB2Binder -
url jdbc:db2://localhost:50001/sample -user userName-password yourPassword -action
replace -blocking all -package packageName

In the above command, you can replace the parameters with information specific to your environment.

localhost          : Replace this with the host name where your database resides
50001              : Replace this with port number where your DB2 Service is listening
sample            : Replace this with your database name
userName       : Replace this with your userid
yourPassword : Replace this with your password.

Find more options available with DB2Binder here.

Thanks for reading!

-Swati Thorve