Rebind Options Dialog Box

The following fields and controls are used in the Rebind Options dialog box:

Existence Checking
One of the following options:
  • Optional creates a package even if database objects referenced in the DBRM do not exist. Use this option to create a package prior to defining all data objects.
  • Required creates a package only if all database objects referenced in the DBRM exist.
Resource Release
One of the following options:
  • Commit releases database resources after a commit. Provides a high level of concurrency.
  • Deallocation releases database resources when the connection is terminated.
Explain
One of the following options:
  • No Statements disables the EXPLAIN option to create the package without generating descriptive information.
  • All Statements enables the EXPLAIN option to write descriptive information about the package to owner.PLAN_TABLE. This table must exist before you execute the bind.
Package Owner
The AuthID assigned to the package. This DB2 AuthID must have authority to execute all the SQL in the package.
Default Qualifier
The AuthID used to complete any unqualified (one-part) table names in the DBRM file. If you leave this field blank, the Bind Utility uses the current SQLID.