Re: TDP for SQL and Stripes
2002-05-16 14:43:33
> 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.
|
|
|