Adding Logical-Log Files Manually

Add logical-log files one at a time, up to a maximum of 32,767 files, to any dbspace. As soon as you add a log file to a dbspace, it becomes a critical dbspace. You can add a logical-log file during a storage space backup.

To add a logical-log file using onparams

Login as user informix or root on UNIX or as a member of the Informix-Admin group on Windows.
Ensure that the database server is in online, single-user, or quiescent, or cleanup phase of fast-recovery mode.
The database server writes the following message to the log during the cleanup phase:
```
Logical recovery has reached the transaction cleanup phase.
```
Decide whether you want to add the log file to the end of the log file list or after the current log file.
You can insert a log file after the current log file regardless of the DYNAMIC_LOGS parameter value. Adding a log file of a new size does not change the value of LOGSIZE.
1. The following command adds a logical-log file to the end of the log file list in the logspace dbspace, using the log-file size specified by the LOGSIZE configuration parameter:
```
onparams -a -d logspace
```
2. The following command inserts a 1000-kilobyte logical-log file after the current log file in the logspace dbspace:
```
onparams -a -d logspace -s 1000 -i
```
3. To add a logical-log file with a new size (in this case, 250 kilobytes), execute the following command:
```
onparams -a -d logspace -s 250
```
Use onstat -l to check the status of the log files. The status of the new log file is A and is immediately available.
The next time you need to back up data, perform a level-0 backup of the root dbspace and the dbspaces that contain the new log files.
Although you no longer need to back up immediately after adding a log file, your next backup should be level-0 because the data structures have changed. For information on backing up data, refer to the IBM Informix Backup and Restore Guide.

For more information on using onparams to add a logical-log file, see the IBM Informix Administrator's Reference.

To add a logical-log file with ON-Monitor (UNIX)

Follow the instructions on adding a log file in Adding Logical-Log Files Manually, except use ON–Monitor instead of onparams.
Select Parameters > Add-Log to add a logical-log file.
In the field labelled Dbspace Name, enter the name of the dbspace where the new logical-log file will reside.
The size of the log file automatically appears in the Logical Log Size field. The new log file is always the value specified by LOGSIZE.