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.