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