Re: Query - Two Phase Commit

suchi@psi.ernet.in (Suchitra Rao) writes: > Hello friends, > > I wish to develop an "Any Branch Banking" software for a large > bank in India. We are using Informix 5.1 SE. I want to know > some details on Two phase commit in this kind of distributed > database updations. Does Informix Software has any built in layer > to help maintain database concurrency and recovery in case of > distributed database updations. > > Suchitra Rao (suchi@psi.ernet.in) > ----------------------------------------------------------------------- > PSI Data Systems Ltd, 19 Primrose Road, BANGALORE - 560 025, INDIA > VOICE : 91-80-5585726/7 FAX: 91-80-5588298 Email: suchi@psi.ernet.in > ----------------------------------------------------------------------- Hi Suchitra -- Yes, Informix does have a two-phase commit. But I believe it is only in Informix OnLine, not Informix SE. They call it the "XA" feature. In addition to having a DBMS that supports the XA protocol (almost all do) you would also need a Transaction Manager to coordinate the two-phase commit. All Unix TP Monitors -- Tuxedo, CICS/6000, Encina, Top End -- will do this. Informix was one of the pioneers in two-phase commit. They have supported it for a long time. -- Gary --------------------------------------------------------------------------- Gary Long glong@magna.com Vice President, Product Development Magna Software Corporation Phone: 703/222-3500 12450 Fair Lakes Circle Fax: 703/222-8433 Fairfax, Virginia 22033 Technical data on "MAGNA X" CS/TP Application Generator info@magna.com