DB2 - Problem description
Problem IT16444 | Status: Closed |
8KB MEMORY LEAK IN CLI_SETSESSIONGLOBALVARIABLES() | |
product: | |
DB2 FOR LUW / DB2FORLUW / A50 - 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: * * Non-SQL routines calling CLI_setServerVariables * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Apply v10.5 Fixpack xx to the DB2 Server. * **************************************************************** | |
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 | |
Problem first fixed in v10.5 Fixpack xx | |
Workaround | |
See LOCAL FIX | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 03.08.2016 27.09.2017 27.09.2017 |
Problem solved at the following versions (IBM BugInfos) | |
Problem solved according to the fixlist(s) of the following version(s) |