DB2 - Problem description
Problem IT37634 | Status: Closed |
HANG IF REMOTE NODE OUTPUT OF MON_GET_LOCKS OR MON_GET_PKG_CACHE_STMT IS BIGGER THAN 2GB | |
product: | |
DB2 FOR LUW / DB2FORLUW / B50 - DB2 | |
Problem description: | |
In a DPF or pureScale environment if MON_GET_LOCKS or MON_GET_PKG_CACHE_STMT is called to gather data from other nodes and the output from one of those remote nodes is larger than 2Gb in size the table function can hang. a probe such as the following will appear in the db2diag.log of the remote node whose output is bigger than 2Gb: 2021-07-14-14.53.32.655299-240 I25088E624 LEVEL: Error PID : 25608 TID : 139998632339200 PROC : db2sysc 0 INSTANCE: db2inst1 NODE : 000 DB : SAMPLE APPHDL : 1-67 APPID: *N1.db2inst1.210714185245 AUTHID : DB2INST1 HOSTNAME: MYHOST1 EDUID : 135 EDUNAME: db2agntp (SAMPLE) 0 FUNCTION: DB2 UDB, WLM, sqlrwGetWLMTableFunctionResult, probe:20 DATA #1 : String, 63 bytes Not able to process the data because the size is larger than 2G DATA #2 : signed integer, 8 bytes 2995922508 DATA #3 : signed integer, 2 bytes 21 The coordinator calling the table function will have a stack that looks like this: semtimedop sqloWaitEDUWaitPost sqkfChannel::WaitRecvReady sqkfChannel::ReceiveAnyBuffer sqkdBdsBufferTable::dequeueBuffer sqkdBdsBufferTable::getNextBuffer sqlkdReceiveReply sqlrkrpc_nl sqlrwSendGetWLMTableFunctionResult sqlrwGetWLMTableFunctionMergedResult sqlerTrustedRtnCallbackRouter monGetPkgCacheStmt_v115m4fp0 sqloInvokeFnArgs sqlriInvokeInvoker sqlriutf sqlri_tfopn sqlriopn sqlrita sqlriSectInvoke sqlrr_process_fetch_request sqlrr_fetch sqljs_ddm_cntqry sqljsParseRdbAccessed sqljsParse sqljsDrdaAsDriver sqeAgent::RunEDU sqzEDUObj::EDUDriver sqloEDUEntry | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * Anybody calling mon_get_locks or mon_get_pkg_cache_stmt in * * dpf or pureScale * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to the latest fix pack. * **************************************************************** | |
Local Fix: | |
Solution | |
Workaround | |
**************************************************************** * USERS AFFECTED: * * Anybody calling mon_get_locks or mon_get_pkg_cache_stmt in * * dpf or pureScale * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to the latest fix pack. * **************************************************************** | |
Comment | |
Problem was first fixed in DB2 UDB Version 11.5 fix pack 7 | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 14.07.2021 15.12.2021 29.03.2022 |
Problem solved at the following versions (IBM BugInfos) | |
Problem solved according to the fixlist(s) of the following version(s) |