DB2 FOR LUW / DB2FORLUW / 970 - DB2

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

Re-create the database with a user whose username length is 
<=8 characters.

keiner bekannt / siehe Local-Fix

This APAR is a duplicate of IC65070

Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:

13.07.2010
13.07.2010
13.07.2010