RE: Calculating BLOB space table size
you can also run,
oncheck -pB <database name>:<table name>
the above command will give you the number of blobpages used by the table in the blobspace
-----Original Message-----
From: owner-informix-list@iiug.org
[mailto:owner-informix-list@iiug.org]On Behalf Of John Miller
Sent: Tuesday, February 15, 2005 12:59 AM
To: informix-list@iiug.org
Subject: Re: Calculating BLOB space table size
Steve:
I would suggest using oncheck -pT database:table. You will get a
report and part of this report has a detail section on space utilization
of blobs stored in the table. (see below) The line with "TBLspace
BLOBs" will tell you how many pages are being used, and how
full each page is.
If you feel like this table is growing two large consider using
fragmentation. Also you might want to consider change your next
extent size using the SQL command ALTER TABLE. Updating the
extent size with the ALTER TABLE statement just updates this
attribute on the table.
TBLspace Usage Report for d1:miller3.t2
Type Pages Empty Semi-Full Full Very-Full
---------------- ---------- ---------- ---------- ---------- ---------
Free 7
Bit-Map 1
Index 0
Data (Home) 0
TBLspace BLOBs 0 0 0 0 0
----------
Total Pages 8
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
sending to informix-list