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

At 08:34 AM 3/13/95 GMT, spitz@ana.med.uni-muenchen.de wrote: >Jon C. Vemo (jvemo@cyberspace.com) wrote: >: In the DSA releases (6.0 and beyond), the >: locking scheme was changed, to 'key value locking' which only locks the >: current record. In order to do this, the index structure was changed >: slightly, adding an extra byte per index row. For this reason, when >: 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. If you read further in the migration guide (should be included with Doc set), it states that the system tables will be converted automatically, and the 'sysmaster' database is created. It should also state that all 'user' tables with indexes, will need to be converted. This can be accomplished a couple different ways, one of which is through 'update statistics'. When run the first time, it will detect your indexes in the old format, and automatically convert. However I have found that it quicker to drop and create them seperately, before running update stats. If you'd like, we can take this off-line, and discuss further. Jon ================================================================== Jon Vemo Internet: jvemo@cyberspace.com Bothell, WA USA ------------------------------------------------------------------ Watch out for road-kill on the information superhighway....SPLAT!! ==================================================================