You might want to also look at: http://www-01.ibm.com/support/docview.wss?uid=swg21452146&myns=swgtiv&mynp=OCSSGSG7&mync=E
also APAR IC69506 Automatic Index Reorgs of the Tivoli Storage Manager database does not occur. Regards, Joerg Pohlmann 250-585-3711 ----- Original Message ----- From: "Prather, Wanda" <wprat...@icfi.com> Date: Thursday, February 3, 2011 9:46 am Subject: Re: [ADSM-L] Reduce DB in 6.2.2.2 To: ADSM-L@VM.MARIST.EDU > Yes, it does online reorgs by default. I think it checks > every hour, and starts a reorg of any tables that need it. > It suspends the reorg if other activity picks up, and picks up > where it left off when other activity is low. > > -----Original Message----- > From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On > Behalf Of Hart, Charles A > Sent: Thursday, February 03, 2011 9:08 AM > To: ADSM-L@VM.MARIST.EDU > Subject: Re: [ADSM-L] Reduce DB in 6.2.2.2 > > Doest DB2 do Online Re-oirgs? Or was the intend to clean > up a 5.x DB for a migrate to 6.2? > > -----Original Message----- > From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On > Behalf Of Grigori Solonovitch > Sent: Thursday, February 03, 2011 5:44 AM > To: ADSM-L@VM.MARIST.EDU > Subject: Re: [ADSM-L] Reduce DB in 6.2.2.2 > > To release DB space I am using for TSM 5.5: > 1) estimate dbreorgstats > 2) dsmserv UNLOADDB devclass=<class> volumenames=<vols> > 3) dsmserv LOADFORMAT ........... > 4) dsmserv LOADDB devclass=<class> volumenames=<vols> > 5) dsmserv AUDITDB fix=yes, if required > > It takes time, but works fine. > > > > Grigori G. Solonovitch > > ________________________________ > From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On > Behalf Of Alexander Heindl > Sent: Thursday, February 03, 2011 2:32 PM > To: ADSM-L@VM.MARIST.EDU > Subject: [ADSM-L] Reduce DB in 6.2.2.2 > > Hi, > > I have a TSM-Server instance with a 188 GB Database: > Space Used by Database(MB): 188,032 > > Although deleting several (big) filespaces which are not needed > anymore, database ist not shrinking. I thought with 6.1 (an 6.2) > this is done automatically? > > Best Regards, > Alex > > ______________________________________ > Ing. Alexander Heindl > > Generali IT-Solutions GmbH > WIs > > Kratochwjlestraße 4, 1220 Wien > Telefon: +43 (0)1 53401-13160 > Fax: +43 1 532 09 49 3160 > E-Mail: > alexander.hei...@generali.at<mailto:alexander.hei...@generali.at> > http://www.generali.at<http://www.generali.at/> > > Generali IT-Solutions GmbH, Sitz in Wien registriert beim > Handelsgericht Wien unter FN 215738 m > DVR-Nr.: 2111166. > Die Gesellschaft gehört zur Unternehmensgruppe der Assicurazioni > Generali S.p.A., Triest, eingetragen im > Versicherungsgruppenregister der ISVAP unter der Nummer 026. > ______________________________________ > > ________________________________ > CONFIDENTIALITY AND WAIVER: The information contained in this > electronic mail message and any attachments hereto may be > legally privileged and confidential. The information is intended > only for the recipient(s) named in this message. If you are not > the intended recipient you are notified that any use, > disclosure, copying or distribution is prohibited. If you have > received this in error please contact the sender and delete this > message and any attachments from your computer system. We do not > guarantee that this message or any attachment to it is secure or > free from errors, computer viruses or other conditions that may > damage or interfere with data, hardware or software. > > Please consider the environment before printing this Email. > > This e-mail, including attachments, may include confidential > and/or proprietary information, and may be used only by the > person or entity to which it is addressed. If the reader of this > e-mail is not the intended recipient or his or her authorized > agent, the reader is hereby notified that any dissemination, > distribution or copying of this e-mail is prohibited. If you > have received this e-mail in error, please notify the sender by > replying to this message and delete this e-mail immediately. >
