Re: High Memory Utilization Alert

[Sneha Verma <snehaverma001@xxxxxxxx>]

Thanks Rob.
 
Can the memory utilization go over 100% mark.I have noticed the CPU Utilization going above 100% because the partition is uncapped.Can the same happen with memory utilization for this uncapped partition?.
 
Regards
Sneha

--- On Tue, 4/5/10, rob@xxxxxxxxx <rob@xxxxxxxxx> wrote:


From: rob@xxxxxxxxx <rob@xxxxxxxxx>
Subject: Re: High Memory Utilization Alert
To: "Midrange Systems Technical Discussion" <midrange-l@xxxxxxxxxxxx>
Date: Tuesday, 4 May, 2010, 1:41 PM


There are multiple schools of thought. 

One is that memory is like purchasing a piece of equipment for the shop 
floor, if you're using it at full capacity, that's a good thing.  It's 
hard for them to grasp my running my milling machine at full capacity will 
slow down their injection molder.

One is that QPFRADJ does it's adjustment too slowly to avoid wide swings. 
For example, you switch from day to night.  IOW, everyone goes home and a 
slew of night jobs kick in promptly at whistle blow.  QPFRADJ will only 
move so much memory at certain intervals.  It may take awhile for batch to 
be optimized.  Expect vendor replies from companies that have software to 
tune more timely than QPFRADJ.

Some may throw more memory at it.

Some may suggest a comprehensive tuning analysis which may, or may not, 
result in thowing more memory at it.

My school of thought is that if you're getting too damned many alerts and 
people are conveniently forgetting their pagers or blackberries because 
they are tired of hearing of it, then turn it off.

What, exactly, are they to do when this happens?  If this only turned on 
because FRANK runs the query from hell interactively and kills the system 
and you need to kill his job, then have your tool say if the memory hog is 
from an interactive session from FRANK and that query is in the call stack 
than kill his job.  This is long hand for automated operations.


Rob Berendt