RE: A migration question

Malcolm If it's any help I have a similar problem instance, i.e. a shambles, and I've got to transfer to a n incompatible hardware platform and from 7.31 to 9.4. After weighing up all the options I concluded synonyms was the only way to go. ER was considered at one stage, however you can count the number on primary keys on the 300 plus tables on one hand !! I have used synonyms in the past to split a version 5 instance that ran out of chunks so I know they are stable and work well. My proposal is to create the new instance and create all tables as synonyms then in slow time replace each with the true table. The concept has been unofficially validated as a viable method by a mutual IBM acquaintance. Keith -> -----Original Message----- -> From: malcolm weallans [mailto:malcolm.iiug@btopenworld.com] -> Sent: Friday, November 05, 2004 11:05 AM -> To: informix-list@iiug.org -> Subject: A migration question -> -> -> I am working on a migration plan for a 24 by 7 site. -> We are migrating from IDS 9.3 to IDS 9.4 and although -> it would be possible to achieve this by a simple -> install of 9.4 over 9.3 it is never that easy. -> -> The 9.3 installation has two major problems. -> -> rootdbs has been created with offset 0 on AIX 5.2 -> 64-bit in an HACMP environment. It works, but I am -> assured by my IBM AIX specialists that this is a -> potential disaster area. -> -> Many of the tables have large numbers of extents. -> Nobody ever thought to set extent sizes for any of the -> databases. -> -> The site currently has about 20 dbspaces, and apart -> from the "critical" dbspaces all the dbspaces have -> multiple chunks and one has about 20. -> -> We do have an amount of free space, (not enough to -> fully duplicate) and I am contemplating creating a new -> instance for 9.4 and migrating over a long period of -> time, probably by exporting databases and importing -> them with correct extent sizes. -> -> But last night in the bath I had a brainwave and I -> would like your views. -> -> Could I create a 9.4 instance and migrate one table at -> a time using synonyms to provide access to tables that -> are in the other server? If I could do that then I -> can minimise the duration of outages. I don't think I -> would save any time in the long run but it might just -> be a little more feasible. -> -> regards -> -> Malcolm -> sending to informix-list -> ********************************************************************************** This message is sent in strict confidence for the addressee only. It may contain legally privileged information. The contents are not to be disclosed to anyone other than the addressee. Unauthorised recipients are requested to preserve this confidentiality and to advise the sender immediately of any error in transmission. This footnote also confirms that this email message has been swept for the presence of computer viruses, however we cannot guarantee that this message is free from such problems. ********************************************************************************** sending to informix-list