Re: dropping chunk

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/