|
Problem IT21930
|
Status: Closed |
If DB2 happens to be backing up the tablespace at the same time it is being altered, this could cause DB2 panic. |
| product: |
DB2 FOR LUW / DB2FORLUW / B10 - DB2 |
| Problem description: |
When taking an online backup, and running an alter tablespace at
the same time, if DB2 happens to be backing up the tablespace at
the same time it is being altered, this could cause DB2 to panic
and come down. The resulting stack might resemble:
0x090000000056DF14 pthread_kill + 0xD4
0x090000000768098C sqloDumpEDU + 0x6C
0x0900000006B1D808 sqle_panic__Fv + 0x218
0x0900000006BFF5B8
dumpDiagInfoAndPanic__17SQLO_SLATCH_CAS64CFCPCcCUiCUlT3ClT3CiT1T
3T7 + 0x310
0x09000000088DB820 releaseConflict__17SQLO_SLATCH_CAS64Fv +
0x45C
0x0900000009D37180
sqlbpfParallelDirectReadV__FP14SQLB_pfParIoCbP17SQLB_DIRECT_IO_C
B + 0x5D6C
0x0900000009D2ACF0
sqlbDirectReadBlock__FP19SQLB_DIRECT_READ_CBP14SQLB_pfParIoCbUiP
UiT4 + 0x40D4
0x0900000009D1FC84 sqlubReadDMS__FP14SQLU_BUFMAN_CB + 0x191C
0x0900000009D1B4C8 sqlubBMProcessData__FP14SQLU_BUFMAN_CB +
0x62C
0x0900000009D17C48 sqlubbuf__FP8sqeAgent + 0x898
0x0900000007644D4C sqleSubCoordProcessRequest__FP8sqeAgent +
0x180
0x09000000083A3FD4 RunEDU__8sqeAgentFv + 0x704
0x09000000083A3114 EDUDriver__9sqzEDUObjFv + 0x13C
0x09000000083A2F9C sqlzRunEDU__FPcUi + 0x10
0x09000000083B66BC sqloEDUEntry + 0x264
or
-----------
0x090000000056DF14 pthread_kill + 0xD4
0x090000000768098C sqloDumpEDU + 0x6C
0x0900000006B1D808 sqle_panic__Fv + 0x218
0x0900000006BFF5B8
dumpDiagInfoAndPanic__17SQLO_SLATCH_CAS64CFCPCcCUiCUlT3ClT3CiT1T
3T7 + 0x310
0x090000000706CE08 getConflictComplex__17SQLO_SLATCH_CAS64FCUl +
0x138
0x0900000008707CDC getConflict__17SQLO_SLATCH_CAS64FCUl + 0x80
0x0900000009D375E4
sqlbpfParallelDirectReadV__FP14SQLB_pfParIoCbP17SQLB_DIRECT_IO_C
B + 0x61D0
0x0900000009D2ACF0
sqlbDirectReadBlock__FP19SQLB_DIRECT_READ_CBP14SQLB_pfParIoCbUiP
UiT4 + 0x40D4
0x0900000009D1FC84 sqlubReadDMS__FP14SQLU_BUFMAN_CB + 0x191C
0x0900000009D1B4C8 sqlubBMProcessData__FP14SQLU_BUFMAN_CB +
0x62C
0x0900000009D17C48 sqlubbuf__FP8sqeAgent + 0x898
0x0900000007644D4C sqleSubCoordProcessRequest__FP8sqeAgent +
0x180
0x09000000083A3FD4 RunEDU__8sqeAgentFv + 0x704
0x09000000083A3114 EDUDriver__9sqzEDUObjFv + 0x13C
0x09000000083A2F9C sqlzRunEDU__FPcUi + 0x10
0x09000000083B66BC sqloEDUEntry + 0x264 |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* ALL *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to Db2 11.1 Mod 3 Fix Pack 3 or higher *
**************************************************************** |
| Local Fix: |
Do not run alter tablespace on tablespaces that are being backed
up. |
| available fix packs: |
Db2 Version 11.1 Mod 3 Fix Pack 3 for Linux, UNIX, and Windows
Db2 Version 11.1 Mod3 Fix Pack3 iFix001 for Linux, UNIX, and Windows
Db2 Version 11.1 Mod3 Fix Pack3 iFix002 for Linux, UNIX, and Windows
|
| Solution |
First fixed in Db2 11.1 Mod 3 Fix Pack 3 |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 09.08.2017
19.03.2018
19.03.2018 |
| Problem solved at the following versions (IBM BugInfos) |
|
| Problem solved according to the fixlist(s) of the following version(s) |
