SEO

#1 (**permalink**) 02-27-2008, 02:27 AM

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.

#2 (**permalink**) 02-27-2008, 02:28 AM

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

#3 (**permalink**) 02-27-2008, 02:28 AM

> 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.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SEO

Equalent to Statspack for DB2..