MVSFORUMS.com

[arvibala]

Hi,

We are asked to write an email alert Job for a table so that if it reaches 80% of its capacity an alert needs to be sent.

So I will need 2 data for this. Actual Space and Used Space.

I was told the accurate figure can be arrived at if we able to get the VSAM files alloted for the table.

Can someone guide me through this.


Thanks
_________________
Arvind
"You can make a difference with your smile. Have that with you always"

[papadi]

One way to get space info is to do a RUNSTATS on the tablespace in which the table is residing.

Another might be a LISTCAT on the LDS in question.
_________________
All the best,

di

[kolusu]

arvibala,

Run the utility STOSPACE which updates DB2 catalog columns that indicate how much space is allocated for storage groups and related table spaces and indexes. Once that is done you can query those tables and send out the notification.

Check this link which explains in detail about The STOSPACE utility

Kolusu

[arvibala]

Thanks .. Running the Utility gives Used Space in SPACE or SPACEF column, how to find the Actual Space?
_________________
Arvind
"You can make a difference with your smile. Have that with you always"