Re: BPCS 6102 Performance

["Clare Holtham" <Clare.Holtham@xxxxxxxxxxxxxx>]

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