Latest versionsfixlist
11.1.0.6 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
Have problems? - contact us.
Register for free anmeldung-x26
Contact form kontakt-x26
Question in the chat LiveZilla Live Help

DB2 - Problem description

Problem IC65334 Status: Closed

Function execution blocked with SQL0551N when invoked with
authenticated group from non-catalog database partition

product:
DB2 FOR LUW / DB2FORLUW / 950 - DB2
Problem description:
The following SQL0551N can be returned when a function from 
non-catalog database partition is invoked even if it is 
correctly authenticated on EXECUTE by group to which the 
requester id belongs. 
 
SQL0551N "USERXXXX" does not have the privilege to perform 
operation "EXECUTE" on object "SCHEMAXXX.FUNCTIONXXX". 
SQLSTATE=42501
Problem Summary:
**************************************************************** 
* USERS AFFECTED:                                              * 
* Multi-partitioned db user                                    * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* The SQL0551N can be returned when a function fromnon-catalog * 
* database partition is invoked even if it iscorrectly         * 
* authenticated on EXECUTE by group to which therequester id   * 
* belongs.                                                     * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to db2 Version 9.5 FixPak 6                          * 
****************************************************************
Local Fix:
There are several workaround available - they should all be 
noted here explicitly, such as: 
- Execute from catalog node. 
- Grant explicit privilege to the user themselves 
- Executing the exact same SQL which invokes the function on the 
catalog node first, *may* allow non-catalog nodes to 
successfully execute as well.
available fix packs:
DB2 Version 9.5 Fix Pack 6a for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 7 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 8 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 10 for Linux, UNIX, and Windows

Solution
Problem was first fixed in Version 9.5 FixPak 6
Workaround
not known / see Local fix
BUG-Tracking
forerunner  : APAR is sysrouted TO one or more of the following: IC65449 
follow-up : 
Timestamps
Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :
28.12.2009
05.07.2010
05.07.2010
Problem solved at the following versions (IBM BugInfos)
9.5.
Problem solved according to the fixlist(s) of the following version(s)
This site uses cookies to make it easier for us to provide you with our services. By using our site you agree to the use of cookies.