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
------------------------------
Original Message:
Sent: Mon April 22, 2024 04:17 PM
From: Freddie Callander
Subject: DMC ERD
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
------------------------------