onparams -a -d dbspace: Add a logical-log file

Read syntax diagramSkip visual syntax diagram

>>-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 IBM® Informix® 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 IBM Informix Administrator's Guide.

This command has an equivalent SQL administration API function.

Copyright© 2018 HCL Technologies Limited