If you have your monitor switches ON :
a) for dynamic sql : The application snapshot will have the SQL
Statement
b) for static sql(normally used in SPs) : The application snapshot
will tell you the package name and section number. You can use
SYSCAT.PACKAGES and SYSCAT.STATEMENTS to know the SQL Statement

Sathyaram Sannasi
Tel:01423-85-2461


-----Original Message-----
From: ighiurea
[mailto:db2udbdba-ezmlmshield-x36533152.[Email address protected]
Sent: 27 July 2004 19:47
To: LazyDBA Discussion
Subject: db2 cmds: to display user querie


Hi,
is it a way in db2 to find what querie each one of the users are
running in db2 cvo, db2 list application /show detail seems useless at
all ......!!!!



Isabella




---------------------------------------------------------------------
PLEASE CLICK REPLY-ALL TO SEND A REPLY TO EVERYONE
website: http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
For additional commands, e-mail: db2udbdba-[Email address protected]

**********************************************************************
This email and any files transmitted with it are confidential and are
intended solely for the use of the individual or entity to whom they are
addressed. This communication represents the originator's personal views and
opinions, which do not necessarily reflect those of HPI Limited. If you are
not the original recipient or the person responsible for delivering the
email to the intended recipient, be advised that you have received this
email in error, and that any use, dissemination, forwarding, printing, or
copying of this email is strictly prohibited. If you received this email in
error, please immediately notify [Email address protected]

This message has been scanned by Panda Anti-Virus. Recipients are advised to
apply their own virus checks to this message on delivery.
**********************************************************************



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