Look at nleaf in syscat.indexes to find index space usage.

Also, do "list tablespaces show detail" to see allocations to the
tablespace files.

J. Bart Coffman


Sent: Wednesday, March 29, 2006 2:15 PM
To: LazyDBA Discussion
Subject: Very Urgent


Hi All,
My database is running out off space.I calculated from the npages as
10TB
while the disk produced 14 GB.I am unable to determine where difference
in
space 4Gb is hidden.Id there anybody experienced with table
SNAPSHOT_DATABASE.
What other places the space would have consumed.Is there any space
hidden
without reporting in NAPGEs.

thanks,
Ramesh


******* Confidentiality Notice *******
This email, its electronic document attachments, and the contents of its website linkages may contain confidential health information. This information is intended solely for use by the individual or entity to whom it is addressed. If you have received this information in error, please notify the sender immediately and arrange for the prompt destruction of the material and any accompanying attachments.




DB2 & UDB email list listserv db2-l LazyDBA home page