Hello,
We're running AIX 4.3.3, Sybase Server Enterprise 12.0 and CICS TX 5.0. We use COBOL for development. We followed the instructions as lined out in the "TXSeries Planning and Installation Guide for AIX" to setup a CICS environment without RDBMS and ran the IBM Cobol IVP programs and other IBM COBOL programs without any problems. We also created a CICS environment for connection with a Sybase DBMS and executed all steps as lined out in the "Sybase XA Interface Integration Guide for CICS, Encina and Tuxedo". As instructed in the manual we installed MicroFocus COBOL, created a MicroFocus Cobol Runtime environment and compiled our CICS COBOL programs (with imbedded SQL statements) using the (MicroFocus) COBOL libraries. We created the files: "interfaces", "xa_config" and defined everything needed in the CICS Definition XAD stanza file. When CICS has been started it opens the connections with Sybase (XA_Open) as defined in XAD (-Nconnection_1), xa_config and interfaces files; however starting a CICS transaction using the Sybase Database (EXEC SQL SET CONNECTION connection_1) causes the transaction to abend because the program is not able to connect the database; the userid (-Uuserid) has been granted to use the database. Even the supplied verification program (uxa1) do abend (A141).
Does anyone have/had the same experience with this problem. The application programs are compiled but we can't test them because the interfaces between the operating subsystem components doesn't work. Because we tried everything we could find in the documentation and the internet, we think about a mismatch in the subsystem software levels (as experienced with a MQSeries project), but no software supplier can tell us. Please help!
Regards.
We're running AIX 4.3.3, Sybase Server Enterprise 12.0 and CICS TX 5.0. We use COBOL for development. We followed the instructions as lined out in the "TXSeries Planning and Installation Guide for AIX" to setup a CICS environment without RDBMS and ran the IBM Cobol IVP programs and other IBM COBOL programs without any problems. We also created a CICS environment for connection with a Sybase DBMS and executed all steps as lined out in the "Sybase XA Interface Integration Guide for CICS, Encina and Tuxedo". As instructed in the manual we installed MicroFocus COBOL, created a MicroFocus Cobol Runtime environment and compiled our CICS COBOL programs (with imbedded SQL statements) using the (MicroFocus) COBOL libraries. We created the files: "interfaces", "xa_config" and defined everything needed in the CICS Definition XAD stanza file. When CICS has been started it opens the connections with Sybase (XA_Open) as defined in XAD (-Nconnection_1), xa_config and interfaces files; however starting a CICS transaction using the Sybase Database (EXEC SQL SET CONNECTION connection_1) causes the transaction to abend because the program is not able to connect the database; the userid (-Uuserid) has been granted to use the database. Even the supplied verification program (uxa1) do abend (A141).
Does anyone have/had the same experience with this problem. The application programs are compiled but we can't test them because the interfaces between the operating subsystem components doesn't work. Because we tried everything we could find in the documentation and the internet, we think about a mismatch in the subsystem software levels (as experienced with a MQSeries project), but no software supplier can tell us. Please help!
Regards.