ADDLOG

Adds a new log file to the DBEnvironment.

Scope

SQLUtil Only

SQLUtil Syntax

>> ADDLOG DBEnvironment Name: DBEnvironmentName Maintenance Word: MaintenanceWord Enter Log File Name(s) Separated by a Blank? LogFileName1 [LogFileName2] New Log File Size? FileSize Add Log File (y/n)? { Y[es] N[o] }

Parameters

DBEnvironmentName: is the name of a DBEnvironment.
MaintenanceWord: is the maintenance word.
LogFileName1, LogFileName2: is the physical (HP-UX) name of the log file that is to be added. LogFileName2 is included only if you are using dual logging.
FileSize: is the size of the new log file.

Description

This command starts a DBEnvironment session, and lets you add one new log file. The DBEnvironment can be in use when this command is executed.
Each time ALLBASE/SQL switches to a new log file, a checkpoint is taken. Therefore, the size and number of log files can control the frequency of checkpoints. If you repeatedly see a Log Full message, add a new log file of the appropriate size.
In nonarchive logging mode, add as many log files as you need (one at a time, with separate ADDLOG commands) for a total size that can accommodate your largest transaction carried out by the maximum number of concurrent users.
In archive logging mode, add as many log files as you need (one at a time, with separate ADDLOG commands) to permit an ongoing cycle of STORELOG operations which make log files available.
ADDLOG prompts for the names of files to be added. You may enter a single log file name or, in the case of dual logging, you may enter two file names. ADDLOG will not accept more than two file names on a single line.
The maximum number of log files in a DBEnvironment is 34. Since one log is created when you start the DBEnvironment, the maximum number of log files you can add to a DBEnvironment is 33.

Authorization

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

Example

   >> addlog

   DBEnvironment Name:  PartsDBE

   Maintenance Word:   Return 

   Enter Log File Name(s) Separated by a Blank? lgn1

   New Log File Size? 300

   Add Log File (y/n)?  y



   Log file 'lgn1' was Added.

   Log Identifier Is: 2