By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
440,077 Members | 1,237 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 440,077 IT Pros & Developers. It's quick & easy.

Equalent to Statspack for DB2..

P: n/a
Hi All,
Greeting.
I am Junior DBA working in a privaite firm. Statspack is used to
monitor the Oracle Database Server. Is there any such thing in DB2 to
monitor performance. I want to know what the SQL which got executed
and how many times it got executed and like that stuff.

Advance Thanks for ur reply.
WantedToBeDBA.
Nov 12 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
WantedToBeDBA wrote:
Hi All,
Greeting.
I am Junior DBA working in a privaite firm. Statspack is used to
monitor the Oracle Database Server. Is there any such thing in DB2 to
monitor performance. I want to know what the SQL which got executed
and how many times it got executed and like that stuff.

Advance Thanks for ur reply.
WantedToBeDBA.

The easiest is to take a look at the health monitor in DB2 V8.2 for LUW.
Besides that, if you like to do things on foot, take a look at the
snapshot table functions in the SQL Reference.

Cheers
Serge
Nov 12 '05 #2

P: n/a
> WantedToBeDBA wrote:
Hi All,
Greeting.
I am Junior DBA working in a privaite firm. Statspack is used to
monitor the Oracle Database Server. Is there any such thing in DB2 to
monitor performance. I want to know what the SQL which got executed
and how many times it got executed and like that stuff.

I would look at the Dynamic SQL snapshot:

GET SNAPSHOT FOR DYNAMIC SQL ON database-alias

You will need to turn the Dynamic SQL Monitor switch on in the DBM
configuration for the instance. This is not really a point in time snapshot,
but covers the period from when you turn the monitor switch on until you
take the snapshot. The monitor data can be flushed explicitly with RESET
MONITOR or is cleared when the database is deactivited.
Nov 12 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.