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.
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.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.