|
Problem IC91607
|
Status: Closed |
TRAP IN SQLBFINDPAGEINBPORSIM FOLLOWING FAILED BUFFER POOL REDUCE |
| product: |
DB2 FOR LUW / DB2FORLUW / A10 - DB2 |
| Problem description: |
An ALTER BUFFERPOOL ... REDUCE operation issued either manually
or automatically by STMM fails for internal reasons (a known
case is a failure in the sqldFixTCB routine). Depending on the
point of the failure, some of the buffer pool's properties may
have been changed, but this modification is not rolled back
appropriately. If this condition is met, a subsequent buffer
pool reduce operation may free buffer pool memory that is still
in use. The symptom may vary, a known case is an instance abend
when inserting new index keys, with the call stack similar to:
sqlbFindPageInBPOrSim
sqlbfix
sqlbFixPage
sqlifix
sqlischf
sqliSearchFromCache
sqlirdk
sqldBatchInxPXLocks
sqldInsertPrefInxPXLocks
sqldKeyInsert
sqldRowInsert
sqlrinsr
sqlriisr |
| Problem Summary: |
See Problem Description |
| Local Fix: |
Restart (deactivate/activate) the database before attempting the
subsequent buffer pool reduce operation. |
| available fix packs: |
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
|
| Solution |
Problem first fixed in IBM DB2 10.1 for Linux, UNIX, and Windows
Fix Pack 3 |
| Workaround |
See Problem Description |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 16.04.2013
21.10.2013
21.10.2013 |
| Problem solved at the following versions (IBM BugInfos) |
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 10.1.0.3
|
 |
| 10.1.0.3
|
|
