Can anyone tell me how best to manage space in the recovery log and DB.

Last night I received the following messages:

03/29/2000 05:28:38 ANR0314W Recovery log usage exceeds 90 % of its assigned
capacity.
03/29/2000 05:30:50 ANR0314W Recovery log usage exceeds 92 % of its assigned
capacity.
03/29/2000 05:33:03 ANR0314W Recovery log usage exceeds 94 % of its assigned
capacity.
03/29/2000 05:35:22 ANR0314W Recovery log usage exceeds 96 % of its assigned
capacity.
03/29/2000 05:38:06 ANR0314W Recovery log usage exceeds 98 % of its assigned
capacity.

What is the normal course of events if the above happens ?

I realise I can extend the recovery log.  But how do I know if it is being
utilised properly.  I have also noticed that the utilisation counters have
not been reset since 22/06/98.  Is this a problem.

A display of my log file is as follows:

ANS8000I Server command: 'QUERY LOG F=D'
       Available Space (MB): 592
     Assigned Capacity (MB): 592
     Maximum Extension (MB): 0
     Maximum Reduction (MB): 584
          Page Size (bytes): 4,096
         Total Usable Pages: 151,040
                 Used Pages: 337
                   Pct Util: 0.2
              Max. Pct Util: 100.3
           Physical Volumes: 4
             Log Pool Pages: 128
         Log Pool Pct. Util: 3.34
         Log Pool Pct. Wait: 0.22
Cumulative Consumption (MB): 722,834.19
Consumption Reset Date/Time: 06/22/1998 15:10:41

Looking at the above should I extend my log ?


> John Doherty. Tel:   +44   (0)   141 275 7793
>               Fax:  +44   (0)   141 275 9199
>               Email: JDohe1 AT Anfis.co DOT uk
>
>       Technical Specialist, Storage Management L02S
>
> Email communications are not necessarily secure and may be intercepted or
> changed after they are sent.  Abbey National Financial and Investment
> Services  does not accept liability for any such changes. If you wish to
> confirm the origin or content of this communication, please contact the
> sender using an alternative means of communication.  This communication
> does not create or modify any contract.  If you are not the intended
> recipient of this communication you should destroy it without copying,
> disclosing or otherwise using its contents.  Please notify the sender
> immediately of the error.
>
> ABBEY NATIONAL FINANCIAL AND INVESTMENT SERVICES plc
>         Registered Office Abbey National House 287 St Vincent Street
>         Glasgow G2 5NB United Kingdom Registered in Scotland No 159852
>