• Subject: Re: Performance solutions through hardware
  • From: fkolmann@xxxxxxxxxxxxx
  • Date: Wed, 21 Jul 1999 09:31:25 +1000



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
+---


This thread ...

Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2019 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].