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.