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

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.

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.