Re: deleting logfiles

On Thu, 15 May 2003 02:14:48 -0400
Justin Bleistein <justin.bleistein AT SUNGARD DOT COM> wrote:

> Am I missing something here? This database is in normal mode, and I'm
> trying to delete one of my temporary log volumes that I just intended to
> use for tsm server recovery earlier. Now it's up and I've emptied the log I
> don't need it anymore. Now the reduction says I can reduce by 9 gig (if I'm
> reading that right?). Now as you can see the  "/downloads/log_save" volume
> is only 500 meg. What's keeping me from deleting this volume? It's early in
> the morning and I work 1st shift maybe it's a brain fart. Any suggestions
> I'd appreciate thanks!. I need to get rid of this volume.
>

first do a `reduce log 500`

then do your `delete logvol <logvol>`

that will work...

> tsm: ALTSM1>q log
>
> Available Assigned   Maximum   Maximum    Page     Total      Used   Pct
> Max.
>     Space Capacity Extension Reduction    Size    Usable     Pages  Util
> Pct
>      (MB)     (MB)      (MB)      (MB) (bytes)     Pages
> Util
> --------- -------- --------- --------- ------- --------- --------- -----
> -----
>     9,320    9,320         0     9,188   4,096 2,385,408    33,030   1.4
> 5.8
>
> tsm: ALTSM1>delete logvolume /downloads/log_save
> ANR2445E DELETE LOGVOLUME: Insufficient space on other recovery log volumes
> to
> delete volume /downloads/log_save.
> ANS8001I Return code 6.
>
> tsm: ALTSM1>q logvolume /downloads/log_save f=d
>
> Volume Name (Copy 1): /downloads/log_save
>          Copy Status: Sync'd
> Volume Name (Copy 2):
>          Copy Status: Undefined
> Volume Name (Copy 3):
>          Copy Status: Undefined
> Available Space (MB): 500
> Allocated Space (MB): 500
>      Free Space (MB): 0
>
>
> tsm: ALTSM1>
>
> --Justin Richard Bleistein
> Unix/TSM Systems Administrator (Sungard eSourcing)
> Desk: (856) 566 - 3485
> Cell:    (856) 912 - 0861
> Email: justin.bleistein AT sungard DOT com


-- Remco