The jnlrput command outputs to the standard output user journal record information within the specified unload journal file or global archive unload journal file, CPU usage time information for a transaction branch, and statistics about response.

-t [start-time][,end-time]

Specifies the output range of uptime statistics in terms of journal output begin and end times.

In "begin", specify the output start time. In "end", specify the output end time.

For begin, specify a time between 00:00:00 on January 1, 1970 and the current year, month, day, and time.

The start time and end time cannot both be omitted. When the start time is omitted, the output range is from the beginning of the unload journal file to the specified end time. When the end time is omitted, the output range is from the specified start time to the end of the unload journal file.

The begin and end times are expressed in the format hhmmss[MMDD[YYYY]]:

hh: Hour (01 hh 23); cannot be omitted

mm: Minute (00 mm 59); cannot be omitted

ss: Second (00 ss 59); cannot be omitted

MM: Month (01 MM 12); can be omitted^#

DD: Day (01 DD 31); can be omitted^#

YYYY: Year (4-digit year from 1970); can be omitted^#

#: If the year is omitted from the begin or end time, the specified month, day, and time of the current year are assumed. If the year, month, and day are omitted, the current year, month, and day, and the specified time are assumed. You cannot omit only the month and day, or the month or the day. Doing so causes an option error. If you want to omit the month or the day, then omit the year, the month, and the day (all three).

If the -t option is omitted, all information in the specified file is output.

-e

Outputs only commit-determined user journal records (UJ).

When this option is not specified, all user journal records (UJ) are output.

-f

Outputs commit-determined user journal records from the first file. Also, checks whether the journal file's block numbers are sequential ones in ascending order, beginning with 1. If an error is found, processing terminates.

The -f option is valid only when the -e option is specified.

If this option is not specified, system assumes inheritance from the previous record output process, checking whether the block numbers are sequential ones in ascending order, beginning with the last block number + 1. If an error is found, processing terminates.

-l

Outputs commit-determined user journal records from the last file. Then the inheritance file is deleted.

The -l option is valid only when the -e option is specified.

If this option is not specified, system assumes inheritance to the next record output process, creating an inheritance file.

-c key~((001-999))<<001>>

Specifies part of the name of an inheritance file. Actually, OpenTP1 creates a file named jnlrput*** (*** = the value specified in this option), which in turn becomes the name of the inheritance file.

