Discussion:
How to capture historical usage and samples of SQL query
(too old to reply)
a***@yahoo.com
2007-10-03 13:34:24 UTC
Permalink
How to capture the historical usage and samples of SQL queries that ran on the DB server (long running and short running )?
Mark A
2007-10-03 13:42:57 UTC
Permalink
Post by a***@yahoo.com
How to capture the historical usage and samples of SQL queries that ran on
the DB server (long running and short running )?
db2 "get snapshot for dynamic sql on db db-name"

See the Command Reference manual. You will need to turn on the STATEMENT
monitor via:

"db2 update monitor switches STATEMENT ON"

Note: above syntax is not guaranteed to be accurate, please see manual.
Loading...