TDP for SQL ver 2.2 does support multiple sessions backing up to the tsm
server.  The term they use in the manual for this is data striping.
 Have a management class in the domain that your node belongs to that goes
to your tape pool.  You will want to send your data objects to this
managmentclass and your meta objects to a disk managementclass.
You will need to modify your options file to do this.
   include \...\meta \...\* diskmgmtclass
   include \...\data \...\* tapemgmtclass
Update your node so that it can use 4 tape drives (update <nodename>
maxnummp=4)

When you run your backup you will need to set the number of stripes equal to
the number of drives that you wish to use.  Also use this value when
performing restores.

James Thompson

From: Diego N Fabani <fabanid AT AR.IBM DOT COM>
Reply-To: "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Database Backup with multiple drives
Date: Tue, 19 Jun 2001 10:39:39 -0300

Hi! I'm trying to perform a database backup ( ms-sql ) with TDP for SQL. I
want to do it directly to a storage pool using 4 tape drives. Do you know
how can i do to backup a big database using my 4 drives at the same time?

Thank you very much, Diego.

 Diego Nicolas Fabani
 Distributed Services
 E-mail :  fabanid AT ar.ibm DOT com
 Tel. #: 54-11-4319-7063.  Tie Line #: 840-7063
 CTSI Martinez. IBM Argentina S.A.

_________________________________________________________________
Get your FREE download of MSN Explorer at http://explorer.msn.com