On Monday 29 March 2004 23:21, Crawford, Lindy wrote:
> Good Day TSMers,
>
> Please HELP......we do db2 backups to TSM on a daily basis. What I would
> like to do to satify our auditors is make a copy of the backup taken on
> Friday nights to a storage pool that I've called weekly.
>
> I do not want to move the data, but make a copy of that backup set taken as
> at the friday night.

You are confused. :)

If I understand you correctly, you want to retain the Friday night's DB2
backups for a period different from that of the DB2 backups produced on other
nights of the week? And, you are already producing "copy pool" tapes to be
sent off-site.

The retention of client backups (including DB2) is separate from the location
of that data on disk/tape, and across storage pools. It is the TSM
Policy/Management Classes that control how the data is retained. Even if the
data is duplicated to multiple storage pools (Primary/Copy) that data is all
retained, and expired, at the same time, as specified by the various
Management Classes.

You can't simply copy the Friday DB2 backups to a differnt storage pool and
retian that media for a different period. TSM doesn't bother about retaining
media - it only retains data - and when the database expires the data from
the database the index of the data on ALL storage pool media is expired.

To retain the Friday night's DB2 backups for a period separate from the
retention of the other night's you will probably need to create a new client
account on the TSM server, and a new Management Class to retain the data.

Then configure the DB2 client to use the special nodename only on a Friday,
and bind the Friday's backup to the new Management Class.

There is no need to create a special "Weekly" storage pool to contain the
data. TSM will happily track the retention of your "normal" DB2 backups, and
"Friday" DB2 backups, in the same storage pool, and even on the same tape/s.

Your system should look _something_ like the following:

Nodename                        Day of week     Mgmt Class      StgPool
---------------                 ------------------      ------------------      
-------------
NODE_DB2                SMTWT-S         DB2                     DB2POOL
NODE_DB2_FRI    Friday          DB2_FRI         DB2POOL

This is necessary because (if I remember correctly) DB2 saves it's backups as
a combination of *consistently named* "Backup" objects for data and "Archive"
objects for logs. You can't just change the Management Class used for
Friday's backup without effecting the retention of the "backup" objects saved
from previous DB2 backups (if they belong to the same client account).

You probably also want to ensure the Friday backup is a "full" DB2 backup...

Remember, storage pools "contain" data, Management Classes "retain" data.

Regards,
Steven P.

--
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