MON_HEAP_SZ

[Santhosh]

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]

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

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

[Pierre Saint-Jacques]

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" <ko******@yahoo.coma écrit dans le message de news:
11**********************@h48g2000cwc.googlegroups. com...

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