Adding logical-log files manually
You can use an onparams command to add logical-log files.
About this task
- 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
- 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
- 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:
- 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 Informix® Backup and Restore Guide.
Results
For more information about using onparams to add a logical-log file, see the Informix® Administrator's Reference.