|
Problem IC69133
|
Status: Geschlossen |
ONLINE BACKUP HANGS UP ON DEADLATCH CONDITION BETWEEN DB2BM AND PREFETCHERS |
| Produkt: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| Problembeschreibung: |
The online backup can hang up with the following stacks under
very stressful conditions for prefetching resources and those
stacks are the eye-catchers of this issue.
db2bm is waiting in sqloCSemP :
0x0900000000248358 msgrcv + 0xD8
0x0900000007D4EB5C sqloCSemP + 0x194
0x09000000060ED278
sqlbpfParallelDirectReadV__FP14SQLB_pfParIoCbP17SQLB_DIRECT_IO_C
B
+ 0x1488
0x09000000060E8FE4
sqlbDirectReadBlock__FP17SQLB_DIRECT_IO_CBP14SQLB_pfParIoCbUiPUi
T4
+ 0xC50
0x09000000060E70E0 sqlubReadDMS__FP14SQLU_BUFMAN_CB + 0x8D0
0x0900000005B4B4C0 sqlubBMCont__FP14SQLU_BUFMAN_CB + 0x1C0
0x09000000060E1284 sqlubbuf__FP8sqeAgent + 0x590
0x09000000047F1890 sqleSubCoordProcessRequest__FP8sqeAgent +
0x1F4
Some db2pfchrs are waiting on the range latch as follows :
0x09000000000EAC18 thread_wait + 0x98
0x0900000007D80104 getConflictComplex__17SQLO_SLATCH_CAS64FCUl +
0x3DC
0x0900000007D7F724 getConflict__17SQLO_SLATCH_CAS64FCUl + 0x58
0x0900000007F758DC
getConflict__17SQLO_SLATCH_CAS64FCUl@glueF7@clone1 + 0x74
0x0900000007DBE968
sqloltch_track__FCP10sqlo_latchCUlCPCcT2P16SQLO_LATCH_TABLECbC14
SQLO_LT_VALUES@glue9B7
+ 0x128
0x0900000007C60080
sqlbLatchPoolRange__FP12SQLB_GLOBALSUsUiT3PiT5ib + 0x224
0x0900000004BD3278
sqlbReadAndReleaseBuffers__FP16SQLB_OBJECT_DESCUiUlN23P11SQLB_pf
Misc
+ 0x448
0x0900000007D5037C sqlbServiceRangeRequest__FP11SQLB_pfMisc +
0x1D0 |
| Problem-Zusammenfassung: |
****************************************************************
* USERS AFFECTED: *
* Online backup user *
****************************************************************
* PROBLEM DESCRIPTION: *
* The online backup hangs up under very stressful conditionsby *
* the deadlatch between db2bm and prefetchers *
* duringprefetching resources. *
****************************************************************
* RECOMMENDATION: *
* Upgrade to db2 Version 9.7 FixPak 3 *
**************************************************************** |
| Local-Fix: |
- increase NUM_IOSERVERS settings and it much reduces the
problem risk. |
| verfügbare FixPacks: |
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
|
| Lösung |
Problem was first fixed in Version 9.7 FixPak 3 |
| Workaround |
keiner bekannt / siehe Local-Fix |
| Bug-Verfolgung |
Vorgänger : APAR is sysrouted TO one or more of the following: IC69857 IC74016
Nachfolger : |
| Weitere Daten |
Datum - Problem gemeldet :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
| 10.06.2010
30.09.2010
04.02.2011 |
| Problem behoben ab folgender Versionen (IBM BugInfos) |
9.7.
|
| Problem behoben lt. FixList in der Version |
| 9.7.0.3
|
 |
| 9.7.0.3
|
|
