Re: BPCS 6102 Performance

But that's because of the SQL in V6 BPCS which was not there in V4. And by
creating indexes (or logicals) for the SQL statements you can make a huge
(40%+) improvement in performance, not only response times but also CPU, so
you may not need to upgrade after all.

Clare

Clare Holtham
Director, Small Blue Ltd - Archiving for BPCS
Web: www.smallblue.co.uk
IBM Certified AS/400 Systems Professional
E-Mail: Clare.Holtham@btinternet.com
Mobile: +44 (0)7960 665958
----- Original Message -----
From: <Roger.Henady@thorco.com>
To: <bpcs-l@midrange.com>
Sent: Friday, December 20, 2002 4:30 PM
Subject: Re: BPCS 6102 Performance


> This is a multipart message in MIME format.
> --
> [ Picked text/plain from multipart/alternative ]
> We had the same experience.     They interactive part of the AS/400 is
> overloaded.     The system creates a job like to governor/ que the work
> load.    If you look at the WRKSYSSTS or WRKACTJOB the system CPU % is
> probably topped out.  (Governor job name is CFINT01)     The Job CPU's
> might not addup right but the interactive part is overloaded.     You may
> end up having to upgrade the interactive feature.
>
> Loading the sub files and displaying is the slowest part.
>
> We have a 720 with 120 interactive.   We tried running live for 2 days, it
> took minutes to pick, confirm orders, and bring up order maintenance. We
> made the business decision to return to BPCS 405CD.
>
> Wish you the best
>
> Roger Henady
> Thorco Industries
> (417) 682-1340
>
>
>
>
> "Moy, Bill" <bill.moy@appliance.invensys.com>
> Sent by: bpcs-l-admin@MIDRANGE.COM
> 12/19/2002 06:01 PM
> Please respond to bpcs-l
>
>
>         To:     bpcs-l@midrange.com
>         cc:
>         Subject:        BPCS 6102 Performance
>
>
> This message is in MIME format. Since your mail reader does not understand
> this format, some or all of this message may not be legible.
> --
> [ Picked text/plain from multipart/alternative ]
> Dear BPCS Expert,
>
> We just upgraded from BPCSv6.1 to BPCSv6102 (mix mode OS400 V4r5) and the
> performance is horrible. It is taking us minutes to bring up programs like
> PUR500, CST100, PUR640..etc.  Any suggestions to overcome this issue will
> be
> greatly appreciated.
>
> Regards
> Bill Moy
> _______________________________________________
> This is the SSA's BPCS ERP System (BPCS-L) mailing list
> To post a message email: BPCS-L@midrange.com
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/cgi-bin/listinfo/bpcs-l
> or email: BPCS-L-request@midrange.com
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/bpcs-l.
>
>
> --
>
>
>
> _______________________________________________
> This is the SSA's BPCS ERP System (BPCS-L) mailing list
> To post a message email: BPCS-L@midrange.com
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/cgi-bin/listinfo/bpcs-l
> or email: BPCS-L-request@midrange.com
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/bpcs-l.
>
>