IBM Support

IC73331: ADD TOKEN TO SQL1159N ERROR SHOWING THE USERID TRYING TO ACCESS IBM.DATA.DB2.DLL AND DB2APP.DLL.

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • A user may get an error such as sql1159n rc=10 saying there is a
    mismatch of IBM.Data.DB2.dll and db2app.dll.
    
    This error can also be typically caused due to the application
    userid not having proper permission to read the files in the
    SQLLIB directory where DB2 is installed.  When using Extended
    Windows security, the userid in question must be added to either
    the DB2USERS or DB2ADMNS folders on the machine.
    
    In some cases, such as ASP.Net applications running under IIS,
    it is difficult to identify the userid that is being used by the
    IIS process under the covers.  This APAR will improve the
    SQL1159N error message so that it will display the userid that
    requires the additional permission.
    

Local fix

  • - A temporary fix would be to add the "everyone" group to the
    DB2USERS or DB2ADMNS group to allow all users on the machine to
    access the SQLLIB directory.
    - A permanent fix would be to use a tool such as Process Monitor
    on Windows to identify the userid that is trying to access
    IBM.Data.DB2.dll and db2app.dll.
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * DB2 LUW v9.7 using the .Net provider                         *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * ADD TOKEN TO SQL1159N ERROR SHOWING THE USERID TRYING TO     *
    * ACCESS IBM.DATA.DB2.DLL AND DB2APP.DLL.                      *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to v9.7 Fixpack 4 to see the new token in the        *
    * sql1159n error message.                                      *
    ****************************************************************
    

Problem conclusion

  • The new token in the sql1159n error will be available in v9.7
    Fixpack 4
    

Temporary fix

  • A 3rd party tool such as Microsoft Process Monitor can be used
    to identify the userid that is trying to access the DLL causing
    the sql1159n error message
    

Comments

APAR Information

  • APAR number

    IC73331

  • Reported component name

    DB2 FOR LUW

  • Reported component ID

    DB2FORLUW

  • Reported release

    970

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2010-12-16

  • Closed date

    2011-04-29

  • Last modified date

    2011-04-29

  • 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 FOR LUW

  • Fixed component ID

    DB2FORLUW

Applicable component levels

  • R970 PSN

       UP

[{"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSEPGG","label":"DB2 for Linux, UNIX and Windows"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"9.7","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
29 April 2011