According to the IBM documentation, it’s not possible to backup and restore a replicated environment because this would break the replication. The /nz/data contains replication information, and the worst aspect of it all is that in the event of restoring a backup, the replication information would be overwritten, breaking the replication.
Perhaps IBM should be looking to move the replication data from the /nz/data and separating it where possible from the Netezza data as a means to keep it isolated ?
Question When running in a Netezza replicated environment, if you attempt to run a hostbackup from a node you will see the following error. nzhostbackup: Error: Host backup/restore is not supported on replicated nodes Cause nzhostbackup: Error: Host backup/restore is not supported on replicated nodes In a replication environment the backup and restoring of the NPS host catalog using ‘nzhostbackup’ & ‘nzhostrestore’ is not supported outside of rare circumstances (ex. migration to a different model system). The reason behind this is because the future restore of an older host backup on an active replication system will never be consistent on all of the replication catalog tables, such as those that contain the CSN.
Answer At a high level, this is a restriction put in place to protect