ADSM-L

Re: Reorg your database

2002-03-12 21:49:23
Subject: Re: Reorg your database
From: Gabriel Wiley <wileyg AT US.IBM DOT COM>
Date: Tue, 12 Mar 2002 21:48:29 -0500
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>