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 IC98522 Status: Closed

MEMORY LEAK WHEN USING THE TEXT SEARCH MODULE

product:
DB2 FOR LUW / DB2FORLUW / 970 - DB2
Problem description:
Multiple leaks in the private memory area. Queries running 
concurrently on the database using text search feature will show 
noticeable growth in private memory usage. 
 
 
Sample query would be:- 
db2 connect to tst 
 
db2 "SELECT author, year, SUBSTR(title,1,30) FROM tab1  WHERE 
CONTAINS(bookinfo, 
'@xpath:''/bookinfo/story[contains(\"range\")]''') = 1  or 
CONTAINS(bookinfo, 
'@xpath:''/bookinfo/title[contains(\"the\")]'' ') = 1" fetch 
first 1 rows only 
 
db2 connect reset 
 
 
TIME      USER          PID   %CPU  %MEM   SZ  RSS    COMMAND 
MEM_Name    MemUsed(KB)  AVM      FRE     TSSHM  Agents 
15:25:07  db2inst6  38797330  0.2  7.0  1015772  1015688 
db2sysc    PRIVATE    29824         1556227  595594  8592  4262 
15:25:20  db2inst6  38797330  0.2  8.0  1050012  1049928 
db2sysc    PRIVATE    30848         1565828  585991  8592  4403 
15:25:33  db2inst6  38797330  0.2  8.0  1083804  1083720 
db2sysc    PRIVATE    30848         1574954  576480  8592  4540 
15:25:46  db2inst6  38797330  0.2  8.0  1117916  1117832 
db2sysc    PRIVATE    31872         1583094  568340  8592  4675 
15:26:00  db2inst6  38797330  0.2  8.0  1151580  1151496 
db2sysc    PRIVATE    31872         1591681  559752  8592  4808 
15:26:13  db2inst6  38797330  0.2  8.0  1185284  1185200 
db2sysc    PRIVATE    32896         1600168  551265  8592  4943 
15:26:26  db2inst6  38797330  0.2  9.0  1219484  1219400 
db2sysc    PRIVATE    32896         1608798  542635  8592  5078
Problem Summary:
**************************************************************** 
* USERS AFFECTED:                                              * 
* All                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Problem Description above                                * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 Version 9.7 Fix Pack 10                       * 
****************************************************************
Local Fix:
Solution
First fixed in 9.7 Fix Pack 10
Workaround
not known / see Local fix
Timestamps
Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :
30.12.2013
09.04.2015
09.04.2015
Problem solved at the following versions (IBM BugInfos)
9.7.FP10
Problem solved according to the fixlist(s) of the following version(s)
9.7.0.10 FixList
This site uses cookies to make it easier for us to provide you with our services. By using our site you agree to the use of cookies.