RE: BOM900

Hi Ho Rick

        A couple of things.

        1. Backup your MBI file. Delete all records accept for those for the
past two years (you can make it one year if you want). This is only an event
log file.

        2. Run this SQL statement for MBM
        DELETE FROM BPCSXXXF/MBM WHERE BPROD NOT IN (SELECT IPROD FROM
BPCSXXXF/IIM). If the item is not in your item master there should not be a
BOM for it. 
                XXX being the name of your data file library.

        3. Run this SQL statement for MPN
        DELETE FROM BPCSXXXF/MPN WHERE PNPROD NOT IN (SELECT IPROD FROM
BPCSXXXF/IIM). If the item is not in your item master there should not be a
Item Process Note record. 

        I hope it helps. Good luck

        Marc Lacelle
        Royal Canadian Mint
> ----------
> From:         RickCarter@holley.com[SMTP:RickCarter@holley.com]
> Reply To:     BPCS-L@midrange.com
> Sent:         Sunday, December 05, 1999 8:35 PM
> To:   BPCS-L@midrange.com
> Subject:      BOM900
> 
> 
> AS400  E620  Mixmode BPCS ver 6.1         
> 
> We just converted a few weeks ago from Ver 6.02 to version 6.1 and with
> the help of Nexgen, our implementation partner, the conversion went very
> well. 
> We have had a few quirky things going on with some of the jobs and BOM900
> is one of them.  We have not had a successful run since being on ver 6.1
> mainly due to the time its taking for the job to run.  As we write this
> email, the job has been running for 25 hours and appears to be through
> only about 2/3rds of the MBM file.  On our previous version, this job was
> taking around 2-4 hours to run.  DBMON has not shown any logicals to
> rebuild but if anyone has any to suggest we'll try them.  SSA doesn't
> appear to have any BMRS for this so we're sort of out of options.  Not
> many weekends have 30-40 hours for a job to run.   thanks  
> 
+---
| 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
+---