DB2 - Problem description
Problem IT08289 | Status: Closed |
PRIVATE MEMORY LEAK DUE TO NATIVE ENCRYPTION. | |
product: | |
DB2 FOR LUW / DB2FORLUW / A50 - DB2 | |
Problem description: | |
The memory consumption on db2sysc process keeps growing only when native encryption is enabled. For example, the private segments (Esid 10,11,12.. in svmon) keep growing in AIX systems, and [anon] blocks in pmap keep increasing in Linux systems. However, the DB2 memory statistics shows no leak sign in the PRIVATE set, db2pd -dbptnmem and db2pd -memblock shows stable memory stats on private memory usage. The malloc debug in AIX shows one of major leak is observed in the following code path. 0x090000000004a428 malloc_common_debugging 0x090000001a0d6d0c default_malloc_ex 0x090000001a0d7e9c C101_CRYPTO_malloc@AF28_12 0x090000001a07bf94 efCRYPTO_malloc 0x090000001a083b7c efCRYPTO_calloc 0x0900000019f99098 ICCC_EVP_CIPHER_CTX_new@AF299_235 0x0900000019f96e08 ICCC_EVP_CIPHER_CTX_new 0x0900000019f8d2b4 ICC_EVP_CIPHER_CTX_new 0x0900000002b62300 cryptSetupEncryptCipherCtx 0x090000000204fcc8 sqlexRedeemCipherTicket__FP17sqlexCipherTicketPUcUlP5sqlca 0x0900000002339720 sqlpEncrypt__FCPCvCUlPvT2P17sqlexCipherTicketPUcPib 0x0900000003b64bb8 sqlpgEncryptUserDataInNLogPages__FCPvPvCUsP17sqlexCipherTicketC 0x0900000005ab5b80 sqlpgWriteNLogPagesInternal__FR12SQLO_FHANDLECPvPvClCUlCPUlCUsP 0x0900000005a6c388 sqlpgWriteNLogPagesInternal__FR12SQLO_FHANDLECPvPvClCUlCPUlCUsP 0x0900000005a6c184 sqlpgWriteNLogPages__FR12SQLO_FHANDLECPvPvCUlClT4CPUlCUsP17sqle 0x0900000005a6bb24 sqlpgWriteToDisk__FP9SQLP_DBCBP9SQLP_LFPBUlbT4T3 0x0900000005a6b6d8 sqlpgPingPong__FP9SQLP_DBCBP9SQLP_LFPBUlbT3 0x0900000005a6b148 sqlpgwlp__FP9SQLP_DBCBUlT2PC9SQLP_LSN8T2 0x0900000005a63534 sqlpLoggwMain__11sqpLoggwEduFv | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * Users who use native encryption functionality. * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Please upgrade to DB2 V10.5 fixPack 6 or later. * **************************************************************** | |
Local Fix: | |
Please turn off native encryption. | |
Solution | |
This problem was first fixed in DB2 V10.5 FixPack 6. | |
Workaround | |
not known / see Local fix | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 14.04.2015 08.10.2015 08.10.2015 |
Problem solved at the following versions (IBM BugInfos) | |
Problem solved according to the fixlist(s) of the following version(s) | |
10.5.0.6 |