IBM Support

Changing database password using IBM Data Studio

Product Documentation


Abstract

A new feature has been designed that allows changing a password of the database server directly from IBM Data Studio. This will avoid a user to log in to the database server, and then change the password from within the server. The user can directly change the password from Data Studio.

Content

Note: 

  • As of now, this feature is only available for Db2 LUW SSL and non-SSL servers and Db2 for z/OS.
  • PTF UI58954 should be installed on zos for the password change feature to work for Db2 for z/OS.

 

Procedure

  1. Open IBM Data Studio.
  2. In the Administer Databases window, right-click the database for which you want to change the password, select Manage Connection > Change Database Password.

    Administer Databases

    After you selected Change Database Password, the Change Password for the Database window opens. This window displays the connection profile for which the password can be changed.

    Change password for the Database

    You can see the user name in the User name and old password are in the Old Password field.

  3. Enter a new password and re-enter the new password to verify if you have entered correct password.

    There is no client-side validation for new password only validation it has that should not be same as old password. If the password is same, then an error is displayed.

    If confirm new password is not same as new password, then an error is displayed to indicate that new password and confirm new password do not match.

    The following two images shows these scenarios:

    Connection profile

    Password does not match

    Unless all the criteria are met, the Apply button remains disabled.

    All other password validations, such as password rules are done on the server side. If any error occurs on server side, an error message is displayed as shown in the following image:

    Password error

    After you successfully change the password, a success message is displayed.

    Password success

 

 

[{"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SS62YD","label":"IBM Data Studio"},"Component":"","Platform":[{"code":"PF016","label":"Linux"},{"code":"PF033","label":"Windows"}],"Version":"4.1.3","Edition":"APAR 2","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
10 December 2018

UID

ibm10715949