Hi,

I want write a script to reflect the status of tablespace consumed by the database . Can anyone please tell me which SYS table contains the information of free pages and used pages.? I am aware of table SYSTABLESPACES but it contains only static information.
Also it would be great if anyone can tell where(in which sys tables) i can see log space consumption and temp space consumption, and max agents reached details/

Thanks
Kunal

What you need is snapshot table functions (e.g. snap_get_db(), snap_get_tbsp())

That doesn't answer your question (n_i already mentioned snapshot functions), but you should never use the SYSIBM.SYS* tables on DB2 for LUW (except SYSIBM.SYSDUMMY1). Those tables are not documented and may change at any time. Instead, rely on the catalog views in the SYSCAT schema.

Thanks . I can see that there is SYSCAT schema which contains SNAP views which will serve the purpose to some extent.

But i can see that it will give me infomration only AT THE MOMENT snapshot is taken . I will not get information like what is the resourse consumed over the batch window of say 4 hrs i.e what is total memory consumed and whats MOMENTARY MAX limiit reached..etc .from where would i get that statistics over period?

if you need to study tablespace behaviour over a period create Event Monitor

CONNECT TO DBNAME ;
CREATE EVENT MONITOR as FOR TABLESPACES WRITE TO TABLE BUFFERSIZE 4 BLOCKED MANUALSTART ;
CONNECT RESET;

this will create a table tablespace_as where u can see the details

Thanks .It was great advice .

But this will be enough for monitoring TABLESPACE consumption . Could you please also tell similer thing to monitor log space and temp space consumption?

Thanks
Kunal

Hi ,
I have created event monitor ...started it and stopped after some time...now when i want to analyse the data ... i dont see any data in the table TABLESPACE_AS...any ideas whats gone wrong?

Nothing. Except, may be, the fact that you didn't read the manual, which says that "the event monitor records a table space event for each table space when the last application disconnects from the database".