DB2 - Problem description
Problem IT20976 | 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 / A50 - 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 10.5 Fix Pack 9 or higher * **************************************************************** | |
Local Fix: | |
Do not run alter tablespace on tablespaces that are being backed up. | |
Solution | |
First fixed in Db2 10.5 Fix Pack 9 | |
Workaround | |
not known / see Local fix | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 09.06.2017 29.09.2017 29.09.2017 |
Problem solved at the following versions (IBM BugInfos) | |
9.0. | |
Problem solved according to the fixlist(s) of the following version(s) |