Can we do the same on OS/390 Version 6?
Thanks,
Mery B. Moreno
Database Administrator - DBA
Lakeland Regional Medical Center
Phone: 863-687-1100 Ext 2830
>>> "Thirumaran " <db2udbdba-ezmlmshield-x81688420.[Email address protected] 07/28/04 10:21AM >>>
hi
use db2 Event monitor / snapshopts
example
# db2 "get dbm monitor switches"
DFT_MON_STMT - collecting SQL statements information
Listing applications connected to the database
db2 => list application
db2 => connect to dbname
db2 => update monitor switches using statement on
DB20000I The UPDATE MONITOR SWITCHES command completed successfully.
Creating SQL event monitor for capturing the SQL statements for the user
PAYMENT1:
db2 => create event monitor SQLNODE1_PAY1 for statements where
AUTH_ID='PAYMENT1' write to
file '/home/db2inst1/pay1_1' NONBLOCKED REPLACE ON NODE 1 LOCAL
DB20000I The SQL command completed successfully.
Activate the SQL event monitors for the user PAYMENT1: db2 => set event
monitor SQLNODE1_PAY1 state=1
DB20000I The SQL command completed successfully.
Checking status for the SQL event monitor switch:db2 => get monitor switches
SQL Statement Information (STATEMENT) = ON 05-22-2003
10:12:49.890612
db2 => select EVMONNAME,TARGET,NODENUM,MONSCOPE from syscat.eventmonitors
EVMONNAME TARGET NODENUM MONSCOPE
------------------ -------------------- ------- --------
SQLNODE1_PAY1 /home/db2inst1/pay1_1 1 L
SQLNODE1_PAY9 /home/db2inst1/pay9_1 1 L
SQLNODE2_PAY1 /home/db2inst1/pay1_2 2 L
SQLNODE2_PAY9 /home/db2inst1/pay9_2 2 L
Reporting Bad SQL Code Stopping the SQL collection for users PAYMENT1 and
PAYMENT9:db2 => set event monitor SQLNODE1_PAY1 state=0
DB20000I The SQL command completed successfully.
The generated file is a non-readable binary file. We will use the standard
DB2 system command db2evmon to format trace file to the readable format. >>
db2evmon -path /home/db2inst1/pay1_1 > sql_payment1_node1.txt
Reading /tmp/00000000.evt ...
check the text file for the sql statements
Regards
Thirumaran
----- Original Message -----
From: "ighiurea " <db2udbdba-ezmlmshield-x36533152.[Email address protected]
To: "LazyDBA Discussion" <[Email address protected]
Sent: Wednesday, July 28, 2004 12:16 AM
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]
>
---------------------------------------------------------------------
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]
BEGIN:VCARD
VERSION:2.1
X-GWTYPE:USER
FN:Moreno, Mery
ORG:;I.S.
EMAIL;WORK;PREF:Mery.[Email address protected]
N:Moreno;Mery
TITLE:DBA
END:VCARD
DB2 & UDB email list listserv db2-l LazyDBA home page