Re: dropping chunk

Sorry Jonathan and all. I read the release note, and mentioned as below. 1.4.2.3 Managing the tblspace tblspace You have enhanced flexibility in managing the tblspace tblspace. The tblspace tblspace is a set of pages that describe the location and structure of all tblspaces in a given dbspace. Use the onspaces utility to move or drop the chunk containing the tblspace tblspace. Use onspaces utility. Regards. -- Tsutomu Ogiwara from Tokyo Japan. ICQ#:168106592 >From: Jonathan Leffler <jleffler@earthlink.net> >Reply-To: Jonathan Leffler <jleffler@earthlink.net> >To: informix-list@iiug.org >Subject: Re: dropping chunk >Date: Tue, 12 Apr 2005 03:43:16 GMT > >Tsutomu Ogiwara wrote: > > It is too late.. > > If your chunk has TBLSPACE TBLSPACE, you can not drop the chunk. > > Export data and drop DB space and create DB space again. > > > > If you use IDS 10.0, you can avoid this situation using oncheck >-me(IIRC). > >Not using 'oncheck -me' - that isn't in IDS 10.x (or 9.x) but only in >7.3x (and therefore has to be run before you upgrade a 7.3x instance to >IDS 9.x or 10.x). However, in IDS 10.x, you can configure the size of >your tblspace tblspace to avoid (reduce) the probability of such problems. > > > >>From: howie_lfc@hotmail.com (howie) > >> > >>IDS9.40.FC4 > >>HP-UX 11.11 > >> > >>I have successfully dropped an empty chunk from the database and tried > >>to allocate it to another dbspace (after a Level 0 Archive) I am > >>getting the message "The chunk specified already exists.". However, > >>when looking for the chunk using "onstat -d" and "oncheck -pe" no > >>reference can be found. Is there a system table where chunk > >>information is kept? How do I get around this? > > > >-- >Jonathan Leffler #include <disclaimer.h> >Email: jleffler@earthlink.net, jleffler@us.ibm.com >Guardian of DBD::Informix v2005.01 -- http://dbi.perl.org/ sending to informix-list