1. There is no way to turn the monitor switches on for a single
database. You will need to turn the Bufferpools switch on for the
monitoring to begin. If you are using DB2 v8 you can try and use the
Health Indicators which are more 'lightweight' but do not provide as
much information. If you are only interested in cumulative metrics
for bufferpools instead of instantaneous results(i.e. the values of
various counters after the last application disconnects) - you can use
an event monitor instead of a snapshot monitor.
2. The best way to trace all sql statements for a user session is to
use an event monitor on the server. Look at the CREATE EVENT MONITOR
sql statement for further details.
hy********@yahoo.com (hype) wrote in message news:<71*************************@posting.google.c om>...
Hi,
1) If I need to monitor a resource eg, bufferpools at the database
level across all users, how can I do this ?
If snapshot monitoring needs to be done wouldn't enabling the switch
at the DBM level cause performance problems ?
2)How does one find the SQL statement that a particular user session
is executing?
TIA,
Hype.