Using the QVPN journal

To view the entry-specific details in the VPN journal, you can display the entries on the screen or you can use the output file.

By copying the journal entries to the output file, you can easily view the entries by using query utilities such as Query/400 or SQL. You can also write your own HLL programs to process the entries in the output files. The following is an example of the Display Journal (DSPJRN) command:
DSPJRN JRN(QVPN) JRNCDE((M)) ENTTYP((TS)) OUTPUT(*OUTFILE) OUTFILFMT(*TYPE4)
    OUTFILE(mylib/myfile) ENTDTALEN(*VARLEN *CALC)

Use the following steps to copy the VPN journal entries to the output file:

.
  1. Create a copy of the system-supplied output file QSYS/QATOVSOF into a user library. You can do this by using the Create Duplicate Object (CRTDUPOBJ) command. The following is an example of the CRTDUPOBJ command: 
    CRTDUPOBJ OBJ(QATOVSOF) FROMLIB(QSYS) OBJTYPE(*FILE) TOLIB(mylib)
     NEWOBJ(myfile)
  2. Use the Display Journal (DSPJRN) command to copy the entries from the QUSRSYS/QVPN journal to the output file created in the previous step. If you attempt to copy the DSPJRN into an output file that does not exist, the system creates a file for you, but this file does not contain the correct field descriptions.