ITH Size
"Milt Habeck" <[email protected]>
| Newsgroups | gmane.comp.systems.as400.bpcs |
|---|---|
| Message-ID | <[email protected]> |
<vendor> Hi Billy ... Our Locksmith archiving software for BPCS/ERP LX is a bulls-eye for your requirements: http://www.unbeatenpath.com/software/locksmith/archiving.pdf The archived data is moved to a different user-invented library and stored there with the precise file layout of the production file(s). So, if you create a library list with the user-invented library and run BPCS/ERP LX using that library list, then BPCS uses the data as if it never left the production environment. Slick. Custom queries continue to work with that same library list device. The archiving is very configurable; you can archive slices of data by business process by time period and point the results at different user-invented libraries as you see fit. Locksmith also archives and then reorganizes the key master files .... which is handy if you run out of vendor numbers, for example. Key final advice: don't purge anything. Get the old stuff into a library and save it to tape and then purge the library. But, don't just purge it. We've had calls over the years from some places that have purged data from x files for order processing, for example, and find out later that they have created a mess because of orphans left behind in obscure ORD-related files. Locksmith arrives with 100% of the files for each business flow already identified so you never create orphans with Locksmith. Peace to you and God bless, Milt Managing Partner Unbeaten Path International [email protected] (888) 874-8008 (+USA) 262-681-3151 </vendor> -----Original Message----- From: BPCS-L [mailto:bpcs-l-bounces-Zwy7GipZuJhWk0Htik3J/[email protected]] On Behalf Of Billy Waters Sent: Monday, February 22, 2016 6:44 AM To: bpcs-l-Zwy7GipZuJhWk0Htik3J/[email protected] Subject: [BPCS-L] ITH Size Currently ITH 9 million records. Considering a process change that could greatly increase the daily ITH record created. Boss is concerned about the size of ITH and performance considerations. If you can please respond with your ITH size and any other information you feel would be of use. We cannot purge ITH at month end due to an internal reporting process. We are working on another new process that will allow purging of ITH at month end. -- This is the BPCS ERP System (BPCS-L) mailing list To post a message email: BPCS-L-Zwy7GipZuJhWk0Htik3J/[email protected] To subscribe, unsubscribe, or change list options, visit: http://lists.midrange.com/mailman/listinfo/bpcs-l or email: BPCS-L-request-Zwy7GipZuJhWk0Htik3J/[email protected] Before posting, please take a moment to review the archives at http://archive.midrange.com/bpcs-l. -- This is the BPCS ERP System (BPCS-L) mailing list To post a message email: BPCS-L-Zwy7GipZuJhWk0Htik3J/[email protected] To subscribe, unsubscribe, or change list options, visit: http://lists.midrange.com/mailman/listinfo/bpcs-l or email: BPCS-L-request-Zwy7GipZuJhWk0Htik3J/[email protected] Before posting, please take a moment to review the archives at http://archive.midrange.com/bpcs-l.