Re: Going from 5.03 to 7.21 (any suggestions!)

rcyrus@promarkone.com wrote in article <850845687.4774@dejanews.com>... > We will be going from 5.03 ONLINE to 7.21 ONLINE and also from SUNOS 4.1.3 > to SUN SOLARIS 2.5. > > Basically we were going to Install the 7.21 release, lay out the root/Log > logs/Phy. logs etc then get the 5.03 database dbschema's, unload the load > it to the 7.21 release, using > > * tbunload and onload or > * dbexport and dbimport or > > can we use tbunload with HPL (parallel loader)? > Has anybody used HPL successfully from one Informix Online to another? > What other methods have you guys used to go from 5.x to 7.x > > robin cyrus > Sr. informix DBA > Promark 1 inc > Scottsdale AZ > > -------------------==== Posted via Deja News ====----------------------- > http://www.dejanews.com/ Search, Read, Post to Usenet You don't say how large your database(s) is (are) -- this makes a big difference in the choice of data migration methods. I've done a few 5.x -> 7.x conversions where we dbexport'ed from 5 and then dbimport'ed to 7. In some case the export was to disk, in other cases to tape. In some cases we tweaked the SQL schema created by dbexport to resize table extents, place tables in differenet dbspaces, etc. On some recent exports/imports from 7 to 7, we have also rearranged things so that table indexes get created AFTER all of the data is loaded, rather than as the data is loaded. This can make a BIG time difference on larger databases. Please e-mail me if you're interested in more detailed assistance. -- Irwin Goldstein Objective Software Systems, Inc. http://www.objectsoft.com