ADSM-L

Database Free Space

2004-12-15 07:51:40
Subject: Database Free Space
From: "Coats, Jack" <Jack.Coats AT BANKSTERLING DOT COM>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Wed, 15 Dec 2004 06:48:13 -0600
My database backup (TSM 4.3.1 on Windows 2000) is running VERY slowly.
Taking about 4.5 to 5 hours now.

 

LOGS::

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
--------- -------- --------- --------- ------- --------- --------- -----
-----
   13,312   11,060     2,252     3,076   4,096 2,830,848 2,042,151  72.1
100.0
 
DATABASE: 
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
--------- -------- --------- --------- ------- --------- --------- -----
-----
   40,360   23,184    17,176       664   4,096 5,935,104 5,517,214  93.0
96.7
 

Apparently I need to increase log space again, but is there enough free
space in the DATABASE?  

I try to keep the logs no higher than 80%, is there a magic number that
could help improve the backups speed?

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