I just wrote a script to set the password:
[EMAIL PROTECTED]:/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
[EMAIL PROTECTED]:/db2/tsm$
-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] Behalf Of
[EMAIL PROTECTED]
Sent: Monday, November 17, 2003 2:03 PM
To: [EMAIL PROTECTED]
Subject: Re: DB2 backups with multiple DB's on one host
=> On Mon, 17 Nov 2003 09:35:50 -0500, Bill Boyer <[EMAIL PROTECTED]>
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
