|
Problem IC63760
|
Status: Closed |
Table size may unnecessarily increase after failed inserts. |
| product: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| Problem description: |
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 Summary: |
****************************************************************
* 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. |
| available fix packs: |
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
|
| Solution |
The problem was first fixed in V9.7 Fix Pack 3 |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 16.10.2009
11.08.2010
11.08.2010 |
| Problem solved at the following versions (IBM BugInfos) |
9.7.FP3
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.7.0.3
|
 |
| 9.7.0.3
|
|
