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!

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

UTIL_HEAP_SZ

Status
Not open for further replies.
kozlow

kozlow

MIS
Mar 3, 2003
326
US
When I graphed our memory usage by db2 for a week, I found that the UTIL_HEAP_SZ was not part of the Buffer Pool. We have a large Util Heap size to allow the backups to run faster at night and for some weekend jobs which run imports, exports and loads.
During Prime shift, we do not need the memory allocated to UTIL.... It comes out to about 1/4 of the available memory on this server.
I was going to create a job that would alter the bufferpool and Util heap sizes before the backups start and then reverse the process once completed. I am pretty sure the database will require all applications to disconnect before the changes take place.... Defeating the whole Online backup purpose. This would be unacceptable for our users.

Any Ideas on how to solve the memory allocation?

Running UDB 7.2
 
Sort by date Sort by votes
Never had a chance to check it ..
But as per the manuals, util_heap_sz is allocated when requested by BACKUP, RESTORE or LOAD (note - imports and exports not included) and freed when those utilites no longer need memory ...

HTH

Sathyaram

More DB2 questions answered at
 
Upvote 0 Downvote
I know..... There is an old IBM acronym... RTFM....

Still a big waste of memory in my eyes... If I do not have enouph free memory to be allocated for UTIL, then my backups will fail... If I lower the size, they will not complete in our windows. If I change the size of the buffer pool and util heap before the backups and loads, it will not take affect until all applications disconnect. Which never happens.... Stuck between a rock and a hard place... Guess the only choice is to dump the present server and get one with 3X the memory, allowing for the amount that can not be used during the day.....

Guess it comes down to, I hate not being able to use the memory during prime shift, when I need it the most....

Thanks for the feed back...
 
Upvote 0 Downvote
kozlow,

on version 8, you can change this and have it take effect immediately. Don't know if that helps in your purchase decisions.

Greg
 
Upvote 0 Downvote
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top