RE: oncheck -me

Dave oncheck -me was an undocumented and unsupported option intended onlyfor use by Tech Support in order to resolve upgrade problems. There were a couple of threads regarding it in Sept/Oct 2003. It also needs RASHELP set souse that to search as well. As it is now documented I assume it must be supported but be careful. Originally the command was not logged, could not be rolled back, was not completed internally and was not completely safe. I have run it in a test environment on data tables, never on system tables and I cannot remember the locking (if any !! ). Keith -> -----Original Message----- -> From: Dave Griffen [mailto:dgriffen@nospam.finishline.com] -> Sent: Wednesday, September 08, 2004 11:34 PM -> To: informix-list@iiug.org -> Subject: oncheck -me -> -> -> In preparation for a migration from 7.3 to 9.4, I've come across the -> following passage from page 3-49 of the Migration Guide... -> -> Partition header pages should not be full; key descriptors -> will occupy -> slightly -> more space after conversion to Dynamic Server 9.40. Use the -> oncheck -me -> command to compress extents and reduce the amount of storage used in -> partition headers. -> -> I'd like to know more about the oncheck -me command such -> as...does this -> command require exclusive use of key systems tables or can -> it be run while -> users are still online? I have some databases where tables such as -> sysconstraints and syscolumns have large numbers of extents. -> Would this -> command help consolidate these tables? -> -> I've looked for information on this command but I can't find -> it referenced -> anywhere in the Administrator's Guide or Administrator's -> Reference and -> oncheck -? doesn't even list -me as a valid switch. I've -> also done a Google -> search which did not return anything usefull. I've opened a -> tech support -> case asking for information on this as well (the tech had -> never heard of -> oncheck -me either...he is looking into it). -> -> So after all that, can anyone here help provide some -> information about -> oncheck -me? -> -> ********************************************************************************** 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. ********************************************************************************** sending to informix-list