RE: moving a database from one server to another.

Provided you can set up a server on the new machine identical to the existing, and you don't need to do an immediate reorganisation of data, I would restore an archive to get your data across and an engine up and running. Next make any onconfig changes to take advantage of the increased memory (BUFFERS, Non-Resident Segment etc.). Then add additional disk space as required for additional logs, temp dbspace, reorganising tables, separating indexes etc. Much of this can be done with the engine in use and perhaps a quick bounce over lunch or in an evening (if you have that luxury). -> -----Original Message----- -> From: spamfreeemail@despammed.com -> [mailto:spamfreeemail@despammed.com] -> Sent: Tuesday, August 12, 2003 9:00 AM -> To: informix-list@iiug.org -> Subject: Re: moving a database from one server to another. -> -> -> It is being backed up to tape, but with the target machine -> having much -> more disk (on D:) and more memory (1 GB) I thought I would need to do -> some config changes? -> -> "Simmons, Keith" <keith.simmons@bbslimited.co.uk> wrote in -> message news:<bh8886$7qt$1@terabinaries.xmission.com>... -> > How is the machine currently being archived? Have you -> considered just doing -> > a straight restore from an archive? Same OS/same IDS disks -> set up the same -> > so same chunks available. Unless you have very good reason -> to need to -> > reorganise the data this appears to cry out for a quick -> and simple ontape -> > -r. -> > -> > Keith -> > -> > -> -----Original Message----- -> > -> From: spamfreeemail@despammed.com -> > -> [mailto:spamfreeemail@despammed.com] -> > -> Sent: Monday, August 11, 2003 12:50 PM -> > -> To: informix-list@iiug.org -> > -> Subject: moving a database from one server to another. -> > -> -> > -> -> > -> NT 4.0, IDS 7.3 -> > -> -> > -> Hi all I'm moving a small database (4gb) from one server to -> > -> another as -> > -> a favour to a mate. -> > -> -> > -> I'm savvy with IDS on Unix but have never used it on Windows. -> > -> -> > -> The database doesn't have any blobs. And the source and target -> > -> operating systems and Informix versions are identical. -> The target -> > -> machine has much more disk and memory. -> > -> -> > -> Looking through the manual it looks a little different to Unix. -> > -> -> > -> May I ask you a few questions? (Pardon my ignorance in advance). -> > -> -> > -> Should I use onunload/ onload or dbexport/dbimport? -> > -> -> > -> Do I need to run these commands through a command shell -> or is there a -> > -> nice menu driven system to use? -> > -> -> > -> Do I need to specify tape block sizes or does the block -> size default? -> > -> -> > -> Are there any "undocumented" problems that I should be -> aware of in -> > -> this process? -> > -> -> > -> Any other comments? -> > -> -> > -> Thanks in anticipation :) -> > -> -> > -> > -> ************************************************************* -> ********************* -> > 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 -> ********************************************************************************** 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