Re: Performance solutions through hardware

[fkolmann@xxxxxxxxxxxxx]

Dwight Slessman wrote:

> Is the same job consistently slow or does it run quickly sometimes and slow
> other times?  We have found many areas of BPCS that use very poor
> programming techniques in general and SQL in particular.

Dwight we have a donk that is too big for us.  The jobs times are constsistant.
By this I mean it is not the load
on the AS400 affecting the job.  It is the job itself.  Other jobs running at
the same time as the jobs in quwstion, ECM
are flying along.

> The As/Set case tool (we have been using since 1992) does not generate the
> world's most
> efficient code to begin with.  Add to that some "creative" techniques used
> by SSA and you get some real dogs.

We are also using AS/Set.  (Is this really a CASE tool?)  I thought CASE tools
made programming easier
rather than an arcane art.)  Its the SQL that SSA use in place of setting up
data models, or rather the difficulty of
modifying data models and having all programs that use the model updated that
may be part of the problem.

> We had a sizing problem with our AS/400 and would experience intermittant
> performance problems.  If your
> performance comes and goes you could also be experiencing a "governing"effect
> supplied by IBM.When your job appears to "go to sleep", useWRKSYSACT and
> check if there are any CFINTxx jobs running and how much CPU they are
> pulling.  If you see multiple CFINTxx jobs running and they are pulling a
> significant percentage of CPU, you are being slowed down by IBM

Ahh my  paranoia is at an end , no headshrinker required (for now anyway).
Thanks for the tip.

> upgrade.  By the way we are on BPCS 6.0.04 mixed mode with an AS/400 2178.

Thanks DWIGHT, we are also 6.04 MM and  have a 640-2237 on V4R2M0.



+---
| This is the BPCS Users Mailing List!
| To submit a new message, send your mail to BPCS-L@midrange.com.
| To subscribe to this list send email to BPCS-L-SUB@midrange.com.
| To unsubscribe from this list send email to BPCS-L-UNSUB@midrange.com.
| Questions should be directed to the list owner: dasmussen@aol.com
+---