Detail window
You can enter “++” (or the Enter key) on any line to display a pop-up window containing additional information. For example, entering “++” on an SQL line will cause this detail window to appear:
File View Navigate Help
+----------------------------------------------------------------------------+
| |
| SQL Call Information |
| Sample count 1 DB2 Authid USER1 |
| SQL CPU time 0.002 Service time 0.00 |
| |
| SQL Statement Information |
| Subsystem name DSN1 Attach type SASS |
| Plan name PFSAMPC Plan bind time no data |
| |
| DBRM name PFSAMPA DBRM token 17D8B8DF 05CC86F8 |
| DBRM date/time May-08-06 15:48:14 |
| |
| Package ID PFSAMPA Location CABNETDB24 |
| Collectn name PFSAMPX1 Pkg BIND time no data |
| |
| SQL function SELECT Static/dynamic Static |
| Precmplr stmt# 678 DBRM section# 4 |
| CSECT/module PFSAMPA in PFSAMPA Offset of call 00002764 |
| Sample count 147 SQL req count 333 |
| SQL CPU time 0.60 Service time 0.84 |
| |
| SQL Statement: |
| SELECT * |
| INTO : H , |
| : H : H , |
| : H : H |
| FROM DEP |
| WHERE XRATE = : H |
| |
| DB2 Thread Information |
| Thread sequence number 00001 |
| Attachment type CICS |
| |
| First REQCT value observed 05256 |
| Time of first REQCT 14:06:47.24 |
| |
| Last REQCT value observed 10613 |
| Time of last REQCT 14:07:46.74 |
| |
| Total REQCT increments 5,358 |
| Duration first to last 59.49 |
| SQL rate for thread, per second 90.06 |
| Number of samples for thread 1,417 |
| Number of REQCT values sampled 1,292 |
| |
+----------------------------------------------------------------------------+