Task 8: Adding a Log File

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.

Task 8: Adding a Log File

Technical documentation

» Table of Contents

» Glossary

» Index