The jnlcolc command extracts journal records required for DAM file, TAM file or ISAM file recovery from specified unload journal files and then outputs them to the standard output. The integrated result can also be redirected and output to a file.

-k recovery-type

Specifies the type of file to be subject to recovery:

d: DAM file

t: TAM file

i: ISAM file

-f

Specifies that the journals required for file recovery are to be extracted from the first unload journal files. The command checks whether or not the journal file generation numbers are n ascending order beginning with 1. If not, processing terminates.

When this option is omitted, the command assumes that information is to be inherited from the previous journal record extraction processing and checks whether or not the inheritance file generation numbers are arranged in ascending order beginning with the last generation number + 1. If not, processing terminates.

-l

Specifies that the journals required for file recovery are to be extracted from the last unload journal files. The command then deletes the inheritance file.

If file recovery journals are integrated by specifying this option, the -f option must be specified when another online journal is integrated.

When this option is omitted, inheritance files are not deleted.

-n

Specifies that all FJ records are to be output, even if there is update information for the same logical file or the same relative block number in the transaction (information about FJ before and after update processing is not checked, and duplicate information is not deleted).

When this option is omitted and there is update information for the same logical file or the same relative block number in the transaction, only the final update information is output.

This option is applicable only when the recovery type indicates a DAM file.

-m

Integrates journal records on the file to be recovered. If this option is specified, it is assumed that the -n option has been specified. If the option is omitted, a buffer is allocated on memory for integration of journal records.

-i online-backup-information-name

Collects integration startup information of the file recovery journal from the specified file, and skips the records preceding the startup location. This option is applicable only when d or t (DAM or TAM file as the recovery type) is specified in the -k option. If the -i option is omitted, file recovery journals are integrated from the beginning of the file.

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

Specifies the last three characters of the inheritance file name. OpenTP1 creates an inheritance file under the name jnlcolc***, replacing *** with the value specified with this option.

file-name~<path name>

Specifies the name of the file containing journal records needed for file recovery. When the multinode facility is used, the name of the file whose journal records have been sorted and merged by the jnlsort command must be specified. If the multinode function is not used, the name of the unload journal file must be specified. When more than one 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.

• If the inheritance information file specified in the jnlcolc command already exists, the existing file is retained under the name jnlcolc***.bak.
• If multiple journal files are to be integrated, they must all have been output during the same online operation. If even one of them is different, processing terminates.
• The following types of journal records are output:
  

  For DAM file recovery:

  FJ: File (DAM) update information

  HJ: Transaction temporary synchronous point information

  PJ: Transaction commit processing startup information

  DJ: Heuristic decision information

  BJ: Transaction rollback information

  For TAM file recovery:

  CJ: Update information for a table subject to recovery

  HJ: Transaction temporary synchronous point information

  PJ: Transaction commit processing startup information

  DJ: Heuristic decision information

  BJ: Transaction rollback information

  For ISAM file recovery:

  FJ: File (ISAM) update information

  HJ: Transaction temporary synchronous point information

  PJ: Transaction commit processing startup information

  DJ: Heuristic decision information

  BJ: Transaction rollback information

• If journal records are to be integrated from multiple unload journal files by executing the jnlcolc command more than once, the same values must be specified for the -k, -n, and -c options in all the jnlcolc commands.
• If no unload journal file name or global archive journal file name is specified, the standard input is assumed, and the input file must be specified by piping, redirecting, etc.
• If a memory allocation error occurs, the jnlcolc command with its -m option specified must be entered again. No fast processing speed can be expected because journal records are integrated on a file. When the file name is omitted, the -m option must not be specified.
• The jnlcolc command is used with a file (DAM, TAM or ISAM) recovery command and the jnlsort command to recover files. For the ISAM file recovery command, see the manual Indexed Sequential Access Method ISAM.
• If you integrate multiple journal files into one file, specify the file names in the chronological order from the earliest acquired file. If file names are not chronologically specified, the system outputs the error message KFCA02601-E and terminates processing due to an invalid journal file.
• Do not specify an unload journal file 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.

In the examples below, the generation numbers are 1,2,...

Unload journal files: sysjnl001, sysjnl002,...

(1) Integrate journal records for DAM FRC from an unload journal file that has not been split

jnlcolc -k d -f -l /OpenTP1/jnl/sysjnl001

(2) Integrate journal records for TAM FRC in one step from an unload journal file that has been split into three files

jnlcolc -k t -f -l /OpenTP1/jnl/sysjnl001
             /OpenTP1/jnl/sysjnl002
             /OpenTP1/jnl/sysjnl003

(3) Integrate journal records for DAM FRC in three steps from an unload journal file that has been split into four files

Step 1:
jnlcolc -k d -f /OpenTP1/jnl/sysjnl001 /OpenTP1/jnl/sysjnl002
Step 2:
jnlcolc -k d /OpenTP1/jnl/sysjnl003
Step 3:
jnlcolc -k d -l /OpenTP1/jnl/sysjnl004