ADSM-L

Re: My LOG! My LOG!

1999-04-15 17:18:16
Subject: Re: My LOG! My LOG!
From: "Kelly J. Lipp" <lipp AT STORSOL DOT COM>
Date: Thu, 15 Apr 1999 15:18:16 -0600
The things you did won't effect the log at all.  Database transactions are
kept in the log not activity log types of stuff.  Your log must be in roll
forward mode.  That means all transactions between db backups are kept in
the log.  In this fashion, it is possible to recover from a failed database
to the last successfully committed transaction by rolling these
transactions into the database after it is restored.  If you don't need
this feature, set your log mode to normal.  Then you probably have a large
enough log file.

You could also add some space to your recovery log

define logvol filename formatsize=500

to create a log volume of 500 MB.  Then extend the log using

extend log 500

Kelly J. Lipp
Storage Solutions Specialists, Inc.
www.storsol.com
lipp AT storsol DOT com
(719)531-5926

<Prev in Thread] Current Thread [Next in Thread>