• United States
IBM?
  • Site map
IBM?
  • Marketplace

  • Close
    Search
  • Sign in
    • Sign in
    • Register
  • IBM Navigation
IBM Developer Answers
  • Spaces
    • Blockchain
    • IBM Cloud platform
    • Internet of Things
    • Predictive Analytics
    • Watson
    • See all spaces
  • Tags
  • Users
  • Badges
  • FAQ
  • Help
Close

Name

Community

  • Learn
  • Develop
  • Connect

Discover IBM

  • ConnectMarketplace
  • Products
  • Services
  • Industries
  • Careers
  • Partners
  • Support
10.190.13.195

Refine your search by using the following advanced search options.

Criteria Usage
Questions with keyword1 or keyword2 keyword1 keyword2
Questions with a mandatory word, e.g. keyword2 keyword1 +keyword2
Questions excluding a word, e.g. keyword2 keyword1 -keyword2
Questions with keyword(s) and a specific tag keyword1 [tag1]
Questions with keyword(s) and either of two or more specific tags keyword1 [tag1] [tag2]
To search for all posts by a user or all posts with a specific tag, start typing and choose from the suggestion list. Do not use a plus or minus sign with a tag, e.g., +[tag1].
  • Ask a question

I am trying to search table which is replicating in IIDR from a long list of subscriptions. Do we have a metadata dataase where we query in for the details related to all subscriptions with their source and target tables and other information ?

550001SUME gravatar image
Question by Abhisek_Bahinipati  (3) | Dec 06, 2018 at 05:26 AM subscriptioniidr

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 ?

People who like this

  0
Comment
10 |3000 characters needed characters left characters exceeded
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster

2 answers

  • Sort: 
2700013TF4 gravatar image

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

Comment
Abhisek_Bahinipati

People who like this

  1   Share
10 |3000 characters needed characters left characters exceeded
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
270001GKBD gravatar image

Answer by Glenn Steffler (26) | Dec 06, 2018 at 03:03 PM

https://www.ibm.com/support/knowledgecenter/en/SSTRGZ_11.3.0/com.ibm.cdcdoc.chcclp.doc/refs/listtablemappings.html

Comment

People who like this

  0   Share
10 |3000 characters needed characters left characters exceeded
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster

Follow this question

154 people are following this question.

Answers

Answers & comments

Related questions

In IIDR CDC Is staging store per subscription? Why staging store size keep on growing and it reached 100%? 1 Answer

How can IBM IIDR write in Avro or Json to Kafka Topic? 3 Answers

One of my production Subscription was somehow deleted from the management Console. Is there a way to check or retrieve the deleted subscription from log or the metadata ? 1 Answer

Update table definition is not available in th Management consoles 0 Answers

How to deploy an IBM Filenet P8 Subscription? 1 Answer

  • Contact
  • Privacy
  • IBM Developer Terms of use
  • Accessibility
  • Report Abuse
  • Cookie Preferences

Powered by AnswerHub

Authentication check. Please ignore.
  • Anonymous
  • Sign in
  • Create
  • Ask a question
  • Spaces
  • API Connect
  • Analytic Hybrid Cloud Core
  • Application Performance Management
  • Appsecdev
  • BPM
  • Blockchain
  • Business Transaction Intelligence
  • CAPI
  • CAPI SNAP
  • CICS
  • Cloud Analytics
  • Cloud Automation
  • Cloud Object Storage
  • Cloud marketplace
  • Collaboration
  • Content Services (ECM)
  • Continuous Testing
  • Courses
  • Customer Experience Analytics
  • DB2 LUW
  • DataPower
  • Decision Optimization
  • DevOps Services
  • Developers IBM MX
  • Digital Commerce
  • Digital Experience
  • Finance
  • Global Entrepreneur Program
  • Hadoop
  • Hybrid Cloud Core
  • IBM Cloud platform
  • IBM Design
  • IBM Forms Experience Builder
  • IBM Maximo Developer
  • IBM StoredIQ
  • IBM StoredIQ-Cartridges
  • IIDR
  • ITOA
  • InformationServer
  • Integration Bus
  • Internet of Things
  • Kenexa
  • Linux on Power
  • LinuxONE
  • MDM
  • Mainframe
  • Messaging
  • Node.js
  • ODM
  • Open
  • PowerAI
  • PowerVC
  • Predictive Analytics
  • Product Insights
  • PureData for Analytics
  • Push
  • QRadar App Development
  • Run Book Automation
  • Search Insights
  • Security Core
  • Storage
  • Storage Core
  • Streamsdev
  • Supply Chain Business Network
  • Supply Chain Insights
  • Swift
  • UBX Capture
  • Universal Behavior Exchange
  • UrbanCode
  • WASdev
  • WSRR
  • Watson
  • Watson Campaign Automation
  • Watson Content Hub
  • Watson Marketing Insights
  • dW Answers Help
  • dW Premium
  • developerWorks Sandbox
  • developerWorks Team
  • Watson Health
  • More
  • Tags
  • Questions
  • Users
  • Badges