in 8.2 (fixpk>7) db2advis -d hipasstg -g -p
places recent sql (memory) into the advisor/explain tables as a workload

db2 "select distinct workload_name from advise_workload"

NOTICE TO RECIPIENT: If you are not the intended recipient of this
e-mail, you are prohibited from sharing, copying, or otherwise using or
disclosing its contents. If you have received this e-mail in error,
please notify the sender immediately by reply e-mail and permanently
delete this e-mail and any attachments without reading, forwarding or
saving them. Thank you.




"Schleicher Jeremy D. "
<db2udbdba-ezmlmshield-x83591050.[Email address protected]
05/22/2007 12:14 PM

To
"LazyDBA Discussion" <[Email address protected]
cc

Subject
RE: How can I get sql is currently running in prod






An event monitor will do the trick but it can be rather hard on the
machine and should not be run for extended periods of time. A snapshot
for applications should do the trick, limit it to a specific agentid.
Also look into get snapshot for dynamic sql. That will give the
statements that are in the package cache.

-----Original Message-----
From: Sheuehua
[mailto:db2udbdba-ezmlmshield-x61747087.[Email address protected]
Sent: Tuesday, May 22, 2007 3:08 PM
To: LazyDBA Discussion
Subject: How can I get sql is currently running in prod

Hi all,
Our prod db is db2udb v7.1; how can I get current statement
is
running in prod.
I use "db2 get snapshot for all applications"; but does not
show which sql is runnig.
How can I see who is running what in prod?
Thanks,

Sue
**********************************************************************
This e-mail transmission and any attachments that accompany it may
contain information that is privileged, confidential or otherwise
exempt from disclosure under applicable law and is intended solely for
the use of the individual(s) to whom it was intended to be addressed.
If you have received this e-mail by mistake, or you are not the
intended recipient, any disclosure, dissemination, distribution,
copying or other use or retention of this communication or its
substance is prohibited. If you have received this communication in
error, please immediately reply to the author via e-mail that you
received this message by mistake and also permanently delete the
original and all copies of this e-mail and any attachments from your
computer. Thank you.
**********************************************************************


---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html



---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html



DB2 & UDB email list listserv db2-l LazyDBA home page