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
|