Changing the password for a tuning profile

When you create a tuning profile, the user ID and password for the Db2 for z/OS target database is stored in the repository database. Whenever that password changes, you must update the password for the tuning profile.

About this task

To change the password for a tuning profile, you can either delete existing profile and re-create it with a new password, or you can use the Connections API.

Procedure

To use the Connections API to change the password for a tuning profile, use the following example PUT request and modify it for your tuning profile.

curl -X 'PUT' \
  'https://service_ip:httpsport/tuningservice/v1/connections/{existing_profile_name}' \
  -H 'accept: application/json' \
  -H 'Authorization: Bearer Bearer_token_for_the_SQL_Tuning_Services_ID' \
  -H 'Content-Type: application/json' \
  -d '{
  "collection_cred": {
    "user": "{db2_authid_T}",
    "password": "{new_password}",
    "security_mechanism": "3"
  },
  "host": "{Db2_host}",
  "location": "{location}",
  "port": "{port}"
}'