Statement Table Rows panel
ZDT/Db2 displays the Statement Table Rows panel if you use the SR line command against an item listed on the Plan Table Rows panel.
Use this panel to display the rows from a table.
Process Options Utilities Help ______________________________________________________________________________ ZDT/Db2 (DFG2) Statement Table Rows Row 1 to 1 of 1 Query COLLECT. Progname Stmt C Estimated Estimated C Number (COLLID) (PACKG) Type C Serv. Units Proc. ms Reason __________* *_______ *_______ *_____ * *__________ *__________ *____________ __ 2001071003 HFM2TEST MGRMAIN SELECT A 13 3 ******************************* END OF Db2 DATA ******************************* Command ===> Scroll PAGE F1=Help F2=Split F3=Exit F4=CRetriev F7=Backward F8=Forward F9=Swap F10=Actions F12=Cancel
The Statement Table Rows panel shows you rows from a statement
table:
- C
- Input field where you can enter one of the following line commands:
- DK
- Delete rows for package
- DP
- Delete rows for plan
- DQ
- Delete rows for query number
- I
- Interpret EXPLAIN data
- K
- Show package
- M
- Show DBRM
- P
- Show plan
- Query Numb
- A number that identifies the SQL statement.
- Applname
- PLAN name or blank for dynamic EXPLAIN. This information only is displayed for the PLAN format of the panel.
- Collect.
- Collection name. This information only is displayed for the COL format of the panel.
- Progname
- DBRM/package name.
- Stmt Type
- Statement type.
- C C
- Cost category:
- A
- Not using default values.
- B
- Using default values when calculating costs.
- Est. SU
- Estimated processor cost in service units.
- Est. P ms.
- Estimated processor cost in milliseconds.
- Reason
- A string indicating the reason for putting an estimate into cost category B (see C C).
Parent panels
Child panels
To display this panel… | Use/do this |
---|---|
EXPLAIN Interpretation panel | Line command I |
Application Packages panel | Line command K |