ADSM-L

Re: AW: TSM DB cleanup

2004-03-02 12:10:51
Subject: Re: AW: TSM DB cleanup
From: Glen Hattrup <ghattrup AT US.IBM DOT COM>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Tue, 2 Mar 2004 10:10:20 -0700
Ralph,

Without knowing why or what your exact concerns are with the TSM database, 
it is hard to give you generic advice to follow.

Unless you are experiencing internal errors, diagnostic messages, or other 
oddities that clearly indicate there is something wrong with your TSM 
server, you do NOT need to do anything specific to 'verify' the database 
before upgrading your system.

An Unload / Load would only reorganize your database.  It does not 'clean' 
your database or verify that your database is 'clean'.  The Unload / Load 
process has more of an effect on performance than space allocation. Search 
the list archives and you'll find differing opinions regarding short and 
long term benefit of an unload / load process.  I don't think it's needed 
in your case.

Please do NOT audit your database as was suggested below.  Depending upon 
the size of your database, you may end up wasting a significant amount of 
time (days, weeks?).  DB Audit is a 'computationally intensive' process 
(to put it mildly) and it is not clear that you'll see any benefit from 
doing so.   There are very few cases where the blanket response of "audit 
your database" is appropriate.

There are some known problems during upgrade from 4.2.x that depend upon 
your system and backup environment.  The monthly FAQ posts answers to the 
general "how do I upgrade" question, and the list archive is another 
excellent source to search.  Always read the README's, and always take a 
full database backup before upgrading your TSM environment.

Glen Hattrup
IBM - Tivoli Systems
Tivoli Storage Manager




Salak Juraj <j.salak AT ASAMER DOT AT> 
Sent by: "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>
03/02/2004 09:44 AM
Please respond to
"ADSM: Dist Stor Manager"


To
ADSM-L AT VM.MARIST DOT EDU
cc

Subject
AW: TSM DB cleanup






1) halt
2) dsmserv auditb

regards
juraj


-----Ursprüngliche Nachricht-----
Von: Levi, Ralph [mailto:RLevi AT HESS DOT COM]
Gesendet: Dienstag, 02. März 2004 16:09
An: ADSM-L AT VM.MARIST DOT EDU
Betreff: TSM DB cleanup


I am running TSM 4.2.1 (upgrading in a month after our next disaster
recovery test) and noticed that our DB is now 95% full.  I don't want to
have to expand it before the upgrade.  Is there a utility that can be
run to make sure it is "clean" ?

Thanks,
Ralph

<Prev in Thread] Current Thread [Next in Thread>