IDS Forum

RE: SBSPACE FULL

Posted By: Stuart McCann
Date: Tuesday, 17 February 2009, at 5:35 p.m.

In Response To: SBSPACE FULL (JULIO FLORES)

Is the SBSpace the Deafult SBSpace ?

Does the SBSpace store data from more than 1 table?

What data type is being stored, BLOB, CLOB, Spatial ??

At a minimum, each SmartBlob will use 1 page ( 2 or 4 K ) depending on
page size. So 100,000 x 2 or x 4 is 200,000 or 400,000 KB at a minimum,
however, check the output of onstat -g sms s, this will give you info on
the space reserved by default for each smart blob. The output will look
something like this for each smartBlob space:-

sbnum 19 address 5c7b3760

Space : flags nchk owner sbname

-------- 1 informix xxxsbs

Defaults :

LO : ud b/pg flags flags avg s/kb max lcks

2048 0 -------- 4 -1

Ext/IO : 1st sz/p nxt sz/p min sz/p mx io sz

0 0 0 -1

HdrCache : max free

512 0

Take note of the avg, in the output above, each smart blob will have at
least 3x2K Pages (6KB) or 2x1 4K Pages allocated when a blob is stored
in this smart blob space. This value is set either when the Smart Blob
Space is created using onspaces -c -S sbSpacename -p pathToChunk -o
offset -s size -DF "AVG_LO_SIZE=4", or onspaces -ch sbSpacename -Df
"AVG_LO_SIZE=4".

If the avg size of your blobs is < 2K (which it sounds like it is) then
AVG_LO_SIZE should be set to 1 so that only 1 page (2 or 4K) will be
used per blob. If you set it to 2 ( on a 2K Page Size system) then
because of the blob page overhead Informix will allocate 2 Pages per
blob.

You can see the size of each smartBlob extent using oncheck -pe
smartBlobSpace. This is the size ( in pages ) allocated to each smart
blob. If you used onspaces -Df "AVG_LO_SIZE=N", then that will be the
minimum extent size reserved for each smart blob.

You can also, check dbschema -d database -ss and look for blob storage
specification like this:-

put blobCol in ( sbSpace ) ( extent size N )
where N = Avg KB per blob.

Unfortunately there is not a size() function which will work with all
types of smart blobs. You can download the SBInfo Blade which will work
with BLOBs and CLOBs but not other UDTs.

It's all a bit kludgey, but hope the above helps and good luck with it.

Stuart McCann
Integrated Spatial Services Unit
Information Communication & Technology
Department of Lands, Bathurst

Phone: (02) 63328284
stuart.mccann@lands.nsw.gov.au

-----Original Message-----
From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of
JULIO FLORES
Sent: Wednesday, 18 February 2009 3:06 AM
To: ids@iiug.org
Subject: SBSPACE FULL [14899]

I have a sbspace with 50GB. I stored 100,000 and recived a message of
space
full.

I created the sbspace with 25 chunks of 2GB each, with the default
options.

this objects store only 5MB in File System. How can I calculate the
space used
for each object in my sbspace?.

The message are:

2396128 - transacciondm CR Wait -9810 -12031 9.03 Off
2396103 - transacciondm CR Wait -9810 -12031 9.03 Off

$ finderr 9810

-9810 Smart-large-object error.

An error occurred during the processing of a smart large object.

For more information, check the accompanying, detailed
smart-large-object
error code.

$ finderr 12031

-12031 Smart Large Objects: Sbspace is full.

The user data area or areas have insufficient storage for a write
request.
Delete some smart large objects or add a chunk to the sbspace.

************************************************************************
*******
Forum Note: Use "Reply" to post a response in the discussion forum.

***************************************************************
This message is intended for the addressee named and may contain confidential information. If you are not the intended recipient, please delete it and notify the sender. Views expressed in this message are those of the individual sender, and are not necessarily the views of the Department of Lands. This email message has been swept by MIMEsweeper for the presence of computer viruses.
***************************************************************
Please consider the environment before printing this email.

Messages In This Thread

• SBSPACE FULL
  JULIO FLORES -- Tuesday, 17 February 2009, at 11:05 a.m.
  • RE: SBSPACE FULL
    Stuart McCann -- Tuesday, 17 February 2009, at 5:35 p.m.

IDS Forum is maintained by Administrator with WebBBS 5.12.