On Wednesday 31 March 2004 09:22, Steve Harris wrote:
> Time to weigh in here.
>
> 1. DB2 backups are API backups.  Generate backupset will not work.
> 2. DB2 backups are different to other backups.  the db2adutl program is
> used to expire them.  TSM holds indefinitely until db2adutl explicity
> deletes.

It seems I'm confused too! :)

I forgot that DB2 stores it's backups as *uniquely* named objects, not
*consistently* named objects. Since each backup object is uniquely named, the
retention policy needs to be set to keep one copy of each object "forever",
and to immediately expire the data when it is eventually "deleted".

So the DB2 Management Class should look like this:

Backup copy group: VE = 1, VD = 0, RE = 0, RO = 0;
Archive copy group: RD = NoLimit;

The DB2 admin (or a script) then uses the "db2adutl" command to tell TSM which
backups and logs are no longer required (ie. it tells TSM they were
"deleted", and then TSM policy expires the object).

This is described in the Redbook "Backing up DB2 using Tivoli Storage Manager"
sg246247, section 7.4 in particular.

I guess I was thinking of some horrible mix of DB2 and Domino. Sorry for the
disinformation. :)

Regards,
Steven P.

> So what is necessary is to examine your DB2 processes and the way that
> db2adutl is run.  If you are scripting it to do the deletions (there is a
> delete after so many days parameter) then you will need to revisit that for
> your Friday exceptions.
>
> That said, if you want to keep another copy of your DB2 backup, without
> taking another backup, then you can retrieve the Db2 backup from TSM to a
> disk file, again using arguments to db2adutl, and then you can back that up
> to TSM again by the usual backup or archive mechanism.  Now there is a DB2
> control file that holds details of backups..... whether you will be able to
> restore 12 months hence and need to also keep a copy of the control
> information is a question for your DB2 DBA.
>
>
> Regards
>
> Steve Harris
> AIX and TSM Admin
> Queensland Health, Brisbane Australia

--
Steven Pemberton
Senior Enterprise Management Consultant
IBK, Senetas Group

Mobile: +61/0 418 335 136 | Phone: +61/3 9820 5811 | Fax: +61/3 9820 9907
Level 1, 11 Queens Road, Melbourne, Victoria, 3004, Australia
http://www.senetas.com.au | http://www.ibk.com.au | http://www.datum.com.au