Home | Previous Page | Next Page   Logging and Log Administration > Managing Logical-Log Files > Dropping a Logical-Log File or Logslice >

Dropping a Logical-Log File or Logslice with onutil

Use onutil to drop a logical-log file or logslice. To obtain the logid, use the xctl onstat -l command. You might want to back up the old logical-log files and logslices before you drop them.

Note:
After a logical log file or logslice is dropped, you must perform a level-0 archive of all dbspaces. If a level-0 archive is not performed, the log file remains in a "deleted" state, but is not freed.

Dropping a Log File

Execute the following command to drop a logical-log file, whose logical log file number is 6, that is on coserver eds.2:

onutil
1> DROP LOG 6 COSERVER eds.2;

For information on the onutil DROP LOGICAL LOG command, see the utilities chapter in the IBM Informix: Administrator's Reference.

Dropping a Logslice

You drop logslices one at a time. You can drop a logslice that has a status of free (F) or newly-added (A). You can only drop a logslice with a status of used (U), if it is also marked "backed up" and is no longer needed for fast recovery.

You must know the name of each logslice that you intend to drop.

Execute the following command to drop a logslice whose name is logslice2:

onutil
1> DROP LOGSLICE logslice2;

For information on the onutil DROP LOGSLICE command, see the utilities chapter in the IBM Informix: Administrator's Reference.

Home | [ Top of Page | Previous Page | Next Page | Contents | Index ]