|
Problem IT17219
|
Status: Geschlossen |
SYSCAT.COLUMNS AND SYSIBM.SYSCOLUMNS MAY SHOW INLINE_LENGTH OF 0FOR A TABLE'S LOB COLUMNS |
| Produkt: |
DB2 FOR LUW / DB2FORLUW / B10 - DB2 |
| Problembeschreibung: |
SYSCAT.COLUMNS and SYSIBM.SYSCOLUMNS may show INLINE_LENGTH of 0
for a table's LOB columns following ALTER TABLE DROP COLUMN
statements against the table. This issue can be seen when
dropping a column earlier than a LOB column in the table
definition.
ie. when dropping a column of a table where the COLNO for the
dropped column is less than the COLNO for a LOB column in the
same table |
| Problem-Zusammenfassung: |
****************************************************************
* USERS AFFECTED: *
* all *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* upgrade to Db2 v 111m1fp1 *
**************************************************************** |
| Local-Fix: |
|
| verfügbare FixPacks: |
DB2 Version 11.1 Mod1 Fix Pack1 iFix001 for Linux, UNIX, and Windows
DB2 Version 11.1 Mod 2 Fix Pack 2 for Linux, UNIX, and Windows
Db2 Version 11.1 Mod2 Fix Pack2 iFix001 for Linux, UNIX, and Windows
Db2 Version 11.1 Mod2 Fix Pack2 iFix002 for Linux, UNIX, and Windows
Db2 Version 11.1 Mod 3 Fix Pack 3 for Linux, UNIX, and Windows
Db2 Version 11.1 Mod3 Fix Pack3 iFix001 for Linux, UNIX, and Windows
Db2 Version 11.1 Mod3 Fix Pack3 iFix002 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:
| 26.09.2016
11.10.2017
11.10.2017 |
| Problem behoben ab folgender Versionen (IBM BugInfos) |
|
| Problem behoben lt. FixList in der Version |
| 11.1.1.1
|
 |