-u transaction-global-identifier [,transaction-branch-identifier~<33 alphanumeric characters, special characters, and hexadecimal digits>

Specifies the contents to be edited by specifying the transaction identifier. The transaction identifier must be in "transaction-global-identifier, transaction-branch-identifier." If this option is omitted, all transaction IDs are subject to editing.

-o journal-collection-mode

Specifies a journal collection mode. Multiple modes can be specified.

c

Outputs journals in transaction test mode whose attribute is commit or in MCF nontransaction test mode.

r

Outputs journals in transaction test mode whose attribute is rollback.

s

Outputs journals in other than online test mode.

If this option is omitted, journals in all journal collection modes are output.

-j~<<u>>

Specifies the record type that identifies the contents to be output. Following are the values to be specified as record type and the contents to be output.

#: With _trn specified in the -q option, the information about the CPU usage time by a transaction branch is output. With _rpc specified in the -q option, the response statistics are output.

-q _trn

Outputs the information about the CPU usage time by a transaction branch within the specified file.

Specification of this option is valid only with "s" (system statistics) specified in the -j option.

-q _rpc

Outputs the response statistics within the specified file.

Specification of this option is valid only with "s" (system statistics) is specified in the -j option.

-d user's-extraction-conditions

Specifies the conditions of extracting the user journal records (UJ). When this option is specified, the journal records are compared to the comparison data and the journal records that satisfy the conditions specified with comparison symbols. The number of characters in the specified extraction conditions must not exceed 255.

The following shows the description format of extraction conditions:

comparison-position,[comparison-symbol],[comparison-format],comparison-data
                  [,comparison-position,[comparison-symbol],[comparison-
                  format],comparison-data]

Up to two extraction conditions can be specified.

When more than one extraction condition is specified, the journal records that satisfy all the conditions are extracted.

comparison-position~<hexadecimal>((0 to 7faf8))

Specifies the position of the comparison data to be compared to the user journal records. Specify the position from the beginning of the UAP journal. For UJ code, specify "CODE".

comparison-symbol~<<eq>>

Specifies a comparison symbol as the comparison condition for the data to be compared to the user journal records.

eq

The contents of UJ are equal to the comparison data. (contents of UJ = comparison data)

ne

The contents of UJ are not equal to the comparison data. (contents of UJ comparison data)

gt

The contents of UJ are greater than the comparison data. (contents of UJ > comparison data)

ge

The contents of UJ are greater than or equal to the comparison data. (contents of UJ comparison data)

lt

The contents of UJ are less than the comparison data. (contents of UJ < comparison data)

le

The contents of UJ are less than or equal to the comparison data. (contents of UJ comparison data)

comparison-format~<<x>>

Specifies the format of the data to be compared. The user journal records are compared to the comparison data, based on the format specified by the comparison format.

x: Hexadecimal format

c: Character format

comparison-data

Specifies the data to be compared. When specifying the comparison data in hexadecimal format, specify the data with 0 to 9 and a to f (or A to F) in even number of digits.

When specifying the UJ code, use a 2-, 4-, 6-, or 8-digit hexadecimal number.

A comma (,), space, and metacharacters of the shell cannot be specified.

-x

Outputs only the user journal records (UJ) that are out of the scope transaction.

If you omit the -x option, all the user journal records (UJ) are output.

file-name~<path name>

Specifies the name of an unload journal file or global archive unload journal file. If the multinode facility is used, the name of the file sorted and merged by the jnlsort command must be specified.

The -e option allows more than one file to be specified. When more than one is specified, a space must be placed between files. You can specify a maximum of 256 files.

If this command argument is omitted, standard input is assumed.

The following shows the possible combinations of command arguments and options that can be specified:

(1) Output format of all the journal records when UJ is output

1. The size of the file management information is 128 bytes.
2. The size of the record information is stored in the "record information size" in the record management information (3.).
3. The size of the record management information is stored in the "record management information size" in the file management information (1.).
4. The size of the record data header is stored in the "record data header size" in the file management information (1.).
5. The size of the UJ record data is as follows:
   [Size of UJ record data] = [Size of record information] - [Size of record management information + Size of UJ record data header]
   

(2) Detailed output format of each information item

Note

When the transaction ID existence flag is 0x00, 0x00 is set for the global_tran_id[12] entry and the branch_tran_id[12] entry.

1.

Displays file management information (the status and contents of output results as a whole).

2., 3., 4., 5., 6., 7., 8., 9., 10., 11., and 12.

Indicates Record information.

2.

Displays record management information (the status and contents of applicable record information as a whole)

3., 4., 5., 6., 7., 8., 9., 10., 11., and 12.

Displays record data (the record data header indicating fixed record data, and record data indicating floating record data). For transaction branch CPU usage time information and aj record, only record data headers indicating fixed record data are displayed.

For response statistics, record data headers and second record data headers indicating fixed record data are displayed.

The output format of 1. to 12., is defined by dcjup.h.

• If the output range is specified and no journal record corresponds to the specified begin or end time, the journal records between the begin and end positions are to be output.
• If the output range is specified in terms of time and the start time value is greater than the end time value, the month and day or the month, day, and year must be specified so that the end time is after the start time. If the requisite information is omitted, an error occurs. If the date is omitted, the date the jnlmcst command is entered is assumed; therefore, if the output range does not fit within the current day, either the month and day or the month, day, and year must be specified.
• If no file name is specified, the standard input is assumed. Therefore, the input file must be specified by piping, redirecting, etc.
• When the inheritance file specified in the -e option already exists, the file remains under the name jnlrput***.bak.
• When the jnlrput command with its -e option specified is executed several times to output commit-determined user journal records (UJ) from more than one unloaded-journals file, the same value must be specified in the -c option of each jnlrput command.
• When the -e option is specified to extract records from more than one unloaded-journals file or global archive unloaded-journals file, all of the journal files must be those which were output during the same online operation.
• If a timeout error occurs during the RPC, -1 is set for the response time (res_min_data and res_miq_data) in the response statistics second record header while other information items are set to 0.
• When the -e option is specified, do not specify the unload journal file that is acquired by specifying the -t option in the jnlunlfg command. If you do so, message KFCA02601-E is output.
• The number of characters you can enter in this command is determined by your OS. If the number of entered characters exceeds the upper limit, an error occurs.
• An error occurs when the number of opened files exceeds the maximum number of files that can be opened for one process, including when the specified number of files is less than 256.
• The last four bytes of the "transaction global identifier" and "transaction branch identifier" regions (unsigned DCLONG type numerals) of the record management information differ from the last four bytes of the global transaction IDs that appear in messages and other forms of system output.

1. Output CPU usage time information from an unloaded-journals file.
   

   jnlrput -j s -q_trn/tpl/jnl/sysjnl001

2. Output commit-determined user journal records (UJ) from an unloaded-journals file consisting of three files, in one step.
   

   jnlrput -e -f -l /tpl/jnl/sysjnl001 /tpl/jnl/sysjnl002 /tpl/jnl/sysjnl003

3. Output commit-determined user journal records (UJ) from an unloaded-journals file consisting of four files, in three steps.
   

   <First> jnlrput -e -f /tpl/jnl/sysjnl001 /tpl/jnl/sysjnl002 <Second> jnlrput -e /tpl/jnl/sysjnl003 <Third> jnlrput -e -l /tpl/jnl/sysjnl004

4. Output system statistics (SJ), which are in an unload journal file, from 00:00:00.0 on January 1, 2003 up to 23:59:59.999999 on December 31, 2003:
   Unload journal file: sysjnl001
   

   jnlrput -t 00000001012003,23595912312003 -j s /tp1/jnl/sysjnl001