Source Explain Options window

You can display the Source Explain Options window by specifying a command in the ISPF/PDF editor or on the SQL Statement Selection panel.

In the command line of the ISPF/PDF editor, type EXPLAIN OPTIONS and press Enter.
If you have previously selected the Always display this window field in the Source Explain Options window, you can type EXPLAIN in the command line of the ISPF/PDF editor and press Enter.
In the command line of the SQL Statement Selection panel, type OPTIONS and press Enter.

You can use the Source Explain Options window to specify the Source Explain processing options, for example, the language of the source code you are editing, the subsystem ID of the explaining DB2®, the SQLID to be used, or the degree of parallelism.

Figure 1. Source Explain Options window

DGOMYWSO                  Source Explain Options

Update fields as required, then press Enter

   Local DB2 subsystem . . . . . . . . ____
   Current server location . . . . . . ________________
   Current SQLID . . . . . . . . . . . ________
   Query number  . . . . . . . . . . . _________

_  Set current degree to ANY
/  Always display this window

   Define source language  . . . . . . _  1. Assembler
                                          2. C/370
                                          3. COBOL
                                          4. FORTRAN
                                          5. PL/I
                                          6. SPUFI


 F1=Help     F2=Split    F3=Exit     F9=Swap    F12=Cancel

On the Source Explain Options window, you can specify the following options:

Local Db2 Subsystem: The local Db2 subsystem to which you want to connect.
Current Server Location: The Db2 subsystem where you want the source SQL statements to be explained.
In this field, you can specify the Db2 test subsystem you want to connect to while you are executing the explain on the remote production system. If you do not specify a subsystem, the local Db2 subsystem is used.
Current SQLID: A different SQL authorization ID for qualifying the unqualified tables in the SQL statements being explained.
A different SQL authorization ID is also used to qualify the plan table to be accessed. If you do not specify an SQL authorization ID, your user ID is used.
Query number: A number that identifies the Explain statement.
If you do not specify a number, the value 999 735 912 is assigned to this field.
Set current degree to ANY: To specify whether the SQL statement is eligible for query parallelism.
By default, the current degree of parallelism is set to 1. To set the current degree of parallelism to ANY, type a slash (/) in this field.
Always display this window: To control the display of the Source Explain Options window.
By default, the Source Explain Options window is not displayed on each Source Explain request. To display the Source Explain Options window on each Source Explain request, type a slash (/) in this field.
Define source language: In this field, you must specify the language of the source that contains the SQL statements. This field cannot be left blank.

After you have specified the Source Explain options to be used, press Enter to proceed to the SQL Statement Selection panel.