DB2 - Problembeschreibung
Problem IC73331 | Status: Geschlossen |
ADD TOKEN TO SQL1159N ERROR SHOWING THE USERID TRYING TO ACCESS IBM.DATA.DB2.DLL AND DB2APP.DLL. | |
Produkt: | |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 | |
Problembeschreibung: | |
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-Zusammenfassung: | |
**************************************************************** * 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. | |
verfügbare FixPacks: | |
DB2 Version 9.7 Fix Pack 4 for Linux, UNIX, and Windows | |
Lösung | |
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 | |
Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 16.12.2010 29.04.2011 29.04.2011 |
Problem behoben ab folgender Versionen (IBM BugInfos) | |
9.7., 9.7.FP4 | |
Problem behoben lt. FixList in der Version | |
9.7.0.4 |