RE: dcServ - BPCS Month end Close

        It should take you less time to reload the DCSerV files than 7
hours, and the alternative of turning off triggers is better. You may also
be able to get SSASE to give you a faster way to reload their server files
than the one they gave you initially. They showed us an alternate method
recently.

        Dick Bailey

        -----Original Message-----
        From:   Robert Schmuhl [SMTP:BSchmuhl@worldnet.att.net]
        Sent:   Thursday, October 07, 1999 12:34 PM
        To:     BPCS-L@midrange.com
        Subject:        Re: dcServ - BPCS Month end Close

        We remove our triggers before month end. We are on BPCS 4.05CD and
it saves
        us quite a bit of time. If all you are doing is the inventory roll,
it
        shouldn't have any affect on you because all you are doing is moving
your
        inventory from one bucket to another (Receipts/Adjustments/Issues to
        Openning balance). Files such as FSO where you may be purging
records, you
        will have to make a decision as to whether it is more efficient to
remove
        the triggers and then re-initialize the file after month end or to
leave the
        triggers in place.
        -----Original Message-----
        From: Mike Fleming <Mike_Fleming@norwalk-furniture.com>
        To: BPCS-L@midrange.com <BPCS-L@midrange.com>
        Date: Thursday, October 07, 1999 10:05 AM
        Subject: dcServ - BPCS Month end Close


        >BPCS 6.0.2,  510-AS400 V4R3
        >
        >I'm run dcPassageway 2.3.1 with the July PTF, I'm using
        >dcBridge as the export. The question, I'm looking for
        >opinions regarding removing BPCS database triggers before
        >and adding them back after the month end close to avoid all
        >the trigger firing and the increase in time for the close.
        >It took about 7hrs. for the SQL database on the engine to
        >get all the records, when I've left the triggers on.
        >A few current file sizes to consider
        >IIM 26,000 records
        >ILI  150,000
        >YCI 30,000
        >FSO 3,000 new shop orders daily
        >
        >+---
        >| 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
        >+---

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