
December 27th, 2012, 01:08 AM
|
|
Registered User
|
|
Join Date: Dec 2012
Posts: 2
Time spent in forums: 10 m 57 sec
Reputation Power: 0
|
|
|
Stmt_text is null
Hi,
i can get statement text from table function SNAP_GET_STMT , i am getting null value in stmt_text . Can any one clarify me why am always getting null value in stmt_text column.
i am running this query in db2 v10
select AGENT_ID,DB_NAME,STMT_USR_CPU_TIME_MS,STMT_SYS_CPU _TIME_MS,STMT_TEXT from TABLE(SNAP_GET_STMT('',-1))
AGENT_ID DB_NAME STMT_SYS_CPU_TIME STMT_TEXT
26776 SAMPLE 0 (null)
26795 SAMPLE 0 (null)
26775 SAMPLE 0 (null)
thanks & regards
selva
|