DB2 Version 10.1 for Linux, UNIX, and Windows

db2jdbcbind - DB2 JDBC package binder command

This utility is used to bind or rebind the JDBC packages to a DB2® database.

JDBC and CLI share the same packages. If the CLI packages have already been bound to a database, then it is not necessary to run this utility and vice versa.

Authorization

One of the following authorities:

DBADM
BINDADD privilege if a package does not exist, and one of:
- IMPLICIT_SCHEMA authority on the database if the schema name of the package does not exist
- CREATEIN privilege on the schema if the schema name of the package exists
ALTERIN privilege on the schema if the package exists
BIND privilege on the package if it exists

Required connection

This command establishes a database connection.

Command syntax


>>-db2jdbcbind--+------+---------------------------------------->
                '-help-'   

>---url jdbc:db2://servername:portnumber/dbname----------------->

>-- -user -username-- -password -password----------------------->

>--+-----------------------------+------------------------------>
   '- -collection--collection ID-'   

>--+----------------------------+------------------------------->
   '- -size--number of packages-'   

                 .-,------------------------------.   
                 V                                |   
>-- -tracelevel ---+-TRACE_ALL------------------+-+------------><
                   +-TRACE_CONNECTION_CALLS-----+     
                   +-TRACE_CONNECTS-------------+     
                   +-TRACE_DIAGNOSTICS----------+     
                   +-TRACE_DRDA_FLOWS-----------+     
                   +-TRACE_DRIVER_CONFIGURATION-+     
                   +-TRACE_NONE-----------------+     
                   +-TRACE_PARAMETER_META_DATA--+     
                   +-TRACE_RESULT_SET_CALLS-----+     
                   +-TRACE_RESULT_SET_META_DATA-+     
                   '-TRACE_STATEMENT_CALLS------'

Command parameters

-help: Displays help information, all other options are ignored.
-url jdbc:db2://servername:portnumber/dbname: Specifies a JDBC URL for establishing the database connection. The DB2 JDBC type 4 driver is used to establish the connection.
-user username: Specifies the name used when connecting to a database.
-password password: Specifies the password for the user name.
-collection collection ID: The collection identifier (CURRENT PACKAGESET), to use for the packages. The default is NULLID. Use this to create multiple instances of the package set. This option can only be used in conjunction with the Connection or DataSource property currentPackageSet.
-size number of packages: The number of internal packages to bind for each DB2 transaction isolation level and holdability setting. The default is 3. Since there are four DB2 isolation levels and two cursor holdability settings, there will be 4x2=8 times as many dynamic packages bound as are specified by this option. In addition, a single static package is always bound for internal use.
-tracelevel: Identifies the level of tracing, only required for troubleshooting.