The nzdr command
With the nzdr command, you can configure and manage your replication software on Netezza Performance Server that supports Cloud Pak for Data System 1.0.8.0 and later.
Syntax
The nzdr command uses the following syntax.
./nzdr [-h] subcommand [subcommand options]
Inputs
The nzdr command takes the following inputs.
| Input | Description |
|---|---|
| nzdr add [node|db] | Adds configurations for a specified node or database. |
| nzdr alert[list|ack] | Displays alert related information or acknowledges alerts. |
| nzdr list [node|db] | Lists configurations for a specified node or database. |
| nzdr update [node|db] | Updates configurations for a specified node or database. |
| nzdr delete [node|db] | Deletes configurations for a specified node or database. |
| nzdr status [node|db] | Displays the general status or for a specified node or database. |
| nzdr replicate | Submits new replication jobs on demand or displays job status. |
| nzdr replication [start|stop] | Starts or stops a replication activity on a specified node. |
| nzdr failover | Performs failover for a specified database. |
| nzdr version | Lists the replication version for a specific node or all nodes. |
| nzdr change [role] | Change the roles of the nodes in the database. |
| nzdr job [-h] |
Parameters
| Command | Parameter | Description |
|---|---|---|
|
nzdr add node |
--node-name | Specifies the name of the node that you want to add. |
| --host-name | Specifies the name of the host, on which the node is. | |
| --capture-interval |
Specifies capture interval. Replication interval in minutes, must be greater than 180 minutes.
Set to 0 to disable scheduled backups. Ad hoc backups can still be triggered manually.
Note:
|
|
| --repl-user | Optional. Specifies the name of the replication user for which you want to register the credentials so that the user can be used for capture and apply procedures. | |
| --repl-user-password | Optional. Specifies the password for the replication user. | |
| nzdr alert list | --all | Optional. Specifies that you want to view all of the alerts, including the closed ones, that are generated on the current system. |
| --id | Optional. Specifies alert ID for which you want to view alert information. | |
| nzdr alert ack | --all | Optional. Specifies that you want to close all of the alerts that are generated on the current system. |
| --id | Optional. Specifies the ID of the alert that you want to close. | |
|
nzdr list node |
-j | Optional. Returns a json formatted output of the node information. |
| --node-name | Specifies the name of the node that you want to list information for. | |
| nzdr update node | --node-name | Specifies the name of the node that you want to update. |
| --capture-interval |
Specifies capture interval. Replication interval in minutes, must be greater than 180 minutes.
Set to 0 to disable scheduled backups. Ad hoc backups can still be triggered manually.
Note:
|
|
| --repl-user | Optional. Specifies the name of the replication user for which you want to register the credentials so that the user can be used for capture and apply procedures. | |
| --repl-user-password | Optional. Specifies the password for the replication user. | |
| nzdr delete node | --node-name | Specifies the name of the node that you want to delete. |
| nzdr status node | --node-name | Specifies the name of the node that you want to get status. |
|
nzdr add db |
--db-name | Specifies the name of the database that you want to add. |
| --primary-node | Specifies the primary node. | |
| --replica-nodes | Specifies the replica node or nodes. | |
| --db-full-backupset-id | Specifies the full backup set ID of a databases. | |
| --capture-interval |
Specifies capture interval. For 3.0.0.0, the minimum required capture interval is 180. Starting with 3.0.1.0, the minimum required capture interval is 30. The suggested capture interval is 180 minutes. If you need to set a value lower than 180 minutes, use the --force option. If you want the database to take the replication interval of the node, set this value to -1. You can change the replication interval for any of the replication nodes by logging in to any of the systems that participate in replication. |
|
| --force |
Optional. Force apply a capture interval that is less than 180 minutes, but cannot be less than 30 minutes. |
|
| nzdr list db | --db-name | Specifies the name of the databases that you want to list information for. |
| -j | Optional. Returns a json formatted output of the node information. |
|
| nzdr update db | --db-name | Specifies the name of the databases that you want to update. |
| --capture-interval |
Specifies capture interval. For 3.0.0.0, the minimum required capture interval is 180. Starting with 3.0.1.0, the minimum required capture interval is 30. The suggested capture interval is 180 minutes. If you need to set a value lower than 180 minutes, use the --force option. If you want the database to take the replication interval of the node, set this value to -1. You can change the replication interval for any of the replication nodes by logging in to any of the systems that participate in replication. |
|
| --force |
Optional. Force apply a capture interval that is less than 180 minutes, but cannot be less than 30 minutes. |
|
| nzdr delete db | -h, --help | Optional. Shows help message and exit. |
| --db-name db-name | Specifies the name of the databases that you want to delete. | |
| --force | Do a forced delete operation of the databases. | |
| nzdr status db | -h, --help | Optional. Shows help message and exit. |
| --db-name db-name | Required. Name of databases. | |
| --details | Required. Display detailed status information of all databases. | |
| --show-all | Required. Display all summary information of all databases. | |
| -j | Optional. Returns a json formatted output of the node information. |
|
| nzdr replication start | --node-name | Specifies the name of the nodes that you want to start. |
| nzdr replication start | --db-name | Start replication on both primary and replica for specified databases. |
| nzdr replication start |
--db-name --node-name |
Start replication on specified nodes for specified databases. |
| nzdr replication stop | -h, --help | Optional. Shows help message and exit. |
| --db-name db-name | Name of replication db | |
| --node-name node-name | Name of replication node. | |
| --force | Force stop replication operation. | |
| nzdr replication | -h | Optional. Shows help message and exit. |
| start | Start scheduler for replication. | |
| stop | Stop scheduler for replication. | |
| {start, stop} | Start or stop scheduler for replication. | |
| --node-name --db-name | Name of the replication nodes and replication databases. | |
| --force | Force stop replication operation. | |
| nzdr replicate | -h, --help | Optional. Shows help message and exit. |
| --node-name node-name | Required. Specifies the name of the nodes where the databases are primary. | |
| --db-name db-name | Required. Specifies the name of the databases that you want to replicate. | |
| nzdr failover | --node-name | Specifies the name of the nodes, which is a replica for a specific database. |
| --db-name | Specifies the name of the databases that needs to be failed over. | |
| nzdr change role | -h, --help | Optional. Shows help message and exit. |
| --node-name node-name | Required. Name of the replica node for the databases role that needs to be changed. | |
| --db-name db-name(s) | Required. List of comma separated databases for which role needs to be changed. | |
| --role-type role-type | Required. The new role for which the database should be changed to. The allowed value is
primary. |
|
| --begin | Optional. Start role reversal. | |
| --end | Optional. Complete role reversal. | |
| nzdr job | -h, --help | Optional. Shows help message and exit. |
| --node-name node-name | Required. Name of node where job was submitted | |
| --job-id job-id | Required. Job id of the job submitted by the user. |