Clearing the Joural Entries attached for a receiver
Ex: Run DSPJRN JRN01, and you can see the list of entries of changes.
Can someone explain me, how to clear the above list without deleting receiver?
Software/Hardware used:
Iseries
Software/Hardware used:
Iseries
ASKED:
February 12, 2010 11:10 AM
UPDATED:
April 30, 2010 1:15 PM
RELATED QUESTIONS
Answer Wiki:
typically you would
change the jrn to the next receiver
back-up the receiver
delete the receiver
Phil
=====================================================
<i>...how to clear the above list without deleting receiver?</i>
For that question, the answer is "You can't."
That is, high-level programming can not access journal entries to clear or delete them. That's why journals can be far superior to files for audit logs.
But note that this doesn't appear to be the correct question. Your later comment was "Actually I tried using RMVJRNCHG, but its now worked for me." Perhaps you meant to say "...its <b>not</b> worked for me."
Please clarify what you need to know.
Removing journaled changes <i>is not</i> the same as clearing entries from a receiver.
Tom
To see all answers submitted to the Answer Wiki: View Answer History.
Is it possible to use the same receiver by clearing the records and with out deleting it?
Actually I tried using RMVJRNCHG, but its now worked for me.
I don’t understand your last message.
RMVJRNCHG is used to back out changes to the data files that are journalled
This doesn’t sound like what you were trying to do.
Phil
The Remove Journaled Changes (RMVJRNCHG) command used to remove the changes
done on Journaled Object. It is not used to clearing the Entries…!
Pls confirm whether i am correct or not…?
Removing Journal changes RMVJRNCHG will back out transactions on the actual file and will just add additional records into the journal receiver saying that it did remove the journal changes previously added to the journal receiver. Nothing is ever deleted from the journal receiver. That is the power behind why this is still the greatest machine on the planet.
Be very carefull in using this command over your production files in a fully integrated system or you will get the data out of sync if you do not get all the records in all the files backed out in the same job that wrote them in the first place.
Lovemyi
Be very carefull in using this command over your production files in a fully integrated system or you will get the data out of sync if you do not get all the records in all the files backed out in the same job that wrote them in the first place.
In some ways, that would seem to be a problem with an application rather than with using the command. If the tables have proper constraints (e.g., cascading DELETEs, etc.,) and transactions are processed under commitment control, it should be more difficult to use the command wrongly.
Tom
Is it possible to use the same receiver by clearing the records and with out deleting it?
No.
Tom
Once again, You sould
change the jrn to the next receiver
back-up the receiver
delete the receiver
Keep the backup so you can use the receiver in investigations/data corrections.
Phil
You can regenerate a new receiver (example: CHGJRN JRN(QUSRDIRDB/QSQJRN) JRNRCV(*GEN). Dave and delete the old one(s).