Re: Database defragmentation (was Expiration)

Subject:	Re: Database defragmentation (was Expiration)
From:	"Cook, Dwight E" <cookde AT BP DOT COM>
Date:	Thu, 19 Apr 2001 08:45:05 -0500

Here is how you tell if you need to defrag your TSM DB !
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
--------- -------- --------- --------- ------- --------- --------- -----
-----
-----
   20,416   15,384     5,032         0   4,096 3,938,304    17,791   0.5
   20,416   15,384     5,032         0   4,096 3,938,304    17,791   0.5
0.5

Note that out of 15 GB used in a 20 GB db only 0.5% is used yet I can't
reduce the db ANY !

time to unload / load :-(

Dwight

<Prev in Thread]	Current Thread	[Next in Thread>
Database defragmentation (was Expiration), M Jenkins Re: Database defragmentation (was Expiration), Chibois, Herve Re: Database defragmentation (was Expiration), Cook, Dwight E <=

Previous by Date:	Re: TDP for SQL Server Setup, Michel Engels
Next by Date:	AIX TSM DB ON NT?, Steve Hicks
Previous by Thread:	Re: Database defragmentation (was Expiration), Chibois, Herve
Next by Thread:	? BUFPOOLSIZE limit under TSM4.1 / NT, sal Salak Juraj
Indexes:	[Date] [Thread] [Top] [All Lists]