Setting DB2 Navigator options

Use the following procedures to set the behavior of certain DB2 Navigator options.

To set general options

1. On the DB2 Navigator perspective, click Options .
2. Select the General tab.

3. Select your preferences from the following options:
   
   

   Option	Description	Default
   Decimal Point	Select this check box to use a period (.) for decimal points. Clear this check box to use a comma.	Selected (period)
   Verbose Output	Select this check box to run the command with output level VERBOSE. Clear this check box to use output level TERSE.	Selected (VERBOSE output)
   Define (HDDL and DDL only)	Select this check box to include the DEFINE parameter in DDL or HDDL for a table space or index. Clear this check box to omit the parameter.	Not selected
   SQLID Before Grant (DCL only)	Select this check box to generate a SET CURRENT SQLID= grantor statement before each GRANT statement. This option is used for processing HDDL with AUTHs, HGRANT, and CASCADE REVOKE REASSIGN. Clear this check box to omit the statement.	Not selected

4. Click OK.

To set the HDDL command output options

1. On the DB2 Navigator perspective, click Options .
2. Select the General tab.
3. To include the DEFINE parameter for a table space or index, select Define.
4. Select the Include in HDDL tab.

5. Select the following options as required:

   Option	Description	Default
   Object types	Select the object types that you want to include in the HDDL output. Clear the check box for any object type that you want to omit. You can select the following object types: Aliases Auths Databases Foreign keys Indexes Materialized Queries Plans Synonyms Table spaces Tables Triggers Views	All selected except AUTHS
   Packages	Select one of the following options to control the BIND PACKAGE commands added to the HDDL output: No BIND statements BIND statements for all versions BIND statement for the latest version REBIND statement for all versions	No BIND statements

6. Click OK.

To set HSTATS command output options

(BMC.DB2.SPE2301)

1. On the DB2 Navigator perspective, click Options .
2. Select the Include in HSTATS tab.

3. Select the following options as required:

   Option	Description	Default
   Include objects with	Select one of the following options for which statistics to include: Access path statistics—Generates DML statements for statistics used for generating access paths during the bind process All statistics—Generates DML statements for all statistics regardless of their usage	Access path statistics
   Insert commits after every	Select after which objects you want to include a COMMIT statement. You can select the following object types: Table space—Specifies whether to insert a commit after each table space update Index—Specifies whether to insert a commit after each index update Table—Specifies whether to insert a commit after each table update 100 statements—Specifies whether to insert a commit after every 100 statements	All selected

4. Click OK.