Re: Q: How is the transactional behaviour in an Informix DB implemented?

Filip, Informix supports XA if that's what you're after. We use 7.22 with Tuxedo 6.3. There are some restrictions on what statements you can use in your Tuxedo servers, since Tuxedo (or whatever TM) now manages the transactions and the connections: you can't commit, rollback, connect, disconnect, set connection, etc, etc. Also, not all versions support XA, check with Informix support. How these protocols are implemented in Informix: you'd have to ask Informix support but they probable won't tell you :-). There is a single library though (libinfxxa.a/.so) and a header file called xa.h with the definition of the xa switch structure which you link/include with your servers/application programs. HTH Filip De Turck wrote: > > Dear all, > > The X/Open DTP (Distributed Transaction Processing) standard defines the protocols to make a DB transaction capable. Can anyone explain me > how these protocols are implemented in an Informix DB system? Are there any general rules which are usually followed when making a DB t > ransaction capable? > > Thanks a lot, > Filip -- /* ----------------------------------------------------- * * Willem Roos wroos@shoprite.co.za * * roosj@mweb.co.za * * 0(+27)21 980 4941 * * 0(+27)21 919 0198 * * ----------------------------------------------------- */