RE: daily migration of Informix 9.4 databases from AIX to RedHat

Posted in 2003

Francisco Roldan — Mon, 11 Aug 2003 17:56:53 -0600 — source: Usenet: comp.databases.informix

What is that HPL Replication option about? I really would appreciate if you explain it Thanks in advance -----Mensaje original----- De: Richard Kofler [mailto:richard.kofler@chello.at] Enviado el: Lunes, 11 de Agosto de 2003 12:21 p.m. Para: informix-list@iiug.org Asunto: Re: daily migration of Informix 9.4 databases from AIX to RedHat Stefan Voets wrote: > > Hi, > > we are running 2 informix 9.4 instances on two separate machines > > srv1 AIX p-series server (AIX 5.1) & IDS 9.40.FC1 > srv2 intel hardware with redhat linux (8.0) & IDS 9.40.UC1 Upgrade to UC2 ASAP. Many features corrected in UC2 > > There are a couple of dbspaces that should be equalized every night. > At the moment we are using load/unloads to realize this, but the > entire process takes to long to complete during one night ... > > I considered following options : > > a) HDR : different OS'ses => not possible > b) ER : had a bad experience with this => not an option just because I am so courious :), details, please ... > c) ONBAR backup/restore => not possible because of different OS'ses > > according to you gurus out there, are there any usefull alternatives ? IMHO best option is ER. But if you have the window and if your DB is not too big, HPL on both sides is maybe an option, too: HPL express mode loading from pipe, which is a rexec/rsh job doing HPL unload on the other machine. Depending on your CPU vs. network speed, gzip on both sides should be considered. dic_k -- Richard Kofler SOLID STATE EDV Dienstleistungen GmbH Vienna/Austria/Europe sending to informix-list