home clear 64x64
en blue 200x116 de orange 200x116 info letter User
suche 36x36
Neueste VersionenFixList
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
Haben Sie Probleme? - Kontaktieren Sie uns.
Kostenlos registrieren anmeldung-x26
Kontaktformular kontakt-x26

DB2 - Problembeschreibung

Problem IC65070 Status: Geschlossen

Using system defined modules result in SQL0551N "SYSIBM RATOR"
does not have the required authorization or privilege

Produkt:
DB2 FOR LUW / DB2FORLUW / 970 - DB2
Problembeschreibung:
This symptom can be made if the database is created with 
username of which length is greater than 8 characters such as 
ADMINISTRATOR and the system defined module is executed. If you 
see a SQL0551N error with "SYSIBM RATOR",  you are impacted by 
this issue. 
 
For example,  while executing, module UTL_FILE fails with error 
below. 
 
  SQL0551N "SYSIBM RATOR" does not have the required 
authorization or privilege to perform operation "EXECUTE" on 
object "SYSIBMADM.Pxxxxxxx".  SQLSTATE=42501 
 
If you see the "Definer length  : 13" and "Definer : SYSIBM 
RATOR" in the output of the following db2cat, then you have the 
issue on that database. 
 
  > db2cat -d <dbname> -s SYSIBMADM -n imp_fopen -m UTL_FILE  -p 
 routine -o imp_fopen.pd.fmt 
  > find /i "definer" imp_fopen.pd.fmt 
 
  ---------- IMP_FOPEN.PD.FMT 
   Definer length                : 13 
   Definer                       : SYSIBM  RATOR 
   Definer type                  : S
Problem-Zusammenfassung:
**************************************************************** 
* USERS AFFECTED:                                              * 
* All                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* Using system defined modules result in SQL0551N like         * 
* "SYSIBMRATOR" does not have the required authorization       * 
* orprivilege.                                                 * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to db2 Version 9.7 FixPak 2                          * 
****************************************************************
Local-Fix:
Re-create the database with a user whose username length is   <= 
8 characters.
verfügbare FixPacks:
DB2 Version 9.7 Fix Pack 2 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 3 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 3a for Linux, UNIX, and Windows
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 9a 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 10 for Linux, UNIX, and Windows

Lösung
Problem was first fixed in Version 9.7 FixPak 2
Workaround
keiner bekannt / siehe Local-Fix
Bug-Verfolgung
Vorgänger  : APAR is sysrouted TO one or more of the following: IC69777 IC69792 
Nachfolger : 
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
11.12.2009
30.06.2010
15.07.2010
Problem behoben ab folgender Versionen (IBM BugInfos)
9.7.
Problem behoben lt. FixList in der Version
9.7.0.2 FixList