If you journal *BEFORE and *AFTER images, then yes, you could in
theory roll back the delete using RMVJRNCHG.

However, it's not a command to take lightly. In addition, off the top
of my head, I'm not sure if it would work if you used CLRPFM instead
of for instance running an RPG program that deleted all the records
using RLA.

The second option, would be to restore the file, then APYJRNCHG to the
object up to the point at which the delete was issued. That's
probably a better way to recover.


On Thu, Aug 20, 2009 at 4:39 PM, Jerry Adams<Jerry@xxxxxxxxxxxxxxx> wrote:
  In 29 years of working with the i and its predecessors I have done an
  unplanned full restore once and lost a handfull of transactions (< 5).

My boss told me that, before I came to work here, he accidentally cleared our order details file.  (How one can do that accidentally is a mystery to me, but I digress.)

Everyone in the office spent the rest of the day re-entering the orders from printed picking tickets.

As I said before, I am not a journaling expert (or even novice), but wouldn't journaling be of no benefit in such situations?  I.e., it seems to me that the journal would simply said something along the lines of "Order 123 deleted" ad nauseum.  Applying the journals would result in nothing being recovered.  Or is there a rollback option, such as "Roll the Order Details back to its state at Noon."?

Jerry C. Adams
IBM System i Programmer/Analyst
B&W Wholesale
office: 615-995-7024
email:  jerry@xxxxxxxxxxxxxxx

This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.

This thread ...


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

This mailing list archive is Copyright 1997-2019 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].