We have just bagged in a new project and we are running through the initial phase. I am trying to search a table which is replicating in IIDR from a long list of subscriptions. Do we have a metadata database where we can query in for the details related to all subscriptions with their source and target tables and other information related to that ?
Answer by Rphilo (1236) | Dec 06, 2018 at 09:57 AM
Hello Abhisek
An answer applicable to virtually all environments is use CHCCLP scripting (or Java APIs) to list all source/target table mappings by subscription
However what might be easier is use Management Console/Configuration perspective/DataStores (select source datastore)/Replication Tables/(select table of interest)/properties/Subscriptions/Search
CDC for iSeries holds its metadata in DB2/400 data files, and CDC for zSeries holds its metadata in DB2/z tables. These can be queried but their use is not documented. CDC for LUW holds it metadata in internal Pointbase databases embedded in the filesystem with the rest of the instance data. So the CDC metadata is not really accessible for this sort of thing, sadly