IBM Support

IT23069: FILEDSN IS NOT WORKING WITH V111M2FP2 : SPECIFIED DRIVER COULD NOT BE LOADED DUE TO SYSTEM ERROR 1114: A DYNAMIC LINK LIBRARY (

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • After upgrading to 11.1.2.2  customer get the following error:
    
    System.Data.Odbc.OdbcException (0x80131937): ERROR [IM003]
    Specified driver could not be loaded due to system error  1114:
    A dynamic link library (DLL
    ) initialization routine failed. (IBM DB2 ODBC DRIVER -
    D_clidriver, D:\clidriver\BIN\db2clio.dll).
    
    What is interesting is that the db2clio.dll is referenced in the
    procmon log when we try running a test 64bit program, but when
    the 64bit odbc adminstration tool does a test connection, it is
    successful and shows no trace of db2clio.dll in a procmon log.
    
    This same program runs fine when run against a v10.5.4 driver.
    Same error with v11.2.2 Runtime Client and ODBC Driver Package.
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * Applications trying to use db2clio.dll using dsdriver on     *
    * windows platform. Trying to use FileDSN.                     *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to Db2 V11.1 M3FP3 or later releases. You can use    *
    * SB_37009 too to get fix on top of Db2 V11.1 M1FP2.           *
    ****************************************************************
    

Problem conclusion

  • Issue is fixed in DB2 V11.1 M3FP3 release and later fix packs.
    After applying the fix, application is able to use FileDSN and
    db2clio.dll.
    

Temporary fix

Comments

APAR Information

  • APAR number

    IT23069

  • Reported component name

    DB2 CONNECT

  • Reported component ID

    DB2CONNCT

  • Reported release

    B10

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2017-11-07

  • Closed date

    2017-12-20

  • Last modified date

    2017-12-20

  • APAR is sysrouted FROM one or more of the following:

  • APAR is sysrouted TO one or more of the following:

Fix information

  • Fixed component name

    DB2 CONNECT

  • Fixed component ID

    DB2CONNCT

Applicable component levels

  • RB10 PSN

       UP

  • RB10 PSY

       UP

[{"Business Unit":{"code":"BU054","label":"Systems w\/TPS"},"Product":{"code":"SG19M"},"Platform":[{"code":"PF054","label":"z Systems"}],"Version":"11.1","Line of Business":{"code":"","label":""}}]

Document Information

Modified date:
19 June 2020