You are right. We haven't tried any other
value than 100 yet but we are
going to see how much we can lower it
without disrupting the backup.
If it turns out that only numbers
close to 100 work we'll start
doing full backups.

Alexander

> -----Original Message-----
> From: Zlatko Krastev/ACIT [mailto:acit AT ATTGLOBAL DOT NET] 
> Sent: donderdag 8 mei 2003 9:50
> To: ADSM-L AT VM.MARIST DOT EDU
> Subject: Re: SQL TDP - Server out of data storage space - Solved
> 
> 
> If only numbers close to 100 work you may need to think about 
> replacing
> all differential backups with fulls.
> 
> Zlatko Krastev
> IT Consultant
> 
> 
> 
> 
> 
> 
> Alexander Verkooijen <alexander AT SARA DOT NL>
> Sent by: "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>
> 08.05.2003 07:42
> Please respond to "ADSM: Dist Stor Manager"
> 
> 
>         To:     ADSM-L AT VM.MARIST DOT EDU
>         cc:
>         Subject:        Re: SQL TDP - Server out of data 
> storage space - Solved
> 
> 
> Thanks to everybody who responded.
> Setting DIFFESTIMATE to 100 solved
> our problem.
> 
> Thanks again,
> 
> Alexander
> 
> > -----Original Message-----
> > From: Del Hoobler [mailto:hoobler AT US.IBM DOT COM]
> > Sent: vrijdag 2 mei 2003 15:09
> > To: ADSM-L AT VM.MARIST DOT EDU
> > Subject: Re: SQL TDP - Server out of data storage space
> >
> >
> > Alexander,
> >
> > Take a look at the following options:
> >
> >    /LOGESTimate=numpercent
> >
> >    /DIFFESTimate=numpercent
> >
> > They are in the User's Guide.
> > In some sitautions, the intial size estimate that the
> > SQL server tells DP for SQL is too low.
> > The User's Guide discusses those details.
> >
> > Thanks,
> >
> > Del
> >
> > ----------------------------------------------------
> >
> > > (Server 5.1.6.4 on AIX 4.3.3, SQL TDP 2.2 (not completely sure) on
> > > WinNT, 5.1.5.0 TSM client)
> > >
> > > I have a TDP for MS SQL that can't complete it's backup:
> > > Full: 0   Read: 411059712  Written: 411059712  Rate: 
> 5,901.75 Kb/Sec
> > > Full: 0   Read: 411059712  Written: 411059712  Rate: 
> 5,816.24 Kb/Sec
> > > Full: 0   Read: 411059712  Written: 411059712  Rate: 
> 5,733.18 Kb/Sec
> > > Full: 0   Read: 411059712  Written: 411059712  Rate: 
> 5,652.45 Kb/Sec
> > > Full: 0   Read: 411059712  Written: 411059712  Rate: 
> 5,652.37 Kb/Sec
> > > Backup of AwareUtrechttest failed.
> > > ANS1311E (RC11)   Server out of data storage space
> > >
> > > The activity log on the server agrees with the client:
> > > 04/29/03   04:18:50  ANR0534W Transaction failed for
> > session 9796 for
> > > node
> > >                       IF_SQL1 (TDP MSSQL) - size estimate
> > exceeded and
> > > server
> > >                       is unable to obtain additional space
> > in storage
> > > pool
> > >                       IFDISKPOOL.
> > > My first thought was that the client was trying to send
> > data that grew
> > > during compression because that usually produces this 
> error message.
> >
>