|
Problem IT20857
|
Status: Closed |
DROP/TRUNCATE PARTITION TABLE IS VERY SLOW ON PURESCALE |
| product: |
DB2 FOR LUW / DB2FORLUW / A50 - DB2 |
| Problem description: |
Truncate or drop a partition table is very slow on pureScale,
even the table is empty. The time taken has nothing to do with
GBP size, but LBP size. From db2trc on coordinator member,
sqlbSendFlushPurgeRPC() takes long time, from db2trc on the
other member(s), the time consuming part is within
sqlbPurgeAllPagesCommon(). |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* ALL *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to Db2 10.5 Fix Pack 9 or higher *
**************************************************************** |
| Local Fix: |
|
| Solution |
First fixed in Db2 10.5 Fix Pack 9 |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 04.06.2017
29.09.2017
29.09.2017 |
| Problem solved at the following versions (IBM BugInfos) |
9.0.
|
| Problem solved according to the fixlist(s) of the following version(s) |
