ADSM-L

Re: [ADSM-L] DP for SQL Server full backup failure

2007-11-27 10:11:00
Subject: Re: [ADSM-L] DP for SQL Server full backup failure
From: Del Hoobler <hoobler AT US.IBM DOT COM>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Tue, 27 Nov 2007 09:55:20 -0500
These commands will do the trick:

   tdpsqlc set BUFFERS=3
   tdpsqlc set BUFFERSIZE=1024
   tdpsqlc set SQLBUFFERS=0
   tdpsqlc set SQLBUFFERSIZE=1024
   tdpsqlc set STRIPES=1

You can also set them through the DP/SQL GUI "Edit-->Configuration".

Del

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

"ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU> wrote on 11/27/2007
09:30:12 AM:

> Hi Del!
> Thank you very much for your reply!!!
> I assume these paramaters all have to be specified in the TDP option
> file?
> Kindest regards,
> Eric van Loon
> KLM Royal Dutch Airlines
>
>
> -----Original Message-----
> From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On Behalf 
> Of
> Del Hoobler
> Sent: dinsdag 27 november 2007 12:40
> To: ADSM-L AT VM.MARIST DOT EDU
> Subject: Re: DP for SQL Server full backup failure
>
> Hi Eric,
>
> You didn't give any details about the BUFFERS, BUFFERSIZE, SQLBUFFERS,
> SQLBUFFERSIZE, or STRIPES that you are using.
> I would start by setting
>    BUFFERS 3
>    BUFFERSIZE 1024
>    SQLBUFFERS 0
>    SQLBUFFERSIZE 1024
>    STRIPES 1
> to see if that helps at all.
> If not, I suggest that you place a call with IBM Support.
> This one may need a trace and help from support to solve.
>
> Thanks,
>
> Del

<Prev in Thread] Current Thread [Next in Thread>