Hi Steve,

It's a great question. Data is a funny thing... it can dedup/compress 
really well one day.. then not very much the next (for example, if 
database maintenance or re-orgs are done). 

As it stands right now, Spectrum Protect has to assume it won't dedup to 
make sure there is a enough space on the server to hold it. If Spectrum 
Protect allowed 2.9TB of your 3TB to be backed up.. then failed it because 
"out of space" conditions, IBM would get an APAR that said... if you knew 
that backup would fail due to space... why not fail it right away? 

Making an educated guess (cognitive) is a great idea... i.e. using 
historical analysis of previous backups of this database to apply an 
algorithm on estimated space needed.

These (and others) are the types of things Spectrum Protect development is 
looking at as we investigate other cognitive ideas to make the system 
smarter.

FYI... there is a Data Protection for SQL 8.1 already available:

        
http://www.ibm.com/support/knowledgecenter/SSER7G_8.1.0/db.sql/dps_con_info_whatsnew.html


Thank you,

Del

----------------------------------------------------


"ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU> wrote on 01/11/2017 
11:17:24 AM:

> From: "Schaub, Steve" <Steve_Schaub AT BCBST DOT COM>
> To: ADSM-L AT VM.MARIST DOT EDU
> Date: 01/11/2017 11:17 AM
> Subject: ANS1311E (RC11)   Server out of data storage space - container 
pool
> Sent by: "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>
> 
> BA client 7.1.3
> TDP client 7.1.4
> TSM server 7.1.7
> 
> Doing some testing of SQL TDP with container pools.  Getting ~ 95% 
> data reduction (client level compression & dedupe).
> Seeing this ANS1311E error on a 3TB database.
> It should barely fit the free space in the container pool if dedupe/
> compression is ignored, and easily fit once dedupe/compression are 
> factored in.
> 
> My question is whether there is a client/server version combination 
> that is smart enough to know that based on the compress/dedupe a 
> backup is getting, to go ahead and attempt the backup?
> Is there a TDP 8.1 coming out anytime soon?
> 
> Thanks,
> 
> Steve Schaub
> Systems Engineer II, Backup/Recovery
> Blue Cross Blue Shield of Tennessee
> 
> 
> 
------------------------------------------------------------------------------
> Please see the following link for the BlueCross BlueShield of 
> Tennessee E-mail disclaimer:  http://www.bcbst.com/email_disclaimer.shtm
>