Results 1 to 4 of 4

Thread: Drop Chunk

  1. #1
    Join Date
    Feb 2004
    Location
    Austria
    Posts
    2

    Unanswered: Drop Chunk

    Hi,

    I need help!!!

    Informix Online Version 5.10.
    I have add a new chunk with "tbspaces".
    I used a wrong offset, now is the new chunk number 22 on the same space as the old chunk number 11.

    view with tbstat -d:
    Chunks
    Adress chk/dbs offset size free bpages flags pathname
    .
    .
    10040ac8 11 2 0 1000000 48 PO- /dev/ios0/rsraid01l0s9
    .
    .
    10041150 22 3 500000 131000 130997 PO- /dev/ios0/rsraid01l0s9
    .
    .



    Can I remove the new chunk number 22 ?

    Or can I drop down the chunk, that it doesn't use, like "onspaces -d" at version 7.x ?

  2. #2
    Join Date
    Aug 2002
    Location
    Belgium
    Posts
    534
    Best thing you can do is drop the chunk on th einstance level. Isn't there a flag on tbspaces to drop the chunk?
    rws

  3. #3
    Join Date
    Feb 2004
    Location
    Austria
    Posts
    2
    Originally posted by Roelwe
    Best thing you can do is drop the chunk on th einstance level. Isn't there a flag on tbspaces to drop the chunk?
    I think at version 5.x is no flag on tbspaces t drop a chunk.

  4. #4
    Join Date
    Aug 2003
    Location
    Argentina
    Posts
    780

    Re: Drop Chunk

    Originally posted by g.rath
    Hi,

    I need help!!!

    Informix Online Version 5.10.
    I have add a new chunk with "tbspaces".
    I used a wrong offset, now is the new chunk number 22 on the same space as the old chunk number 11.

    view with tbstat -d:
    Chunks
    Adress chk/dbs offset size free bpages flags pathname
    .
    .
    10040ac8 11 2 0 1000000 48 PO- /dev/ios0/rsraid01l0s9
    .
    .
    10041150 22 3 500000 131000 130997 PO- /dev/ios0/rsraid01l0s9
    .
    .



    Can I remove the new chunk number 22 ?

    Or can I drop down the chunk, that it doesn't use, like "onspaces -d" at version 7.x ?
    Hi,

    Yes, you can drop the chunk using "onmonitor" and use the proper offset value.
    I suggest that run level 0 back-up before and after.

    Gustavo.

Posting Permissions

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