Re: Converting 5.x -> 6.0 (was: SET ISOLATION)

} } >: migrating from 5.x to 6 or 7, all indexes must be converted (drop and } rebuild). } > } ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ } > } >Is the statement about conversion of indexes really true? The release } notes } >for our 6.0 Informix enginges (Online and SE) (Port for Siemens-Nixdorf } >RMxxx machines under SINIX 5.4x) just say that the database will be } >converted when the 6.0 engine accesses the database for the first time. } > } >Having to recreate all indexes would be a pain in the a..!!! } >Please tell me that we won't have to do that. } > } } Actually, no, you shouldn't have to physically drop and recreate all the } indexes. All you have to do is run update statistics after upgrading } (unless Jon knows something that I don't ;-) ) to 6.X or 7.XX. } Platform: SCO UNIX 3.2.4.2 Informix: SE 5.01 ---> 7.10 I've found that if you plan on using the dbschema command with the new "-hd" option (lists histograms of distribution) that running update statistics is not enough. You will get a procedure (systdist) not found message. You must do a dbexport and dbimport to fix this. It seems that unless the 7.10 SE creates the database the systdist procedure will not created. Informix tech support has comfirmed this. They said that it was not a bug and that the releases notes are in error. John -- ============================================================================== John R. Morris | email: jrm@hycel.com Director of Data Processing | phone: (314) 961-2000 fax: (314) 961-8508 ==============================================================================