Use the nzhostbackup command to back up the IBM® Netezza® data directory and system catalog on the host.
In the rare situations when a Netezza host server or disk fails, but the SPUs and their data are still intact, you can restore the /nz/data directory (or whatever directory you use for the Netezza data directory) from the host backup without the additional time to restore all of the databases. For more information, see Host backup and restore.
If you run the nzhostbackup command, then change a user's password and then run the nzhostrestore command, the old password is replaced.
nzhostbackup [-g GRACE_PERIOD] [-D DATA_DIR] FILE
nzhostbackup -h
Input | Description |
---|---|
FILE | Specifies the path name of the archive file that you want to create. This file is a compressed tar file. |
nzhostbackup -h | Displays online help for this command. |
nzhostbackup -g GRACE_PERIOD | Specifies the maximum time to wait (in seconds) for queries (or any system action, such as a load) to finish before the system begins the backup. After the system waits this amount of time, it cancels any remaining queries and starts the backup. The default is 60 seconds. |
nzhostbackup -D DATA_DIR | Specifies the path name of the system data directory to back up. The default is the NZ_DATA_DIR, which is usually /nz/data. |
In addition, if you unset NZ_DIR and NZ_KIT_DIR and then run the nzhostbackup backup_dir command, the command works because it internally determines the location of NZ_KIT_DIR, NZ_DIR and NZ_DATA_DIR.
nzhostbackup /home/host/backup.tar.gz
nzhostbackup -g 300 /home/host/backup.tar.gz