Filter
Top Products
Using OMEGAMON II for DB2 with !DB/EXPLAIN 99
Using the OMEGAMON II for DB2 Callable Interface
Using the D2/EXPLAIN Options Panel
The following table provides a list of fields and valid values for completing the
D2/EXPLAIN Options panel.
Field Description
Extract Id 1– to 8–character field that identifies an extract of plans and packages. It
represents a logical grouping that typically identifies a DB2 subsystem and
an MVS system. An Extract ID must be configured within !DB/EXPLAIN
before it is used, but an actual extract is not required for the EXPLAIN.
User Profile DSN Optional field names the dataset containing the !DB/EXPLAIN user
profile. Contains overrides to the !DB/EXPLAIN options specified in the
group profile and the system profile.
Group Profile DSN Optional field names the dataset containing the !DB/EXPLAIN group
profile. Contains overrides to the !DB/EXPLAIN options specified in the
system profile.
SQL Statement
PDS
Name of the dataset where the SQL statement is saved. Must be a PDS.
The SQL Process Level is specified on the Terminal Options panel under
the Options pull-down (fastpath O2). If SAVE, the text is saved but
!DB/EXPLAIN is not invoked. If SAVE/EXPLAIN, !DB/EXPLAIN saves the
text and invokes the EXPLAIN function.
Member Name Name to use when saving the SQL text into the SQL statement PDS. If
omitted, the system generates a name. When you define a member, the
system prompts for whether the member should be replaced or appended.
Type of Save Type of save to be executed when saving SQL text to the member
specified within the SQL statement PDS. Values are REPLACE and
APPEND.
■
REPLACE writes over an existing member or creates the member if it
does not currently exist.
■
APPEND concatenates the new SQL text to the existing number.
Default Qualifier Qualifier to use to qualify unqualified tables, views, and aliases in SQL
statements.
Qualifier Option Type of qualifier. Values are USE and PROMPT.
■
USE indicates the current default qualifier for unqualified SQL text.
■
PROMPT indicates you want to be prompted for a qualifier whenever
an SQL statement is used.
Gather Statistics Type YES to have !DB/EXPLAIN gather statistics; type NO to bypass.