RE: dropping chunk

Hi howie. It is to 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). Regards. -- Tsutomu Ogiwara from Tokyo Japan. ICQ#:168106592 >From: howie_lfc@hotmail.com (howie) >Reply-To: howie_lfc@hotmail.com (howie) >To: informix-list@iiug.org >Subject: dropping chunk >Date: 8 Apr 2005 03:37:05 -0700 > >Hello all, > >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? > >Thanks in advance, > >Howard sending to informix-list

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/