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.
|
