ADSM-L

Re: TDP for SQL and Stripes

2002-05-16 14:43:33
Subject: Re: TDP for SQL and Stripes
From: Del Hoobler <hoobler AT US.IBM DOT COM>
Date: Thu, 16 May 2002 14:42:43 -0400
> What happens if, by reclamation process, two or more of the "striped"
> portions of the backup get reclaimed onto the same tape?  Will TSM allow
> that to happen?  if so, how do you do a restore?  Any other gotchya's out
> there?

Todd,

In a nutshell.. turn on collocation by filespace to avoid this.
We talk about this in Chapter 1 of the User's Guide
under "Additional Strategy Considerations".

* If you use data striping, also use Tivoli Storage
  Manager server filespace collocation to try to keep
  each stripe on a different storage volume. Use the Tivoli
  Storage Manager command UPDATE STGPOOL to set this
  parameter. It is recommended that meta data (counted as a separate
  filespace) not be allowed to go to tape media.

* The maximum number of data stripes you can use must
  be smaller than the maximum supported by the SQL server
  and less than the value of the Tivoli Storage Manager
  server TXNGROUPMAX option in the dsmserv.opt file.
  SQL Server 7.0 allows a maximum of 32 data stripes,
  and SQL Server 2000 allows a maximum of 64.

Thanks,

Del

----------------------------------------------------
Del Hoobler
Del Hoobler
IBM Corporation
hoobler AT us.ibm DOT com

Leave everything a little better than you found it.
Smile a lot: it costs nothing and is beyond price.
<Prev in Thread] Current Thread [Next in Thread>