|
Problem IT21733
|
Status: Closed |
8KB MEMORY LEAK IN CLI_SETSESSIONGLOBALVARIABLES()
|
| product: |
DB2 FOR LUW / DB2FORLUW / B10 - DB2 |
| Problem description: |
If non-SQL routines call this function then it will result in
db2fmp process growing. CLI_SETSESSIONGLOBALVARIABLES() is
called by sysproc.reorgchk_tb_stats and
sysproc.reorgchk_ix_stats. May affect other routines if they
also call this function. The function stack would look like
below if calling sysproc.roergchk_tb_stats()
sqloGetPrivateMemoryFromOs
allocateChunkGroup
getChunksFromTree
getContiguousChunks
getNewChunkSubgroup
sqlogmblkEx
sqlogmblkEx
add__7rccList
add__7rccListFP
add__7rccListFP
getParamsForDSN
getParamsForDSN
CLI_setServerVariables
CLI_setServerVariables
SQLPrepare2
SQLPrepare
isTypedTable
reorgchk_tb_stats
sqloInvokeFnArgs
@84@sqlerRunRoutine__FP13sqleInvokerCBPi
sqlerDyload
sqlerFmpListener
main
__start |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* ALL *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Apply v11.1 M1 FP2 to client or server which is calling *
* CLI_SetSessionGlobalVariables *
**************************************************************** |
| Local Fix: |
Set DBM CFG parameter KEEPFENCED=NO to disable pooling of
db2fmps. Setting this parameter may result in performance
degradation since there is no pooling of unused db2fmps |
| Solution |
|
| Workaround |
See LOCAL FIX |
| BUG-Tracking |
forerunner : IT16444
follow-up : |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 03.08.2017
10.10.2017
10.10.2017 |
| Problem solved at the following versions (IBM BugInfos) |
|
| Problem solved according to the fixlist(s) of the following version(s) |
