I am using informix 9.4 TC1
I have added SBSPACE
onspaces -c -S sbspace3 -p D:\IFMXDATA\cdr5\sbspace_dat.003 -o 0 -s 1024

which has status
Chunks
address chunk/dbs offset size free bpages flags pathname
0CFBD018 61 60 0 256 103 103 POS- D:\IFMXDAT
A\cdr5\sbspace_dat.003
Metadata 100 74 100

I have created table in this spaces using
create table IFMXprod_serv
(
id integer,
name BLOB
)
put name in (sbspace1)

I am inserting data using command
insert into IFMXprod_serv values (1,FILETOBLOB("D:\informix\toblob","server"));

After adding lot of data I got an error that Sbspace is full showing following status
Chunks
address chunk/dbs offset size free bpages flags pathname
0CFBD018 61 60 0 256 0 103 POS- D:\IFMXDAT
A\cdr5\sbspace_dat.003
Metadata 100 74 100

It seems that there is still gree space in sbspace.
How to add data into that Metadata.
even thouth i am adding with Ms option in onspaces same thing is happening.

Can anyone help.

Hi,

You can add space in metadata or user data with onspaces -ch, plase run from line command onspaces, for help.
Remember that next of create a sbspaces or add a chunk must be force change of logical logs.
Add the name in the SBSPACENAME configuration parameter.
Use onstat -d, onstat -g smb s, and oncheck -cs, -cS, -ps, or -pS to
display information about the sbspace.

Gustavo.

gustav

Thanks for help.But my problem is slightly different.I want to write into Metadata area of sbspace.
How can we do it

Metadata is the information about the object, not the object itself. You don't store into metatdata, Informix does that. You only allocated 256 pages of which 103 were available for your use before you started. You filled them up.