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:
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
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.
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:
There is no decimal delimiter specified for this database server.
A period will be used as the decimal delimiter in the text of the SQL statements that are run on a database server.
A comma will be used as the decimal delimiter in the text of the SQL statements that are run on a database server.
String Delimiter
Specify the character used to separate character strings in the SQL statements that are run on this database server.
Specify that there is no string delimiters specified for this database server.
Specify that an apostrophe will be used as the string delimiter in the text of the SQL statements that are run at this database server.
Select this button to specify that a quote will be used as the string delimiter in the text of the SQL statements that are run at this database server.
Date Format
Specify how dates are to be formatted for this database server.
Specify that there is no date formatting used when binding QMF for Windows packages.
Specify that the International Organization for Standardization (ISO) date format will be used when binding the QMF for Windows packages. Dates will appear in the following format: YYYY:MM:DD.
Specify that the United States (USA) date format will be used when binding the QMF for Windows packages. Dates will appear in the following format: MM:DD:YYYY.
Specify that the European (EUR) date format will be used when binding the QMF for Windows packages. Dates will appear in the following format: DD:MM:YYYY.
Specify that the Japanese Industrial Standard (JIS) date format will be used when binding the QMF for Windows packages. Dates will appear in the following format: YYYY-MM-DD.
Time Format
Specify how times are to be formatted for this database server.
Specify that there is no time formatting used when binding QMF for Windows packages.
Specify that the International Organization for Standardization (ISO) time format will be used when binding the QMF for Windows packages. Times will appear in the following format: HH.MM.SS.
Specify that the United States (USA) time format will be used when binding the QMF for Windows packages. Times will appear in the following format: HH:MM AM or HH:MM PM.
Specify that the European (EUR) time format will be used when binding the QMF for Windows packages. Times will appear in the following format: HH:MM:SS.
Specify that the Japanese Industrial Standard (JIS) time format will be used when binding the QMF for Windows packages. Times will appear in the following format: HH:MM-SS.
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.
Check this radio button to specify that the isolation level for the QMF for Windows application will be the default specified for all applications. For more information on Isolation Level options, refer to your database product's documentation.
Check this radio button to specify that the isolation level for the QMF for Windows packages will be Repeatable Read (RR). The RR isolation level provides the most protection from other applications. For more information on Isolation Level options, refer to your database product's documentation.
Check this radio button to specify that the isolation level for the QMF for Windows packages will be Read Stability (RS). For more information on Isolation Level options, refer to your database product's documentation.
Check this radio button to specify that the isolation level for the QMF for Windows packages will be Cursor Stability (CS). The CS isolation level provides the maximum concurrency with data integrity. For more information on Isolation Level options, refer to your database product's documentation.
Check this radio button to specify that the isolation level for the QMF for Windows packages will be Uncommitted Read (RS) which allows an application to read uncommitted data. For more information on Isolation Level options, refer to your database product's documentation.
Check this radio button to specify that the isolation level for the QMF for Windows packages will be No Commit (NC). An application running with an isolation level of NC does not make permanent database changes. For more information on Isolation Level options, refer to your database product's documentation.
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.
Check this radio button to specify that no special query blocking options will be used in binding the QMF for Windows packages. QMF for Windows uses your database default values. For more information on Query Blocking options, refer to your database product's documentation.
Check this radio button to specify that the query blocking option used in binding the QMF for Windows packages will be All. For more information on Query Blocking options, refer to your database product's documentation.
Check this radio button to specify that the query blocking option used in binding the QMF for Windows packages will be Unambiguous. For more information on Query Blocking options, refer to your database product's documentation.
Check this radio button to specify that the query blocking option used in binding the QMF for Windows packages will be None. For more information on Query Blocking options, refer to your database product's documentation.
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.
Check this radio button to specify that no special release options will be used in binding the QMF for Windows packages. QMF for Windows uses your database default values. For more information on Release options, refer to your database product's documentation.
Check this radio button to specify that the release option used in binding the QMF for Windows packages will be Commit. Commit specifies that the RDB releases resources used by the package every time a unit of work is either committed or rolled back. For more information on Release options, refer to your database product's documentation.
Check this radio button to specify that the release option used in binding the QMF for Windows packages will be Deallocate. Deallocate specifies that the target RDB releases resources used by the package when the conversation with the database server is finished or deallocated. For more information on Release options, refer to your database product's documentation.
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.
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.
Check this radio button to specify that QMF for Windows will use your database default setting to determine whether or not explain data will be gathered. For more information on Explain options, refer to your database product's documentation.
Check this radio button to specify that QMF for Windows will use the All option to determine whether or not explain data will be gathered. For more information on Explain options, refer to your database product's documentation.
Check this radio button to specify that QMF for Windows will gather explain data. For more information on Explain data options, refer to your database product's documentation.
Check this radio button to specify that QMF for Windows will not gather explain data. For more information on Explain options, refer to your database product's documentation.
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.
Check this radio button to specify that QMF for Windows will use your database default setting to determine whether or not a snapshot of the explain data will be gathered. For more information on the Explain Snapshot options, refer to your database product's documentation.
Check this radio button to specify that QMF for Windows will use the All option to determine whether or not a snapshot of the explain data will be gathered. For more information on the Explain Snapshot options, refer to your database product's documentation.
Check this radio button to specify that QMF for Windows will gather a snapshot of explain data. For more information on the Explain Snapshot options, refer to your database product's documentation.
Check this radio button to specify that QMF for Windows will not gather a snapshot of explain data. For more information on Explain Snapshot options, refer to your database product's documentation.
Validate Time
Use this option to specify when packages are validated in your database environment.
Check this radio button to specify that QMF for Windows will use your database default setting. For more information on the Validate Time options, refer to your database product's documentation.
Check this radio button to specify that validation will be done during the bind process. For more information on the Validate Time options, refer to your database product's documentation.
Check this radio button to specify that validation will be done at runtime. For more information on the Validate Time options, refer to your database product's documentation.
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.
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.
Check this radio button to specify that QMF for Windows will use your database default settings. For more information on the Dynamic rules options, refer to your database product's documentation.
Check this radio button to specify that QMF for Windows will use run as a dynamic rule. For more information on the Dynamic rules options, refer to your database product's documentation.
Check this radio button to specify that QMF for Windows will use bind as a dynamic rule. For more information on the Dynamic rules options, refer to your database product's documentation.
Check this radio button to specify that QMF for Windows will use invoker/requestor as the dynamic rule. For more information on the Dynamic rules options, refer to your database product's documentation.
Check this radio button to specify that QMF for Windows will use invoker/owner as the dynamic rule. For more information on the Dynamic rules options, refer to your database product's documentation.
Check this radio button to specify that QMF for Windows will use definer/requestor as the dynamic rule. For more information on the Dynamic rules options, refer to your database product's documentation.
Check this radio button to specify that QMF for Windows will use definer/owner as the dynamic rule. For more information on the Dynamic rules options, refer to your database product's documentation.
Character Sub-type
Use this option to specify the character sub-types for your database environment.
Check this radio button to specify that there are no character sub-types defined. For more information on the Character Sub-Type options, refer to your database product's documentation.
Check this radio button to specify that QMF for Windows will use bit data as the character sub-type. For more information on the Character Sub-Type options, refer to your database product's documentation.
Check this radio button to specify that QMF for Windows will use SBCS data as the character sub-type. For more information on the Character Sub-Type options, refer to your database product's documentation.
Check this radio button to specify that QMF for Windows will use mixed data as the character sub-type. For more information on the Character Sub-Type options, refer to your database product's documentation.
Check this radio button to specify that QMF for Windows will use the default set up in your database for all applications. For more information on the Character Sub-Type options, refer to your database product's documentation.
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.