Fixed-length portion of the journal entry

This topic provides the layouts of the fixed-length portion of the journal entries.

When you use the Display Journal (DSPJRN) command, Receive Journal Entry (RCVJRNE) command, Retrieve Journal Entry (RTVJRNE) command, or the Retrieve Journal Entries (QjoRetrieveJournalEntries) API you can select one of the formats in which to receive the layout for the fixed-length portion of the journal entry:

• *TYPE1
• *TYPE2
• *TYPE3
• *TYPE4
• *TYPE5

*TYPE1 format

The *TYPE1 format shows the fields that are common for all journal entry types. These fields are shown when you request *TYPE1 for the output file format or the entry type format.

*TYPE2 format

If you request OUTFILFMT(*TYPE2) on the DSPJRN command, or ENTFMT(*TYPE2) on the RCVJRNE or RTVJRNE command, then the fixed-length portion of each converted journal entry is the same as the format in *TYPE1, except for the information that follows the commit cycle identifier field. The fields of the prefix that follow the commit cycle identifier are shown in *TYPE2 field descriptions.

TYPE3 field descriptions

A third value, *TYPE3, is supported on the OUTFILFMT parameter for the DSPJRN command, and the ENTFMT parameter for the RCVJRNE and RTVJRNE commands. If either OUTFILFMT(*TYPE3) is specified on the DSPJRN command or ENTFMT(*TYPE3) is specified on the RCVJRNE or RTVJRNE command, the information in the prefix portion of a converted journal entry is shown in *TYPE3 field descriptions. *TYPE3 has the same information as the *TYPE1 and *TYPE2 formats, except that it has a different date format and a null-values indicator.

*TYPE4 field descriptions

A fourth value, *TYPE4, is supported on the OUTFILFMT parameter for the DSPJRN command and the ENTFMT parameter for the RCVJRNE and RTVJRNE commands. If either OUTFILFMT(*TYPE4) is specified on the DSPJRN command or ENTFMT(*TYPE4) is specified on the RCVJRNE or RTVJRNE command, the information in the prefix portion of a converted journal entry is shown in Table 4. *TYPE4 output includes all of the *TYPE3 information, plus information about journal identifiers, triggers, and referential constraints and entries which will be ignored by the APYJRNCHG or RMVJRNCHG commands.

*TYPE5 field descriptions

The *TYPE5 format is only available with the DSPJRN and RTVJRNE commands. The *TYPE5 format is supported on the OUTFILFMT parameter for the DSPJRN command and ENTFMT parameter of the RTVJRNE command. If you specify OUTFILFMT(*TYPE5) on the DSPJRN command or ENTFMT(*TYPE5) on the RTVJRNE command, the information in the prefix portion of a converted journal entry is shown in Table 5. *TYPE5 output includes all of the *TYPE4 information, plus information about the following:

• System sequence number
• Thread identifier
• Remote address
• Address family
• Remote port
• Arm number
• Receiver name
• Receiver library name
• Receiver library ASP device name
• Program library name
• Program library ASP device name
• Program library ASP number
• Logical unit of work
• Transaction identifier
• Receiver library ASP number
• Object type
• File type
• Nested commit level

The RCVJRNE command also supports the *TYPEPTR and *JRNENTFMT formats. The layout of the journal entry data for the *TYPEPTR interface is the same as the RJNE0100 format which is described in the QjoRetrieveJournalEntries API.

The layout of the journal entry data for the *JRNENTFMT interface is the same as either the RJNE0100 format or the RJNE0200 format of the QjoRetrieveJournalEntries API. You can select which format to use by selecting the RJNE0100 or the RJNE0200 value for the Journal Entry Format (JRNENTFMT) parameter of the RCVJRNE command.

You can find the field descriptions for layouts *TYPE1, *TYPE2, *TYPE3, *TYPE4, and *TYPE5 in the Journal entry information finder.