|
Problem IC65070
|
Status: Closed |
Using system defined modules result in SQL0551N "SYSIBM RATOR" does not have the required authorization or privilege |
| product: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| Problem description: |
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 Summary: |
****************************************************************
* 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. |
| available fix packs: |
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
|
| Solution |
Problem was first fixed in Version 9.7 FixPak 2 |
| Workaround |
not known / see Local fix |
| BUG-Tracking |
forerunner : APAR is sysrouted TO one or more of the following: IC69777 IC69792
follow-up : |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 11.12.2009
30.06.2010
15.07.2010 |
| Problem solved at the following versions (IBM BugInfos) |
9.7.
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.7.0.2
|
 |
