|
Problem IC63760
|
Status: Geschlossen |
Table size may unnecessarily increase after failed inserts. |
| Produkt: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| Problembeschreibung: |
When rows are inserted into a table, if all the free space in
the existing pages is consumed,
the table will to into append mode temporarily, until more space
is available for inserts;
for example, when subsequent inserts cause a new page to be
added to the table.
This can for instance happen on an import.
However, if those subsequent inserts fail, the new page will
still be allocated to the table but
the table may remain in append mode.
This will result in further inserts being appended to the table
rather than reusing
the space freed up by the failed inserts. This can cause the
table to grow in size
without new rows being added. |
| Problem-Zusammenfassung: |
****************************************************************
* USERS AFFECTED: *
* all *
****************************************************************
* PROBLEM DESCRIPTION: *
* Table size may increase unexpectedly after failed inserts *
****************************************************************
* RECOMMENDATION: *
* Upgrade the database server to V9.7 Fix Pack 3 *
**************************************************************** |
| Local-Fix: |
To clear this append state, either restart the database, or
perform
a number of successful inserts to ensure the allocation of new
pages. |
| verfügbare FixPacks: |
DB2 Version 9.7 Fix Pack 3 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 3a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 4 for Linux, UNIX, and Windows
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 |
The problem was first fixed in V9.7 Fix Pack 3 |
| Workaround |
keiner bekannt / siehe Local-Fix |
| Weitere Daten |
Datum - Problem gemeldet :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
| 16.10.2009
11.08.2010
11.08.2010 |
| Problem behoben ab folgender Versionen (IBM BugInfos) |
9.7.FP3
|
| Problem behoben lt. FixList in der Version |
| 9.7.0.3
|
 |
| 9.7.0.3
|
|
