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 | |
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 |