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" <wPrather AT ICFI DOT COM>
Date: Thursday, February 3, 2011 9:46 am
Subject: Re: [ADSM-L] Reduce DB in 6.2.2.2
To: ADSM-L AT VM.MARIST DOT 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 AT VM.MARIST DOT EDU] On
> Behalf Of Hart, Charles A
> Sent: Thursday, February 03, 2011 9:08 AM
> To: ADSM-L AT VM.MARIST DOT 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 AT VM.MARIST DOT EDU] On
> Behalf Of Grigori Solonovitch
> Sent: Thursday, February 03, 2011 5:44 AM
> To: ADSM-L AT VM.MARIST DOT 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 AT VM.MARIST DOT EDU] On
> Behalf Of Alexander Heindl
> Sent: Thursday, February 03, 2011 2:32 PM
> To: ADSM-L AT VM.MARIST DOT 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.heindl AT generali DOT at<mailto:alexander.heindl AT generali DOT
> 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.
>
|