Hi,

I would like to know whether there is any utility or methods by which I can change the dbspace status from BLOB to Normal

Details : ours is Informix 9.4 FC2 on HPux11-i and we run Baan IVc4 ERP application.

Earlier idxdbs dbspace was created as normal dbspace and two chunks were added both the chunks are of normal type.
In the men time we changed our Database logging mode from ANSI to Buffered and recreated the database by loading tables thru. Baan utility.
All tables got created successfully. Database logging mode is buffered. but one change we foud is that idxdbs status has changed to N B. and earlier two chunks in this dbspace status is normal.
Now when I try to and new chunk in this dbspace idxdbs, it adds chunk successfully but with status as PO B. i.e chunk type is BLOB.
I would like to know the procedure by which I can change the dbspace status from BLOB to normal
Thanks
Jayant

In 9.40 the chunbk limit is raised from 2GB to 4TB. But to make compatibility (and reversion) possible this is optional. Probably someone has given the command onmode -BC 1 (and maybe even onmode -BC 2). THis will enable the big chunk options. Big chunks/dbspaces are specified with a B in the onstat output. This B is put on the 'new' fourth position. The B on the third position is used for BLOB spaces.

Hopes this helps,

Rob

Thanks for the reply.
pl. go thru the output of onstat -d.
"B" is at fourth place.

If you would like comment on this pl. reply.

Regards

Jayant
IBM Informix Dynamic Server Version 9.40.FC2 -- On-Line -- Up 14:07:33 -- 3611612 Kbytes

Dbspaces
address number flags fchunk nchunks flags owner name
c0000000ca802e60 1 0x1 1 1 N informix rootdbs
c0000000cba66028 2 0x1 2 4 N informix datdbs
c0000000cba661a8 3 0x2001 3 1 N T informix temdbs
c0000000cba66328 4 0x1 4 1 N informix llogdbs
c0000000cba664a8 5 0x40001 5 3 N B informix idxdbs
c0000000cba66628 6 0x1 6 1 N informix plogdbs
c0000000cba667a8 7 0x1 11 1 N informix biddbs
7 active, 2047 maximum

Chunks
address chunk/dbs offset size free bpages flags pathname
c0000000ca804028 1 1 0 250000 246449 PO-- /dev/informix/rootchk
c0000000cae24a08 2 2 0 1048575 0 PO-- /dev/informix/datchk1
c0000000cae24ba0 3 3 0 1048575 1048522 PO-- /dev/informix/tmpchk
c0000000cae24d38 4 4 0 1048575 1020522 PO-- /dev/informix/llogchk
c0000000ca804218 5 5 0 1048575 0 PO-- /dev/informix/idxchk1
c0000000ca8043b0 6 6 0 1048575 898522 PO-- /dev/informix/plogchk
c0000000ca804548 7 2 0 1048575 4 PO-- /dev/informix/datchk2
c0000000ca8046e0 8 2 0 1048575 1013712 PO-- /dev/informix/datchk3
c0000000ca804878 9 2 0 1048575 1048572 PO-- /dev/informix/datchk4
c0000000ca804a10 10 5 0 1048575 846656 PO-- /dev/informix/idxchk2
c0000000ca804ba8 11 7 0 1048575 938962 PO-- /dev/informix/bidchk1
c0000000ca804d40 12 5 0 1048576 1048573 PO-B /dev/informix/idxchk3
12 active, 2047 maximum

Expanded chunk capacity mode: disabled