Databases
cancel
Showing results for 
Search instead for 
Did you mean: 

informix/sap r3 deleting a chunk

nibble
Super Advisor

informix/sap r3 deleting a chunk

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.
6 REPLIES
Victor Fridyev
Honored Contributor

Re: informix/sap r3 deleting a chunk

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
Entities are not to be multiplied beyond necessity - RTFM
nibble
Super Advisor

Re: informix/sap r3 deleting a chunk

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
Honored Contributor

Re: informix/sap r3 deleting a chunk

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

Entities are not to be multiplied beyond necessity - RTFM
nibble
Super Advisor

Re: informix/sap r3 deleting a chunk

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
Super Advisor

Re: informix/sap r3 deleting a chunk

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
Honored Contributor

Re: informix/sap r3 deleting a chunk

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
Entities are not to be multiplied beyond necessity - RTFM