db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Kristian Waagan <Kristian.Waa...@Sun.COM>
Subject Re: a command to show table file-size?
Date Wed, 13 Jun 2007 09:18:05 GMT
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:

It is not polished, but shows you the space of tables and indexes.


> 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.

View raw message