Migration from 7.31 to 9.40

As it's a slow news day I'll ask about migrations. I'm testing migrating from 7.31 to 9.40, the upgrade works fines and takes around 5 mins to convert everything. The migration plan says to run onchecks (-cc, -cD, -cI, -cc, -ce) before and after. As these take quite some time to complete, a -cI took 8hrs 25mins for one table with 2 indexes and 290M rows how can I improve the runtimes for these checks so I don't end up taking two days to perform the migration? Overall DB size is approx 320Gb. Several tables have 100M+ rows. RI is used throughout the DB so there are some tables with a number of indexes. Regards Colin sending to informix-list

It's worth doing. We did a v7 -> v9 conversion and, when practising in advance, we found that there were some small errors introduced by the upgrade (which the oncheck fixed) not present before. presumably you can take a Timefinder copy first and practice this in advance too (if not, and as discussed off-line, we'd love the chance to show you how :-)). And I suppose, if you tested it on a Thursday amd there were no errors, then you went live on the Saturday, you'd be unlucky if there were some introduced then ... Presumably an oncheck -cDI would be quicker than -cD and cI separately? Also, wouldn't PDQ help? -- Neil Truby t:01932 724027 Director m:07798 811708 Ardenta Limited e:neil.truby@ardenta.com "Colin Dawson" <cjd_1955@hotmail.com> wrote in message news:1119875044.db65b1a86e5252864fba6250d2ac5f65@teranews... > > > As it's a slow news day I'll ask about migrations. > > I'm testing migrating from 7.31 to 9.40, the upgrade works fines and takes > around 5 mins to convert everything. The migration plan says to run > onchecks > (-cc, -cD, -cI, -cc, -ce) before and after. As these take quite some time > to > complete, a -cI took 8hrs 25mins for one table with 2 indexes and 290M > rows > how can I improve the runtimes for these checks so I don't end up taking > two > days to perform the migration? > > Overall DB size is approx 320Gb. Several tables have 100M+ rows. RI is > used > throughout the DB so there are some tables with a number of indexes. > > > Regards > > Colin > > > sending to informix-list