Re: Reorg your database
2002-03-12 21:49:23
Mark,
There is a little equation I use to figure out what the difference between
reality and what TSM thinks..
Try this: DB Assigned Capacity - ( DB Assigned Capacity ) * DB Pct Util )
Remember your calculating MB(s)
Hope this helps, works for me~
Gabriel C. Wiley
ADSM/TSM Administrator
AIX Support
Phone 1-614-308-6709
Pager 1-877-489-2867
Fax 1-614-308-6637
Cell 1-740-972-6441
Siempre Hay Esperanza
David Smith
<[email protected] To: ADSM-L AT VM.MARIST
DOT EDU
OM.AU> cc:
Sent by: "ADSM: Subject: Re: Reorg your database
Dist Stor
Manager"
<[email protected]
.EDU>
03/12/2002 05:35
PM
Please respond to
"ADSM: Dist Stor
Manager"
Mark,
I've just unloaded/loaded our TSM 4.1.5 database to fix performance
problems. Our 18GB database shrank to 11GB and a 'query archive' that used
to run for over an hour now takes 10 seconds. It took 4 hours to dump (to
a
fileclass volume) and 2 hours to load on an RS/6000 6M1 but it was mostly
I/O so I don't think the speed of the machine helped all that much.
I did have a failure running it on 4.1.2 server as it locked up when
changing from one file volume to another. I updated to 4.1.5 and made the
fileclass max volume size 20GB. The unload then ran fine to the one file
volume.
Regards,
David Smith
AIX Administrator
Corporate Express Australia
67-77 Epsom Rd Sydney NSW
PH 02 93350318 or 0412 258 208
|
<Prev in Thread] |
Current Thread |
[Next in Thread>
|
- Reorg your database, Mark Hayden
- Re: Reorg your database, David Smith
- Re: Reorg your database,
Gabriel Wiley <=
- Re: Reorg your database, Michael, Monte
- Re: Reorg your database, David Smith
- Re: Reorg your database, Seay, Paul
- Re: Reorg your database, David Smith
- Reorg your database, Mark Hayden [mailto:MHayden
- Re: Reorg your database, David Smith [mailto:david.smith
- Re: Reorg your database, Michael , Monte [mailto:monte.michael
- Re: Reorg your database, Michael , Monte [mailto:monte.michael
- Re: Reorg your database, Seay , Paul [mailto:seay_pd
|
|
|