How can I export iSeries journals to a PC and handle them there?
This is an interesting question and I don't know of a specific command for this but with a combination of DSPJRN and CPYTOIMPF, I think we can accomplish what you would like. Here is what I did to move the IFS and then I could FTP the stream file to a text document. You could also map a network drive to get it there.
1. DSPJRN JRN(SMOHR/SMOHRJRN) OUTPUT(*OUTFILE) OUTFILFMT(*TYPE4) OUTFILE(SMOHR/JRNOUT)
2. CPYTOIMPF FROMFILE(SMOHR/JRNOUT) TOSTMF('/smohr/jrnout') STMFCODPAG(*PCASCII) RCDDLM(*CRLF) DTAFMT(*FIXED)
The first step writes the journal entries out to a database outfile and the second puts that database outfile onto the IFS in a stream file with *PCASCII code page. From there you can FTP the file to a PC and read it or map a network drive to that IFS location and drag and drop. You should be able to read the file as a text file.
One problem you may encounter is that if you are looking for specific record update and insert delete records that involve packed data you will not be able to read the packed data. The record entries are combined into one character field and you would need a program to extract the packed data that is contained in the entry specific data. If this is a concern for you might want to read document 10955647 from the IBM iSeries Knowledgebase website on how to extract the entry specific data if it is needed but this process would be required on each file that is journaled as the record layout would be different.
MORE INFORMATION ON THIS TOPIC
The Best Web Links: Tips, tutorials and more.
Ask your systems management questions--or help out your peers by answering them--in our live discussion forums.
Read this Search400.com Featured Topic: Managing your iSeries.