|
Problem IC91607
|
Status: Geschlossen |
TRAP IN SQLBFINDPAGEINBPORSIM FOLLOWING FAILED BUFFER POOL REDUCE |
| Produkt: |
DB2 FOR LUW / DB2FORLUW / A10 - DB2 |
| Problembeschreibung: |
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-Zusammenfassung: |
See Problem Description |
| Local-Fix: |
Restart (deactivate/activate) the database before attempting the
subsequent buffer pool reduce operation. |
| verfügbare FixPacks: |
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
|
| Lösung |
Problem first fixed in IBM DB2 10.1 for Linux, UNIX, and Windows
Fix Pack 3 |
| Workaround |
See Problem Description |
| Weitere Daten |
Datum - Problem gemeldet :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
| 16.04.2013
21.10.2013
21.10.2013 |
| Problem behoben ab folgender Versionen (IBM BugInfos) |
|
| Problem behoben lt. FixList in der Version |
| 10.1.0.3
|
 |
| 10.1.0.3
|
|
