When you restart the PwxCDCPublisher utility with the RESTART=FROM_END parameter, the CDC Publisher does not set the checkpoint to the end-of-log position. The checkpoint is updated only when the CDC Publisher sends change data to the target. If no change data is sent, the recorded checkpoint remains unchanged. In this situation, the next time you restart the utility, it starts from the last recorded checkpoint instead of from the end-of-log position that was requested for the previous restart.

Workaround: If you want to restart PwxCDCPublisher utility from the previously requested end-of-log position, specify RESTART=FROM_CONFIG and use the Extract.restart1 and Extract.restart2 properties to specify the restart point.

The PowerExchange CDC Publisher does not automatically exclude extraction maps that are associated with capture registrations that have the status of Inactive, History or Suspended. The CDC Publisher will not publish change data based on these extraction maps for the registered source objects.

Workaround: You can exclude the extraction maps from CDC Publisher processing to reduce resource consumption by using the Extract.captureConsumerExcludeNameList configuration property. First ensure that any change data that was previously captured for the source object has been published to the target messaging system. Then define the exclusion filter and restart the CDC Publisher process.