Candle-lite DB2 manual Press the Process SQL key

Using the OMEGAMON II for DB2 Callable Interface

Step Action

3Select 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.

	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

4Select Option 3, SQL Call Being Executed, from the GoTo pull-down menu. Result: The system displays the SQL Call Being Executed panel.

+	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
+	----------------------------------------------------------------------------								+

5

Press the Process SQL key.

Using OMEGAMON II for DB2 with !DB/EXPLAIN 101