watch db activity

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Omar Vazquez - 29 Nov 2004 23:56 GMT

i need to see the db activity when a app makes some operation on it,
for example select, insert, update, delete thanks in advance

Reply to this Message

dotyet - 30 Nov 2004 14:29 GMT

use snapshots

db2 "get snapshot for dynamic sql on <db_name>"
db2 "get snapshot for applications on <db_name>"

look at System Monitoring & Reference Guide for details.

hth,
dotyet

> i need to see the db activity when a app makes some operation on it,
> for example select, insert, update, delete thanks in advance

Reply to this Message