|
Problem IC63245
|
Status: Geschlossen |
SQL0901N OCCURS INSERTING OR UPDATING AN LBAC PROTECTED ROW WITH A BEFORE TRIGGER THAT MODIFIES A NEW TRANSITION VARIABLE |
| Produkt: |
DB2 FOR LUW / DB2FORLUW / 950 - 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 *
* aBEFORE 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'tuse LBAC on *
* the table or (2) don't use SET statement thatmodifies new *
* transition variable in before trigger. *
****************************************************************
* RECOMMENDATION: *
* Upgrade to DB2 v9.5 FP6 or newer. *
**************************************************************** |
| Local-Fix: |
N/A |
| verfügbare FixPacks: |
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
|
| Lösung |
Upgrade to DB2 v9.5 FP6 or newer. |
| Workaround |
keiner bekannt / siehe Local-Fix |
| Bug-Verfolgung |
Vorgänger : APAR is sysrouted TO one or more of the following: IC63246
Nachfolger : |
| Weitere Daten |
Datum - Problem gemeldet :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
| 17.09.2009
21.09.2010
21.09.2010 |
| Problem behoben ab folgender Versionen (IBM BugInfos) |
9.5.FP6
|
| Problem behoben lt. FixList in der Version |
