MIDRANGE dot COM Mailing List Archive



Home » MAPICS-L » November 2006

Re: Archive Hell



fixed

Just a 9406-520. 
The job itself has been known to hang with a Y2U0009 message -  "Change or 
delete operation could not find requested record".  That's always fun.
I'm lucky enough to be able to whack a year's worth of IMHIST without archiving 
too.  I'll probably delete 10 million records this year which is another 12 
hour job at least.
Bryan

-----Original Message-----
From: mapics-l-bounces@xxxxxxxxxxxx
[mailto:mapics-l-bounces@xxxxxxxxxxxx]On Behalf Of Greg Wenzloff
Sent: Wednesday, November 22, 2006 9:34 AM
To: MAPICS ERP System Discussion
Subject: Re: [MAPICS-L] Archive Hell


Bryan,

I'm impressed! You must have an awesome AS400/i series/system I.
Yes must do the save part to comply with SEC record retention rules.

Greg  

-----Original Message-----
From: mapics-l-bounces@xxxxxxxxxxxx
[mailto:mapics-l-bounces@xxxxxxxxxxxx] On Behalf Of Burns, Bryan
Sent: Wednesday, November 22, 2006 9:47 AM
To: MAPICS ERP System Discussion
Subject: Re: [MAPICS-L] Archive Hell

Greg,

Is it imperative that you archive?  I'm lucky enough to be able to run
just the deletion process so it takes out the tape issues.  Granted,
it's still mind blowingly slow process. About 12 hours for 500,000
orders.  I do it once a year.

Bryan
ECHO, Inc. 







Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2014 by MIDRANGE dot 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 here. If you have questions about this, please contact