I have an AIX server that is used as our DB2 server. Our users do not have the ability to login to that machine as the only thing it does is serve up DB2. We need to have the ability to change the users password from Toad. We can install the DB2 client to allow the user to change passwords, but that is just one more thing for the users to maintain. They would have to setup their DB2 catalog in there, and then they have to remember how to use the tool, etc.
I have tried from the SQL window to use the db2 connect command to change it, but I get an error doing that.
**connect to** *db* **user** *userid* **using** *password* **new** *new passowrd* **confirm** *new password*
Is there a way to do this in Toad for DB2 and I just have not found it yet?