CDC Troubleshooting

CDC Clear Staging Store

ERROR:

Source functionality is disabled due to a configuration error. If you have resolved the problem, you should restart IBM InfoSphere Change Data Capture.

This instance of IBM InfoSphere Change Data Capture uses 47 GB as the staging store disk quota. However, there is only 46539 MB free space on /CDCstage. The staging store has used 2 MB. Please free up more disk space and restart IBM InfoSphere Change Data Capture.

It can be also recommended action from IBM.

Solution: Clear Staging Store

Before clearing staging store all subscriptions should be stopped

cd /opt/IBM/InfoSphereChangeDataCapture/ReplicationEngineforOracle/bin

./dmclearstagingstore -I DBNAME

echo $?

Stop IBMCDC

Start IBMCDC

Check logs in /CDCstage/instance/DBNAME/log