Results 1 to 4 of 4
  1. #1
    Join Date
    Jul 2003
    Posts
    50

    Unanswered: Monitoring SORT OVERFLOWS / UDB 8.1

    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

  2. #2
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650

    Re: Monitoring SORT OVERFLOWS / UDB 8.1

    Doesn't your health centre have one ?

    Cheers
    Sathyaram

    Originally posted by c149187
    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
    Visit the new-look IDUG Website , register to gain access to the excellent content.

  3. #3
    Join Date
    Jul 2003
    Posts
    50

    Re: Monitoring SORT OVERFLOWS / UDB 8.1

    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

  4. #4
    Join Date
    Jul 2003
    Location
    Austin, TX, USA
    Posts
    278

    MOnitoring Sort Overflows.

    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
    Last edited by nitingm; 11-12-03 at 05:54.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •