View Only
  • 1.  DRDA connection to Informix 10.00.UC5W5

    IBM Champion
    Posted Thu February 23, 2023 04:46 PM

    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
            IBM DB .NET provider version:
            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.


    Mike Walker
    xDB Systems, Inc

  • 2.  RE: DRDA connection to Informix 10.00.UC5W5

    Posted Fri February 24, 2023 02:02 AM

    Hi Mike,

    As per my knowledge, DRDA was first introduced in IDS 10.00.xC4.  but it is not fully supported, and there are several restrictions (for example only ansi db's are supported, max db name length of 8 chars, etc) 
    So to my understanding DRDA has not been recommended in conjunction with IDS 10.


    Gaurav Kumar

  • 3.  RE: DRDA connection to Informix 10.00.UC5W5

    Posted Fri February 24, 2023 02:38 AM

    I cannot remember if 10.x supported DRDA at all or partly.
    You obviously have configured a listener, so some support is present.
    According to the SQL error, not all the features were supported in IDS 10, (-999 is translated to "Not implemented yet").
    What keeps you in IDS10 ? We successfully converted a number of very old legacy systems (even 9.4 instances) at least to 11.70IE
    (while converting the DB from SCO/HP/Windows to virtualized Linux and these keep running very cleanly, a jump from 32bit to 64bit is
    also not an issue).