Informix

Does anybody know if it's possible to use a DRDA connection with Informix 10.00.UC5W5?

I have somebody trying to use Microsoft Power Apps with this old version of Informix, and it requires a DRDA connection.  An upgrade is out of the question, so we've been trying to get this combination to work, but without success.

I started up the listener with the drsoctcp protocol and we see the host listening on the port.  Power Apps tries to connect but flashes up an error message too quickly to read.  We have tried to test with the testconn40 utility in the IBM Data Server Client Package.  The test fails on Step 4 where it attempts to query systables, but Step 3 where it retrieves the database version is successful.

c:\Program Files\IBM\IBM DATA SERVER DRIVER\bin>testconn40 database=sysmaster;server=<ip address>:9089;userid=informix;password=<password>

Step 1: Printing version info
        .NET Framework version: 4.0.30319.42000
        64-bit
        IBM DB .NET provider version: 9.7.4.4
        IBM DB .NET file version: 11.5.4000.4
        Capability bits: ALLDEFINED
        Build: s2006161200
        Factory for invariant name IBM.Data.DB2 verified
        Elapsed: 0.1247272

Step 2: DB2DSDRIVER_CFG_PATH env var: unset
        Validating db2dsdriver.cfg against db2dsdriver.xsd schema file
        File searched at C:\ProgramData\IBM\DB2\IBMDBCL1\cfg\db2dsdriver.cfg  missing. Nothing to validate
        Elapsed: 0.0100052

Step 3: Connecting using "database=sysmaster;server=<ip address>:9089;userid=informix;password=<password>"
        Server type and version: IDS 10.04.0000
        Warning: The version of the gateway is . It could potentially limit certain functionalities
        Elapsed: 0.2320289

Step 4: Selecting rows from informix.systables to validate existence of packages
   SELECT * FROM informix.systables
IBM.Data.DB2.DB2Exception (0x80004005): ERROR [] [IBM][IDS/UNIX32] SQL0969N  There is no message text corresponding to SQL error "-999" in the message file on this workstation.  The error was returned from module "IFX10040" with original tokens "".

   at IBM.Data.DB2.DB2Command.ExecuteReaderObject(CommandBehavior behavior, String method, DB2CursorType reqCursorType, Boolean abortOnOptValueChg, Boolean skipDeleted, Boolean isResultSet, Int32 maxRows, Boolean skipInitialValidation)
   at IBM.Data.DB2.DB2Command.ExecuteReaderObject(CommandBehavior behavior, String method)
   at IBM.Data.DB2.DB2Command.ExecuteReader(CommandBehavior behavior)
   at IBM.Data.DB2.DB2Command.ExecuteReader()
   at TestConn.myClassName.SelectFromTable()

Test failed.

We tried the same with Informix 11.70 and it worked perfectly, even though it has the same warning in Step 3.

We tried the -ids and -idsold arguments to testconn40 and it made no difference.

Something odd is that "onstat -g ntd" shows Calls as "no" for drdaexec.  It reports "yes" on Informix 11.70.

Client Type     Calls   Accepted   Rejected       Read      Write
sqlexec         yes        14976         11    6733792    7481225
srvinfx         yes            0          0          0          0
drdaexec        no             0          0          0          0
onspace         yes            0          0          0          0
onlog           yes            0          0          0          0
onparam         yes            0          0          0          0
oncheck         yes            0          0          0          0
onload          yes            0          0          0          0
onunload        yes            0          0          0          0
onmonitor       yes            0          0          0          0
dr_accept       yes            0          0          0          0
cdraccept       no             0          0      57549      57550
ontape          yes            0          0          1          2
srvstat         yes            0          0          0          0
asfecho         yes            0          0      14919          0
listener        yes            0          0          0          0
crsamexec       yes            0          0          0          0
safe            yes            0          0        240        170
onutil          yes            0          0          0          0
Totals                     14976         11    6806501    7538947

We have read conflicting information as to whether DRDA is supported in Informix 10, so confirmation of that would be a good start, but otherwise any suggestions would be appreciated.

Thanks!

