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 ────────────────────────────────────────────────────────────────────────────── ZDT/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 HFM2GEN 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:
- The system option, Show all catalog table columns, affects which columns ZDT/Db2 displays when you use the Object List utility.
- You can also customize which columns ZDT/Db2 displays when you use the Object List utility. For details, see the Z Data Tools 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 |