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
|
|
|
+----------------------------------------------------------------------------+
Summary of Contents for Network Adapter DB2
Page 6: ...6 OMEGAMON II for DB2 User s Guide CUA Interface Version 540...
Page 13: ...13...
Page 14: ...14 OMEGAMON II for DB2 User s Guide CUA Interface Version 540...
Page 18: ...18 OMEGAMON II for DB2 User s Guide CUA Interface Version 540...
Page 64: ...Using the Callable Interface 64 OMEGAMON II for DB2 User s Guide CUA Interface Version 540...
Page 88: ...Using the IFCID Trace Facility 88 OMEGAMON II for DB2 User s Guide CUA Interface Version 540...
