ADDLOG

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.

The new file is added in the same account as the DBECon file. You can specify a different group name. If you specify an account name, it must be the same as that of the DBECon file.

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.