Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Lock Manager Heap

Status
Not open for further replies.

oana12

Programmer
Jan 6, 2005
21
CA
Hi,
From Memory Visualizer I saw that Lock Manager Heap is high up to 100%. Which parameters I have to configure?

Thanks.
 
Which are the values for these parameters if I have 2 GB memory and 3 GHz CPU? Sometimes when I ran big stored procedure I am disconnected from the DB2 SERVER.

Thanks
 
Hi,
If you do a snapshot for dbm (or on Unix, snapshot for db), this is what you get:

Memory Pool Type = Lock Manager Heap
Current size (bytes) = 278528
High water mark (bytes) = 278528
Configured size (bytes) = 278528

The lock manager heap is fully allocated on database activation, so technically that memory is always being used even if there are no locks being held.

Hope that helps!
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top