Stanley Bradbury wrote:
Geoff hendrey wrote:
Is there a utility or command that I can use to
identify the disk space (bytes) occupied by a
particular table?
The query listed at the link below can be used to determine the filename
for a table or tables in a database. You can then check the size
directly or feed the results into a routine that reports the size.
Another option is to use DerbyDiskSpaceDiag.java attached to the
following Jira:
https://issues.apache.org/jira/browse/DERBY-2549
It is not polished, but shows you the space of tables and indexes.
hth,
--
Kristian
http://www.ibm.com/developerworks/db2/library/techarticle/dm-0408bradbury/#cs_map_filename
Note that this query requires the user function bigintToHexString be
created. This is documented in the section just above the one pointed
to by the URL provided.
Hope this helps.
