Results 1 to 4 of 4
  1. #1
    Join Date
    Dec 2016
    Posts
    18

    Unanswered: How add a space dbaces

    Team ,

    Please help me how add a additional space in apart from existing space ,below are the space details added for reference.


    onstat -d

    IBM Informix Dynamic Server Version 12.10.FC6AEE -- On-Line -- Up 17 days 20:01:12 -- 653480 Kbytes

    Dbspaces
    address number flags fchunk nchunks pgsize flags owner name
    4d209028 1 0x1 1 1 2048 N BA informix rootdbs
    4fa67d88 2 0x1 2 1 2048 N BA informix logdbs
    50a95d58 3 0x2001 3 1 2048 N TBA informix tmpdbs
    4fff3bf8 4 0x1 4 1 8192 N BA informix datadbs
    50119530 5 0x1 5 1 8192 N BA informix indexdbs
    50691d58 6 0x8001 6 1 2048 N SBA informix sbdbs
    503a3b58 7 0x1 7 1 8192 N BA informix tsdbs
    504a95c0 8 0x1 8 1 8192 N BA informix ts1dbs
    503a3d98 9 0x1 9 1 8192 N BA informix ts2dbs
    50698580 10 0x1 10 1 8192 N BA informix ts3dbs
    4fef4d58 11 0xa001 11 1 2048 N UBA informix tmpsbdbs
    500a8a10 12 0x1000001 12 1 2048 N PBA informix plogdbs
    12 active, 2047 maximum

    Chunks
    address chunk/dbs offset size free bpages flags pathname
    4d209268 1 1 0 150000 100250 PO-B-D /sbt_data/opt/informix_storage/rootdbs
    50a95028 2 2 0 500000 4947 PO-B-D /sbt_data/opt/informix_storage/logdbs
    4fada028 3 3 0 500000 499897 PO-B-- /sbt_data/opt/informix_storage/tmpdbs
    50490028 4 4 0 1250000 1211911 PO-B-D /sbt_data/opt/informix_storage/datadbs
    50691028 5 5 0 125000 118002 PO-B-D /sbt_data/opt/informix_storage/indexdbs
    4fef4028 6 6 0 500000 466266 466272 POSB-D /sbt_data/opt/informix_storage/sbdbs
    Metadata 33675 25057 33675
    4fe7a028 7 7 0 125000 124947 PO-B-D /sbt_data/opt/informix_storage/tsdbs
    4fe7c028 8 8 0 250000 249947 PO-B-D /sbt_data/opt/informix_storage/ts1dbs
    5034a028 9 9 0 250000 249947 PO-B-D /sbt_data/opt/informix_storage/ts2dbs
    503a1028 10 10 0 250000 249947 PO-B-D /sbt_data/opt/informix_storage/ts3dbs
    509ef028 11 11 0 50000 46558 46558 POSB-- /sbt_data/opt/informix_storage/tmpsbdbs
    Metadata 3389 2522 3389
    50817028 12 12 0 50000 0 PO-BED /sbt_data/opt/informix_storage/plogdbs
    12 active, 32766 maximum

    NOTE: The values in the "size" and "free" columns for DBspace chunks are
    displayed in terms of "pgsize" of the DBspace to which they belong.


    Expanded chunk capacity mode: enabled

    Thanks

  2. #2
    Join Date
    May 2008
    Posts
    33
    Please verify that you have space left on
    /sbt_data/opt/informix_storage This is where your chunks currently are.
    Those seem to be cooked files as you using direct I/O ("D" flag in lower part of onstat -d)


    The upper part of onstat -d shows spaces, lower one chunks.

    First create a new chunk by running:

    touch /sbt_data/opt/informix_storage/NAME_OF_CHUNK
    chown informix:informix /sbt_data/opt/informix_storage/NAME_OF_CHUNK
    chmod 660 /sbt_data/opt/informix_storage/NAME_OF_CHUNK


    Next step depends whether you want to add a new space or add a new chunk to a space.

    To add a new space, use

    onspaces -c -d NAME_OF_SPACE -p /sbt_data/opt/informix_storage/NAME_OF_CHUNK -o 0 -s SIZE_IN_KB

    To add a new chunk to an existing space, use

    onspaces -a NAME_OF_SPACE -p /sbt_data/opt/informix_storage/NAME_OF_CHUNK -o 0 -s SIZE_IN_KB

  3. #3
    Join Date
    Dec 2016
    Posts
    18
    Thanks with the response.

  4. #4
    Join Date
    May 2008
    Posts
    33
    hi,

    ok please mark thread answered then

Posting Permissions

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