DB2 - Problem description
Problem IT35208 | Status: Closed |
DB2 : SET WRITE RESUME COMMAND HANGS | |
product: | |
DB2 FOR LUW / DB2FORLUW / B10 - DB2 | |
Problem description: | |
The SET WRITE RESUME command might hang. This is caused by some other operation (typically LOAD) trying to perform update to the GLFH file from function sqlpUpdateGlobalTimeInGLFH(), which is blocked due to database is in write suspended state. The following stack can be seen: 0x00001000186FBF78 semtimedop + 0x0038 0x000010000F36F078 sqlpSuspendIOGuard::getSuspendIOCBLatchAndCheckState() + 0x0798 0x000010000F23BE98 sqlpgUpdateGLFH(SQLP_GLFH*, SQLP_GLFH_CB*) + 0x00a8 0x000010000F6B6548 sqlpMasterDbcb::sqlpgOpenAndUpdateGLFH() + 0x0218 0x000010000F559C6C sqlpGLFHValLotch::writeNew() + 0x023c 0x000010000F72B9A0 sqlpUpdateGlobalTimeInGLFH(sqeBsuEdu*, sqeLocalDatabase*) + 0x13f0 0x0000100010BF4DA8 sqluRegisterLoadEnd(unsigned char*, unsigned char*, int, SQLUVLCB_TYPE*, unsigned char, int, int, int, int, int, sqeAgent*, SQLB_GLOBALS*, SQLU_LOADAPI_LOAD_CB*, int, sqlubmh*, int*) + 0x0ca8 0x00001024B67ECC50 0x0000100010C02878 0x0000100010BFF608 sqluLoadPartition(sqeAgent*, sqluCLoadRequestDescriptor*, int, int, int, int*, int*) + 0x02e8 0x000010001114FDD8 sqlusCLoadSubAgent::iRun() + 0x02b8 0x000010001117DDB8 sqlusSubAgentRouter(sqeAgent*, int) + 0x0bc8 0x00001024B67EDB80 0x000010000C4FAD1C 0x000010000C4F4440 sqleProcessSubRequest(sqeAgent*) + 0x2400 0x000010000C573E74 sqeAgent::RunEDU() + 0x09f4 0x00001000115FDA04 sqzEDUObj::EDUDriver() + 0x0344 0x00001000115FD69C sqlzRunEDU(char*, unsigned int) + 0x001c 0x000010000F1FF5F4 sqloEDUEntry + 0x0334 | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * ALL * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to DB2 Version 11.1 Mod 4 Fix Pack 6 * **************************************************************** | |
Local Fix: | |
NA | |
Solution | |
Workaround | |
**************************************************************** * USERS AFFECTED: * * ALL * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to DB2 Version 11.1 Mod 4 Fix Pack 6 * **************************************************************** | |
Comment | |
First fixed in DB2 Version 11.1 Mod 4 Fix Pack 6 | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 09.12.2020 26.10.2021 26.10.2021 |
Problem solved at the following versions (IBM BugInfos) | |
Problem solved according to the fixlist(s) of the following version(s) |