Fixes are available
Db2 Version 11.1 Mod4 Fix Pack4 iFix001 for Linux, UNIX, and Windows
Db2 Version 11.1 Mod 4 Fix Pack 4 for Linux, UNIX, and Windows
Db2 Version 11.1 Mod 4 Fix Pack 6 for Linux, UNIX, and Windows
Db2 Version 11.1 Mod 4 Fix Pack 5 for Linux, UNIX, and Windows
Db2 Version 11.1 Mod 4 Fix Pack 7 for Linux, UNIX, and Windows
APAR status
Closed as program error.
Error description
When running a procedure containing following DBMS_SQL system module calls, db2pd -dbptnmem shows that DBMS set grows. CALL DBMS_SQL.OPEN_CURSOR(v_curid); CALL DBMS_SQL.PARSE(v_curid, v_sql, DBMS_SQL.native); CALL DBMS_SQL.EXECUTE(v_curid, v_status); CALL DBMS_SQL.CLOSE_CURSOR(v_curid); The db2pd -memblocks indicates memory blocks for the system routines allocated in the krcbh heap keeps increasing as below: $ db2pd -memblock dbms 69 sort Memory blocks in DBMS set for pool 69. Memory blocks sorted by size for krcbh pool: (PoolID: 69, SecondID: 0, PoolAddr: 0x00000002000033A8) PoolID PoolName TotalSize(Bytes) TotalCount LOC File 69 krcbh 1333344136 22727093 3010 907928531 69 krcbh 6291456 1 1798 698130716 69 krcbh 101968 1 1608 698130716 69 krcbh 66800 1 5470 698130716 69 krcbh 16400 1 5641 1507598115 69 krcbh 4304 1 1407 698130716 69 krcbh 1280 10 470 2296446861 69 krcbh 856 1 8502 698130716 69 krcbh 552 1 1999 698130716 69 krcbh 80 1 1973 698130716 69 krcbh 16 1 1957 698130716 Total size for krcbh pool: 1339827848 bytes (PoolID: 69, SecondID: 0, PoolAddr: 0x00000002000033A8) Note: the LOC can slightly vary depending on the fixpack and/or platform.
Local fix
Please disconnect the application which called DBMS_SQL.OPEN_CURSOR.
Problem summary
**************************************************************** * USERS AFFECTED: * * Users using DBMS_SQL system * * module * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to Db2 v11.1 m4fp4 * ****************************************************************
Problem conclusion
Problem first fixed in v11.1 m4fp4
Temporary fix
Comments
APAR Information
APAR number
IT24846
Reported component name
DB2 FOR LUW
Reported component ID
DB2FORLUW
Reported release
B10
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2018-04-25
Closed date
2018-12-10
Last modified date
2018-12-10
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Fix information
Fixed component name
DB2 FOR LUW
Fixed component ID
DB2FORLUW
Applicable component levels
RB10 PSY
UP
[{"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSEPGG","label":"DB2 for Linux- UNIX and Windows"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"11.1","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
04 May 2022