onparams -a -d dbspace: Add a logical-log file
>>-onparams-- -a-- -d--dbspace--+-----------+--+-----+---------><
'- -s--size-' '- -i-'
| Element | Purpose | Key considerations |
|---|---|---|
| -a -d dbspace | Adds a logical-log file to the end of the log-file list to the specified dbspace | You can add a log file to a dbspace only if the
database server has adequate contiguous space. The newly added log
files have a status of A and are immediately available for
use. You can add a log file during a backup. You can have a maximum
of 32,767 logical-log files. Use onstat -l to view
the status of your logical-log files. It is recommended that you take
a level-0 backup of the root dbspace and the dbspace that contains
the log file as soon as possible. You cannot add a log file to a blobspace or sbspace. Syntax must conform to the Identifier segment; see HCL OneDB™ Guide to SQL: Syntax. |
| -i | Inserts the logical-log file after the current log file | Use this option when the Log File Required alarm prompts you to add a logical-log file. |
| -s size | Specifies a size in kilobytes for the new logical-log file | This value must be an unsigned integer greater
than or equal to 200 kilobytes If you do not specify a size with the -s option, the size of the log file is taken from the value of the LOGSIZE parameter in the ONCONFIG file when database server disk space was initialized. For information on changing LOGSIZE, see the chapter on managing logical-log files in the HCL OneDB Administrator's Guide. |
This command has an equivalent SQL administration API function.