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 IT19712 Status: Closed

REVOKING PRIVILEGES MAY CAUSE THE DB2 SERVER TO TERMINATE ABNORMALLY

product:
DB2 FOR LUW / DB2FORLUW / B10 - DB2
Problem description:
In rare circumstances, revoking privileges may cause the DB2 
server to terminate abnormally. The stack looks similar to the 
example below (from Linux): 
 
sssDumpStackTraceInternal 
ossDumpStackTrace 
_ZN11OSSTrapFile 
sqlo_trce 
sqloEDUCodeTrapHandler 
0x0000003FC180F710 address: 0x0000003FC180F710 
sqlrlProcessRoutineAuths 
r_aainfoP16aainfoRepository 
sqlrlRevokeRoleFromUserOrPublic 
sqlrlRolePrivileges 
sqlrlRevokeRoles 
sqlnq_auth_stmt_end 
sqlnq_auth_role_stmt
Problem Summary:
**************************************************************** 
* USERS AFFECTED:                                              * 
* ALL                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 11.1 Mod 2 Fix Pack 2 or higher               * 
****************************************************************
Local Fix:
available fix packs:
DB2 Version 11.1 Mod 2 Fix Pack 2 for Linux, UNIX, and Windows
Db2 Version 11.1 Mod2 Fix Pack2 iFix001 for Linux, UNIX, and Windows
Db2 Version 11.1 Mod2 Fix Pack2 iFix002 for Linux, UNIX, and Windows
Db2 Version 11.1 Mod 3 Fix Pack 3 for Linux, UNIX, and Windows
Db2 Version 11.1 Mod3 Fix Pack3 iFix001 for Linux, UNIX, and Windows
Db2 Version 11.1 Mod3 Fix Pack3 iFix002 for Linux, UNIX, and Windows

Solution
First fixed in DB2 11.1 Mod 2 Fix Pack 2
Workaround
not known / see Local fix
Timestamps
Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :
15.03.2017
23.06.2017
23.06.2017
Problem solved at the following versions (IBM BugInfos)
Problem solved according to the fixlist(s) of the following version(s)