MON_HEAP_SZ

Santhosh · *nix forums beginner Joined: 01 Dec 2005 Posts: 17

Dear All

I have a DB2 instance running in WINTEL platform. The MON_HEAP_SZ set
is 66. Now we received 'ADM2004E" error and as per the soln for this
error, requested to increase to 200.

So can I know what can be impact on DB2 if I increase the heap sz to
200 from 66? Any impact on the performance? Any database impact?

Please advice.. It is a production database issue

Regards
Santhosh

shenanwei@gmail.com · *nix forums addict Joined: 14 Jun 2005 Posts: 69

If you dont have memory concern, increase to 200 is a very little
change, will not impact perf at all.
Santhosh wrote:

Pierre Saint-Jacques · *nix forums Guru Wannabe Joined: 29 May 2005 Posts: 217

The message is issued if you are using snapshot monitors or tools that
depend on it.
It means it does not have enough memory to store the snapshot info.
It is dbm cfg parameter and it'll cost you200 pages of real memory to change
it. I don't believe the impact will be bad; certainly, not as bad as not
having enough space.

I would look at what monitors (Health, Activity, Snapshot) you are running
and ask myself: Are they needed on all the time???
HTH, Pierre.

--
Pierre Saint-Jacques
SES Consultants Inc.
514-737-4515
"Santhosh" <kollam68@yahoo.com> a écrit dans le message de news:
1153359141.851940.174200@h48g2000cwc.googlegroups.com...

Google