RE: oncheck -me

Malcolm There have been several threads on this, particularly:- http://groups.google.com/group/comp.databases.informix/browse_thread/thread/ac2f0882c890f46a/825ba9ba79a9b877?q=%22oncheck+-me%22&rnum=1#825ba9ba79a9b877 Keith -> -----Original Message----- -> From: mweallans@panacea.co.uk [mailto:mweallans@panacea.co.uk] -> Sent: Wednesday, January 25, 2006 11:45 AM -> To: informix-list@iiug.org -> Subject: oncheck -me -> -> -> The Migration Guide refers to a command - oncheck -me - -> -> "Use the oncheck -me command to compress extents and reduce -> the amount -> of storage used in partition headers." Page 3-49 of the 9.4 -> Migration -> Guide -> -> But I can find no reference to this anywhere else in the -> documentation. -> -> -> Is there any more information available on what this does? -> -> regards -> -> Malcolm -> -> _______________________________________________ -> Informix-list mailing list -> Informix-list@iiug.org -> http://www.iiug.org/mailman/listinfo/informix-list -> ********************************************************************************** This message is sent in strict confidence for the addressee only. It may contain legally privileged information. The contents are not to be disclosed to anyone other than the addressee. Unauthorised recipients are requested to preserve this confidentiality and to advise the sender immediately of any error in transmission. This footnote also confirms that this email message has been swept for the presence of computer viruses, however we cannot guarantee that this message is free from such problems. **********************************************************************************

Simmons, Keith wrote: > There have been several threads on this, particularly:- > http://groups.google.com/group/comp.databases.informix/browse_thread/thread/ac2f0882c890f46a/825ba9ba79a9b877?q=%22oncheck+-me%22&rnum=1#825ba9ba79a9b877 > -> -----Original Message----- > -> From: mweallans@panacea.co.uk [mailto:mweallans@panacea.co.uk] > -> > -> The Migration Guide refers to a command - oncheck -me - > -> > -> "Use the oncheck -me command to compress extents and reduce > -> the amount > -> of storage used in partition headers." Page 3-49 of the 9.4 > -> Migration > -> Guide > -> > -> But I can find no reference to this anywhere else in the > -> documentation. > -> > -> > -> Is there any more information available on what this does? Bear in mind that this is the Migration guide, and that the discussion includes migrating from IDS 7.x to IDS 9.4. This chapter is about migrating from 9.x, 7.3x or 7.24 - and the section is about preparing to upgrade. The 'oncheck -me' option is specific to IDS 7.3x (and was not added in 7.30.UC1 or 7.31.UC1 IIRC), so you need to scout around the 7.3x manuals and/or documentation notes or release notes to find out about it. I think it could usefully be marked as specific to the 7.3x source versions of IDS. No; I actually haven't gone looking at the 7.3x documentation or release notes. If it isn't there either, it is a somewhat separate bug. As to what '-me' (merge extents) does: it moves data pages around so that the number of extents in the table is reduced, reducing the chances of failing during upgrade. -- Jonathan Leffler #include <disclaimer.h> Email: jleffler@earthlink.net, jleffler@us.ibm.com Guardian of DBD::Informix v2005.02 -- http://dbi.perl.org/

Is oncheck -me supported in IDS 10? Zev Berezin From: Jonathan Leffler <jleffler@earthlink.net> Organization: Randomly Disorganized Subject: Re: oncheck -me Date sent: Thu, 26 Jan 2006 04:48:55 GMT To: informix-list@iiug.org > Simmons, Keith wrote: > > There have been several threads on this, particularly:- > > http://groups.google.com/group/comp.databases.informix/browse_thread/thread/ac2f0882c890f46a/825ba9ba79a9b877?q=%22oncheck+-me%22&rnum=1#825ba9ba79a9b877 > > > -> -----Original Message----- > > -> From: mweallans@panacea.co.uk [mailto:mweallans@panacea.co.uk] > > -> > > -> The Migration Guide refers to a command - oncheck -me - > > -> > > -> "Use the oncheck -me command to compress extents and reduce > > -> the amount > > -> of storage used in partition headers." Page 3-49 of the 9.4 > > -> Migration > > -> Guide > > -> > > -> But I can find no reference to this anywhere else in the > > -> documentation. > > -> > > -> > > -> Is there any more information available on what this does? > > Bear in mind that this is the Migration guide, and that the discussion > includes migrating from IDS 7.x to IDS 9.4. This chapter is about > migrating from 9.x, 7.3x or 7.24 - and the section is about preparing to > upgrade. The 'oncheck -me' option is specific to IDS 7.3x (and was not > added in 7.30.UC1 or 7.31.UC1 IIRC), so you need to scout around the > 7.3x manuals and/or documentation notes or release notes to find out > about it. I think it could usefully be marked as specific to the 7.3x > source versions of IDS. > > No; I actually haven't gone looking at the 7.3x documentation or release > notes. If it isn't there either, it is a somewhat separate bug. > > As to what '-me' (merge extents) does: it moves data pages around so > that the number of extents in the table is reduced, reducing the chances > of failing during upgrade. > > -- > Jonathan Leffler #include <disclaimer.h> > Email: jleffler@earthlink.net, jleffler@us.ibm.com > Guardian of DBD::Informix v2005.02 -- http://dbi.perl.org/ > _______________________________________________ > Informix-list mailing list > Informix-list@iiug.org > http://www.iiug.org/mailman/listinfo/informix-list >