Adding logical-log files manually

You can use an onparams command or ON-Monitor to add logical-log files.

About this task

You might add logical-log files manually for the following reasons:

To increase the disk space allocated to the logical log
To change the size of your logical-log files
To enable an open transaction to roll back
As part of moving logical-log files to a different dbspace

Restriction: You cannot do the following actions:

Add a log file to a blobspace or sbspace.
Add logical or physical logs to dbspaces that have non-default page sizes.

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.

You can add a logical-log file in either of the following locations:

At the end of the file list using the onparams -a command
After the current logical-log file using the onparams -a -i command

To add a logical-log file using onparams

Procedure

Log-in 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, administration, 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.
- 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
```
- The following command inserts a 1000 KB logical-log file after the current log file in the logspace dbspace:
```
onparams -a -d logspace -s 1000 -i
```
- To add a logical-log file with a new size (in this case, 250 KB), run 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 must back up data, perform a level-0 backup of the root dbspace and the dbspaces that contain the new log files.
Although you are no longer required to back up immediately after adding a log file, your next backup must be level-0 because the data structures have changed. For information about backing up data, see the HCL OneDB™ Backup and Restore Guide.

Results

For more information about using onparams to add a logical-log file, see the HCL OneDB 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 labeled Dbspace Name, enter the name of the dbspace where the new logical-log file is located.
The size of the log file automatically is in the Logical Log Size field. The new log file is always the value specified by LOGSIZE.