db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Stanley Bradbury <Stan.Bradb...@gmail.com>
Subject Re: a command to show table file-size?
Date Tue, 12 Jun 2007 22:50:43 GMT
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.

 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.



Mime
View raw message