home clear 64x64
en blue 200x116 de orange 200x116 info letter User
suche 36x36
Neueste VersionenFixList
11.1.0.7 FixList
10.5.0.9 FixList
10.1.0.6 FixList
9.8.0.5 FixList
9.7.0.11 FixList
9.5.0.10 FixList
9.1.0.12 FixList
Haben Sie Probleme? - Kontaktieren Sie uns.
Kostenlos registrieren anmeldung-x26
Kontaktformular kontakt-x26

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
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

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 FixList