|
Problem IC73331
|
Status: Closed |
ADD TOKEN TO SQL1159N ERROR SHOWING THE USERID TRYING TO ACCESS IBM.DATA.DB2.DLL AND DB2APP.DLL. |
| product: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| Problem 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. |
| 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. *
**************************************************************** |
| 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. |
| available fix packs: |
DB2 Version 9.7 Fix Pack 4 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 5 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 6 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 7 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 8 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 10 for Linux, UNIX, and Windows
|
| Solution |
The new token in the sql1159n error will be available in v9.7
Fixpack 4 |
| Workaround |
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 |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 16.12.2010
29.04.2011
29.04.2011 |
| Problem solved at the following versions (IBM BugInfos) |
9.7.,
9.7.FP4
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.7.0.4
|
 |
