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.