Change the database password

Use the Xdbconnect utility to change the database passwords.

Xdbconnect collects Process Engine runtime (f_sw or its alias) and Process Engine maintenance (f_maint or its alias) passwords, encrypts them, and stores them in /fnsw/local/sd/rdbup.bin. When Process Engine needs to connect to database, it extracts the password from /fnsw/local/sd/rdbup.bin, and decrypts it to construct the connection.

Xdbconnect changes the password in the database for SQL and Oracle, and also changes the binary encrypted password file that Process Engine uses.

For DB2, the OS users (f_sw, f_maint or their aliases) must change their passwords; Xdbconnect only changes the encrypted file with new passwords. The password entered via Xdbconnect must match the password for OS users on the DB2 server.

To change the password using Xdbconnect

For Oracle and SQL

  1. Run Xdbconnect -r
  2. Enter the user password (the default is SysAdmin).

    Xdbconnect displays windows for all database accounts with passwords you can modify.

  3. Click Change.
  4. Enter and confirm the new password.
  5. Click OK.

    /fnsw/local/sd/rdbup.bin is updated with the new password.

    This also changes Process Engine user passwords in the database.

  6. Exit Xdbconnect.

For DB2

The passwords for OS users used as Process Engine runtime or maintenance must be changed by OS users or the system administrator.

  1. Run Xdbconnect -r
  2. Enter the password for the SysAdmin user.

    Xdbconnect displays windows for all database accounts with passwords you can modify.

  3. Click Change.
  4. Enter and confirm the new password for either the runtime (f_sw) or maintenance (f_maint) passwords.
  5. Click OK.

    The new password overrides the existing Process Engine primary password. You can then optionally enter a new secondary password.

  6. Exit Xdbconnect.

    For DB2, you can run this procedure before or after changing the password on the DB2 server for Process Engine runtime and maintenance accounts (Operating System accounts).

The password is encrypted and saved in /fnsw/local/sd/rdbup.bin. In a farm environment, you must set the password on each server in the farm. You can also copy the rdbup.bin once created from one server to the rest of the servers in the farm to avoid mistyping the password.