Results 1 to 4 of 4
  1. #1
    Join Date
    Aug 2003
    Location
    India
    Posts
    262

    Unanswered: System Monitoring Scripts

    Hi all,

    does any one have scripts to find out in which dbspace my database/tables are created. In which dbspaces my index are created and some additonal scripts for monitoring the server. Also is there any GUI tool to monitor the database

    Regards,

    lloyd

  2. #2
    Join Date
    Aug 2002
    Location
    Belgium
    Posts
    534
    There are lots of third party tools.
    Internally, you can look at ISA.

    if you do a

    select hex(partnum), tabname
    from systables
    where tabid > 99

    you get a number like this: 0x00100100

    the 0x001 points to the chunk id, the rest is the page number of the tblspace of the table in the chunk.

    same for indexes.
    rws

  3. #3
    Join Date
    Aug 2002
    Location
    Belgium
    Posts
    534
    You also might want to check
    http://www.iiug.org
    and
    http://www.oninit.com

    http://www.herber-consulting.de is an example of a third party tool
    rws

  4. #4
    Join Date
    Aug 2003
    Location
    India
    Posts
    262
    Originally posted by Roelwe
    You also might want to check
    http://www.iiug.org
    and
    http://www.oninit.com

    http://www.herber-consulting.de is an example of a third party tool
    Hi Roelwe,

    Thanks once again mate.

Posting Permissions

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