Tying smart blobs to a table
Posted in 2005
Doug Conrey — — source: Usenet: comp.databases.informix
I'm trying to work out a way of determining how much space a given table
is using in the sbspace. oncheck -pB will give me this information for
simple blobs. Is there an alternative for smart blobs? oncheck -pS
doesn't seem to give me any way to attach the object to a particular
table.
Can I do something like this:
select trunc(sblobstatsize(<field>) / 4096) + 1 from <table> where
<field> is not NULL;
It seems like that's going to miss metadata and overhead.
I'm using 9.40.FC5 on AIX 5.2, if that helps.
Thanks.
DC
---------------------------------
Douglas Conrey
Production Database Administrator
OCI
Cheyenne, WY
sending to informix-list