Re: Informix TP-XA

As you pointed out in your posting below: >"INFORMIX-STAR is not supported in this version of INFORMIX-TP/XA". >I wonder whether it has anything to do my problem since I am running >I-STAR TCP/IP across the two machines. This is precisely why you get an error when your transaction attempts to access a remote system. INFORMIX-TP/XA 5.0 does not support accessing a remote system via an XA transaction. There are many complications that must be resolved to ensure integrity across remote and distributed systems when executing global transactions - these were not resolved for the 5.0 version of TP/XA. Thus remote XA transactions via I-Net and I-Star are not supported for TP/XA 5.0. Julie In article 7403@copper.Denver.Colorado.EDU, ywleung@ouray.denver.colorado.edu (YIU WAH LEUNG) writes: >I have installed Informix TP-XA product in the 486 machines running >UNIX 4.2 (known as NetWare). The client and server programs work fine >if all the programs only assess the local database. > >However, if I include a "select" statement to query the remote database, >(e.g. select ssn from db1@mach1:"informix".t1), the server reports error >message -926 (Informix-Online is not licensed for distributed data access). >If I write a simple esql/c program, I have no problem to access data from >database 'db1' in remote machine 'mach1'. > >Please send mail to kevin@if.com or call me at (303) 572-6585 if anyone has >any clues of how this happens and how to fix it. > >Note: My remote machine is running Informix sqlexecd 4.1.UD2, sqlturbo 4.1.UD2 >My local machine is running Informix sqlexecd 5.0.UC1, sqlturbo 5.0.UC1 >In Informix TP/XA User Manual Version 5.0 page 1-13, it states that >"INFORMIX-STAR is not supported in this version of INFORMIX-TP/XA". >I wonder whether it has anything to do my problem since I am running >I-STAR TCP/IP across the two machines. > >Thanks in advance! > >/************************************************************************* >Disclaimer: The opinions expressed here are my own, and has nothing to do with > Information Foundation. > >*** Kevin Leung Voice: (303) 572-6585 >*** Technical Manager Fax : (303) 572-6484 >*** Information Foundation Email: kevin@if.com >*** 1200 17th St. #1900 Denver, CO 80202 >*************************************************************************/