ADSM-L

Re: [ADSM-L] Reduce DB in 6.2.2.2

2011-02-03 12:20:51
Subject: Re: [ADSM-L] Reduce DB in 6.2.2.2
From: Dave Canan <ddcanan AT GMAIL DOT COM>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Thu, 3 Feb 2011 09:19:03 -0800
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.
> ______________________________________
>
>