Hi all,

I have a question about DB2 and TSM backups. We've settled on a policy
that we would like ti implement but I'm having a hell of a time figuring
out how to actual do it. I know that TSM handles API backups from DB2
differently and I'm looking for tips on the best way to automate this
process.

We currently have a maintenance window that gives us enough breathing
room to do full offline backups. We would like to implement the following:

Monthly full backups for one year
Two years of annual backups
14 days of daily backups

I think we're okay with log files (even though we're doing offline
backups, we currently keeping those until we settle into a verified
policy. They don't take much space anyway) since TSM treats those as
archives and not backups.

The questions comes with the database backups. I don't want TSM to
expire any monthly backups that may be sitting out there when it runs
expire inventory. Is there a way to generate an archive of a specific
database backup from TSM or does it have to be done with db2adutl and a
bit of scripting so as to make sure I don't delete the month end and
annual backups? I'm also curious about how to configure the management
class for this. We really enjoy backing up straight to TSM as it makes
cross node recovery each night on our QA box a snap to script.

Sadly enough none of our DBAs are as well versed in TSM and the TSM
admin role is owned by myself and the SAs who work under me.

Thanks in advance!

John E. Vincent