Re: Reorg your database
2002-03-12 17:38:31
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
|
|
|