IBM PureData System for Analytics, Version 7.1

Changing default passwords

Use the following instructions to change the default passwords.

Changing passwords for operating system users

To change a password for the root and nz operating system users, run the passwd Linux command. No other steps are required.

Changing passwords for database users

The NPS® data warehouse has three users that are created by default, admin, histuser, and histdbowner.

Procedure

To change the admin password:
1. Log in as nz to the NPS virtual machines.
2. Use nzsql to change the password:
```
nzsql system –c "alter user admin with password '<new_password>'"
```
3. Change the password in the NZ_PASSWORD variable that is defined in /home/nz/.bashrc, or remove NZ_PASSWORD from that file completely, and use nzpassword command to securely store new password:
```
nzpassword add -u admin -pw <new_password>
```
To change the histdbowner password:
1. Log in as nz to the NPS virtual machines.
2. Use nzsql to change the password:
```
nzsql system –c "alter user histdbowner with password '<new_password>'"
```

To change the histuser password:

Use nzsql to change the password:

nzsql system –c "set history configuration no_hist"
nzstop
nzstart
nzsql system –c "alter user histuser with password '<new_password>'"
nzsql system –c "alter history configuration all_hist password '<new_password>'"
nzsql system –c "set history configuration all_hist"
nzstop
nzstart

Changing passwords for IBM® Netezza Performance Portal users

You can change the default password for the Netezza® Performance Portal user in the portal itself.

Procedure

Open the Netezza Performance Portal at https://<nps_host_address>.
Log in with the admin credentials.
Open the Portal Administration tab and click Change Password.
Complete the required information and click OK.