Calculating BLOB space table size
Posted in 2004
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