Smart Large Objects: Sbspace is full
At first, I created following table to store PDF data in column img_doc.
create table img
(
img_key varchar(40),
img_no integer,
img_doc "informix".blob,
) PUT img_doc in
(
img_db01,
img_db02
);
Sometimes later, SBspace img_db01 and img_db02 were full. Therefore, I
added other new SBspace img_db03 and img_db04 to the column.
create table img
(
img_key varchar(40),
img_no integer,
img_doc "informix".blob,
) PUT img_doc in
(
img_db01,
img_db02,
img_db03,
img_db04
);
Sometime later, when I insert row to the table. I got following message.
9810: Smart-large-object error.
12031: Smart Large Objects: Sbspace is full.
I found that the first 2 SBspace are full but img_db03 and img_db04 are
still have a lot of space.
Can I balance the data in the four SBspaces except to delet and re-insert
all the row?