JCL utility by which i can find the percentage of space used

jagankallis · New User Joined: 28 Jun 2006 Posts: 29 Location: DUISBURG

Hi Friends,

I am currently working in a UAT environment of 50+ tables. Each day i load in more data.
% of free space in the tablespace is needed to b e known for each table.
Is there a JCL utility by which i can find the percentage of space used and % of space free in each table.

Please give your valuable suggestion.

Thanks a lot in advance for your co-operation

mkarmegam · New User Joined: 28 May 2006 Posts: 13 Location: USA

Are you talking about free allocated space?
Thanks
Murugesh

mkarmegam · New User Joined: 28 May 2006 Posts: 13 Location: USA

If you can run a catalog query, then the following query should give idea about freespace:

SELECT (NACTIVE*4) AS USED_SPACE , SPACE AS ALLOCATED_SPACE,
(SPACE - (NACTIVE *4)) AS FREESPACE
FROM SYSIBM.SYSTABLESPACE;