Re: Calculating BLOB space table size
Using the sysmaster database and dbaccess makes it very easy:
select sum(size) as pages
from sysmaster:sysextents
where dbsname = 'your_database_name'
and tabname = 'IMAGE_REC'
Steve N. wrote:
> Is there a simple way to calculate the amount of space a BLOB table is
> using within my present DBspace? I have been trying to use "oncheck
> -cT" but I am not exactly clear what I should be looking for.
>
> I have the following BLOB table, which contains scanned TIF files of
> our company bills of lading, sales orders, etc.
>
> Table: IMAGES_REC
>
> Column name Type Nulls
> name nchar(30) no
> data byte yes
>
> Row Size 86
> Number of Rows 31012
> Number of Columns 2
>
> The oncheck gave me this info:
>
> TBLspace Flags c02 Row Locking
> TBLspace contains TBLspace
> BLOBs
> TBLspace use 4 bit bit-maps
> Maximum row size 86
> Number of special columns 1
> Number of keys 0
> Number of extents 155
> Current serial value 1
> First extent size 8
> Next extent size 4096
> Number of pages allocated 404560
> Number of pages used 401633
> Number of data pages 690
> Number of rows 31012
> Partition partnum 4198261
> Partition lockid 4198261
>
> ...and then several extents with varying sizes.
>
> Is there no command that you can use that will supply a total amount
> of bytes that this table is taking up in my dbspace?
>
> TIA,
>
> Steve