db2 "update monitor switches using lock ON sort ON bufferpool ON uow ON table ON statement ON"
db2 "get snapshot for tablespaces|tables| on db db_name"
and to see which switches are active:
use
db2 "get dbm monitor switches"
Note:don't use double quotes while running the command from CLP
the following links provide good explanation for monitoring database:
http://space.itpub.net/?uid-47598-action-viewspace-itemid-330882
http://www.performancewiki.com/db2-event-monitors.html
http://it.toolbox.com/blogs/db2luw/using-the-snapshot-monitor-and-monitoring-via-sql-5631
using query results like parameter
3 years ago
No comments:
Post a Comment