skip to main content
DataDirect Connect Drivers : DB2 Driver : DB2 Packages
  
DB2 Packages
The DB2 driver automatically creates all required DB2 packages the first time it connects to the database. By default, the DB2 packages contain 200 dynamic sections and are created in the NULLID collection (or library). You can override the default number of dynamic sections by setting the DynamicSections property. Similarly, you can override the collection in which the packages are created by setting the PackageCollection property.
Note: The initial connection may take a few minutes because of the number and size of the packages that must be created for the connection. Subsequent connections do not incur this delay. When the driver has completed creating packages, it writes the following message to the standard output: DB2 packages created.
In most cases, you do not need to create DB2 packages because the DB2 driver automatically creates them the first time it connects to the database. If you need to explicitly create them, you can create them using any of the following methods:
*Using the DataDirect DB2 Package Manager, a Java graphical tool that makes it easy for you to create, drop, and replace DB2 packages. See Creating DB2 Packages Using the Package Manager for instructions.
*Using DB2 driver connection properties specified in a connection URL or data source. See Creating DB2 Packages Using Connection Properties for instructions.
*Running the appropriate DB2 package creation list file for your operating system on the database server. See Creating DB2 Packages Using Package Creation List Files for instructions.
*On z/OS and i only, copy the packages that are installed with the driver as described in Copying the DB2 Packages (z/OS and i).
* Creating DB2 Packages Using the Package Manager
* Creating DB2 Packages Using Connection Properties
* Creating DB2 Packages Using Package Creation List Files
* Copying the DB2 Packages (z/OS and i)