Deleting replication databases

Run the nzdr command with the delete db subcommand to delete configurations for specified databases.

You can run the command on any of the systems.

About this task

If you are dropping a replicated database from Netezza Performance Server by using nzsql, make sure you also remove it from replication by following this procedure.

Important:

If you are planning to re-add the database with the same backupsetid then ensure the following:

Make sure there are no manual replication jobs for specified databases that are in the running state. To monitor the replication status of the job, see Monitoring status of submitted jobs.
Database is in sync on both replication nodes.
Stop replication for the given database. For more information, see Starting and stopping replication for a given database.

Procedure

Log in to the Netezza Performance Server container as the nz user.
```
ssh nz@APPLIANCE HOSTNAME -p 51022
```
Locate the nzdr utility in the /nrs directory.

Delete databases.

./nzdr delete db --db-name DATABASE NAME

Example:

./nzdr delete db --db-name MYDB2
Successfully deleted replication database MYDB2.

For more information about the nzdr command and its options and parameters, see The nzdr command.