Oninit cdi / Archive
Talk to an expert →

RE: Ontape Restore Merging Servers

Posted in 2005

Topics: Backup & Restore, Storage & Space Management, Migration, Import/Export & Data Conversion, Platform-Specific Issues

Simmons, Keith — — source: Usenet: comp.databases.informix

-> -----Original Message----- -> From: Art S. Kagel [mailto:kagel@bloomberg.net] -> Sent: Tuesday, August 09, 2005 10:13 PM -> To: informix-list@iiug.org -> Subject: Re: Ontape Restore Merging Servers -> -> -> Gary Andrus wrote: -> > Informix Dynamic Server Version 7.31.UD2 -> > uname -srv : AIX 2 5 -> > -> > I've been asked to assist with a server migration from -> machines A and B -> > to machine C. -> > -> > Machine A has IDS server A. Machine B has IDS server B. -> > -> > Machine C will have IDS server A. This new server A is supposed to -> > have the combined data from original server A and original -> server B. -> > -> > I have discovered that the original plan was to restore Machine A, -> > Server A to Machine C, Server A followed by a merge of the Server B -> > information via ontape restore. -> > -> > The initial restore of Server A to Machine C has been successfully -> > completed. The next step that was attempted was an ontape -r -D -> > <DbSpaceList> which has not been successful. I didn't -> think this would -> > work and have suggested a dbexport/dbimport of the -> necessary data from -> > server B. -> > -> > I can't find any other cases like this in CDI in my searches this -> > morning, nor have I found it in the documentation. -> > -> > Can the two servers be merged together with ontape (or onbar)? -> > Is dbexport/dbimport the logical choice to perform this action? -> -> Simply? No. Two choices really, -> 1 - unload/dbexport followed by reload/dbimport, or the -> equivalent, both -> servers -or- -> 2 - ontape restore one then dbexport & dbimport the other. -> -> Art S. Kagel -> This is OK if the database(s) from machine B are to be separate to those of machine A. However if (as I read it) the two datasets are to be merged, then after the original ontape -s / -r (assuming identical IDS versions and binary compatible OS versions !!) then the only way to merge the data would be unload to flat files and then reload to extend the existing tables (or create new ones in the same database). Keith ********************************************************************************** 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

↪ replying to Simmons, Keith
Gary Andrus — — source: Usenet: comp.databases.informix

Thanks for all of the questions/answers. I was expecting the initial answer that Art gave about dbexport/dbimport. I hadn't specified database names in my initial message and completely understand Keith's thoughts of unload/load if that were the case. This should help greatly in moving forward with the project. Sorry about the confusion with the AIX version. I've been using Solaris machines for the most part and uname -a gave a different result format on AIX, so I put the specific options on the command line. oslevel (not available on Solaris and an unknown command to me prior to this) indeed returns 5.2.0.0.

Glossary