I know 8.1.4.0 has a defrag option, that moves the content to existing
containers that have space instead of moving the container as a whole, that
might be a solution.
I do think it's new for 8.1.4.0 and I don't think there is a way to get rid
of them before that release.
On Wed, Feb 21, 2018 at 5:52 PM, Remco Post <r.post AT plcs DOT nl> wrote:
> I don’t know, nor do I care one bit. What I care about are those empty
> containers that I can’t get rid of.
>
> > On 21 Feb 2018, at 16:39, Loon, Eric van (ITOPT3) - KLM <
> Eric-van.Loon AT KLM DOT COM> wrote:
> >
> > Hi Remco,
> > Could it be that your SQL Server admins are compressing the data which
> is send to the TSM server? If I'm correct you can turn on compression on
> the SQL server itself as well as on the TDP/API client.
> > Kind regards,
> > Eric van Loon
> > Air France/KLM Storage Engineering
> >
> > -----Original Message-----
> > From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On Behalf
> Of Remco Post
> > Sent: woensdag 21 februari 2018 16:23
> > To: ADSM-L AT VM.MARIST DOT EDU
> > Subject: Re: empty containers?
> >
> > we’re getting about 0% dedup savings (3 * full, plus diffful, plus log
> backups) and about maybe 20% compression savings.
> >
> >> On 21 Feb 2018, at 16:03, PAC Brion Arnaud <Arnaud.Brion AT PANALPINA DOT
> >> COM>
> wrote:
> >>
> >> Hi Remco,
> >>
> >> No direct answer to your question, but your statement " dedup on SQL is
> non-existant" is kind of astonishing me ...
> >>
> >> Here an extract of the output for "q stg DIR_SQL f=d" on my server (you
> guessed it, this stgpool is dedicated to SQL backups ...) :
> >>
> >> Deduplication Savings: 34,513 G (60.21%)
> >> Compression Savings: 17,517 G (76.81%)
> >> Total Space Saved: 52,030 G (90.77%)
> >>
> >> Altogether 90,7 % data reduction !
> >>
> >> I would be curious to hear what our TSM fellows in this list are
> achieving ...
> >>
> >> Cheers.
> >>
> >> Arnaud
> >>
> >>
> >> -----Original Message-----
> >> From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On
> >> Behalf
> Of Remco Post
> >> Sent: Wednesday, February 21, 2018 3:06 PM
> >> To: ADSM-L AT VM.MARIST DOT EDU
> >> Subject: empty containers?
> >>
> >> Hi All,
> >>
> >> today I ran into something new: an empty directory container. No, not
> an empty directory, and empty container. We’re moving SQL backups from
> directories to traditional tape, dedup on SQL is non-existant, so tape is
> cheaper, and after the expiration period the container pool should be
> empty. Well this being the real world and all, of course I have a few
> containers left. Move container bla bla to reduce disk usage. All nice,
> exceprt for some containers that are now empty, thus can’t be moved… How do
> I get rid of those? TSM server level 8.1.1.100
> >>
> >> --
> >>
> >> Met vriendelijke groeten/Kind Regards,
> >>
> >> Remco Post
> >> r.post AT plcs DOT nl
> >> +31 6 248 21 622
> >
> > --
> >
> > Met vriendelijke groeten/Kind Regards,
> >
> > Remco Post
> > r.post AT plcs DOT nl
> > +31 6 248 21 622
> > ********************************************************
> > For information, services and offers, please visit our web site:
> http://www.klm.com. This e-mail and any attachment may contain
> confidential and privileged material intended for the addressee only. If
> you are not the addressee, you are notified that no part of the e-mail or
> any attachment may be disclosed, copied or distributed, and that any other
> action related to this e-mail or attachment is strictly prohibited, and may
> be unlawful. If you have received this e-mail by error, please notify the
> sender immediately by return e-mail, and delete this message.
> >
> > Koninklijke Luchtvaart Maatschappij NV (KLM), its subsidiaries and/or
> its employees shall not be liable for the incorrect or incomplete
> transmission of this e-mail or any attachments, nor responsible for any
> delay in receipt.
> > Koninklijke Luchtvaart Maatschappij N.V. (also known as KLM Royal Dutch
> Airlines) is registered in Amstelveen, The Netherlands, with registered
> number 33014286
> > ********************************************************
>
> --
>
> Met vriendelijke groeten/Kind Regards,
>
> Remco Post
> r.post AT plcs DOT nl
> +31 6 248 21 622
>
|
