DB2 CONNECT / DB2CONNCT / 970 - DB2

With DB2 9.7, new authorities are introduced : 
ACCESSCTRL,DATAACCESS, EXPLAIN, SQLADM, and WLMADM. 
 
If the user (or the group), you are trying to remove, has one of 
these authorities, DB2 Control enter          will fail without 
any error. The user (or the group) will be removed from the list 
displayed by DB2 Control Center but not from the database : it 
will be displayed again, if you refresh the list of the users 
(or groups) or if you restart the tool.

**************************************************************** 
* USERS AFFECTED:                                              * 
* DB2 Control Center                                           * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 9.7 FP4                                       * 
****************************************************************

To remove the user (or group), you can use the command line 
processor instead: 
 
- check the authority by running 
     db2 select * from sysibm.sysdbauth where grantee = "yyyy" 
 
 
- remove the corresponding authority for the user or group by 
running 
      db2 revoke xxxx on database from user yyyy 
      or 
      db2 revoke xxxx on database from group yyyy 
where "xxxx" is the authority and "yyyy" is the group or user 
name.

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
 

DB2 9.7 FP4

keiner bekannt / siehe Local-Fix

Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:

13.07.2010
19.05.2011
19.05.2011

9.7.FP4