Creating DB2 Packages Using Connection Properties
- Last Updated: May 15, 2020
- 1 minute read
- DataDirect Connectors
- JDBC
- IBM Db2 5.1
- MySQL 5.1
- Progress OpenEdge 5.1
- SAP Sybase 5.1
- Documentation
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.
The following table lists the connection properties you can use to explicitly create DB2 packages.
| Property | Database |
|---|---|
PackageCollection=
collection_name (where collection_name is the
name of the collection or library to which DB2 packages are bound) |
DB2 for z/OS and i |
CreateDefaultPackage=true
|
DB2 for Linux/UNIX/Windows, z/OS, and i |
ReplacePackage=true
|
DB2 for Linux/UNIX/Windows |
DynamicSections=
x (where x is a positive integer) |
DB2 for Linux/UNIX/Windows, z/OS, and i |
Note: To create new DB2 packages on DB2 for Linux/UNIX/Windows, you must use
ReplacePackage=true in conjunction with
CreateDefaultPackage=true. If a DB2 package already exists, it will be
replaced when ReplacePackage=true.