Re: BPCS DATABASE ADMIN (was SFC650 slowwwwwwwwww)

[fkolmann@xxxxxxxxxxxxx]

When we went to 6.02 BPCS from PRMS I yelped like a puppy newly separated from
its mother.
My pathetic squeals were patiently tolerated and I was informed by this list as
to what to do. Thanks All.
Not having used SQL I did not understand how it functions and the need to
constantly monitor
the system for database performance.

The point is that BPCS IMO can no longer be shipped to users and left to tick
over.
BPCS and the fact it uses extensive SQL means you
MUST HAVE A DATABASE ADMINISTRATOR OR PERIODICALLY HIRE A
DATABASE ADMINISTRATOR TO  FIND DATABASE PERFORMANCE PROBLEMS.
In the end most problems are easily found via PRTSQLINF and simply fixed with an
SQL Create Index or equivalently with a DDS LGL FILE, but what do you do if you
have NO SQL ACCESS  nor a DDS compiler.

You can even store the CREATE INDEX commands in a source member and execute then
with a
RUNSQLSTM, but what do you do if you have no source editor.

BPCS is far removed from a 'Set it and Forget it' system,  but even on a S36 one
needed to constantly
monitor file sizes and placement on disk.


Washbean@aol.com wrote:

> There was a posting I saw on OGS about a PTF from IBM to help with this. But
> when I applied this PTF it did NOT fix the problem. I called the SSA help
> line and they gave me another PTF and that helped. I am sorry I dont remember
> the exact PTF number.
> Kevin W.   WCC, Inc.

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