Re: Slow SFC400 run

[Roger.Henady@xxxxxxxxxx]

Do you run INV900 at month end?


Roger Henady
Thorco Industries
(417) 682-1340



                    "Krzysztof
                    Dziubinski"            To:     <BPCS-L@midrange.com>
                    <kdziub@idom.co        cc:
                    m.pl>                  Subject:     Slow SFC400 run
                    Sent by:
                    bpcs-l-admin@MI
                    DRANGE.COM


                    04/19/2002
                    05:29 AM
                    Please respond
                    to bpcs-l






This is a multi-part message in MIME format.
--
[ Picked text/plain from multipart/alternative ]
Hello,

Our Batch Component Allocation program (SFC400) has slowed down recently. I
checked the call stack of the job running SFC400. The problem is within
SFC734B which is performing SQL FETCH commands intensively. I have no
sources of SFC734 and I can not identify the query. I suppose the reason is
our lot files ILI and ILN contain almost 500 000 records. Is is safe to
delete old inactive records from ILI (ILN) ?

Regards,

K. Dziubinski
--

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