Oracle statspack Vs DB2 ???

[John G]

Hi all,

I am new to IBM DB2 (V8 - Enterprise Edition) but have been a DBA for Oracle for a few years
now. I have some (more than a little but not very much) idea about doing problem diagnosis and
performance tuning using Oracle Statspack, and was familiar with the most frequently
seen Oracle wait events and all.

Is there a tool or solution, similar to Oracle Statspack for DB2? I am not interested in third
party applications. Even pointers to materials that talk about 'performance tuning in DB2
for oracle DBAs' would help greatly.

Thanks a lot,
-V

[Mark A]

"John G" <[e-mail]> wrote in message
news:nM************@news.oracle.com...

Hi all,

I am new to IBM DB2 (V8 - Enterprise Edition) but have been a DBA for Oracle for a few years now. I have some (more than a little but not very much) idea about doing problem diagnosis and performance tuning using Oracle Statspack, and was familiar with the most frequently seen Oracle wait events and all.

Is there a tool or solution, similar to Oracle Statspack for DB2? I am not interested in third party applications. Even pointers to materials that talk about 'performance tuning in DB2 for oracle DBAs' would help greatly.

Thanks a lot,
-V

All the IBM manuals can be downloaded in PDF format at their website. You
need to do a lot of reading, including "DB2 Administration Guide:
Performance"

[Blair Adamache]

Bez does snapshot monitoring (on DB2m Teradata and Oracle): www.bez.com

John G wrote:

Hi all,

I am new to IBM DB2 (V8 - Enterprise Edition) but have been a DBA for
Oracle for a few years
now. I have some (more than a little but not very much) idea about doing
problem diagnosis and
performance tuning using Oracle Statspack, and was familiar with the
most frequently
seen Oracle wait events and all.

Is there a tool or solution, similar to Oracle Statspack for DB2? I am
not interested in third
party applications. Even pointers to materials that talk about
'performance tuning in DB2
for oracle DBAs' would help greatly.

Thanks a lot,
-V

[John G]

on 2/18/2004 4:23 AM Mark A said the following:

"John G" <[e-mail]> wrote in message
news:nM************@news.oracle.com...
All the IBM manuals can be downloaded in PDF format at their website. You
need to do a lot of reading, including "DB2 Administration Guide:
Performance"

Thanks for your reply. I was able to find it at
ftp://ftp.software.ibm.com/ps/produc...r/db2d3e80.pdf

The only thing that is close to Oracle Statspack that I could find here
is "The Control Center". Can the control center be configured to take periodic
snapshots so that the DBA can go back in time to diagnose issues? That was one
thing I like(d) a lot in Statspack.

The governor utility described in Chapter 9, seems like a whole different thing.

Am I in the right track?

[Mark A]

"John G" <[e-mail]> wrote in message
news:n1**************@news.oracle.com...

on 2/18/2004 4:23 AM Mark A said the following:

"John G" <[e-mail]> wrote in message
news:nM************@news.oracle.com...
All the IBM manuals can be downloaded in PDF format at their website. You need to do a lot of reading, including "DB2 Administration Guide:
Performance"
Thanks for your reply. I was able to find it at

ftp://ftp.software.ibm.com/ps/produc...r/db2d3e80.pdf
The only thing that is close to Oracle Statspack that I could find here
is "The Control Center". Can the control center be configured to take periodic snapshots so that the DBA can go back in time to diagnose issues? That was one thing I like(d) a lot in Statspack.

The governor utility described in Chapter 9, seems like a whole different thing.
Am I in the right track?

The Control Center is just a GUI interface for issuing commands that can
also be issued from the command line.

You probably need to look at DB2 Snapshots (there are many different kinds)
and also the Health Center which can be invoked independently from the
Control Center (or started from the Control Center).

[Mark A]

> The Control Center is just a GUI interface for issuing commands that can

also be issued from the command line.

You probably need to look at DB2 Snapshots (there are many different kinds) and also the Health Center which can be invoked independently from the
Control Center (or started from the Control Center).

Forgot to mention that the syntax for Snapshots is documented in the Command
Reference manual. I would use an FTP program and download the folder with
all the manuals. The Master Index is very helpful and all the PDF files have
PDF hot links in the manual is in the same PDF file or another PDF file in
the same directory.