Using onutil to replace Log Files or Logslices

You can use onutil to replace a logical-log file with a new one of different size or location.

1. Change the value of LOGSIZE using the onutil SET command.

   % onutil
   1> SET LOGSIZE 50000;

2. Use the onutil CREATE LOG command to add a logical-log file. The following example shows how to add a logical-log file to three dbspaces on coserver eds.3:

   % onutil
   1>    CREATE LOG dbspace logspace3;
   Logical log successfully added.
   2>    CREATE LOG dbspace logspace4;
   Logical log successfully added.
   3>    CREATE LOG dbspace logspace5;
   Logical log successfully added.

3. Execute a series of onmode -l commands to make one of the new logs the current log.
4. Write a checkpoint using onmode -c.
5. Using onstat -l, determine the log file numbers of the logs you want to drop.
6. Drop the log files one-by-one using onutil. For example:

   % onutil
   1>    DROP LOG 1 coserver eds.3;
   Logical log 1 successfully dropped.
   2>    DROP LOG 2 coserver eds.3;
   Logical log 2 successfully dropped.
   3>    DROP LOG 3 coserver eds.3;
   Logical log 3 successfully dropped.

You can use onutil to replace a logslice with a new one of different size or location.

1. 1. Change the value of LOGSIZE using the onutil SET command.

   % onutil
   1> SET LOGSIZE 2000;

2. 2. Use the onutil CREATE LOGSLICE command to add a logslice. The following example adds a logslice to the "slice5" dbslice:

   % onutil
   1> CREATE LOGSLICE mylogslice_new
   2> IN DBSLICE slice5;
   Logslice successfully added.

3. Use the onutil DROP LOGSLICE command to drop the old logslice.

   % onutil
   1> DROP LOGSLICE mylogslice_old;
   Logslice successfully dropped.

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