STORELOG

Stores a copy of an archive log file that is ready for backup.

Scope

SQLUtil Only

SQLUtil Syntax

>> STORELOG DBEnvironment Name: DBEnvironmentName Maintenance Word: MaintenanceWord Log Identifier (opt): LogIdentifier To File Name? FileName Store Log File (y/n)? { Y[es] N[o] }

Parameters

DBEnvironmentName: is the name of the DBEnvironment with which the file you are storing is associated. The DBEnvironment name may be entered either as an absolute pathname or as a pathname relative to your current working directory.
MaintenanceWord: is the maintenance word.
LogIdentifier: is the log identifier number of the log file to be stored. Use the SHOWLOG command to display this number.
FileName: is the absolute pathname of the store file. Relative pathnames are not allowed. The maximum length of a pathname is 44 bytes.

Description

This command lets you store an archive log file. The file to be stored must not be the current log file, and it must have the backup status of Ready for Backup in a dynamic SHOWLOG display.
If you specify the log identifier number for a log file that is Ready for Backup, only the specified log file will be stored.
If you omit the LogIdentifier, ALLBASE/SQL will store only the log file with the lowest sequence number that is storable-- that is, has the lowest log sequence number and has Ready for Backup status in a dynamic SHOWLOG display.
If you specify a log identifier number of 0, every log file which currently has the status Ready for Backup will be automatically stored to the same tape or disk device in order of increasing log sequence number. This allows you to store multiple log files to a single tape or disk device.
If the LogIdentifier number you enter corresponds to a log file that is in use, the store will not take place.
If more than one volume is required to store the log file, a request will be displayed on the console. The next tape can then be mounted.
For each successful STORELOG, label the backup tape with the log file name, sequence number, and the date and time of the backup. The sequence number will let you restore and recover log files in the correct order in the event that rollforward recovery is needed.
The DBEnvironment may be in use while this command is executed.
Multiple log support with STORELOG and RESTORELOG is not supported on the OMNIBACK backup tool.

Authorization

You must be the DBECreator or superuser or supply the correct maintenance word to use this command.

Example

STORELOG of single specified log file

   >> storelog

   DBEnvironment Name:  PartsDBE

   Maintenance Word:   Return 

   Log Identifier (opt): 2

   To File Name? /dev/rmt/0h

   Store Log File (y/n)? y



   Log file 'lgn1' with Sequence Number            11 was stored.

STORELOG using a log identifier of 0 to store multiple log file sto the same device

   >> storelog

   DBEnvironment Name:  PartsDBE

   Maintenance Word:   Return 

   Log Identifier (opt): 0

   To File Name? /dev/rmt/0h

   Store Log File (y/n)? y



   Log file 'ptslogA2' with Sequence Number             5 was stored.

   Log file 'ptslogA1' with Sequence Number             6 was stored.

   Log file 'ptslogA3' with Sequence Number             7 was stored.

   Log file 'ptslogA5' with Sequence Number             8 was stored.