|
Problem IC70934
|
Status: Closed |
NET SEARCH EXTENDER COMMAND 'ENABLE DATABASE' FAILS IF INSTANCE OWNER AND INSTANCE OWNER GROUP HAVE IDENTICAL NAMES. |
| product: |
DB2 NET SEARCH / 5765F3800 / 910 - DB2 |
| Problem description: |
On a system where the setup shows a database instance
that has identical username and groupname, the command
db2text enable database for text connect to <database>
results in an error like this:
CTE0100 A DB2 operation failed. DB2 information: "56092"
"[IBM][CLI Driver][DB2/AIX64] SQL0569N The GRANT/REVOKE
statement failed because "<username>" may identify both a user
and a group in the system. SQLSTATE=56092 ". |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
****************************************************************
* PROBLEM DESCRIPTION: *
* NET SEARCH EXTENDER COMMAND 'ENABLE DATABASE' FAILS IF *
* INSTANCE *
* OWNER AND INSTANCE OWNER GROUP HAVE IDENTICAL NAMES. *
****************************************************************
* RECOMMENDATION: *
* upgrade to V91fp10 *
**************************************************************** |
| Local Fix: |
The problem can be circumvented by assigning different names to
the user and its primary group |
| 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 |
Fixed problem to allow instance onwer and instance owner group
to have identical names. |
| Workaround |
not known / see Local fix |
| BUG-Tracking |
forerunner : APAR is sysrouted TO one or more of the following: IC72225 IC72226 IC72227
follow-up : |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 02.09.2010
02.02.2011
02.02.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
|
 |
