Run the nzdr command with the update option to update
the capture interval.
By default, the capture time interval on each Cloud Pak for Data System is set to 180 minutes. As
a result, database changes are captured on the primary Cloud Pak for Data System and applied on the
replica Cloud Pak for Data System every 180 minutes.
For 3.0.0.0, the minimum capture time interval is 180 minutes. Starting from 3.0.1.0, the minimum
capture interval is 30.
You can change the capture interval for any of the replication nodes by logging in to any of the
systems that participate in replication.
Procedure
-
Log in to the Netezza Performance Server host
container as the
nz user on one of the replication nodes.
ssh nz@APPLIANCE HOSTNAME -p 51022
- View details for a specific node.
./nzdr list node --node-name NODE NAME
Example:
[nz@sbpoc06a-npshost nrs]$ ./nzdr list node --node-name CPDS-A
+-------------+---------------------+-------------------+
| node-name | host-name | capture-interval |
+=============+=====================+===================+
| CPDS-A | sbpoc06.svl.ibm.com | 180 |
+-------------+---------------------+-------------------+
- Change
capture-interval to a value that you want.
./nzdr update node --node-name NODE NAME --host-name HOST NAME --capture-interval CAPTURE INTERVAL
Example:
[nz@e1n1-npshost nrs]$ ./nzdr update node --node-name CPDS-A --host-name os.apps.customer_domain.customer.com --capture-interval 1500
Successfully updated configurations for node CPDS-A.
In the example, the interval was changed to 1500 minutes.
- Verify whether the interval is changed.
./nzdr list node
Example:
[nz@sbpoc06a-npshost nrs]$ ./nzdr list node
+-------------+---------------------+-------------------+
| node-name | host-name | capture-interval |
+=============+=====================+===================+
| CPDS-A | sbpoc06.svl.ibm.com | 1500 |
+-------------+---------------------+-------------------+
| CPDS-B | sbpoc01.svl.ibm.com | 180 |
+-------------+---------------------+-------------------+