Re: Typical PC Guy question - and request for RFB contacts

[Dan <dbcemid@xxxxxxxxx>]

Really don't mean to beat a dead horse, and I don't know squat about
your specifics...  I guess when I read that you *had* acceptable
performance and then it dropped to the level you mentioned after the
upgrade...   And now you're telling us that the upgrade "added many db
transactions".

So I'm wondering.  Is it possible that they're doing a lot of db
transactions interactively that could be done in batch?  (Based on the
impression you gave me of your experience with AS/400, you may need to
ask someone else, preferably in your shop.)  One, if the app can
offload the db transactions to batch, you might well get your response
time back from simply cutting it out of the interactive work.  Two, as
a result of moving that to batch, you lessen the impact of the
interactive tax (CPW).  Again, depending on your situation, YMMV, but
there are methods to do this and still have the db transactions get
posted as quickly, if not faster, than if they were done interactively.

I think it's worth investigating, if you or someone more
AS/400-software knowledgeable haven't done so already.  It may well be
that your third-party provider is top-notch and has its product in
tip-top performance shape.  But maybe not.

HTH, Dan

--- Anthony Hardy <mis@jdcc.edu> wrote:
> The changes in their software were needed changes that added many db
> transactions (needed unfortunately) to some of the specific programs
> being
> run.  We have the option of reversing that change (was built in when
> we
> received the update), but would rather keep the needed functionality
> and get
> our hardware up to speed.
>
> Thanks again for ALL your input:).
>
> Anthony

__________________________________________________
Do you Yahoo!?
Yahoo! Mail Plus - Powerful. Affordable. Sign up now.
http://mailplus.yahoo.com