Hi Arni!
Just a thought: could it be that Oracle compression is turned on?
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 
Stefan Folkerts
Sent: donderdag 31 maart 2016 17:55
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Re: Deduplication and database backups

I've seen plenty of databases go to container pools and get fair to good 
deduplications results even on the first backup.
It should not matter that it is one large object, it will make the chunks 
larger but normally you should still get some deduplication as long as it's not 
encrypted.
It would seem like something strange that might just be HANA specific?

On Wed, Mar 30, 2016 at 3:34 PM, Arni Snorri Eggertsson <arnie AT gormur DOT 
com>
wrote:

> Hi all,
>
> I want to hear what others are doing in regards of deduplication and 
> large files / database backups,
>
> on a recent setup we are taking backups of a SAP Hana system to a 
> direcotry container,  I see great dedup stats when the system is doing 
> log backups, but I get no deduplication effects when we are doing full 
> backups, the database is roughly 250 GB in size,  and it looks like 
> TSM sees the object as one file.
>
> ANR0951I Session 550996 for node xxxxx processed 1 files using inline 
> deduplication. 251,754,067,764 bytes were reduced by 0 bytes.  (SESSION:
> 550996)
>
>
> I am not 100% sure how to handle this,   ....  are others using directory
> containers at all?  are you using them for TDP Database backups ? any 
> thoughts ?
>
>
>
>
> *Arni Snorri Eggertsson*
> arnie AT gormur DOT com
>
********************************************************
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
********************************************************