Setting ISPF dialog options

Start of change In Db2 Query Monitor, you can set various ISPF dialog options, such as whether to issue sort warnings and whether to create dumps at the first error. You can also specify information that Db2 Query Monitor is to use when interfacing with SQL PA or Db2 Admin Tool. End of change

Procedure

To set ISPF dialog options:

On the IBM DB2 Query Monitor for z/OS panel (the main menu), specify option 0, and press Enter.
On the Query Monitor Dialog Options panel, specify the options that you want:
Figure 1. Query Monitor Dialog Options panel
```
CQM$OPTN --------- Query Monitor Dialog Options ------------------
Option  ===> _________________________________________________    
                                                                  
  DB2 QM Dialog Options:                                          
    Enter "/" to select option                                    
    _  Issue Sort Warning                                         
    _  Unstack To Prior Level In Summaries                        
    _  Dump on 1st error 
    _  Display Full Command List on Summary Level
    _  Use Group Attach ID for SQL PA Command
   

   Db2 Admin Tool Plan Name  ________                             
   Db2 Admin Tool ADB2FMP schema   ____________________  > 
                                                                  
                                          
  Press Enter to update dialog options or PF3/CANCEL to exit      
```
To enable one of the following options, specify a forward slash (/) next to it. To disable an option, remove the forward slash.

Issue sort warning

When this option is enabled, a warning is issued when you select sorting by SQL text to ensure that you want to perform the sort. The sort warning message provides an option for you to disable the message by asking if you want to display this message again. If you disable the message, the only way to restore this warning message is to enable this Issue sort warning option. For more details about this message, see Sorting by SQLTEXT.

Unstack to prior level in summaries

When processing summary data, you can drill down from any level to another level except the one you are currently at. You can also drill down to a level that you have already viewed. When enabled, this option instructs that you are to return to the last occurrence of the specified drill down. For example, if you drill down from summaries with line commands 1,2,3,4 and then drill down by 2 again, you will return to the previous drill down for option 2. The intent is to allow you to return to a previous point to follow another path. When disabled, you will continue indefinitely.

Dump on 1st error

Use this option only when instructed by IBM® Software Support.

Display full command list on summary level

When this option is enabled, the full command list is shown on the Select Summary Level panel. When this option is disabled, an abbreviated command list is shown on the Select Summary Level panel.

Use Group Attach ID for SQL PA Command

When this option is enabled, the internal data sharing group attach ID, instead of the SSID, is passed to the SQL PA interface when the PA command is issued on the Activity by SQL Text panel, and the subsystem is a member of a data sharing group. This option is ignored when the subsystem is not part of a data sharing group.

If you want to use Db2 Admin Tool functionality from Db2 Query Monitor, specify values for the following fields as needed. Db2 Admin Tool must be installed enabled for use with Db2 Query Monitor; see Customizing Db2 Query Monitor.

Db2 Admin Tool Plan Name

Specify the plan name that is to be used to launch Db2 Admin Tool.

Db2 Admin Tool ADB2FMP schema

Specify the schema that Db2 Query Monitor is to use for the ADB2FMP stored procedure. If a value is not specified, the user's TSO ID will be used as the qualifier for the stored procedure.
Press Enter to save your selections.
Press PF3 to exit the panel.