|
Problem IT21691
|
Status: Closed |
REORG, LOAD, TRUNCATE, DROP TABLE ON 10.5FP8 MAY BE SLOW WHEN DELETING PAGE ON CF
|
| product: |
DB2 FOR LUW / DB2FORLUW / A50 - DB2 |
| Problem description: |
reorg,load truncate, drop table were slow due to slow cshin().
Here is a snippet from CF trace.
FP7(fast):
------
1500520956:926105 svr_cache PATH 6947096 0000001800 000 cshin
ENTRY sid: 316 ityp: 4 rt_nh: 0 rt_rem: 0 vcrt:
0 vcr: 0 vurt: 0 cvn: 0 nm: (0xfff) PAGE_NAME: (0x0) (0x2) (0x4)
(0x10)
1500520956:926109 svr_cache PATH 6947096 0000001800 000
get_cmp_msk() ENTRY
1500520956:926111 svr_cache PATH 6947096 0000001800 000
get_cmp_msk() EXIT
1500520956:926130 svr_cache PATH 6947096 0000001800 000 cshin()
EXIT
------
FP8(slow):
------
1500525212:427395 svr_cache PATH 11731308 0000001286 000 cshin
ENTRY sid: 316 ityp: 4 rt_nh: 0 rt_rem: 0 vcrt: 0 vcr: 0 vurt: 0
cvn: 0 nm: (0xfff) PAGE_NAME: (0x0) (0x2) (0x4) (0x10)
1500525212:427402 svr_cache PATH 11731308 0000001286 000
get_cmp_msk() ENTRY
1500525212:427404 svr_cache PATH 11731308 0000001286 000
get_cmp_msk() EXIT
1500525212:436115 svr_cache PATH 11731308 0000001286 000 cshin()
EXIT
------ |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* pureScale environment *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to DB2 Version 10.5 Fix Pack 9. *
**************************************************************** |
| Local Fix: |
|
| Solution |
|
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 03.08.2017
15.10.2017
15.10.2017 |
| Problem solved at the following versions (IBM BugInfos) |
9.0.
|
| Problem solved according to the fixlist(s) of the following version(s) |
