Just the sort of info I need to know, thanks!

-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On Behalf Of 
Steven Harris
Sent: Thursday, October 20, 2011 8:07 AM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Re: [ADSM-L] Dedup for DB's?

On 19/10/2011 4:18 AM, Prather, Wanda wrote:
> Just asking.
> As I recall, the announcements for client-side dedup said it is supported by 
> the API, so therefore should work with TDP's.
> Has anybody achieved (or attempted?) significant improvements in throughput 
> with backup of large DB's using client-side dedup?
>
> Wanda Prather  |  Senior Technical Specialist  | wprather AT icfi DOT 
> com<mailto:wprather AT icfi DOT com>   |  www.jasi.com<www.jasi.com%20>
> ICF Jacob&  Sundstrom  | 401 E. Pratt St, Suite 2214, Baltimore, MD 
> 21202 | 410.539.1135
>
Of course Wanda there is a gotcha.  CLIENTDEDUPTXNSIZE server option restricts 
the size of the object that can be client deduped, and it is, at 6.2.3 
restricted to 1TiB maximum.  For some DBMS that may not be a problem, e.g 
Oracle breaks its backups into backuppieces of a certain
size,   but for a big DB2 database its an issue as that baby comes down
in one transaction.

Its a little disappointing that such limits exist.

Regards

Steve

Steven Harris
TSM Admin
Canberra Australia