Re: very very big DB!!!!
2005-06-09 10:31:49
FYI... my database is 300GB! (Yes, I am planning to split it):
tsm: TSM_WAYNE>q db f=d
Available Space (MB): 307,852
Assigned Capacity (MB): 307,852
Maximum Extension (MB): 0
Maximum Reduction (MB): 18,848
Page Size (bytes): 4,096
Total Usable Pages: 78,810,112
Used Pages: 73,989,129
Pct Util: 93.9
Max. Pct Util: 93.9
Physical Volumes: 23
Buffer Pool Pages: 300,000
Total Buffer Requests: 796,977,754
Cache Hit Pct.: 95.48
Cache Wait Pct.: 0.00
Backup in Progress?: No
Type of Backup In Progress:
Incrementals Since Last Full: 0
Changed Since Last Backup (MB): 2,874.37
Percentage Changed: 0.99
Last Complete Backup Date/Time: 06/08/05 13:08:57
tsm: TSM_WAYNE>
Robin Sharpe
Berlex Labs
Douglas Currell
<dlcurrell@YAHOO
.COM> To: ADSM-L AT VM.MARIST DOT EDU
Sent by: "ADSM: cc:
Dist Stor Subject:
Manager" Re: very very big DB!!!!
<[email protected]
T.EDU>
06/09/2005 10:23
AM
Please respond
to "ADSM: Dist
Stor Manager"
30 GB is not outrageously large. I've worked with one
that was almost twice that size. You can unload and
load the database or perhaps do an audit on it.
There's an entire section called utilities in the
Admin Reference. Be forewarned that an audit could
take days if not weeks...!!!
--- Mario Di Pede <mario.dipede AT GIDI DOT IT> wrote:
> Hi
> I have a TSM DB of 30 Gb - there are a utilities for
> cleaning its?????
>
> thank's all
>
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
|
<Prev in Thread] |
Current Thread |
[Next in Thread>
|
- very very big DB!!!!, Mario Di Pede
- Re: very very big DB!!!!, Stapleton, Mark
- Re: very very big DB!!!!,
Robin Sharpe <=
- Re: very very big DB!!!!, Lawrence Clark
- Re: very very big DB!!!!, Rees, Chris (Corp)
- Re: very very big DB!!!!, Warren, Matthew (Retail)
- Re: very very big DB!!!!, Richard Rhodes
- Re: very very big DB!!!!, Rees, Chris (Corp)
- Re: very very big DB!!!!, Remeta, Mark
- Re: very very big DB!!!!, Das, Samiran (IDS ECCS)
- Re: very very big DB!!!!, Remeta, Mark
- Re: very very big DB!!!!, Kauffman, Tom
|
|
|