Re: dcServ - BPCS Month end Close

["Robert Schmuhl" <BSchmuhl@xxxxxxxxxxxxxxxx>]

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