Statement Table Rows panel

FM/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.

Figure 1. Statement Table Rows panel (collection ID format)
  Process   Options   Utilities   Help
 ______________________________________________________________________________
 FM/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 FMN2TEST 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

Related tasks