Thanks, Del.  An interim solution might be a cfg parm that allows us to specify 
a percentage of data reduction that TDP would use.  So we could tell TDP to 
assume a 75% total data reduction to factor into its calculation.
-steve

-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On Behalf Of 
Del Hoobler
Sent: Thursday, January 12, 2017 7:47 AM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Re: [ADSM-L] ANS1311E (RC11) Server out of data storage space - 
container pool

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
> 

------------------------------------------------------------------------------
Please see the following link for the BlueCross BlueShield of Tennessee E-mail 
disclaimer:  http://www.bcbst.com/email_disclaimer.shtm