|
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) |
