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 IC75376 Status: Geschlossen

Table protected with the policy has dropped the select statement for the
same table gives error "SQL20264N"

Produkt:
DB2 FOR LUW / DB2FORLUW / 970 - DB2
Problembeschreibung:
When the table protected with the policy has dropped "alter 
table drop security policy" the select statement for the same 
table gives the error "SQL20264N" as shown below. 
 
SQL20264N : 
For table table-name, authorization ID auth-id does not have 
access-type access to the column column-name. 
 
The reason for the error "SQL20264N" :The same access plan is 
used when the select statement is called on the same table after 
policy drop "alter table drop security policy" is detected. 
 
The fix for this would be to invalidate the access plan when the 
command is "alter table drop security policy" detected
Problem-Zusammenfassung:
The fix is fixed in db2 v97 FP5
Local-Fix:
To issue a different statement which would cause a new access 
plan to be generated
verfügbare FixPacks:
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 8 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9a 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:
29.03.2011
12.12.2011
12.12.2011
Problem behoben ab folgender Versionen (IBM BugInfos)
Problem behoben lt. FixList in der Version
9.7.0.5 FixList