DB2 graphic  QMF Version 8

Advanced binding options

Optional: Click Advanced to specify additional binding options that will be used to bind the QMF for Windows packages. The Bind Options window has five tabs:

Identification page

Use the Identification page to specify identification options such as the collection ID, owner ID, qualifier and comments, and to specify what to do with existing packages and authorizations.

FIELDS

Collection ID

Optional: Specify an identifying name that will be used to bind the collection of QMF for Windows packages.

The collection ID you specified in the Collection ID field of the Package Properties page of the Packages Wizard or the Collection ID field of the Packages page of the Parameters window is inserted in this field automatically. If you change the collection ID here, it is also changed in the other collection ID fields.

The Collection ID is used in conjunction with the Owner ID and the Qualifier to uniquely identify the collection.

Owner ID

Optional: Specify a user ID that will be used to bind the QMF for Windows packages. The ID that grants you authority at the server to execute the SQL contained in the package. The owner ID enables you to CREATE tables, bind packages, create views on system tables, and grant EXECUTE authority on these packages.

In order to bind the QMF for Windows packages, your user ID must have the authority at the database server to run the SQL that the packages contain. If your primary user ID has the required authority and privileges, you can leave this field blank.

If you have a secondary authorization ID that you use for administrative tasks, specify it in this field. The owner ID you specified in the Owner ID field of the Package Properties page of the Packages Wizard is inserted in this field automatically. If you change the owner ID here, it is also changed in the other owner ID field.

Qualifier

Optional: Specify a qualifier that will be used in addition to the Collection ID and the Owner ID to identify the QMF for Windows packages.

The name of the collection consists of the collection ID, owner ID, and qualifier, such as DBA.Q.QFW81.

Comments

Optional: Type a comment with a maximum of 80 characters.

Replace Existing Packages

Optional: Check this check box to replace the QMF for Windows packages on a database server with the specified Collection ID with the new QMF for Windows packages.

If you check this box all packages are replaced when you install a new version or service release of DB2 QMF for Windows. All clients with a full QMF for Windows installation will need to upgrade to the new version as well. Otherwise, all QMF for Windows installations with older versions will not be able to connect to the server.

Keep Existing Authorization

Optional: Check this check box to keep the authorizations that are specified for the existing QMF for Windows packages. If you check this check box, the Keep existing authorizations on packages check box on the Bind packages page of the Packages wizard is also checked. Any changes made to one of these check boxes is also automatically made to the other check box.

Formats page

Use the Formats page to specify the decimal and string delimiters and the date and time formats to use on the database server.

FIELDS

Decimal Delimiter

Specify the character that will be used by QMF for Windows for a decimal point in the SQL statements that are run on this database server:

String Delimiter

Specify the character used to separate character strings in the SQL statements that are run on this database server.

Date Format

Specify how dates are to be formatted for this database server.

Time Format

Specify how times are to be formatted for this database server.

Statement Performance page

Use the Statement Performance page to specify the isolation level, query blocking, data release, degree of parallelism, and query optimization options.

FIELDS

Isolation Level

Use this field to specify how much to isolate QMF for Windows from the effects of other running applications.

The isolation level describes the degree to which the data being updated is visible to other transactions.

Query Blocking

Use this option to specify the blocking protocol QMF for Windows will use.

The query blocking facility uses rules established by the administrator to govern end-user query times to avoid consuming system resources.

Release

Use this option to specify when the RDB will release the resources used by QMF for Windows.

This option controls whether to commit work with release at the completion of the stage, or roll back work with release when a negative return code is received from DB2.

Degree of Parallelism

Use this field to enter the required information if your database supports a degree of parallelism option. For more information on Degree of Parallelism options, refer to your database product's documentation.

This option optimizes (tunes) the SQL by running the SQL in different partitions or on different processors

Query Optimization

Use this field to enter the required information if your database supports query optimization For more information on Query Optimization options, refer to your database product's documentation.

Query optimization identifies possible access paths for the SQL statements, computes the access cost for each, selects the lowest-cost access path, then produces executable code.

Statements page

Use the Statements page to specify the explain, time validation, and SQL warnings options.

FIELDS

Explain

Use this option to specify whether QMF for Windows will gather and record explain data during processing.

The EXPLAIN function lets you look at the access and processing choices actually made by the optimizer, which allows you to fine-tune your SQL code to improve performance. This is a useful tool when you BIND or REBIND.

Explain Snapshot

Use this option to specify whether QMF for Windows will gather and record a snapshot version of the explain data during processing.

Output from the EXPLAIN command is written to the PLAN_TABLE. The snapshot provides information for tuning queries.

Validate Time

Use this option to specify when packages are validated in your database environment.

Return SQL Warnings

Check this check box to have any SQL warnings issued during the validation process returned. For more information on the Return SQL Warnings options, refer to your database product's documentation.

Miscellaneous page

Use the Miscellaneous page to specify dynamic rules, character sub-types, and generic options.

FIELDS

Dynamic rules

Use this option to specify the dynamic rules that are specific to your database environment.

Character Sub-type

Use this option to specify the character sub-types for your database environment.

Generic options

Specify any generic options that are required in your database environment. For more information on Generic Options options, refer to your database product's documentation.


Go to the previous page Go to the next page

Downloads | Library | Support | Support Policy | Terms of use | Feedback
Copyright IBM Corporation 1982,2004 Copyright IBM Corporation 1982, 2004
timestamp Last updated: March, 2004