This task describes how to add a new log file to the DBEnvironment.
Performing the Task
Run SQLUtil, issue the ADDLOG command, and add a new
log file as in the following example:
:RUN SQLUTIL.PUB.SYS
>>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
>>exit
|
Task Reference
There are several reasons to add new log file(s) of the size and number
required:
To accommodate the largest transaction carried
out by the maximum number of concurrent users.
To take action to prevent Log Full messages.
To control the frequency of checkpoints.
The DBEnvironment can be in use when this command is executed.
Add log files one at a time using separate ADDLOG commands.
The maximum number of log files in a DBEnvironment is 34.