|
Problem IT09082
|
Status: Geschlossen |
ALTER TABLE DROP COLUMN MAY RESULT IN COLLATIONNAME FIELD FOR THE DROPPED COLUMN IN SYSCAT.COLUMNS VIEW TO BE SET AS INVALID. |
| Produkt: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| Problembeschreibung: |
Issuing an alter table drop column may result in COLLATIONNAME
field for the dropped column in syscat.columns view to be set as
INVALID.
ie. upon querying syscat.columns for that table, we might see an
output like the following:
db2 "select distinct(COLLATIONNAME) from syscat.columns where
TABNAME='<tabname>'"
COLLATIONNAME
----------------------------------------------------------------
----------------------------------------------------------------
INVALID
....
This APAR will fix the above observed issue. |
| Problem-Zusammenfassung: |
****************************************************************
* USERS AFFECTED: *
* ALL *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* See SYSROUTE APARs to see where this APAR is addressed *
**************************************************************** |
| Local-Fix: |
|
| Lösung |
|
| Workaround |
keiner bekannt / siehe Local-Fix |
| Weitere Daten |
Datum - Problem gemeldet :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
| 25.05.2015
09.05.2017
09.05.2017 |
| Problem behoben ab folgender Versionen (IBM BugInfos) |
|
| Problem behoben lt. FixList in der Version |
| 9.7.0.11
|
 |
