jnlcopy (Copy unload journal files)

Format

jnlcopy [-t[begin][,end][-j record-type[record-type...]]
       [-o journal-collection-mode [journal collection mode] ...]
       [[unload-journal-file-name][[Figure]unload-journal-file-name]...]

Function

The jnlcopy command outputs information from specified unload journal files to the standard output.

The jnlcopy command cannot be used under the multinode facility.

Options

-t [begin][,end]

Specifies the copy range in terms of the journal block output begin and end times.

In "begin", specify the copy start time. In "end", specify the copy 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 copy range is from the beginning of the unload journal file to the specified end time. When the end time is omitted, the copy 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 (00 [Figure] hh [Figure] 23); cannot be omitted
mm
Minute (00 [Figure] mm [Figure] 59); cannot be omitted
ss
Second (00 [Figure] ss [Figure] 59): cannot be omitted
MM
Month (01 [Figure] MM [Figure] 12); can be omitted#
DD
Day (01 [Figure] DD [Figure] 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 specific file is edited and output.

-j record-type

Specifies the type of journal records to be copied.

Multiple record types can be specified.

Following are the specification values for the record types:

Record typeSpecificationDescriptionRemarks
PJpTransaction commit processing startup informationSynchronous point journal
HJhTransaction temporary synchronous point information
BJbTransaction rollback information
TJtTransaction synchronous point processing termination information
DJdHeuristic decision information
FJfDAM file update informationRecovery journal
CJcUpdate information for a table subject to recovery
XJxSystem service-specific recovery information
SJsSystem statisticsStatistical journal
AJaSend completion information
IJIMessages cataloged into input queue
OJoMessages cataloged into output queue
MJmMessage journal
GJgReceive information
UJuUser-specific informationUser journal

If the -t option is specified and the -j option is omitted, all journal records in the specified range are copied. If the -t option is not specified but the -j option is specified, all unload journal files whose journal record types are the same as the specified record types will be copied.

If the -t and -j options are all omitted, all information is output from the unload journal files.

-o journal-collection-mode

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

c
Copies journals in transaction test mode whose attribute is commit, or journals in MCF nontransaction test mode.
r
Copies journals in transaction test mode whose attribute is rollback.
s
Copies journals in other than online test mode.

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

Command arguments

unload-journal-file-name~<path name>

Specifies the name of an unload journal file.

When more than one unload journal file is specified, a space must be placed between files. You can specify a maximum of 256 files.

When this command argument is omitted, the standard input is assumed.

Output messages

Message IDDescriptionOutput destination
KFCA02600-EAn error occurred while the unload journal file was being accessed.Standard error output
KFCA02601-EThe unload journal file is invalid.Standard error output
KFCA02602-EThe journal block is invalid.Standard error output
KFCA02603-EThe journal record is invalid.Standard error output
KFCA02604-EMemory cannot be allocated.Standard error output
KFCA02620-WThe target record does not exist.Standard error output
KFCA02630-IHelp messageStandard error output
KFCA02631-EA parameter in the jnlcopy command is invalid or its value exceeds the limit.Standard error output
KFCA02632-EThe combination of options in the jnlcopy command is invalid.Standard error output
KFCA02633-EAn option in the jnlcopy command is specified incorrectly.Standard error output
KFCA02634-EA file name in the jnlcopy command is specified incorrectly.Standard error output

Notes

Examples

In this example, the command outputs information from the beginning of the unload journal files up to 17:30:00.999999 on May 29, 1993:

Unload journal files: sysjnl001, sysjnl002

jnlcopy -t ,17300005291993 /OpenTP1/jnl/sysjnl001
                          /OpenTP1/jnl/sysjnl002