RE: oncheck -cI

And according to IDS 10, you can build indexes online - anyone done this yet ? -----Original Message----- From: informix-list-bounces@iiug.org [mailto:informix-list-bounces@iiug.org] On Behalf Of Model-Bosch, Tilman Sent: 22 February 2006 10:48 AM To: jda; informix-list@iiug.org Subject: AW: oncheck -cI jda wrote: > We are running on HPUX 11i (B.11.11) and IDS 9.4 9.40.HC3. > > Running the oncheck -cI -y on the database did not fix the indexes, Generally I don't recommend to let oncheck repair indexes, at least not larger ones. I'd rather drop bad indices after saving their schema (use dbschema with -ss option ) , then set PDQPRIORITY and ensure PDQ resources have been set properly and then recreate the index. Regards Tilman _______________________________________________ Informix-list mailing list Informix-list@iiug.org http://www.iiug.org/mailman/listinfo/informix-list > The information on this e-mail including any attachments relates to the official business of DigiCare (Pty) Ltd. The information is confidential and legally privileged and is intended solely for the addressee. Access to this e-mail by anyone else is unauthorised and as such any disclosure, copying, distribution or any action taken or omitted in reliance on it is unlawful. Please notify the sender immediately if it has inadvertently reached you and do not read, disclose or use the content in any way. > No responsibility whatsoever is accepted by DigiCare (Pty) Ltd if the information is, for whatever reason, corrupted or does not reach its intended destination. The views expressed in this e-mail are the views of the individual sender and should in no way be construed as the views of DigiCare (Pty) Ltd, except where the sender has specifically stated them to be the views of DigiCare (Pty) Ltd. >