Backup and restore from PureData System for Analytics

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

You can back up your data from PureData System for Analytics on SAN, and then restore that data on Netezza Performance Server that is installed on Cloud Pak for Data System 1.0.X with one or more connector nodes.

Note: If you are on Cloud Pak for Data System 2.0.X, see Deploying backup and restore setups instead.

Before you begin

The storage volumes must be available and visible from PureData System for Analytics and Netezza Performance Server.

Procedure

On PureData System for Analytics, mount the SAN ext4 file system.
Follow the instructions that are described in Adding SAN storage to PureData System for Analytics.
Important: At step 3. Configuring LVM of the procedure, specify the correct device.
```
pvcreate /dev/mapper/mpathbp1
```
If there is a partition, such as p1, on the device, you must use the partition, not the whole device.

On PureData System for Analytics, after you mounted the storage file system, run nzbackup.

nzbackup -db DATABASE_NAME -dir DIRECTORY -streams STREAMS &

Example:

nzbackup -db BAR70DS_20480B -dir /backup/DB_BACKUP -streams 8 & 
nzbackup -db BAR70DS_5000B -dir /backup/DB_BACKUP -streams 8 &

When the backup is completed, unmount the backup file system on PureData System for Analytics and set this file system on the connector node.
1. Comment out the /etc/fstab line that contains /backup on ha1 (and ha2, if applicable) on PureData System for Analytics.
2. Unmount /backup on ha1 on PureData System for Analytics.
3. Set the file system on the connector node. Follow the steps that are described in Mounting PureData System for Analytics storage to connector nodes.

On Netezza Performance Server, restore the database from the file system backup.

nzrestore -db DATABASE_NAME -npshost NPS_HOST -streams STREAMS &

Example:

nzrestore -db BAR70DS_20480B -dir /external_mount/SAN/DB_BACKUP/ -npshost nps_hostname -streams 8 &