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@VM.MARIST.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:[EMAIL PROTECTED] On Behalf Of > Del Hoobler > Sent: dinsdag 27 november 2007 12:40 > To: ADSM-L@VM.MARIST.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
