The nz users sync-from-nps command

Deployment options: Netezza Performance Server for Cloud Pak for Data

When you migrate a database and its users from a source system to a target system, you must synchronize the users between the two systems. Typically, you would run the nzbackup -globals and nzrestore commands to do that. However, on Netezza on Cloud users are managed through Cloud Pak for Data, and all users that are in the Netezza catalog must be also on Cloud Pak for Data.

Therefore, after migration, you must synchronize the users that were migrated and are in the Netezza catalog but not on Cloud Pak for Data by running the nz users sync-from-nps command.

The nz users sync-from-nps command determines which users from the Netezza catalog are not on Cloud Pak for Data, and adds them.

When you are synchronizing users with the nz users sync-from-nps command, you must set a new temporary password for each user that is synchronized because the passwords in the Netezza catalog are encrypted. You cannot decrypt them to plain text. After the nz users sync-from-nps command completes, you can reset the passwords on Cloud Pak for Data to whichever value you want.

Syntax

nz users sync-from-nps [options]

Inputs

Option	Description
-h\|-help	Displays the help message.
-host	Required. Specifies the Cloud Pak for Data hostname of the platform.
-new-pw	Specifies the new password for Cloud Pak for Data users. . You must set a new temporary password for each user that is synchronized because the passwords in the Netezza catalog are encrypted and cannot be decrypted to plain text.
-nps-host	Required. Specifies the NPS hostname.
-print-only	Displays the user or users that need to be synchronized.
-u	Required. Specifies the Cloud Pak for Data user.
-pw	Required. Specifies the Cloud Pak for Data user password `[NZ_PASSWORD]`.

Examples

nz users sync-from-nps -nps-host $NZ_HOST -u $NZ_USER -pw $NZ_PASSWORD -host $CPD_HOST -new-pw <new-pw>

USERNAME  NEEDS TO BE SYNCED  NEEDS TO BE ASSIGNED
--------  ------------------  ---------------------
alice     Y                   Y
bob       Y                   Y

2 users created in CPD
2 users assigned to instance instance-name namespace namespace-name