Results 1 to 3 of 3
  1. #1
    Join Date
    Aug 2004
    Posts
    7

    Unanswered: Change Dbspace status from BLOB to Normal

    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

  2. #2
    Join Date
    Mar 2004
    Location
    Netherlands
    Posts
    183

    Big Chunk

    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

  3. #3
    Join Date
    Aug 2004
    Posts
    7
    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •