RE: dcServ - BPCS Month end Close

["Staunton,Wade" <WStaunton@xxxxxxxxx>]

We, too remove the triggers before month end as well as end all dcPassageway
subsystems. After the month end is closed we do the normal "reorgs" in BPCS.
Then we put the triggers back on and do an initial download of all triggered
files. With dcBridge in place this is a relatively quick upload of the
files. It seems to work very well for us.
Hope this helps -
Wade

 -----Original Message-----
From:   Mike Fleming [mailto:Mike_Fleming@norwalk-furniture.com] 
Sent:   Thursday, October 07, 1999 8:28 AM
To:     BPCS-L@midrange.com
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
+---