Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion Groups
Database Servers
DB2InformixIngresMS SQLOraclePervasive.SQLPostgreSQLProgressSybase
Desktop Databases
FileMakerFoxProMS AccessParadox
General
General DB TopicsDatabase Theory
Related Topics
Java Development.NET DevelopmentVB DevelopmentMore Topics ...

Database Forum / DB2 Topics / April 2005

Tip: Looking for answers? Try searching our database.

Memory used - what is  "Other memory"?

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
bughunter@ru - 19 Apr 2005 07:12 GMT
Very interesting for me

  [...]
  Lock Manager Heap is of size 16809984 bytes
  Database Heap is of size 9273344 bytes
  Database Monitor Heap is of size 5226496 bytes
  Other Memory is of size 729202688 bytes
  FCMBP Heap is of size 4997120 bytes
  Total: 1889337344 bytes

"Other memory" size 40%(!!!). How resolve this memory leak?

Andy
JS - 20 Apr 2005 15:32 GMT
> Very interesting for me
>
[quoted text clipped - 9 lines]
>
> Andy

Yes, we faced similar problem trying to understand this and finally
what you have to do is configure APPGROUP_MEM_SZ for the database,
this is where part of the 'other memory' is comuing from
bughunter@ru - 21 Apr 2005 06:30 GMT
Yes, we have appgroup_mem_sz=30000 *4K = 120 Mb max, is't correct?
Inside snapshot I see

Application Group Shared Heap is of size 99631104 bytes

and this memory ~98Mb calculated in result string. But other memory
size - 730Mb!

Andy
2IBM: ???
JS - 21 Apr 2005 14:38 GMT
> Yes, we have appgroup_mem_sz=30000 *4K = 120 Mb max, is't correct?
> Inside snapshot I see
[quoted text clipped - 6 lines]
> Andy
> 2IBM: ???

The value is 'correct' depending upon how many applications you have
connected to the database, the value is configured in conjunction with
GROUPHEAP_RATIO and APP_CTL_HEAP_SZ. What these values do is control
how many applications can 'fit' into one memory group, once one memory
group is 'filled up', another memory group is allocated, hence you
have lots of memory allocated if your groups are configured too small.
Erik Hendrix - 28 Apr 2005 09:35 GMT
Haven't been completly following this, but is the database memory set to
automatic? If so it will allocate more then what is configured and this
might be the "Other Memory" you are seeing.

> Yes, we have appgroup_mem_sz=30000 *4K = 120 Mb max, is't correct?
> Inside snapshot I see
[quoted text clipped - 6 lines]
> Andy
> 2IBM: ???
bughunter@ru - 29 Apr 2005 13:34 GMT
all automatic disabled.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.