× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



Bryan,
Not knowing the specifics of your AS/400 its hard to tell how long it would
take.
CLRPFM might work however it would leave you with no records. Do you have
SQL on your machine. At least you would have some selection criteria over
the
transaction date.



                                                                                
                                          
                    "Burns, Bryan"                                              
                                          
                    <burnsbm@Echoincorpo        To:     mapics-l@midrange.com   
                                          
                    rated.com>                  cc:                             
                                          
                    Sent by:                    Subject:     Questions on on 
purging IMHIST                               
                    mapics-l-admin@midra                                        
                                          
                    nge.com                                                     
                                          
                                                                                
                                          
                                                                                
                                          
                    08/10/01 11:55 AM                                           
                                          
                    Please respond to                                           
                                          
                    mapics-l                                                    
                                          
                                                                                
                                          
                                                                                
                                          




Hello All,

We are running XA5.5 and I need some help with IMHIST.  It has more than 8
million records and is due for a purge.  I have the following questions:

1)         The MAPICS documentation says to run a transaction history
report
before a purge, but with 8 million records, how long would that take and
how
much DASD would it use?  How necessary is this report?

2)         I have been told the purge will have to be done on a three day
weekend as it will take 50 hours or more.  Any tips on speeding the purge
up?

3)         If the purge is not finished when the work shift begins, I
assume
that IM transactions will be locked out.  What other parts of MAPICS would
be locked?  This is not a dedicated mode task from what I can see.

4)         The IMHIST file has a member IMHNEW with 1.3 million records.
The
MAPICS web site has indicated  that IHNEW is built on the fly for
Transaction History reports.  A DSPFD indicates IMHNEW was last changed on
7/11/01.  We think that it got created but not cleared on that date when we
abended a transaction history report that had no limits.  Can we just do a
clear it with a CLRPFM?

Thanks for any help.

           Bryan Burns
           AS/400 System Operator
           ECHO  Incorporated
           847-540-8400  ext. 493
<Burnsbm@echoincorporated.com <mailto:Burnsbm@echoincorporated.com> >

_______________________________________________
Mapics-L mailing list
Mapics-L@midrange.com
http://lists.midrange.com/cgi-bin/listinfo/mapics-l






As an Amazon Associate we earn from qualifying purchases.

This thread ...


Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.