Re: INV921B

INV900 is part of our end-month series of steps in BPCS 405 CD

Among other things it gets rid of ITH records that are older than some thresh 
holds we have set in SYS800 system parameters ... currently we keep 365 days 
& oldest 3 records ... oldest 3 means that from one physical to the next, if 
the only history is the last physical then this stuff has had no activity.

You might check the archives for threads on what people do in end-year, 
end-month, weekly reorg etc. to make sure that INV900 is not the only thing 
missing from your collection.

Our largest files (over a million records each) are ITH & CMF
There is a systemic problem with BPCS being designed to add business, add 
records, but does not do that great of a job of helping us identify what 
needs to go away & help us with the removal.  We are a make-to-order 
engineer-to-order job shop which means a high level of turn-over of customer 
designs, so a good chunk of what is in our ITH & CMF is for things we will 
never ever make again.

>  From:    nbarraco@theamericanteam.com (Nick Barraco)
>  
>  HI Folks -
>  We're running 6.004 Full-client, and INV921B runs for 3-5 hours... we're 
not 
> running THAT many transactions!!!!  What are some of the things that people 
> have done to improve performance of the INV921B program?  Can you go 
through 
> and delete old records out of ITH?  If so, how have you done it? 
>  
>  Don't find fault, find a remedy. 
>  -Henry Ford 

MacWheel99@aol.com (Alister Wm Macintyre) (Al Mac)
AS/400 Data Manager & Programmer for BPCS 405 CD Rel-02 mixed mode (twinax 
interactive & batch) @ http://www.cen-elec.com Central Industries of 
Indiana--->Quality manufacturer of wire harnesses and electrical 
sub-assemblies - fax # 812-424-6838

+---
| This is the BPCS Users Mailing List!
| To submit a new message, send your mail to BPCS-L@midrange.com.
| To subscribe to this list send email to BPCS-L-SUB@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
+---