15. Performing Backup and Recovery : Checkpoint Template File Description : Substitution Parameters in the Checkpoint Template File
 
Share this page                  
Substitution Parameters in the Checkpoint Template File
The checkpoint template file can optionally include substitution parameters that can be filled in at run time, to specify things like:
Which database directory to back up
Which tape device the user specified in the Checkpoint dialog
The parameters consist of a “%” and a single uppercase character, as follows:
%T
The type of operation: 0 if to tape, 1 if to disk.
%N
The total number of locations being written.
%M
For the begin or end operations, the incremental/current location number. For save or restore operations, this starts at 1 and is incremented after each save or restore command.
%D
The path to the database directory being saved or restored.
%C
The path to the checkpoint directory of disk files or the device name if to tape.
%F
The name of the checkpoint file created or read from.
%A
%C prepended to %F in a form to produce a fully specified file (that is, %A = %C/%F).
%X
The name of the table, pertinent to the work commands executed under table processing.
%B
Expanded during execution to represent the list of internal files that are associated with a table checkpoint. This parameter is pertinent to the work commands executed under table processing.
The “%” parameters in the commands are replaced by ckpdb and/or rollforwarddb when the command is executed.