Re: Questions on journals

<Kirk>
I have some really basic questions on using journals to recover from a bad
SQL based update to a file. The SQL was to update a single field and a
rather small number of records from what I was told, but updated several
hundred thousand before it was stopped. So the file was journaled with
Before and After images.

1st question I assume that what is journaled is the Entire Record not just
what was changed ( say 1 field ), correct?
</Kirk>
The complete Buffer, including the NullByte Map is stored to the journal Receiver, enriched by some journal related information.

<Kirk>
2nd Question Since the file was in active use and other jobs could have
updated other fields of the modified records after the bad SQL was run I
don't think we can just use RMVJRNCHG cmd to backup those SQL changes and
then run APYJRNCHG from the SEQ directly following the the bad changes. If
we use the APLYJRNCHG to a recorded we rolled back it will just put the bad
data back if my assumption in #1 is correct?
</Kirk>

In case of conflicting update operations, you would loose information, if you would try RMVJRNCHG or APYJRNCHG. (lots of nonsens in some answering postings, but RMVJRNCHG or APYJRNCHG seems not to be an option in your case)

<Kirk>
Last question for now, What happens if there are triggers on this file if
we were to use RMVJRNCHG cmd? How about APYJRNCMD?
</Kirk>

Triggers are not fired by APYJRNCHG or RMVJRNCHG.

In your scenario, I would recommend to extract the changes from the journal (there is a little tool ANZJRN at my (sorry german) Freeware section at www.bender-dv.de)amd in most cases SQL scripts might be sufficient to recover the data. Feel free to drop me a mail, if you would need additional hints.

D*B