How setup a database on different host.

Posted in 1999

↪ replying to Liu Jiachuan

Art S. Kagel — Fri, 08 Jan 1999 12:20:06 -0500 — source: Informix-list mailing list archive (1991-1998)

Liu Jiachuan wrote: > > Hi, everybody. > > I want to ask you some question. > My environment is that the OS platform is SCO unix release 5.0.4, and the > informix is online 7.3. I don't know whether the informix can support the > distributed database. I have fulfilled that the program can access several > databases on different host.But I want to know whether I can setup a > database on different host.For example, install a space on host AA, and > another space on host BB. How can I setup a database on these space? > Can you tell me? To do this and have it treated as a single distributed database on a distributed server you need the XPO (Extended Parallel Option) also known as IDS 8.xx. You can however, have independent databases on each of several servers and perform distributed transactions using Informix's built in two-phase commit features which take no programming changes. Just begin a transaction, update the various tables in the various databases on the various servers and commit or rollback. You can even setup local synonyms to the remote tables so that the code will see the tables as if they were local. Art S. Kagel PS - Didn't we just have this discussion last week? ;-)

Liu Jiachuan — Fri, 8 Jan 1999 21:39:03 -0000 — source: Informix-list mailing list archive (1991-1998)

Hi, everybody. I want to ask you some question. My environment is that the OS platform is SCO unix release 5.0.4, and the informix is online 7.3. I don't know whether the informix can support the distributed database. I have fulfilled that the program can access several databases on different host.But I want to know whether I can setup a database on different host.For example, install a space on host AA, and another space on host BB. How can I setup a database on these space? Can you tell me? Thanks.