Changing passwords on a remote Db2 server

If your Cloud APM server uses a remote Db2 server on an external system, you must complete this procedure to change the Db2 user passwords on the Db2 server and configure the Cloud APM server with the updated itmuser password. These steps differ slightly to the steps for changing Db2 user passwords on the Cloud APM server that is connected to the default local Db2 server.

Complete the following steps as the root user:

1. Stop all the Cloud APM server components by entering the following command:

   apm stop_all

2. On the system where you installed the Db2 server, enter the passwd command followed by the user name of the Db2 user whose password you want to change.
   • For the external_db2_instance user, enter passwd external_db2_instance

     where external_db2_instance is the remote Db2 server instance user name that you created when you set up the remote Db2 server.

   • For the itmuser, enter passwd itmuser
3. On the system where you installed the Cloud APM server, run the db2_users_passwd.sh script to change the itmuser password to match the password you configured for that user on the remote Db2 server:

   install_dir/ccm/db2_users_passwd.sh itmuser

   where install_dir refers to the directory where the Cloud APM server is installed. The default installation directory is /opt/ibm.

   The db2_users_passwd.sh script changes the password of itmuser on the system where the Cloud APM server is installed, updates the Cloud APM server configuration with the modified password, and restarts the Cloud APM server. The script does not verify that the password can be used to connect to the remote Db2 server. Therefore, you must ensure the password matches the password of itmuser on the remote Db2 server.

4. The db2apm user exists on the system where you installed the Cloud APM server and is used with the Db2 client on that system. Its password is independent of the Db2 instance user password on the remote Db2 server. If you need to change the password of the db2apm user on the Cloud APM server, run the db2_users_passwd.sh script:

   install_dir/ccm/db2_users_passwd.sh db2apm

   The db2_users_passwd.sh script changes the password of the db2apm user and updates the Cloud APM server with the modified password. The Cloud APM server is not restarted when you change the db2apm password.