home clear 64x64
en blue 200x116 de orange 200x116 info letter User
suche 36x36
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 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
DB2 Version 9.5 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 10 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 FixList