|
Problem IC73162
|
Status: Closed |
WITH FASTGROUPS=TRUE, GROUP LOOKUP IS LIMITED TO 64 GROUPS |
| product: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| Problem description: |
SQL1060N error returned when user tries to connect to database.
The user belongs to a group that has granted connect priviledge.
Problem caused by DB2 imposed a limitation of returning 64
groups of a user when FASTGROUPS=TRUE is set.
If the user belongs to more than 64 groups then not all groups
of the user is being retrieved.
So authorization failed when the left out groups are the
authorized groups. |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* Solaris DB2 users *
****************************************************************
* PROBLEM DESCRIPTION: *
* SQL1060N error returned when user tries to connect to *
* database. *
* *
* *
* The user belongs to a group that has granted connect *
* priviledge. *
* *
* *
* Problem caused by DB2 imposed a limitation of returning 64. *
* The problem only applies to Solaris operating system and *
* also will affect transparent ldap users. *
* *
* groups of a user when FASTGROUPS=TRUE is set. *
* *
* *
* *
* If the user belongs to more than 64 groups then not all *
* groups *
* of the user is being retrieved. *
* *
* So authorization failed when the left out groups are the *
* *
* authorized groups. *
****************************************************************
* RECOMMENDATION: *
* Upgrade to v9.7 Fixpak 4 *
**************************************************************** |
| Local Fix: |
Lower the numger of groups the user belongs to or unset
FASTGROUPS=TRUE |
| available fix packs: |
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
|
| Solution |
Problem was first fixed in v9.7 Fixpak 4 |
| Workaround |
Lower the numger of groups the user belongs to or unset
FASTGROUPS=TRUE |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 09.12.2010
29.04.2011
29.04.2011 |
| Problem solved at the following versions (IBM BugInfos) |
9.7.
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.7.0.4
|
 |
