|
Problem IC63246
|
Status: Geschlossen |
SQL0901N OCCURS INSERTING OR UPDATING A LBAC PROTECTED ROW WITH A BEFORE TRIGGER THAT MODIFIES A NEW TRANSITION VARIABLE |
| Produkt: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| Problembeschreibung: |
An INSERT or UPDATE into an LBAC protected row that fires a
BEFORE TRIGGER containing a SET statement that modifies a new
transition variable will result in an SQL0901N.
There is no proper workaround, but we can either (1) don't use
LBAC on the table or (2) don't use SET statement that modifies
new transition variable in before trigger. |
| Problem-Zusammenfassung: |
****************************************************************
* USERS AFFECTED: *
* Users of LBAC on tables with a BEFORE TRIGGER *
****************************************************************
* PROBLEM DESCRIPTION: *
* An INSERT or UPDATE into an LBAC protected row that fires *
* a BEFORE TRIGGER containing a SET statement that modifies *
* anew transition variable will result in an SQL0901N. There *
* is no proper workaround, but we can either (1) don't use *
* LBAC *
* on the table or (2) don't use SET statement that modifies *
* new *
* transition variable in before trigger. *
****************************************************************
* RECOMMENDATION: *
* Upgrade to DB2 v9.7 FP2 or newer. *
**************************************************************** |
| Local-Fix: |
N/A |
| verfügbare FixPacks: |
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
|
| Lösung |
Upgrade to DB2 v9.7 FP2 or newer. |
| Workaround |
keiner bekannt / siehe Local-Fix |
| Weitere Daten |
Datum - Problem gemeldet :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
| 17.09.2009
14.07.2010
14.07.2010 |
| Problem behoben ab folgender Versionen (IBM BugInfos) |
9.7.FP2
|
| Problem behoben lt. FixList in der Version |
| 9.7.0.2
|
 |
