Examples of the nz_s3connector command

Deployment options: IBM Netezza Appliance IBM Netezza Appliance

This section demonstrates and discusses sample commands to upload existing backups present on a file system to AWS S3 and IBM COS cloud storage and download backups from AWS S3 and IBM COS cloud storage to a file system on host. This backup can be later restored by using the nzrestore command using filesystem or cloud storage connector.

AWS S3

Upload to AWS S3

$ nz_s3connector -db SRCDB -dir /nzscratch/backups -connectorArgs "UNIQUE_ID=SAMPLEBKUP:ACCESS_KEY_ID=xxxxx:SECRET_ACCESS_KEY=xxxxx:DEFAULT_REGION=us-west-1:BUCKET_URL=my.backup.bucket" -npshost hostname -upload -backupset xxxxx -verbose

Download from AWS S3

$ nz_s3connector -db SRCDB -dir /nzscratch/backups -connectorArgs "UNIQUE_ID=SAMPLEBKUP:ACCESS_KEY_ID=xxxxx:SECRET_ACCESS_KEY=xxxxx:DEFAULT_REGION=us-west-1:BUCKET_URL=my.backup.bucket" -npshost hostname -download -backupset xxxxx -verbose

Note: ENDPOINT is not mandatory. The DEFAULT_REGION used in the commands is just an example. You might need to use different values as per the location of your bucket.

IBM COS

Upload to IBM COS

$ nz_s3connector -db SRCDB -dir /nzscratch/backups -connectorArgs "UNIQUE_ID=SAMPLEBKUP:ACCESS_KEY_ID=xxxxx:SECRET_ACCESS_KEY=xxxxx:DEFAULT_REGION=us-west-1:BUCKET_URL=my.backup.bucket:ENDPOINT=s3.us-east.cloud-object-storage.appdomain.cloud" -npshost hostname -upload -backupset xxxxx -verbose

Download from IBM COS

$ nz_s3connector -db SRCDB -dir /nzscratch/backups -connectorArgs "UNIQUE_ID=SAMPLEBKUP:ACCESS_KEY_ID=xxxxx:SECRET_ACCESS_KEY=xxxxx:DEFAULT_REGION=us-west-1:BUCKET_URL=my.backup.bucket:ENDPOINT=s3.us-east.cloud-object-storage.appdomain.cloud" -npshost hostname -download -backupset xxxxx -verbose

Note: ENDPOINT is mandatory. In the commands, ENDPOINT and DEFAULT_REGION are used as examples. You might need to use different values as per the location of your bucket.