We have our important DB2 databases being backed up to local DASD then TSM 
backs up the flat files with the required management class for database 
retention.  This alleviated problems we were seeing with the db2 backups being 
interrupted and causing an "out-of-sync" condition, which only a restart of the 
application could fix.  This also enables us (TSM) to control the expiration of 
the database files instead of relying on the DBA to expire them.  This has 
decreased our storage requirements on some of these servers to a quarter of 
what they were using.


Tony Garrison
I/T Sr. Systems Programmer
USAA
210-913-9836



-----Original Message-----
From: Daniel Sparrman [mailto:daniel.sparrman AT EXIST DOT SE]
Sent: Wednesday, December 11, 2002 6:26 AM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Re: DB2 backup on AIX


Hi

DB2 has built-in capabilities to backup to TSM. Check with your DB2 admin. 
It also explains how to do it in "Backing up databases with Tivoli Storage 
Manager"

Best Regards

Daniel Sparrman
-----------------------------------
Daniel Sparrman
Exist i Stockholm AB
Propellervägen 6B
183 62 HÄGERNÄS
Växel: 08 - 754 98 00
Mobil: 070 - 399 27 51