Checking IBM InfoSphere Change Data Capture replication status

Queries might not be routed to shadow tables if InfoSphere CDC replication stops.

Procedure

To ensure that InfoSphere CDC replication is active:

Log in to the cdc-server-host as a cdc-user .
Change to the bin folder for the InfoSphere CDC for Db2® for LUW by issuing the following command:
```
$ cd /cdc-installation-dir/bin
```
Check the status of the InfoSphere CDC subscription by issuing the dmgetsubscriptionstatus command as follows:
```
./dmgetsubscriptionstatus -I cdc-instance-name -s subscriptionName
```
If replication is active, the state for the subscription is running.
Check the status of the InfoSphere CDC datastore objects by issuing the dmgetstagingstorestatus command as follows:
```
./dmgetstagingstorestatus -I cdc-instance-name
```
This command returns a summary of how many subscriptions are running, disk space usage, and availability.
Check the InfoSphere CDC event log for errors that might affect replication by issuing the dmshowevents command as follows:
```
./dmshowevents -I cdc-instance-name -a
```
If replication is not running, try to restart it by issuing the dmstartmirror command as follows:
```
./dmstartmirror -I cdc-instance-name -s subscriptionName
```