Hi

Where can I monitor SORT OVERRFLOWS in UDB 8.1 ???

In UDB 7.x, you can choose in the control center the database pop-up menu "Performance Monitoring". But how can I monitor it in 8.1, it has disappered from the menu ?

Marc

Doesn't your health centre have one ?

Cheers
Sathyaram

In UDB 8.1, I can't find the performance monitor of udb 7.1 or a tool that corresponds to it. I just want to issue several sql and see which of these causes an sort overflows, so I thought to do that by
a) db2batch
b) Performance monitor

a) With db2batch, it doesn't work because db2batch does an imlicit attach to the local instance
b) with udb 8.1 I can't find the performance monitor ???

So, my questions are:
a) can db2batch only be used with a local database (database which is on my computer and not remote on a server)
b) Where is the performancer monitor in udb 8.1 ?

Marc

Hi.

Please mention your OS and DB2 Version for any posting that really helps.

You However please do try the following

1. Attach to the remote instance.

2. db2 update monitor switches using sort on bufferpool on statement on uow on table on

3. Run your sql

4. db2 get snapshot for dynamic sql on <database name>
This would give you all the information pertaining to the SQL and the times taken

5. db2 get snapshot for all bufferpools
This would give you and idea of bufferpool usage and give u a trend.

6. db2 get snapshot for database on <database-name>
Here you would get if you have any sort overflows.

Depending on the necessary analysis you can go ahead and increase the sortheap and other sort parameters.

I tried to run db2batch against a remote db was finding some errors will post more info on that later.

For the Performance Monitor in DB2 V8 it is called as Health Center and it is under the Monitoring Tools Subsection.


Hope that helps

Nitin