Re: [ADSM-L] Reduce DB in 6.2.2.2

Same as Extend DBSPACE ( Which i tried and workd) to reduce it aprocedure like in the Info Center



 Reducing the size of the database

If a significant amount of data has been deleted from the database,consider reducing the database size.


  1. Create a file containing a list of directories that represent the
     new directories. For example, dbdirs.txt.
  2. Run a full database backup. For example:

     backup db devclass=tapeclass type=full

  3. Halt the server.
  4. Remove the database instance.

     dsmserv removedb TSMDB1

  5. Restore the database specifying the file containing the
     directories to be used. For example:

     dsmserv restore db todate=today on=dbdirs.txt

  6. Restart the server.





On 03/02/2011 19:19, Dave Canan wrote:

Alex, is the issue here that the database is not shrinking or is this a
question about reorgs? There are currently several APARs against the DB2
V9.7 that will not allow the DB to be reduced when reorgs occur. These will
be addressed in a future service level of TSM and DB2. If you have questions
about enabling index reorgs, you should contact TSM support for assistance.
There are several things to be aware of before index reorgs are enabled, so
PLEASE contact them first.

Also, if you'd like we could arrange a call here to discuss this further. I
realize the time differences involved, but we could arrange something. Let
me know.

Dave Canan
IBM Advanced Technical Support
ddcananATUSDOTIBMDOTCOM
916-723-2410



On Thu, Feb 3, 2011 at 3:32 AM, Alexander Heindl<
alexander.heindl AT generali DOT at>  wrote:

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