RE: Deleting Chunk..
Hello
} -----Original Message-----
} From: AlvinKoh@WriteMe.COM [SMTP:AlvinKoh@WriteMe.COM]
} Sent: Thursday, November 13, 1997 7:05 AM
} To: informix-list@rmy.emory.edu
} Subject: Re: Deleting Chunk..
}
} Are you daring enough to mess with the reserved pages? I wrote a
} program
} to read the reserved pages to a text file, and one to write the text
} file
} back.
}
} By modifying the text file, I can rename my chunks and paths, and even
} drop chunks. tbcheck -cr and -ce goes thru fine, but tbcheck -pe still
} thinks that dropped chunk exists. I haven't figured that part yet. But
} anyone with the Informix know-how could take the programs and make it
} work. Anyone want to try?
[Scott] When I took the internal architecture class some
similar procedures came to mind (such as changing the next value on a
serial field). When I made the mistake of mentioning this to the
instructor I got a five or ten minute wrist slapping, and boo-hoo'ing.
Something along the lines of <I> am too stupid to do this
without totally destroying the database. Be prepared to get this from
Jonathan, Clem, and the others. I think Informix makes them sign
something saying they will discourage anyone from doing this. (And for
good reason I suppose)
} Drop me a mail at AlvinKoh@WriteMe.COM if you are interested.
[Scott] On the other hand I would like to see how you're doing
it (for academic reasons only, of course ;-)
} PS. Don't forget LEVEL 0 ARCHIVE and save your tbconfigs before doing
} anything.
}
} Rgds
} Alvin
}
} In article <6465eo$1r2@cssun.mathcs.emory.edu>,
} himnesh@bom-co.IN.DHL.COM
} ("Mr. Himnesh Kapoor") wrote:
}
} >}From : mail>nbl@hpsc.hisd.harris.com
} >To : "Mr. Himnesh Kapoor" himnesh@bom-co.in.DHL.COM
} >Subject : Re: Deleting Chunk..
} >Date : 09/11/97 22:20
} >
} >
} >Hello,
} >
} >We are working on Informix Online version 5.03. In tbspaces
} >command it gives the option to delete DBspace(s) but there is no
} >option to delete the chunk.
} >
} >Thanks
} >
} >Himnesh
} >---------------------------------------------------------------------
} >use the onspaces command.
} >------------------------
} >On 7 Nov 1997, Mr. Himnesh Kapoor wrote:
} >
} >} Hello Everybody.,
} >}
} >} We are working on Informix Online 5.03 on HP-UX 10.10.
} >} I have a DBSpace which has a chunk. I need to remove this chunk
} from
} >} the DBSPACE. Is there way do that.
} >}
} --------------------------------------------------------------------
} >} RSAM Version 5.03.UC5X1 -- On-Line -- Up 01:46:39 -- 11312 Kbytes
} >}
} >} Dbspaces
} >}
} >} address number flags fchunk nchunks flags owner name
} >} c0a5d5c8 1 1 1 3 N informix
} sisdbs
} >} 1 active, 8 total
} >}
} >} Chunks
} >}
} >} address chk/dbs offset size free bpages flags pathname
} >}
} >} c0a5d108 1 1 6 1000000 399032 PO-
} /dev/rootdbs.sis
} >} c0a5d1a0 2 1 0 86000 85997 PO-
} /dev/rootdbs.sis1
} >} c0a5d238 3 1 5 375000 374997 PD-
} /dev/rootdbs.sam
} >} 3 active, 8 total
} >}
} >} I need to remove the last chunk (/dev/rootdbs.sam).
} >}
} >} Thanks in advance,
} >}
} >} Himnesh
} >}
} >}
}
} --
}
} *-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*
} Alvin Koh <AlvinKoh@WriteMe.COM>
}
} ...Today's dreamers are tomorrow's achievers....ZZZZZZZZZZZ....
}
} ($$$)-($$$)-($$$)-($$$)-($$$)-($$$)-($$$)-($$$)-($$$)-($$$)-($$$)
}