Unanswered: Change Dbspace status from BLOB to Normal
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
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.