suche 36x36
Latest versionsfixlist
11.1.0.7 FixList
10.5.0.9 FixList
10.1.0.6 FixList
9.8.0.5 FixList
9.7.0.11 FixList
9.5.0.10 FixList
9.1.0.12 FixList
Have problems? - contact us.
Register for free anmeldung-x26
Contact form kontakt-x26

DB2 - Problem description

Problem IT24809 Status: Closed

DBMS_SQL.OPEN_CURSOR CAUSES MEMORY LEAK IN KRCBH POOL

product:
DB2 FOR LUW / DB2FORLUW / A50 - DB2
Problem 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.
Problem Summary:
****************************************************************
* USERS AFFECTED:                                              *
* All users                                                    *
****************************************************************
* PROBLEM DESCRIPTION:                                         *
* See Error Description                                        *
****************************************************************
* RECOMMENDATION:                                              *
* Upgrade to v10.5 FP10                                        *
****************************************************************
Local Fix:
Please disconnect the application which called
DBMS_SQL.OPEN_CURSOR.
Solution
Workaround
not known / see Local fix
Timestamps
Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :
23.04.2018
12.07.2018
12.07.2018
Problem solved at the following versions (IBM BugInfos)
Problem solved according to the fixlist(s) of the following version(s)