Results 1 to 3 of 3
03-16-2010, 12:35 PM #1
How to? Two TSM nodes for one instance
I have a db2 instance on an AIX server. This instance is the only one on that server and it is backed up 6 days online and Saturdays offline. I am supposed to retain Saturday's offline backup for 52 weeks.
The offline backup is a db2 offline backup, initiated with "db2 backup db use tsm" command. An offline file backup with db2stop and dsmc incremental is not the direction we want to go.
At the moment I am not using passwordaccess generate to reach TSM, but values on db2 configuration, such as TSM_MGMTCLASS, TSM_NODENAME, TSM_OWNER, TSM_PASSWORD.
The question is how do I set up TSM so that I retain daily backups 30 days and weekly backups 52 weeks?
tsm v18.104.22.168 Server
tsm v22.214.171.124 Client
03-16-2010, 03:42 PM #2
- Join Date
- Oct 2008
- Thanked 0 Times in 0 Posts
It has been a while since I've done this so it may not be exactly correct, but should lead you down the right path.
Create a node_name on the TSM Server for the "Weekly" backups (ie db2node_weekly. Then, create a 2nd dsm.opt file that matches this server_name as well as a stanza in the dsm.sys that is configured to match. You can then setup DSMI env variables via either script or profile that references this 2nd dsm.opt file, which will then reference the weekly stanza in the dsm.sys
You should be able then invoke this profile and run a db2 backup to against this weekly node name.
03-16-2010, 05:47 PM #3
Ok, so I should make a script that says
db2 backup db dbname use tsm
But don't I need a db2 stop start in order to make those environment variables recognized by db2?
By adsmsuser in forum TSM ServerReplies: 2Last Post: 03-15-2010, 06:28 AM
By diegoach81 in forum TSM ServerReplies: 2Last Post: 11-03-2008, 06:24 PM
By hellow123 in forum TSM ServerReplies: 1Last Post: 11-10-2007, 02:08 AM
By kabousv in forum TSM ServerReplies: 2Last Post: 02-09-2007, 07:10 AM
By ja954 in forum TSM ServerReplies: 1Last Post: 06-28-2005, 12:09 PM