RE: ITH record purging

["Steve Segerstrom" <SSegerstrom@xxxxxxxxxxxxxx>]

We keep about 6 million transactions on ITH or about 6 months worth.

We run the sys program and have our aging days set to 180. 

-----Original Message-----
From: rfolsom@xxxxxxxx [mailto:rfolsom@xxxxxxxx]
Sent: Monday, June 30, 2003 8:52 AM
To: SSA's BPCS ERP System
Subject: Re: ITH record purging



I agree with Rob.  Use SYS Menu Option 5, modify Transaction History System
Parameters, Inventory Transactions to 730 days, then run month end to purge
your transactions and resequence the ITH records.  If you're uneasy about
it, use the YTH file for backup.
Rick Folsom
Yupo Corporation America
757-819-9230



                                                                                
               
                    ERP/BPCS                                                    
               
                    <bpcsusergroup0@x       To:     bpcs-l@xxxxxxxxxxxx         
               
                    ahoo.com>               cc:                                 
               
                    Sent by:                Subject:     ITH record purging     
               
                    bpcs-l-bounces@xx                                           
               
                    drange.com                                                  
               
                                                                                
               
                                                                                
               
                    06/30/03 09:18 AM                                           
               
                    Please respond to                                           
               
                    "SSA's BPCS ERP                                             
               
                    System"                                                     
               
                                                                                
               
                                                                                
               




Hello All,

We are on BPCS V 6.1.01 (mixed Mode), AS/400.

Our ITH file is populated with the data of more than 5
years. We want to keep only 2 years data in ITH.

If i simply delete all ITH records with date more than
2 years old, will there be any problem for any program
because transaction sequence# from 1 will be deleted.
?? Or any problem in the data ??

Or Please suggest any better other way to clean ITH
file.

Thanks for your help.....

Jim








__________________________________
Do you Yahoo!?
SBC Yahoo! DSL - Now only $29.95 per month!
http://sbc.yahoo.com
_______________________________________________
This is the SSA's BPCS ERP System (BPCS-L) mailing list
To post a message email: BPCS-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/bpcs-l
or email: BPCS-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/bpcs-l.





_______________________________________________
This is the SSA's BPCS ERP System (BPCS-L) mailing list
To post a message email: BPCS-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/bpcs-l
or email: BPCS-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/bpcs-l.