CHUNKS AND SMARTBLOB ERROR...
Tsutomu Ogiwara
Hi Hector.
Do you try Level-0 backup?
Do you set SBSPACENAME in your onconfig file?
Check it out above.
Regards.
At 14:08 01/06/11 -0500, Hector C. Moreno wrote:
>
>Hi everybody, i need your help!
>
>I'm using Informix Universal Server 9.12 on Solaris 5.5.1
>
>I'm inserting images into a database, but the last week an error occur
>while I'm trying to insert them.
>
>9810: Smart Blob error
>12031: Smart Blobs: Sbspace is full
>
>I understand that i must add a chunk to the sbspace, and I added a chunk
>via onmonitor (it size is 300MB) but by some reason the error continues
>and i can't insert more images. The image's size is small (~100KB)
>
>When i added the chunk to the sbspace I put an offset of 0 KB is that
>correct?
>
>the sbspace have 3 chunks: the primary chunk (when IUS was installed),
>and other 2 chunks (10MB and 300MB), both of them have 0 offset.
>
>Chunk Chunk Pages Pages Full Pathname of Chunk Status
> Id Offset In Chunk Used
>
> 2 0 2000 622 /sw/informix/etc/mysb POB
> 4 0 50000 199 /bibli/.blob_ict2/mysbspace2 POB
> 9 0 150000 594 /bibli/.blob_ict2/mysbspace3 POB
>
>
>
>Do you know why the error still continues altough i already added a chunk
>(a big one)?
>
>Thanks a lot!
>
>P.D. sorry about my english... :)
>
>Hector
--
Tsutomu Ogiwara
Informix Business Promotion Dept
ITOCHU TECHNO-SCIENCE Corporation
KURITA-KUDAN BLDG., 1-11-15, FUJIMI,
CHIYODA-KU TOKYO,102-0074 JAPAN
Phone:+81-3-5226-1951 Fax:+81-3-5226-1959
E-mail:Tsutomu...@ctc-g.co.jp / tsu...@my-deja.com
Hector C. Moreno
Thanks for the advice Tsutomu, but unfortunately i'm a dba newbie,
because a i have 2 weeks administrating the database server.
> Do you try Level-0 backup?
sorry... but how do you do that?, this Level-0 backup won't affect the
data stored in the db server?
>
> Do you set SBSPACENAME in your onconfig file?
yes, the onconfig file has the SBSPACENAME
...
SBSPACENAME mysbspace # Default smartblob space name
...
Do I have to do something (like restart the database server) to the db
server detects the new chunk??
sorry about my ignorance...
:(
thanks
> Check it out above.
>
> Regards.
>
> At 14:08 01/06/11 -0500, Hector C. Moreno wrote:
> >
> >Hi everybody, i need your help!
> >
> >I'm using Informix Universal Server 9.12 on Solaris 5.5.1
> >
> >I'm inserting images into a database, but the last week an error occur
> >while I'm trying to insert them.
> >
> >9810: Smart Blob error
> >12031: Smart Blobs: Sbspace is full
> >
> >I understand that i must add a chunk to the sbspace, and I added a chunk
> >via onmonitor (it size is 300MB) but by some reason the error continues
> >and i can't insert more images. The image's size is small (~100KB)
> >
> >When i added the chunk to the sbspace I put an offset of 0 KB is that
> >correct?
> >
> >the sbspace have 3 chunks: the primary chunk (when IUS was installed),
> >and other 2 chunks (10MB and 300MB), both of them have 0 offset.
> >
> >Chunk Chunk Pages Pages Full Pathname of Chunk Status
> > Id Offset In Chunk Used
> >
> > 2 0 2000 622 /sw/informix/etc/mysbspace POB
Tsutomu Ogiwara
Hi Hector.
Answers to your questions are embedded.
At 11:28 01/06/12 -0500, Hector C. Moreno wrote:
>
>Thanks for the advice Tsutomu, but unfortunately i'm a dba newbie,
>because a i have 2 weeks administrating the database server.
>
>> Do you try Level-0 backup?
>
>sorry... but how do you do that?, this Level-0 backup won't affect the
>data stored in the db server?
Level-0 bacukp.
Run following command in command line.
ontape -s -L 0
If TAPEDEV in your onconfigfile not /dev/null, prompt in your telnet-terminal.
e.g)
TAPEDEV /dev/rmt/0
ifmx28% ontape -s -L 0
Please mount tape 1 on /dev/rmt/0 and press Return to continue ...
Else TAPEDEV is /dev/null, messages only.
e.g)
TAPEDEV /dev/null
ifmx28% ontape -s -L 0
Archive to tape device '/dev/null' is complete.
Program over.
Here is part of Administrator's Guide for Informix Dynamic Server.2000.
Adding a Chunk to an Sbspace
<snip>
After you add a chunk to the sbspace, you must perform a level-0 backup of
the root dbspace and the sbspace.
Hector C. Moreno
Hi Tsutomu, I executed 'ontape -s -L 0' and after that, i tried to insert
an image (~200KB) but the same error occurs (sbspace is full), later i
tried to insert a smaller image (~100KB) and it was inserted....
Again, i tried to insert another image (~100KB) and the error occurs
again... it appears that IUS accept smaller images than the last image
that was inserted.....
later i continued trying with different image's size(sometimes the insertion
failed) and finally... i can't insert a 10KB image...
The total size of the insertiones was ~640KB... but later a i can't
insert anymore...
For the insertion i'm using the 'FileToBlob' command... maybe i'm
inserting wrong the images??
please help me... thanks
Tsutomu Ogiwara
Hi again.
Please post onstat -d.
And check extent size in create table statement.
create table ...
put in column_name in (sb_space)
e.g)
Here is a part of "create table" in dbaccessdemo_ud.
-- create table that uses smart large objects (CLOB & BLOB) to
-- store the catalog advertisement data.
CREATE TABLE catalog
(
catalog_num SERIAL8 (10001) primary key,
stock_num SMALLINT,
manu_code CHAR(3),
unit CHAR(4),
advert ROW (picture BLOB, caption LVARCHAR),
advert_descr CLOB,
FOREIGN KEY (stock_num, manu_code, unit) REFERENCES stock
)
PUT advert IN (s9_sbspc)
(EXTENT SIZE 100),
advert_descr IN (s9_sbspc)
(EXTENT SIZE 20, KEEP ACCESS TIME);
Regards.