Change database passwords used by WebSphere Portal

If database passwords are modified or expired, we must specify the new passwords on the WAS and on the IBM DB2 Universal Database™ Enterprise Server Edition server so that IBM WebSphere Portal can access them.

• Verify the administrative server for WebSphere Application Server is running.

• If this server is a clustered environment, we must have the Deployment Manager and the nodes up and the WebSphere Portal server stopped.

• If the VMM is using the database, see Change the password for a repository under a federated repositories configuration in the related links for instructions on updating the VMM database password.

1. Check whether the database user was disabled because of invalid login attempts.

   Re-enable the database user if necessary.

2. Update the data sources for WebSphere Portal:

   1. Log in to the WAS admin console.

   2. Click...
      Security | Global security | Java Authentication and Authorization Service | J2C Authentication Data

   3. Select the alias that we want to change; for example:
      • wpsDBAuth
      • jcrDBAuth
      • fbkDBAuth
      • lmDBAuth
      • wcmDBAuth

   4. Update the password accordingly.

   5. Click Apply, and then click Save to save the configuration. We are informed that security.xml was changed.

3. If we are an administrator and must change the DB2 password, we must change the database administrator user password on the system.

   1. Stop the DB2 server.

   2. Use the passwd command to change the password.

   3. Restart the DB2 server. We can verify the new password by running the db2 CONNECT TO WPSDB user db2admin using password task.

4. Restart the WAS admin console.

5. On the DB2 server, complete the following steps:

   1. Click Administrative Tools > Services.

   2. Stop all running DB2 services.

   3. For each service the DB2 instance uses, display the menu and select Properties.

   4. Select the Log On tab and change the DB2 administrator's user name and password.
   If we do not change the DB2 administrator's user name and password in the properties of each DB2 service, the DB2 database application does not start.

Results

Repeat for each JDBC Provider, data source, and alias that is affected.

Results:

WebSphere Application Server and WebSphere Portal were updated to use your new database passwords. Verify the WebSphere Portal application server is running by opening the following URL in a browser:

http://hostname.example.com:10039/wps/porta

Parent Update user ID and passwords

Related information

Change the password for a repository under a federated repositories configuration