Re: Performance and Number of Databases

In a message dated 98-03-20 22:03:14 EST, Tom wrote:

> We have had several BPCS environments on a single AS/400 for over a year.
>  One environment is BPCS 5.1.1 and the other is BPCS 6.0.2plf.  You can have
>  several environments of the same version or different versions depending on
>  your purpose.

Which reminds me of something that I've been meaning to say since this thread
started, but I've been too busy (implementation is _CLOSE_, and I'm behind
again).  If you go with a single database and multiple facilities, make sure
MFS and/or DRP will meet your needs.  Also, be aware that the extensive use of
SQL in 6.0.02+ will bring _MAJOR_ performance considerations into the sizing
of your machine(s) (depending upon the size of the database, number of
transactions, amount of history kept, etc.).

IMO, the SSA sizing models are still not "up to snuff" for this release.
Either sign an agreement with SSA that they will pay for an upgrade if their
suggested sizing doesn't meet your specified performance characteristics, or
bump their processor suggestion a level and double the memory.  SMP on multi-
processor systems wouldn't be a bad idea, either...

JMHO,

Dean Asmussen
Enterprise Systems Consulting, Inc.
Fuquay-Varina, NC  USA
E-Mail:  DAsmussen@aol.com

"It's Deja Vu all over again..." -- Yogi Berra
+---
| This is the BPCS Users Mailing List!
| To submit a new message, send your mail to BPCS-L@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
+---