DB2 - Problem description
Problem IC72225 | Status: Closed |
NET SEARCH EXTENDER COMMAND 'ENABLE DATABASE' FAILS IF INSTANCE OWNER AND INSTANCE OWNER GROUP HAVE IDENTICAL NAMES. | |
product: | |
DB2 NET SEARCH / 5765F3800 / 950 - 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: | |
db2text enable databsae command fails if the instance owner name and the group name to whcih the instanc eonwer belongs are identical. | |
Local Fix: | |
The problem can be circumvented by assigning different names to the user and its primary group | |
available fix packs: | |
DB2 Version 9.5 Fix Pack 8 for Linux, UNIX, and Windows | |
Solution | |
Upgrade to V95fp8 | |
Workaround | |
not known / see Local fix | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 27.10.2010 14.07.2011 14.07.2011 |
Problem solved at the following versions (IBM BugInfos) | |
9.5.FP8 | |
Problem solved according to the fixlist(s) of the following version(s) | |
9.5.0.8 |