DB2 Packages
- Last Updated: May 15, 2020
- 2 minute read
- DataDirect Connectors
- JDBC
- IBM Db2 5.1
- MySQL 5.1
- Progress OpenEdge 5.1
- SAP Sybase 5.1
- Documentation
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).