Add a Logical-Log File

Home | Previous Page | Next Page Administrative Utilities > The onparams Utility >

Add a Logical-Log File

Add a Logical-Log File:
 
|-- -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	Additional Information: 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. Restrictions: You cannot add a log file to a blobspace or sbspace. References: 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	Restrictions: This value must be an unsigned integer greater than or equal to 200 kilobytes. Additional Information: 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. References: For information on changing LOGSIZE, see the chapter on managing logical-log files in the IBM Informix Administrator's Guide.

Element

Purpose

Key Considerations

-a -d dbspace

Adds a logical-log file to the end of the log-file list to the specified dbspace

Additional Information: 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.

Restrictions: You cannot add a log file to a blobspace or sbspace.

References: 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

Restrictions: This value must be an unsigned integer greater than or equal to 200 kilobytes.

Additional Information: 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.

References: For information on changing LOGSIZE, see the chapter on managing logical-log files in the IBM Informix Administrator's Guide.