Make sure you audit your database first.  Any db errors will cause the
reload to fail.

        -Bill Goliak
NSIT-SEA Unix Systems Adminstrator
Office: 773 702 9425
Pager:  773 652 0744

On Wed, 9 Apr 2003, Rushforth, Tim wrote:

> Have you tried running expiration with skipdirs=yes?  This may run quicker
> and expire most of the data.
>
> When we had long runing expirations we did this (also running regular
> expiration).
>
> -----Original Message-----
> From: Joni Moyer [mailto:joni.moyer AT HIGHMARK DOT COM]
> Sent: Wednesday, April 09, 2003 10:10 AM
> To: ADSM-L AT VM.MARIST DOT EDU
> Subject: Re: UNLOAD/RELOAD DB
>
>
> Another of my problems is that expiration hasn't been able to run from
> beginning to end, I set a duration of approximately 7 hours.  Could this
> also be causing performance/DB growth?  Thanks!
>
> Available Space (MB): 60,456
>         Assigned Capacity (MB): 60,456
>         Maximum Extension (MB): 0
>         Maximum Reduction (MB): 8,044
>              Page Size (bytes): 4,096
>             Total Usable Pages: 15,476,736
>                     Used Pages: 12,913,875
>                       Pct Util: 83.4
>                  Max. Pct Util: 83.5
>               Physical Volumes: 26
>              Buffer Pool Pages: 24,576
>          Total Buffer Requests: 4,229,185
>                 Cache Hit Pct.: 98.30
>                Cache Wait Pct.: 0.00
>            Backup in Progress?: No
>     Type of Backup In Progress:
>   Incrementals Since Last Full: 9
> Changed Since Last Backup (MB): 149.34
>             Percentage Changed: 0.30
> Last Complete Backup Date/Time: 04/09/2003 09:32:43
>
>
> Joni Moyer
> Systems Programmer
> joni.moyer AT highmark DOT com
> (717)975-8338
>