Performing SQL Administrative Tasks › Displaying Index of SQL Plans › How to Display an Index of SQL Plans

How to Display an Index of SQL Plans

Use the following steps to display an index of SQL plans:

Step 1

When you sign on or select the SET MODE function, CA Datacom Datadictionary displays the Datadictionary Mode Select Panel. Select Option 7 or enter the SET MODE SQL command.

Step 2

On the Interactive SQL Service Facility Panel, select Option 2 (SQLADMIN).

Step 3

CA Datacom Datadictionary displays the Interactive SQL Service Facility SQLADMIN Panel. Select Option 4 (DISPLAY PLAN).

 =>
 =>
 =>
 -------------------------------------------------------------------------------
 Interactive SQL Service Facility                                       SQLADMIN
 
 Enter desired option number ===> __    (There are 05 options on the menu)
  1. SET AUTHID                   Set default AUTHID for session
  2. DELETE PLAN                  Delete SQL plan
  3. REBIND PLAN                  Rebind SQL plan
  4. DISPLAY PLAN                 Display index of SQL plans
  5. END                          End SQLADMIN processing

Step 4

The following display appears.

 =>
 =>
 =>
 
 --------------------------------------------------------------------------- >>>
 DDOL:  ANCHORED OCCURRENCE FOR INDEX DISPLAY
 
 TYPE   OCCURRENCE       STA VER                                            S04D
  PLN   SYSADM-BANEMODE   P  001
 -------------------------------------------------------------------------------
        Type   Occurrence-Name                  Status  Version
 ====== ========================== T O P =======================================
 000001  PLN   SYSADM-BANEMODE                     P     001
 000002  PLN   SYSADM-CANEMODE                     P     001
 000003  PLN   SYSADM-DANEMODE                     P     001
 000004  PLN   SYSADM-EANEMODE                     P     001
 000005  PLN   SYSADM-LANEMODE                     P     001
 000006  PLN   SYSADM-TANEMODE                     P     001
 000007  PLN   SYSADM-TESTMODE                     P     001
 ====== ======================= B O T T O M ====================================
 PF1=HELP         PF2=END         PF3=SPLIT         PF4=PROCESS
 PF5=TOP          PF6=BOTTOM      PF7=BACKWARD      PF8=FORWARD
 PF9=EXECUTE      PF10=LEFT       PF11=RIGHT        PF12=ALTERNATE

After a successful display of the index of SQL plans, you can:

• Press PF2 (END) to display the Interactive SQL Service Facility SQLADMIN Panel.
• Press the CLEAR key to return to the Interactive SQL Service Facility Panel where you can choose another option.

If no plans currently exist, or if you are not pointing to the active dictionary where the plan occurrences are defined, you receive an error message as shown following instead of the index display.

 =>
 =>
 =>
 1-DDOL000472I - STRP - NO PLANS CURRENTLY EXIST ON DICTIONARY
 -------------------------------------------------------------------------------
 Interactive SQL Service Facility                                       SQLADMIN
 Enter desired option number ===> __    (There are 05 options on the menu)
  1. SET AUTHID                   Set default AUTHID for session
  2. DELETE PLAN                  Delete SQL plan
  3. REBIND PLAN                  Rebind SQL plan
  4. DISPLAY PLAN                 Display index of SQL plans
  5. END                          End SQLADMIN processing