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 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 FixList
This site uses cookies to make it easier for us to provide you with our services. By using our site you agree to the use of cookies.