ADSM-L

Sybase Dump Striping using BMC SQL-Backtrack

2001-03-26 11:29:05
Subject: Sybase Dump Striping using BMC SQL-Backtrack
From: Scott McCambly <mccambly AT ATTCANADA DOT CA>
Date: Mon, 26 Mar 2001 11:40:25 -0500
Hi everyone,

We've been using SQL-Backtrack (was Datatools, now BMC... trying to get all
those key words in to help those future searches ;-) successfully for many
years now to backup Sybase.

Recently one database has grown so large so as to exceed the maximum file
size allowed at our current level of AIX when it is dumped for backup.

For this reason and to try and maximize performance we want to implement
dump striping.  The documentation on this, however, with respect to using
the ADSM/TSM OBSI module is vague at best and has left us a little confused.

It states that separate management classes must be used for each stripe,
and that these must reference separate tape pools, but it is not clear if
these "pools" are the Backtrack pool definitions or the actual TSM storage
pools.

Does anyone have experience in implementing this?  Do we indeed need
separate management class definitions, or just a MC that points to a tape
pool using a DevClass that has multiple mount points available?  And I'm
assuming in this case that collocation would need to be OFF for this tape
pool.

Any advise would be appreciated.

TIA - Scott

PS: The folks at BMC support can reference Case 444873.

Scott McCambly
AIX/NetView/ADSM Specialist - Unopsys Inc.  Ottawa, Ontario, Canada
(613)799-9269
<Prev in Thread] Current Thread [Next in Thread>
  • Sybase Dump Striping using BMC SQL-Backtrack, Scott McCambly <=