If you must change your System i password periodically, use the following steps:
- In Connect CDC MonCon:
- Open the model
- Select View > Process.
- Right-click the Change Selector and select “Stop All”.
- Wait for the replication queues to empty. To verify, use the SQL editor
and enter the following SQL
statements:
SELECT COUNT(*) FROM <metabase_library>.rp_trans; SELECT COUNT(*) FROM <metabase_library>.rp_log;
When the results are 0 (zero), you may proceed to the next step.
- Right-click Connect CDC Kernel and select “Shutdown All”.
- Change password on the iSeries.
- In Connect CDC Director:
- Open the model.
- Change the password in the Server Properties page.
- Test connection.
- Validate model.
- Commit the model.
- In Connect CDC MonCon:
- Select View > Model Update.
- On the Advanced tab, select Force Version Change.
- After the model update, select View > Process.
- Right-click Processes and select Start All Kernels.
The kernels, requests, and change selector(s) all start.