RE: Migration from 7.31 to 9.40

Posted in 2005

Topics: Installation, Setup & Upgrades, Migration, Import/Export & Data Conversion, Cloud, Docker & Containers

Dirk Moolman — Mon, 27 Jun 2005 13:43:48 +0200 — source: Usenet: comp.databases.informix

I have a question for you: how much space did you use before the upgrade, and how much space after the upgrade ? Or was it all in-place and you are still sitting with the same layout ? -----Original Message----- From: owner-informix-list@iiug.org [mailto:owner-informix-list@iiug.org] On Behalf Of Colin Dawson Sent: 27 June 2005 12:24 PM To: informix-list@iiug.org Subject: 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 sending to informix-list

↪ replying to Dirk Moolman

Neil Truby — Mon, 27 Jun 2005 18:04:09 +0100 — source: Usenet: comp.databases.informix

"Dirk Moolman" <DirkM@mxo.co.za> wrote in message news:1119882085.c2b0b34ea858058704682a6037cfceb7@teranews... > > I have a question for you: how much space did you use before the > upgrade, and how much space after the upgrade ? > > Or was it all in-place and you are still sitting with the same layout? If he has a 290 million row table which took 9 hours just to run an oncheck on, you can be pretty sure that he did an in-place upgarde I would have thought.