Re: Unload DB question

2002-03-05 Thread Daniel Sparrman
Hi MichaelYes, the load/unload procedure is a kind of house cleaning feature.This is probably something that would result in about 100 messages in the list, but i'd suggest to do a unload/load at least once a year. Preferable, every quarter. However, as this is a time consuming procedure, normal installations, according to my experience, doesn't do this at all.Doing an unload/load procedure, can shrink your database up to half it's size(or more depending on how long you have been running). If you consider this, and compare to a harddrive, doing a seek on data placed on only half of the hardrive is much more faster than doing a seek on data placed on all of the harddrive.And, consider that TSM does this seek all day long, doing reclamation, backups of storagepools, migrations, restores and backups and so on...Yes, you can speed up your TSM installation doing a unload/load.Best RegardsDaniel Sparrman---Daniel SparrmanExist i Stockholm ABBergkällavägen 31D192 79 SOLLENTUNAVäxel: 08 - 754 98 00Mobil: 070 - 399 27 51 "Anderson, Michael - HMIS" <[EMAIL PROTECTED]>Sent by: "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]>2002-03-05 08:58 ESTPlease respond to "ADSM: Dist Stor Manager" To: [EMAIL PROTECTED] cc:  bcc:  Subject: Unload DB question        I have been seeing some postings about the unload/load databasecommands. I am a learn as you go tsmer, so         this has peeked my interest. I am in the process of cleaning upsome of the nodes that had resided in TSM. I was         wondering if the unload/load procedure is a maintenance likeprocedure that should be done every so often, or if it         was a cure for a specific problem. I am running TSM 4.1.5 on aix4.3.3 with a 14 gb database at 65% used         Thanks Mike Anderson         [EMAIL PROTECTED]CONFIDENTIALITY NOTICE: This e-mail message, including any attachments,is for the sole use of the intended recipient(s) and may containconfidentialand privileged information. Any unauthorized review, use, disclosure ordistribution is prohibited. If you are not the intended recipient, pleasecontact the sender by reply e-mail and destroy all copies of the originalmessage.

Unload DB question

2002-03-05 Thread Anderson, Michael - HMIS

I have been seeing some postings about the unload/load database
commands. I am a learn as you go tsmer, so
 this has peeked my interest. I am in the process of cleaning up
some of the nodes that had resided in TSM. I was
 wondering if the unload/load procedure is a maintenance like
procedure that should be done every so often, or if it
 was a cure for a specific problem. I am running TSM 4.1.5 on aix
4.3.3 with a 14 gb database at 65% used


 Thanks Mike Anderson
 [EMAIL PROTECTED]


CONFIDENTIALITY NOTICE: This e-mail message, including any attachments,
is for the sole use of the intended recipient(s) and may contain
confidential
and privileged information. Any unauthorized review, use, disclosure or
distribution is prohibited. If you are not the intended recipient, please
contact the sender by reply e-mail and destroy all copies of the original
message.