How to list Journaled files to an Outfile

30 pts.
Tags:
AS/400 journaling
Outfile
Physical File
Hi.  Is there an easy way to get a list that will provide information on which physical files are being journaled within a library?  For some reason, I can not find it, but thought it would be available through one of the DSPFD outfiles, but I haven't found it, nor have I been able to find it when I look at the journal commands. Perhaps I am overlooking the obvious (?)  We are going to do a data conversion to a library that affects most of the files and need to know which ones we should stop journaling on before recompiling (CHGPF) the physical files.  We need it to run dynamically, meaning it will need to execute the process to an outfile and pick up any 'new' physical files that may have journals active.  Thanks!

Software/Hardware used:
AS400

Answer Wiki

Thanks. We'll let you know when a new response is added.

Here are two options:

WRKJRNA JRN(xxxxxx) OUTPUT(*OUTFILE) DETAIL(*JRNFILE) OUTFILE(QTEMP/JRNPFS)

DSPFD FILE(ICULIB/*ALL) TYPE(*ATR) OUTPUT(*OUTFILE) FILEATR(*PF) OUTFI.LE(QTEMP/JRNPFS)

====================================================

(Just in case…) WRKJRNA has OUTPUT(*OUTFILE) beginning with V5R4

DSPFD TYPE(*ATR) has journal info beginning at buffer position 202. You can use DSPFFD over the *outfile and scroll down to see the related fields after that position.

Tom

Discuss This Question: 3  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • aceofdelts
    That DSPFD works for me. Thanks. FYI - the field name is PHJRNL (value Y or N) so sql ... select * from qtemp/jrnpfs where PHJRNL = 'Y' will display them. Mike L.
    1,950 pointsBadges:
    report
  • jamesm333
    Thank You Tom for your reply, I overlooked the previous answer. I really appreciate this useful advice. James
    30 pointsBadges:
    report
  • jamesm333
    Mike, yes - I believe this is exactly what I need. Thanks for that information.
    30 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following