Hi Matt

We have the same architecture.  We used to back it up through GE to an MVS
TSM server and 1.6 GB tapes. We would then migrate to 9840 tapes. This was a
PITA. We never could get the performance up. Now we backup to a P615 TSM
server with 2 FE cards. Performance is about the same. We backup to disk. We
run 4 concurrent backups with parallelism set to 4, so 16 different sessions
on TSM. Our network cards run between 10 and 12 MB/sec. We also precompress
data. Our goal is to go Lanless to LTO2 drives. We've seen 3/1 compression
on this data warehouse so I'm guessing about 70 to 90 MB/sec per drive. This
is only speculation though. 

We do full backups every month and TSP backups of the tables that get
updated weekly every week. Archive logs run every day.

Guillaume Gilbert
TSM Administrator
CGI
(514) 415-3000 x5091


> -----Original Message-----
> From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] 
> On Behalf Of MC Matt Cooper (2838)
> Sent: 6 mai 2004 12:30
> To: ADSM-L AT VM.MARIST DOT EDU
> Subject: What are people doing to bkup big DB2, data warehouse
> 
> 
> Hello all,
>      I am wondering what people are doing to backup these beasts and
> what kind of success (backup times) they have had doing it.
>     We are backup up a 3TB DB2 data warehouse but it is 
> taking almost 11
> hours, end to end.   The disk is all Shark, the client is on a p690
> 14cpu lpar, TSM 5.1 client, GB Ethenet adapter, going to TSM 5.1.8
> server on z/OS 1.4..  We are precompressing the data on the p690 and
> going direct to 6 9840 tape drives.  We are using the DB2 
> backup utility
> with parallelism set to 4, with the 6 concurrent streams.
>     Ideally we would like to back it up hot, seems to big and active.
> There is too much data for mirroring or FLASHCOPY.   Has anyone tried
> just backing upthe RAWS seperatly?
> Matt
>