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