HP 3000 Manuals HP 3000 Manuals
Task 8:Adding a Log File
This task describes how to add a new log file to the DBEnvironment.
Performing the Task
[REV DEL]
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.