Candle-lite DB2 - Manual (Page 101)

Using OMEGAMON II for DB2 with !DB/EXPLAIN 101
Using the OMEGAMON II for DB2 Callable Interface
3 Select the PLANNAME you want and press Enter.
Result: The system displays the Thread Detail panel. If SQL calls are being executed by
the thread, the message (IN-SQL-CALL) also appears. The Thread Detail panel shows
detailed information about the activity, an individual thread, or a parallel task, including
wait time information.
4 Select Option 3, SQL Call Being Executed, from the GoTo pull-down menu.
Result: The system displays the SQL Call Being Executed panel.
5 Press the Process SQL key.
Step Action
GoTo Options Tools Help
+---------------------------------------------------------- mm/dd/yy 8:09:18
| Thread Detail
System: D41A
|
+-------------------------------------+-------------------------------------+
| Thread: Plan . . . . :
KTWPLNR | Attach: TSO Userid . . : RBRIN3 |
| Connid . . . : DB2CALL | Region ASID . : 225 |
| Corrid . . . : RBRIN3 | |
| Authid . . . : RBRIN3 | |
| DB2 Status . . . . . : IN-SQL-CALL | MVS Status . . . . . . : USING CPU |
| Elapsed Time . . . . : 00:00:05.932 | CPU Utilization . . . :
|
| Total CPU Time . . . : 00:00:03.586 | Total Parallel Tasks . : |
| Total Stored Proc CPU: 00:00:00.000 | Current Parallel Tasks : |
+-------------------------------------+-------------------------------------+
+-------------------------------------+-------------------+-----------------+
| IN-DB2 Times
| Total | Current |
+-------------------------------------+-------------------+-----------------+
| Elapsed Time
| 00:00:05.928 | 00:00:05 |
| CPU Time | 00:00:03.584 | 00:00:03 |
| Stored Procedure CPU Time | 00:00:00.000 | N/A |
+-------------------------------------+-------------------+-----------------+
( IN-DB2 Times ) < Waits > < Current Wait Resource >
F1=Help F2=Keys F3=Exit F5=Refresh F6=Console **=Bkwd **=Fwd F10=Action
Bar F15=System Status F24=CUA/TSO
GoTo Options Tools Help
+---------------------------------------------------------- mm/dd/yy 8:47:27
| SQL Call Being Executed
System: D41A
|
+--------------------------------------+-------------------------------------+
| Thread: Plan . . . . . : DSNESPCS | Attach: TSO Userid . . :
RBRIN3 |
| Connid . . . . : TSO | Region ASID . : |
| Corrid . . . . : RBRIN3 | |
| Authid . . . . : RBRIN3 | |
+--------------------------------------+-------------------------------------+
| Lines 1 to 15 of 15 |
+----------------------------------------------------------------------------+
|SQL call is active, call information is as follows :
|
| |
|Thread Status = IN-SQL-CALL SQL Request Type = DYNAMIC |
|Total SQL Reqs = 2 SQL Call Type = OPEN CURSOR |
|SQL DBRM Name = DSNESM68 SQL Statement Number = 00193 |
|Collection ID = DSNESPCS |
| |
| SELECT A.PLNAME, SECTNO, STMTNO, CARD |
| FROM SYSIBM.SYSSTMT A, |
| SYSIBM.SYSPLAN B, |
| SYSIBM.SYSTABLES C |
| WHERE A.PLNAME = B.NAME |
| AND A.STMTNO > C.CARD |
| ORDER BY SECTNO DESC, STMTNO ASC |
| |
+----------------------------------------------------------------------------+