[ADSM-L] Antwort: Re: [ADSM-L] Antwort: Re: [ADSM-L] Reduce DB in 6.2.2.2
2011-02-07 04:13:41
Hi Dave,
Thanks, as deletion of data will be
finished in summer, I'll wait for that to do so
growth: no, not rapidly, it' just continuously
growing (never shrinking).
maybe I'm trying Amos's tip, just backup/restore
DB.
Offlline is ok, as long it can be achieved
in a weekend.
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
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.
______________________________________
Von:
Dave Canan <ddcanan AT GMAIL DOT COM>
An:
ADSM-L AT VM.MARIST DOT EDU
Datum:
04.02.2011 20:23
Betreff:
Re: [ADSM-L]
Antwort: Re: [ADSM-L] Reduce DB in 6.2.2.2
Gesendet von:
"ADSM:
Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>
Alex, you should contact TSM support for this. Because
of these DB2 APARs I
mentioned that are currently open, doing a reorg of the DB and indicies
does
not usually reduce the DB size. There are ways to do this, but they involve
taking TSM down and running db2 commands to export the tables, drop them,
and then re-import them. (that's not exactly the correct terminology, but
that's essentially what we're doing.) They have scripts that they can
provide here. It could just be the case of a few tables that need to have
the scripts run against them.
Are you also seeing rapid growth here in your DB?
On Fri, Feb 4, 2011 at 12:17 AM, Alexander Heindl <
alexander.heindl AT generali DOT at> wrote:
> Hi Dave,
>
> My problem is shrinking. I did not experience performance issues or
> unexpected db growth so far and I know now, that 6.2.3.0 will address
some
> reorg enhancements (Thanks to Joerg Pohlmann).
> To be honest, I don't know the difference between table and index
reorg so
> far as I have less experience with DB2 (just what I need to know for
TSM).
> The goal is to reduce the size of my db, as I'm sure it could shrink
> because of deleting serveral filespaces (yesterday nealy 10%).
> If I have a look at my db history graph, db never decreased ( could
send
> you a jpg)
>
> 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.
> ______________________________________
>
>
>
>
> Von: Dave Canan <ddcanan AT GMAIL DOT COM>
> An: ADSM-L AT VM.MARIST DOT EDU
> Datum: 03.02.2011 18:21
> Betreff: Re: [ADSM-L] Reduce DB in 6.2.2.2
> Gesendet von: "ADSM: Dist Stor Manager"
<ADSM-L AT VM.MARIST DOT EDU>
> ------------------------------
>
>
>
> 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.
> > ______________________________________
> >
> >
>
>
>
smime.p7s
Description: S/MIME Cryptographic Signature
|
|
|