Redirect a restore

Deployment options: Netezza Performance Server for Cloud Pak for Data System

Typically, you restore a backup to the same Netezza host from that it was created. If you want to restore a backup that was created on one Netezza Performance Server host to a different Netezza Performance Server host, you must adjust the proxy settings.

For example, assume that you have a Netezza Performance Server host named NPSA, for which you defined a client node named “NPSA NPS” and a proxy node named NPSA on the Tivoli® Storage Manager server. Assume also that there is a backup file for the NPSA host on the Tivoli Storage Manager server.

If you want to load the backup file onto a different Netezza Performance Server host named NPSB, then you must first ensure that NPSB is registered as a client to the Tivoli Storage Manager server. Assume that there is a client node for “NPSB NPS” and a proxy node named NPSB for this second host.

To redirect the restore file from NPSA to NPSB, you must grant the client node “NPSB NPS” proxy authority over the proxy node NPSA. After you grant the proxy authority to “NPSB NPS”, you are able to restore the backup for NPSA to the NPSB host by using a command similar to the following command:

nzrestore -db database -connector tivoli -npshost NPSA

The value database is the name of the database that was backed up from the Netezza Performance Server host NPSA.