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: [EMAIL PROTECTED]
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
-----Original Message-----
From: Mark Hayden [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, 13 March 2002 7:22 AM
To: [EMAIL PROTECTED]
Subject: Reorg your database
Hello, I have been checking into and reading e-mails from here regarding
reorganizing your database. It sounds like this should be done every so
often. We have some problems that I believe this may fix, but am a little
bit nervous and have not done so. My question is ( for people who have ran
this) How has it worked for you and do you run this as a procedure, or only
when you think the DB is fragmented or in need. Maybe how difficult is the
procedure, and any do's and don'ts......Thanks for your help!
Thanks, Mark Hayden
Network Administrator
E-Mail: [EMAIL PROTECTED]
