Submitting manual replication jobs for specified databases

Run the nzdr command with the replicate option to submit a manual replication job.

Instead of waiting for the scheduled interval of the replication, run the nzdr command with the replicate option to submit a manual replication job for a specified database at any time. The nzdr replicate command captures database changes that happened since the last capture and syncs the replicas immediately.
Note: You can submit only one replication job at any point in time. If you need to submit another request, wait until the previous job completes.

Procedure

  1. Log in to the Netezza Performance Server container as the nz user. 
    ssh nz@APPLIANCE HOSTNAME -p 51022
  2. Run the nzdr command with the replicate subcommand to submit a replication job for a specified database. 
    nzdr replicate --node-name NODE NAME --db-name DATABASE
    Example:
    • Submitting a job for one database:
      nzdr replicate --node-name CPDS-A --db-name REPL_DB_1

Successfully submitted a replication job with id 1 for database(s): REPL_DB_1.
You may monitor the status of this job via 'nzdr replicate --node-name CPDS-A --job-id 1'
    • Submitting a job for two databases:
      nzdr replicate --node-name CPDS-A --db-name REPL_DB_1,REPL_DB_2

Successfully submitted a replication job with id 2 for database(s): REPL_DB_1,REPL_DB_2.
You may monitor the status of this job via 'nzdr replicate --node-name CPDS-A --job-id 2'
    Tip: Note the ID number of the replication job. You might need it if you want to monitor the replication status of the job. See: Monitoring status of submitted jobs.
    CAUTION:
    Do not delete the database from the replication when the job-status is in the running state.