|
Problem IC63633
|
Status: Geschlossen |
DB2 SHOULD ALLOW A BEFORE TRIGGER TO REFERENCE A TRANSITION VARIABLE OF A SECURITY LABEL COLUMN |
| Produkt: |
DB2 FOR LUW / DB2FORLUW / 950 - DB2 |
| Problembeschreibung: |
When using a BEFORE TRIGGER to check the value of a security
label column SQL20094N will be returned. 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: *
* When using a BEFORE TRIGGER to check the value of a *
* securitylabel column SQL20094N will be returned. The *
* SQL20094Nshould only be returned if we are trying to change *
* the valueof the security label column.This defect will relax *
* the restriction so that transitionvariable of security label *
* column can be referenced in aBEFORE trigger. However, *
* modification of such transitionvariable will continue to be *
* blocked (and SQL20094Nreturned). *
****************************************************************
* RECOMMENDATION: *
* Upgrade to DB2 v9.5 FP6 or newer *
**************************************************************** |
| Local-Fix: |
|
| 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 |
|
| Workaround |
keiner bekannt / siehe Local-Fix |
| Bug-Verfolgung |
Vorgänger : APAR is sysrouted TO one or more of the following: IC63634
Nachfolger : |
| Weitere Daten |
Datum - Problem gemeldet :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
| 07.10.2009
14.05.2010
14.05.2010 |
| Problem behoben ab folgender Versionen (IBM BugInfos) |
9.5.FP6
|
| Problem behoben lt. FixList in der Version |
