Hot backup Informix db

Posted in 1999

Christopher J. — 19 Jan 1999 13:16:22 GMT — source: Informix-list mailing list archive (1991-1998)

Can one instance of Informix (on one machine) update another Informix on a separate system across the network? Can it be a constant stream, or is it a log reply type of deal? I am not a DBA, but a UNIX admin who is doing some high level planning. cjw Christopher J. Wargaski; cjw@nospaminteraccess.com "We can judge the heart of a man by his treatment of animals." --Immanuel Kant A conclusion is the place where you got tired of thinking.

↪ replying to Christopher J.

Art S. Kagel — Tue, 19 Jan 1999 15:50:27 -0500 — source: Informix-list mailing list archive (1991-1998)

Christopher J. wrote: > > Can one instance of Informix (on one machine) update another Informix > on a separate system across the network? Can it be a constant stream, > or is it a log reply type of deal? I am not a DBA, but a UNIX admin > who is doing some high level planning. Informix supports full multiple server interaction. The only requirement is that the current database and the remote database have compatible logging modes. Updates can be discrete (ie only involving the remote table) or full two phase commit transactions involving the modification of data on multiple databases in multiple servers on multiple machines accross the network. The Informix engines handle all the nasty details of remote and multi-server updates. Art S. Kagel

↪ replying to Christopher J.

J K Snider (Jill) — Mon, 25 Jan 1999 13:07:31 -0500 — source: Informix-list mailing list archive (1991-1998)

Christopher J. wrote: > > Can one instance of Informix (on one machine) update another Informix > on a separate system across the network? Can it be a constant stream, > or is it a log reply type of deal? I am not a DBA, but a UNIX admin > who is doing some high level planning. > > cjw > > Christopher J. Wargaski; cjw@nospaminteraccess.com > "We can judge the heart of a man by his treatment of animals." --Immanuel Kant > > A conclusion is the place where you got tired of thinking. Are you using Informix 7, by any chance? Otherwise, I know this is possible through db_to_asc command. It's my understanding that Informix 7 has issues with clients using this command (and other one's such as db_access, db_import, ...) -- Jill Katrina Snider Visteon/Ford Motor Company 17000 Rotunda Dr., C275 Dearborn, MI 48121-6010 ph: 313-845-8955 fax: 313-322-9754

↪ replying to J K Snider (Jill)

Clifton M. Bean — Sun, 7 Feb 1999 11:31:43 -0600 — source: Informix-list mailing list archive (1991-1998)

Sounds like you should look into either Data Replication or Enterprise Replication. If your manuals don't speak of this, check out the manuals on the subject at: http://www.informix.com/answers/ Take care. Clifton J K Snider (Jill) wrote in message <36ACB2E3.49A1147C@visteonet.com>... >Christopher J. wrote: >> >> Can one instance of Informix (on one machine) update another Informix >> on a separate system across the network? Can it be a constant stream, >> or is it a log reply type of deal? I am not a DBA, but a UNIX admin >> who is doing some high level planning. >> >> cjw >> >> Christopher J. Wargaski; cjw@nospaminteraccess.com >> "We can judge the heart of a man by his treatment of animals." --Immanuel Kant >> >> A conclusion is the place where you got tired of thinking. > >Are you using Informix 7, by any chance? >Otherwise, I know this is possible through db_to_asc command. > >It's my understanding that Informix 7 has issues with clients using this >command (and other one's such as db_access, db_import, ...) > >-- >Jill Katrina Snider >Visteon/Ford Motor Company >17000 Rotunda Dr., C275 >Dearborn, MI 48121-6010 >ph: 313-845-8955 fax: 313-322-9754