|
Problem IC87086
|
Status: Geschlossen |
DB2LOOK GENERATES INCORRECT IDENTITY COLUMN RESTART VALUE FOR ALTER TABLE DDL |
| Produkt: |
DB2 FOR LUW / DB2FORLUW / 950 - DB2 |
| Problembeschreibung: |
DB2LOOK generated 'ALTER TABLE ... ALTER COLUMN ...' DDL might
contain incorrect RESTART WITH value for identity columns.
'RESTART WITH' value should be calculated as next value to be
loaded into cache if cashing was enabled for identity column or
as next value to be assigned to identity column if caching is
disabled. |
| Problem-Zusammenfassung: |
****************************************************************
* USERS AFFECTED: *
* ALL *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to DB2 version 9.5 Fix Pack 11. *
**************************************************************** |
| Local-Fix: |
Manually alter 'ALTER TABLE ... RESTART WITH' DDL with correctly
calculated value. |
| verfügbare FixPacks: |
DB2 Version 10.1 Fix Pack 3 for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 4 for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 3a for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 6 for Linux, UNIX, and Windows
|
| Lösung |
Problem was first fixed in DB2 version 9.5 Fix Pack 11. |
| Workaround |
keiner bekannt / siehe Local-Fix |
| Weitere Daten |
Datum - Problem gemeldet :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
| 09.10.2012
14.10.2013
14.10.2013 |
| Problem behoben ab folgender Versionen (IBM BugInfos) |
9.5.FP11
|
| Problem behoben lt. FixList in der Version |
| 10.1.0.3
|
 |
| 10.1.0.3
|
|
