Simpler Navigation for Servers and Operating Systems
Completed: a much simpler Servers and Operating Systems section of the Community. We combined many of the older boards, so you won't have to click through so many levels to get at the information you need. Check the consolidated boards here as many sub-forums are now single boards.
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