home clear 64x64
en blue 200x116 de orange 200x116 info letter User
suche 36x36
Neueste VersionenFixList
11.1.0.7 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
Haben Sie Probleme? - Kontaktieren Sie uns.
Kostenlos registrieren anmeldung-x26
Kontaktformular kontakt-x26

DB2 - Problembeschreibung

Problem IC98196 Status: Geschlossen

ANONYMOUS BLOCK FAILS WITH SQL0551N AFTER 3 OR MORE HADR TAKEOVER.

Produkt:
DB2 FOR LUW / DB2FORLUW / A10 - DB2
Problembeschreibung:
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
Problem-Zusammenfassung:
**************************************************************** 
* 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.              * 
****************************************************************
Local-Fix:
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.
verfügbare FixPacks:
DB2 Version 10.1 Fix Pack 4 for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 6 for Linux, UNIX, and Windows

Lösung
This problem was first fixed in DB2 V10.1 FixPack 4.
Workaround
keiner bekannt / siehe Local-Fix
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
06.12.2013
02.06.2014
02.06.2014
Problem behoben ab folgender Versionen (IBM BugInfos)
Problem behoben lt. FixList in der Version
10.1.0.4 FixList