OpenTP1 Version 7 Operation

[Contents][Index][Back][Next]

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 type Specification Description Remarks
PJ p Transaction commit processing startup information Synchronous point journal
HJ h Transaction temporary synchronous point information
BJ b Transaction rollback information
TJ t Transaction synchronous point processing termination information
DJ d Heuristic decision information
FJ f DAM file update information Recovery journal
CJ c Update information for a table subject to recovery
XJ x System service-specific recovery information
SJ s System statistics Statistical journal
AJ a Send completion information
IJ I Messages cataloged into input queue
OJ o Messages cataloged into output queue
MJ m Message journal
GJ g Receive information
UJ u User-specific information User 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 ID Description Output destination
KFCA02600-E An error occurred while the unload journal file was being accessed. Standard error output
KFCA02601-E The unload journal file is invalid. Standard error output
KFCA02602-E The journal block is invalid. Standard error output
KFCA02603-E The journal record is invalid. Standard error output
KFCA02604-E Memory cannot be allocated. Standard error output
KFCA02620-W The target record does not exist. Standard error output
KFCA02630-I Help message Standard error output
KFCA02631-E A parameter in the jnlcopy command is invalid or its value exceeds the limit. Standard error output
KFCA02632-E The combination of options in the jnlcopy command is invalid. Standard error output
KFCA02633-E An option in the jnlcopy command is specified incorrectly. Standard error output
KFCA02634-E A 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