I have created a Registration Group and Extraction Group for change data capture from DB2 on z/OS database. When I try to do a database row test, it does not return any row. I have also confirmed with our DBA that the change data capture has been enabled on that specific table. Could you please let me know if there are any other setting required?
You have to
1) install PWX on the mainframe
2) have the mainframe PWX Listener configured and running to create a capture registration
3) have the mainframe PWX ECCR (change capture), PWX Logger (to log the data), and PWX Agent (to communicate with all the pieces), all up and running.
Then there must be changes that occur on the source DB2 table, so that PWX has something to capture.