Drop a Logical-Log File

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

Drop a Logical-Log File

Drop a Logical- Log File:
 
|-- -d-- -l--lognum--+-----+------------------------------------|
                     '- -y-'

Element	Purpose	Key Considerations
-d -l lognum	Allows you to drop a logical-log file specified by the log file number	Restrictions: This value must be an unsigned integer greater than or equal to 0. The database server requires a minimum of three logical-log files at all times. You cannot drop a log file if the database server is configured for three logical-log files. Drop log files one at a time. Additional Information: You can obtain the lognum from the number field of onstat -l. The sequence of lognum might be out of order. You can drop a log file immediately that has a status of newly Added (A). If you drop a log file that has a status of Used (U) or Free (F), the database server marks it as Deleted (D) and drops it when you take a level-0 backup of all the dbspaces.
-y	Causes the database server to automatically respond yes to all prompts	None.

Element

Purpose

Key Considerations

-d -l lognum

Allows you to drop a logical-log file specified by the log file number

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

The database server requires a minimum of three logical-log files at all times. You cannot drop a log file if the database server is configured for three logical-log files. Drop log files one at a time.

Additional Information: You can obtain the lognum from the number field of onstat -l. The sequence of lognum might be out of order.

You can drop a log file immediately that has a status of newly Added (A). If you drop a log file that has a status of Used (U) or Free (F), the database server marks it as Deleted (D) and drops it when you take a level-0 backup of all the dbspaces.

-y

Causes the database server to automatically respond yes to all prompts

None.

When you move logical-log files to another dbspace, use the onparams commands to add and drop logical-log files. See moving a logical-log file, in the chapter on managing logical-log files in the IBM Informix Administrator's Guide.