Db2

Db2

Where DBAs and data experts come together to stop operating and start innovating. Connect, share, and shape the AI era with us.


#Data


#Data
#Databases
#Operatingsystems
#Db2
#Databasesolutions
 View Only

  • 1.  DMC ERD

    Posted 04/22/24 04:18 PM

    Is there an ERD available for the DMC schema?  Trying to figure out what tables have data pulled in from the various setting on event monitors and the generic monitoring DMC does.



    ------------------------------
    Freddie Callander
    ------------------------------


  • 2.  RE: DMC ERD

    Posted 04/23/24 03:52 AM

    Hi, 

    DMC does not provide an official ERD for its schema/table in repository database. To understand the metrics provided by DMC, you can refer to this KC topic.

    Monitoring Metrics

    Ibm remove preview
    Monitoring Metrics
    You can use the IBM Db2 Data Management Console console for database monitoring and also effectively monitor your database performance by using one or more of the key performance indicators, known as metrics. The console provides the following metric types for monitoring the performance of your database.
    View this on Ibm >

    DMC does provide method to integrate with 3rd tool to analyze the monitoring data. 

    Analyzing Db2 monitoring data from Data Management Console with Splunk

    Ibm remove preview
    Analyzing Db2 monitoring data from Data Management Console with Splunk
    Analyze Db2 LUW monitoring data from Data Management Console, DMC, with Splunk.
    View this on Ibm >



    ------------------------------
    Su Li Hou
    ------------------------------



Related Content