High used/allocated RBA count
I would have preferred that - if that was possible. Since I need "USED"
space value as opposed to "ALLOCATED" space value, and specially for
indexes, there is no reliable way to find out how much space an Index is
using from DB2 catalog. I routinely do LISTCAT to find out what the
high-RBA count is (it keeps changing with DB2 activity, but that' OK),
and it is much too tedious.
Thanks for your response.
Please respond if anyone knows how to find out space utilization for a
DB2 INDEX.
Paresh
Quote:
> Praesh,
> > I need to find out how much space is actually being used by DB2 allocated
> > vsam linear dataset.
> Do nothing outside of DB2 on a DB2 controlled VSAM dataset. Use the
> DB2 STOSPACE-Utility and use SQL to get the statistics form DB2-catalog.
> Roland