DB2 FOR LUW / DB2FORLUW / A10 - DB2

Running an anonymous block will fail with SQL0551N (no 
authorization) after three or more HADR takeover. 
The following steps illustrate how users encounter this problem. 
 
1. Create a SQL procedure, then grant EXECUTE privilege to 
non-admin user. 
 
2. Run the procedure as the non-admin user who has EXECUTE 
granted within an anonymous block. 
 
3. Perform step 2 after each takeover HADR. The call to 
procedure within an anonymous block will eventually fail with 
SQL0551N after 3 or more takeovers. 
 
begin 
 declare t time; 
 call appl1.proc1(t); 
end 
DB21034E  The command was processed as an SQL statement because 
it was not a 
valid Command Line Processor command.  During SQL processing it 
returned: 
SQL0551N  "NEWTON" does not have the required authorization or 
privilege to 
perform operation "EXECUTE" on object 
"USER1.SQL131036262596530". 
SQLSTATE=42501

**************************************************************** 
* USERS AFFECTED:                                              * 
* Uses who use anonymous blocks in HADR systems.               * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Please upgrade to DB2 V10.1 FixPack 4 or later.              * 
****************************************************************

Restart the HADR pair like as below to recover from the 
SQL0551N. 
1. Deactivate HADR Primary, then deactivate HADR Standby. 
2. Activate HADR Standby, then activate HADR Primary.

DB2 Version 10.1 Fix Pack 4 for Linux, UNIX, and Windows
 DB2 Version 10.1 Fix Pack 6 for Linux, UNIX, and Windows
 

This problem was first fixed in DB2 V10.1 FixPack 4.

not known / see Local fix

Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :

06.12.2013
02.06.2014
02.06.2014