RE: Interactive activity approaching capacity of installed feature

        I should have mentioned it.   We have 1gb memory. QPFRADJ is set at
3 so the machine is self tuning.
<Burnsbm@echoincorporated.com <mailto:Burnsbm@echoincorporated.com> >



-----Original Message-----
From:   Jim Franz [SMTP:franz400@triad.rr.com]
Sent:   Tuesday, April 02, 2002 4:04 PM
To:     midrange-l@midrange.com
Subject:        Re: Interactive activity approaching capacity of installed
feature

I recently helped a customer avoid the interactive upgrade by looking
at two areas of interactive processing.
There were a large number of interactive queries. One part of the fix
was that 95% of the queries already had predefined selections, that users
were overriding at run time (runqry ...rcdslt = *yes) but there were not
existing logical view for the selects & sorts run over & over again, so
building some logical views really cut down the run time. Many qry's not
involving rcdslt were move to batch, or in the case of queries with
selection
run over millions of records to select a few hundred records, I use rpg to
created the
"dreaded" qtemp files (in seconds) and ran qry over qtemp version. 10 minute
runs
became a few seconds. Any interactive query or even rpg over 10 seconds
should
be looked at.

We also found many rpg reading way too many records interactively.
Performance
tools found the pgms with the most database activity. In almost every case
better access path or sqlrpg, and/or move to batch solved the problem.
Moving to
batch & not fixing bad logic will still hurt your system.

If you have poor performing programs, even a bigger processor will get
bogged down.
btw-how much memory & how is it distributed?
are you using sysval qpfradj (performance adjuster) ?  (i do, but have
reserved memory for
several pools)
jim

----- Original Message -----
From: "Burns, Bryan" <burnsbm@Echoincorporated.com>
To: <midrange-l@midrange.com>
Sent: Tuesday, April 02, 2002 4:21 PM
Subject: Interactive activity approaching capacity of installed feature


> I started receiving the message below on an almost daily basis about six
> weeks ago. It is a QSYSOPR message with message ID CPI1479.
>
>  Message . . . . :   Interactive activity approaching capacity of
installed
>
>   feature.
>