|
Problem IC63634
|
Status: Geschlossen |
DB2 SHOULD ALLOW A BEFORE TRIGGER TO REFERENCE A TRANSITION VARIABLE OF A SECURITY LABEL COLUMN |
| Produkt: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| Problembeschreibung: |
SQL20094N will be returned when using a BEFORE TRIGGER to check
the value of a security label column. The SQL20094N should only
be returned if we are trying to change the value of the security
label column.
This APAR will relax the restriction so that transition
variable of security label column can be referenced in a BEFORE
trigger. However, modification of such transition variable will
continue to be blocked (and SQL20094N returned). |
| Problem-Zusammenfassung: |
****************************************************************
* USERS AFFECTED: *
* Users checking the value of a security label column *
****************************************************************
* PROBLEM DESCRIPTION: *
* SQL20094N will be returned when using a BEFORE TRIGGER *
* tocheck the value of a security label column. The *
* SQL20094Nshould only be returned if we are trying to change *
* thevalueof the security label column.This defect will relax *
* therestriction so that transition variable of security *
* labelcolumn can be referenced in a BEFORE trigger. *
* However,modification of such transition variable will *
* continue to beblocked (and SQL20094N returned). *
****************************************************************
* RECOMMENDATION: *
* Upgrade to DB2 v9.7 FP2 or newer *
**************************************************************** |
| Local-Fix: |
|
| 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 |
|
| Workaround |
keiner bekannt / siehe Local-Fix |
| Weitere Daten |
Datum - Problem gemeldet :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
| 07.10.2009
25.05.2010
25.05.2010 |
| Problem behoben ab folgender Versionen (IBM BugInfos) |
9.7.FP2
|
| Problem behoben lt. FixList in der Version |
| 9.7.0.2
|
 |
