informix/sap r3 deleting a chunk

[nibble]

guys, ive added a chunk to my server. unfortunately, the raw device with its volume was deleted and could no longer be recovered. how could i delete that chunk? bytheway, the chunk is still empty..thanks.

[Victor Fridyev]

Hi,

Try to use this command with -f:
onspaces -d spacename [-p pathname -o offset] [-f] [-y]. If the command doesn't work because of the chunk absense, create an empty file with the chunk name and try to drop it.If this doesn't work, I hope, you can use the following trick:
Create a new chunk, link it the deleted one, backup the new chunk by dd, drop the old chunk, restore the new one and drop it.

All these things ( except link ) you can do via onmonitor.
HTH

[nibble]

thanks, ive already created the file with the chunk name, no avail...but i wana try your trick... please provide the step by step...im not so familiar with informix.. much more with dd

chunkname: data50
old/deleted path: /dev/data01/rvoldata50

thanks..

[Victor Fridyev]

Hi,

I suppose the follwing:
touch /tmp/chunk; chmod 664 /tmp/chunk; chown informix:informix /tmp/chunk
Replace spacename with the real spacename name. The command below creates chunk 20 MB
onspaces -a spacename -p /tmp/chunk -o 0 -s 10000
dd if=/tmp/chunk of=/tmp/bckp
ln -s /tmp/chunk name_of_deleted_chunk
onspace -d spacename -p name_of_deleted_chunk -o 0 -f -y
dd if=/tmp/bck of=/tmp/chunk
onspace -d spacename -p /tmp/chunk -o 0 -f -y

[nibble]

hi vic,

should i stop the database before adding the chunk? or should this online..what we're doing is startsap/stopsap to start the db..by the ways its on top of ux11.00

[nibble]

hi vic, here's more details

onstat -d

ce052b18 223 3 8 1023991 1023988 PD- /informix/PRD/sapdata/physdev5/data54

does D here means its deactivated?

isapprd:informix 25> onspaces -d psapstab -p /informix/PRD/sapdata/physdev5/data54 -o 0
WARNING: Dropping a chunk.
Do you really want to continue? (y/n)y
Chunk not dropped.
ISAM error: No such chunk

[Victor Fridyev]

Hi Nibble,

All these actions should be done when the DB is up&running.

The flags: P means Primary, D means Down

I'm not sure that you have to stop/start the DB, because I'm afraid that DB will not start up without one of its chunks

HTH