|
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
|
 |
