home clear 64x64
en blue 200x116 de orange 200x116 info letter User
suche 36x36
Latest versionsfixlist
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
Have problems? - contact us.
Register for free anmeldung-x26
Contact form kontakt-x26

DB2 - Problem description

Problem IC70624 Status: Closed

SECURITY MESSAGE IN DB2DIAG.LOG WHEN RUNNING DB2DART

product:
DB2 FOR LUW / DB2FORLUW / 910 - DB2
Problem description:
db2dart generates the following error in the db2diag.log: 
 
 2010-07-20-19.13.25.856000-240 E938H404           LEVEL: Error 
(OS) 
 PID     : 2432                 TID  : 1964        PROC : 
db2dart.exe 
 INSTANCE: DB2_01               NODE : 000 
 FUNCTION: DB2 UDB, oper system services, sqloGetAccountSID, 
probe:30 
 MESSAGE : ZRC=0x83000534=-2097150668 
 CALLED  : OS, -, LookupAccountName 
 OSERR   : 1332 "No mapping between account names and security 
IDs was 
           done." 
 
but still completes successfully. This can occur when 
  1. DB2_EXTSECURITY is NO 
  2. There is no local DB2ADMNS group
Problem Summary:
**************************************************************** 
* USERS AFFECTED:                                              * 
* db2dart users on a Windows platform                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* The following "No mapping between account names and security * 
* IDs was done"                                                * 
* errors are written to the db2diag.log when db2dart is        * 
* executed on a Windows platform.                              * 
*                                                              * 
* 2010-07-20-19.13.25.856000-240 E938H404           LEVEL:     * 
* Error (OS)                                                   * 
* PID     : 2432                 TID  : 1964        PROC :     * 
* db2dart.exe                                                  * 
* INSTANCE: DB2_01               NODE : 000                    * 
* FUNCTION: DB2 UDB, oper system services, sqloGetAccountSID,  * 
* probe:30                                                     * 
* MESSAGE : ZRC=0x83000534=-2097150668                         * 
* CALLED  : OS, -, LookupAccountName                           * 
* OSERR   : 1332 "No mapping between account names and         * 
* security IDs was                                             * 
* done."                                                       * 
*                                                              * 
* db2dart itself executes without any errors. This can         * 
* occur when DB2_EXTSECURITY is set to NO (ie. not enabled)    * 
* and there is no local DB2ADMNS group.                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* db2dart executes successfully, so the messages can be        * 
* ignored.                                                     * 
*                                                              * 
* To work-around the problem, create a local DB2ADMNS group    * 
* and add the user to this group. This newly created DB2ADMNS  * 
* group does not require any privileges.                       * 
*                                                              * 
* The solution is included with FP10.                          * 
****************************************************************
Local Fix:
None 
 
The error message can be ignored because DB2DART is still 
successful. 
 
The work-around is to create a local DB2ADMNS group and add the 
ID to it. You do not need to grant any permissions to this 
group, group membership is all that is required to prevent the 
error message from being logged.
available fix packs:
DB2 Version 9.1 Fix Pack 10  for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 11  for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 12  for Linux, UNIX and Windows

Solution
Problem first fixed in DB2 v9.1 FP10
Workaround
Create a local DB2ADMNS group and add the user to this group. 
This newly created DB2ADMNS group does not require any 
privileges.
BUG-Tracking
forerunner  : APAR is sysrouted TO one or more of the following: IC70659 IC70660 IC70661 
follow-up : 
Timestamps
Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :
18.08.2010
10.06.2011
10.06.2011
Problem solved at the following versions (IBM BugInfos)
9.1.FP10
Problem solved according to the fixlist(s) of the following version(s)
9.1.0.10 FixList