Application Plans panel

You use the Application Plans panel to list application plans in the Db2® catalog.

Panel and field definitions

The columns that are displayed include the SEL field and columns of SYSIBM.SYSPLAN.

   Process   Options   Utilities   Help
  ──────────────────────────────────────────────────────────────────────────────
 FM/Db2 (DFG2)                  Application Plans
 Location:                                                          Format TABL


 SEL    NAME     CREATOR  VALIDAEX  ISOLATEX         VALIDEX OPERATEX
        *        *        *         *                *       *       
 ----   #1--+--- #2--+--- #44-+---- #45-+----1----+- #46-+-- #47-+---
 ****  Top of data  ****
        DSNACLI  CJUNELL  Run time  Repeatable read  Yes     Yes
        DSNEDCL  CJUNELL  Run time  Cursor stability Yes     Yes
        DSNESPCS CJUNELL  Run time  Cursor stability Yes     Yes
        DSNESPRR CJUNELL  Run time  Repeatable read  Yes     Yes
        DSNHYCRD CJUNELL  Run time  Cursor stability Yes     Yes
        DSNREXX  CJUNELL  Run time  Cursor stability Yes     Yes
        DSNTEP81 CJUNELL  Run time  Cursor stability Yes     Yes
        DSNTIA81 CJUNELL  Run time  Cursor stability Yes     Yes
        DSNTP481 CJUNELL  Run time  Cursor stability Yes     Yes
        DSNWZP   CJUNELL  Run time  Cursor stability Yes     Yes
        FMN2GEN  SHRIKES  Bind time Cursor stability Yes     Yes
 Command ===>                                                       Scroll PAGE
  F1=Help      F2=Zoom      F3=Exit      F4=CRetriev  F5=RFind     F6=RChange
  F7=Up        F8=Down      F9=Swap     F10=Left     F11=Right    F12=Cancel
Note:
  1. The system option, Show all catalog table columns, affects which columns FM/Db2 displays when you use the Object List utility.
  2. You can also customize which columns FM/Db2 displays when you use the Object List utility. For details, see the File Manager Customization Guide.

To view other columns on this panel, press the Right function key (F11).

For a complete list of columns, refer to Db2® catalog tables in the DB2 for z/OS SQL Reference relevant to your version of Db2®.

SEL
Line command area.
For a list of the line commands you can use on this panel, see Object list line commands.

Parent panels

Child panels

To display this panel… Use/do this
Bind Application Plan panel Line command BI
Free Application Plan panel Line command FRE
Grant privileges panels Line command G
Details panels Line command I
Plan Table Rows panel Line command LPT
Database Request Modules panel Line command M
Privileges panels Line command P
Application Packages panel Line command PKG
Package List panel Line command PKL
Revoke privileges panels Line command R
Rebind Application Plan panel Line command RBI
Display Row panel Line command ROW
Table Spaces panel Line command S
(ISPF panel) Line command SQL
Tables, Views and Aliases panel Line command T
Tables, Views and Aliases panel Line command V
Indexes panel Line command X
Sort Fields panel Primary command SORT

Related tasks

Related references