Re: oncheck -me option Answered: amber (solid confidence) — Art Kagel (a widely trusted Informix expert in this archive) warns that the undocumented 'oncheck -me' extent-merge option was dropped because it is unsafe and can risk data loss; the original questioner's own post is only quoted, not separately archived.

Advisory only.

Posted in 2003

💣 This thread may describe something risky to do carelessly

oncheck -me was an undocumented extent-merge option that Art Kagel says 'does not work safely' and can risk data loss; it was removed from the product for this reason.

oncheck -me

Advisory only — not a substitute for testing in a non-production environment first.

Art S. Kagel — Wed, 24 Dec 2003 14:41:10 -0500 — source: Usenet: comp.databases.informix

On Tue, 23 Dec 2003 20:25:12 -0500, Wayne T wrote: Browse the archives again! That option was never documented and has since been dropped for several reasons: It does not work safely! You risk your data if you use it. This was covered on the list a few days after the initial posting identifying the 'feature'. Join those of use who have put in a feature request for a safe and complete 'compress partition' command or oncheck option and maybe we'll see it in 9.6 or so. Art S. Kagel > Hi all, > > Does any body know what's IDS version I can use "oncheck -me partnum <taget > extent>" This option allow to merge all extents into single extents and will > not drop and recreate the table. Any info would be appreciated. > > --Wayne > > PS: or any similar tool do same as above and work on IDS 9.21. Thanks and > Merry XMAS