Re: Slow SFC400 run

["Ren Fu Ping" <fupingren@xxxxxxxx>]

Dear Krzysztof,
     Too many record can slow any programm running. as far your case, please 
run the month end close (INV903) first, and zeros balance inventory id in 
ILI,ILN will convert to 'IZ' 'LZ', then run INV970, INV973,INV972 by sequence, 
many inactive ILI and ILN records will automatic delete.

Regards!
Ping


----- Original Message -----
From: "Krzysztof Dziubinski" <kdziub@idom.com.pl>
To: <BPCS-L@midrange.com>
Sent: Friday, April 19, 2002 6:29 PM
Subject: Slow SFC400 run


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.