Re: ITH Size
"Molyneux, Tom" <[email protected]>
| Newsgroups | gmane.comp.systems.as400.bpcs |
|---|---|
| Message-ID | <[email protected]> |
Billy, We have an archiving routine. Each week, we copy ITH records over 2 years old to an archive file (ITH_ARCH) then remove them from ITH ITH currently has 2. 5 million records, ITH_ARCH has 12.3 million records Obviously it doesn't lessen the total disk taken up by ITH and ITH_ARCH records, but it speeds up BPCS processes like inquiries as they have less ITH records to scroll through. We then created an in-house ITH inquiry program which looks at both ITH and ITH_ARCH Tom Molyneux | Deputy MIS Manager NOV Completion & Production Solutions Greengate, Middleton, Manchester M24 1SA Direct +44 161 214 2142 Mobile 0783 443 2791 [email protected] | www.nov.com -----Original Message----- From: BPCS-L [mailto:bpcs-l-bounces-Zwy7GipZuJhWk0Htik3J/[email protected]] On Behalf Of Billy Waters Sent: 22 February 2016 12:44 To: bpcs-l-Zwy7GipZuJhWk0Htik3J/[email protected] Subject: [EXTERNAL] [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: https://urldefense.proofpoint.com/v2/url?u=http-3A__lists.midrange.com_mailman_listinfo_bpcs-2Dl&d=CwICAg&c=oTZJxWjXA97U5efbDJZGEg&r=iwlCIJOzH2dLA7sg-EkdbJ3IFfAoViMu6XNrO_4k9GM&m=SRXdY9RhkUuSCkdnrW5wWa_QL9CHeuhEbqlDQOGvrQU&s=d929F4Lo5fvKfzp65Jup1nWsYZYog4aNYHabuYi_pus&e= or email: BPCS-L-request-Zwy7GipZuJhWk0Htik3J/[email protected] Before posting, please take a moment to review the archives at https://urldefense.proofpoint.com/v2/url?u=http-3A__archive.midrange.com_bpcs-2Dl&d=CwICAg&c=oTZJxWjXA97U5efbDJZGEg&r=iwlCIJOzH2dLA7sg-EkdbJ3IFfAoViMu6XNrO_4k9GM&m=SRXdY9RhkUuSCkdnrW5wWa_QL9CHeuhEbqlDQOGvrQU&s=KnrscQVuhewV89z38tDeDCb0pOGXe0a8OmtDRt0vS_8&e= . -- 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.