Does anybody know if it's possible to use a DRDA connection with Informix 10.00.UC5W5?

I have somebody trying to use Microsoft Power Apps with this old version of Informix, and it requires a DRDA connection.  An upgrade is out of the question, so we've been trying to get this combination to work, but without success.

I started up the listener with the drsoctcp protocol and we see the host listening on the port.  Power Apps tries to connect but flashes up an error message too quickly to read.  We have tried to test with the testconn40 utility in the IBM Data Server Client Package.  The test fails on Step 4 where it attempts to query systables, but Step 3 where it retrieves the database version is successful.

c:\Program Files\IBM\IBM DATA SERVER DRIVER\bin>testconn40 database=sysmaster;server=<ip address>:9089;userid=informix;password=<password>

Step 1: Printing version info
        .NET Framework version: 4.0.30319.42000
        64-bit
        IBM DB .NET provider version: 9.7.4.4
        IBM DB .NET file version: 11.5.4000.4
        Capability bits: ALLDEFINED
        Build: s2006161200
        Factory for invariant name IBM.Data.DB2 verified
        Elapsed: 0.1247272

Step 2: DB2DSDRIVER_CFG_PATH env var: unset
        Validating db2dsdriver.cfg against db2dsdriver.xsd schema file
        File searched at C:\ProgramData\IBM\DB2\IBMDBCL1\cfg\db2dsdriver.cfg  missing. Nothing to validate
        Elapsed: 0.0100052

Step 3: Connecting using "database=sysmaster;server=<ip address>:9089;userid=informix;password=<password>"
        Server type and version: IDS 10.04.0000
        Warning: The version of the gateway is . It could potentially limit certain functionalities
        Elapsed: 0.2320289

Step 4: Selecting rows from informix.systables to validate existence of packages
   SELECT * FROM informix.systables
IBM.Data.DB2.DB2Exception (0x80004005): ERROR [] [IBM][IDS/UNIX32] SQL0969N  There is no message text corresponding to SQL error "-999" in the message file on this workstation.  The error was returned from module "IFX10040" with original tokens "".

   at IBM.Data.DB2.DB2Command.ExecuteReaderObject(CommandBehavior behavior, String method, DB2CursorType reqCursorType, Boolean abortOnOptValueChg, Boolean skipDeleted, Boolean isResultSet, Int32 maxRows, Boolean skipInitialValidation)
   at IBM.Data.DB2.DB2Command.ExecuteReaderObject(CommandBehavior behavior, String method)
   at IBM.Data.DB2.DB2Command.ExecuteReader(CommandBehavior behavior)
   at IBM.Data.DB2.DB2Command.ExecuteReader()
   at TestConn.myClassName.SelectFromTable()

Test failed.

We tried the same with Informix 11.70 and it worked perfectly, even though it has the same warning in Step 3.

We tried the -ids and -idsold arguments to testconn40 and it made no difference.

Something odd is that "onstat -g ntd" shows Calls as "no" for drdaexec.  It reports "yes" on Informix 11.70.

Client Type     Calls   Accepted   Rejected       Read      Write
sqlexec         yes        14976         11    6733792    7481225
srvinfx         yes            0          0          0          0
drdaexec        no             0          0          0          0
onspace         yes            0          0          0          0
onlog           yes            0          0          0          0
onparam         yes            0          0          0          0
oncheck         yes            0          0          0          0
onload          yes            0          0          0          0
onunload        yes            0          0          0          0
onmonitor       yes            0          0          0          0
dr_accept       yes            0          0          0          0
cdraccept       no             0          0      57549      57550
ontape          yes            0          0          1          2
srvstat         yes            0          0          0          0
asfecho         yes            0          0      14919          0
listener        yes            0          0          0          0
crsamexec       yes            0          0          0          0
safe            yes            0          0        240        170
onutil          yes            0          0          0          0
Totals                     14976         11    6806501    7538947

We have read conflicting information as to whether DRDA is supported in Informix 10, so confirmation of that would be a good start, but otherwise any suggestions would be appreciated.

Thanks!