Changing the repository database user ID and password

You will likely need to change the password for the sqlts_repodb_id at regular intervals based on your password-expiration policies or if you encounter authentication issues with the SQL Tuning Services repository database. Similarly, you might need to assign a different user to the sqlts_repodb_id at some point.

Before you begin

If you are changing the password only, you can proceed directly to the procedure.

If you are assigning a new user to the sqlts_repodb_id, you must first set up the new ID by following the instructions in Setting up the repository database.

If the repository database has already been created by the previous sqlts_repodb_id, you need to grant the required DBADM privilege to the new sqlts_repodb_id by running the following command:

GRANT DBADM ON DATABASE IBMTMSDB TO sqlts_repodb_id_new WITH GRANT OPTION

About this task

To change the sqlts_repodb_id password or to assign a different user to this ID, run the repoDBCredReset.sh script.

Procedure

  1. Stop the SQL Tuning Services server.
  2. Run the wlp_user_dir/repoDBCredReset.sh script to specify a new password, a new user ID, or both.
  3. Restart the SQL Tuning Services server.