First look at how much space they take and which are detached from the journal:
SELECT JOURNAL_LIBRARY, JOURNAL_NAME,
RECEIVER_LIBRARY, RECEIVER_NAME,
ATTACHED, SIZE / 1024 / 1024 AS MB, DETACH_TIMESTAMP
FROM QSYS2.JOURNAL_RECEIVER_INFO
WHERE ATTACHED = 'NO'
ORDER BY SIZE DESC
Only those already saved and no longer needed get deleted:
DLTJRNRCV JRNRCV(JRNLIB/RCV0000123) DLTOPT(*IGNINQMSG)
Warning
a journal receiver is what restores the changes made after the last save.
Deleting one that has not been saved means those changes are gone for good if a restore is
ever needed. Before deleting, check that the receiver has been saved: the save field in
DSPJRNRCVA tells you.
Tip
the structural fix is not periodic manual deletion but CHGJRN ... DLTRCV(*YES)
with automatic receiver management, which detaches and deletes them on its own after the
save. Deleting by hand is the symptom of a configuration that needs attention.
Releases. QSYS2.JOURNAL_RECEIVER_INFO is among the more recent IBM i Services: check by
running the query, and if it answers SQL0204 use WRKJRNA JRN(LIB/JRN) option 15, which
lists receivers with size and status. DSPJRNRCVA says whether a receiver has been saved, and
that is the check that matters before deleting anything.
Comments
No comments yet. Be the first to comment!
You need an account to comment. Log in · Sign up