Re: SQL TDP - Server out of data storage space

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.
>