ADSM-L

Re: DB2 backups with multiple DB's on one host

2003-11-17 14:37:43
Subject: Re: DB2 backups with multiple DB's on one host
From: Bill Boyer <bill.boyer AT VERIZON DOT NET>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Mon, 17 Nov 2003 14:37:24 -0500
I just wrote a script to set the password:

wboyer@tivtec1:/db2/tsm$ cat setpw.sh

export DSMI_CONFIG=/db2/${1}/tsm/dsm.opt
export DSMI_DIR=/usr/tivoli/tsm/client/api/bin
export DSMI_LOG=/db2/${1}/tsm
cd /db2/${1}/sqllib/adsm
./dsmapipw

wboyer@tivtec1:/db2/tsm$

-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU]On Behalf Of
asr AT UFL DOT EDU
Sent: Monday, November 17, 2003 2:03 PM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Re: DB2 backups with multiple DB's on one host


=> On Mon, 17 Nov 2003 09:35:50 -0500, Bill Boyer <bill.boyer AT VERIZON DOT 
NET>
said:


> What I did to backup a DB2 server on AIX that had 4 instances:

[1. 2. ...] Dang, I was just going to say that.

We've got some 70 instances on two system images, in support of our
PeopleSoft
installation, so we do this a _LOT_.


> 6. Set the password. Since this needs to be run as "root", you need to
> export the DSMI_CONFIG variable pointing to the correct instances' DSM.OPT
> file. Then run the $HOME/sqllib/adsm/dsmapipw program.

Anther possible method for this;

if you have server instance

DB2BACK_SOMEINSTANCE

in your dsm.sys, you can run


dsmc q sess -se=DB2BACK_SOMEINSTANCE

and you'll do a password setting transaction there too.

That invocation may be more natural to the more TSM-y (as opposed to DB2-y)
of
your admins.


- Allen S. Rout

<Prev in Thread] Current Thread [Next in Thread>