Monitoring and exploring Data Virtualization

The Data Virtualization service provides a dashboard for monitoring, managing, and exploring the service instance. This monitoring and exploring dashboard is powered by IBM® Db2® Data Management Console.

1. Click Monitor dashboard > Summary to get an overview of the Data Virtualization service health, based on the following metrics:

   Metric	Description
   Availability	Indicates whether the service is up or down, and the relevant alerts.
   Responsiveness	Indicates whether the system is responding well to the incoming requests.
   Throughput	Indicates how much workload the system is handling.
   Resource usage	Indicates the resource usage of the service in terms of CPU, memory, storage, and log space.
   Time spent	Indicates the percentage of time that is taken for service calls.

2. Click Monitor dashboard > Statement to get performance data about queries executed in Data Virtualization, based on the following metrics:

   Menu option	Description
   In-flight executions	See a list of the SQL statements that are currently running or that ran recently on Data Virtualization. You can use these metrics to identify costly or long running statements. You can cancel individual statements or disconnect a user or application if the statement needs to be stopped.
   Individual executions	Displays the details of executed SQL statements as system activity.
   Package cache	See information about statements that previously ran on Data Virtualization. For example, you can see the number of executions and the total amount of CPU used for these executions. You can use these metrics to identify statements that use a disproportionate amount of system resources.
   Stored procedures	Displays the aggregated execution metrics for procedures, external procedures, compiled functions, external functions, compiled triggers, and anonymous blocks invoked since the service was activated in Db2 Data Management Console.

3. Click Monitor dashboard > Applications to get an overview of the service usage, based on the following metrics:

   Option	Description
   Top consumers	Displays the top consumers of the system resources.
   Connections	See the different users or applications that have open connections to the service. A user or application can open multiple connections. You can use these metrics to find the source of disruptive behavior.

4. Click Monitor dashboard > Throughput to get an overview of query performance, based on the following metrics:

   Option	Description
   Connection summary	Displays a summary of all connections established to the console.
   Partition summary	Displays the information for each data partition used by Data Virtualization.
   WLM workload summary	Represents the accumulation of all metrics for requests that were submitted by connections, and were mapped to the identified workload objects. This metric is based on Workload Manager.
   WLM service class summary	Represents the accumulation of all metrics for requests that have executed under the indicated service subclass.

5. Click Monitor dashboard > I/O to get an overview of input/output for each data partition, based on the following metric:

   Option	Description
   Buffer pools	Data Virtualization uses the Db2 buffer pools to store cached data and to improve service performance. Adequate buffer pool size is essential for good service performance because it reduces the disk I/O, which uses a considerable amount of time.

6. Click Monitor dashboard > Storage > Table performance to see performance data of each table or each schema.
7. Click Monitor dashboard > Settings to get information about the following profiles:

   Option	Description
   Monitor profile	Displays the information about the profile created to collect monitor data for your Data Virtualization connection. For details, see Monitor profile.
   Event monitor profile	Displays the information about the profile created to monitor specific event types that occur on Data Virtualization. For details, see Event monitor profile.

   Required role: To access these profiles, you must have the Data Virtualization Admin role.
8. Click Explorer to access the following information in Data Virtualization:
   • Tables
   • Views
   • Remote tables
   • Authorization, such as groups, roles, and users that have permissions to the objects in the service.
   • Application objects, which include stored procedures and user-defined functions.

   Additionally, Data Virtualization Admins can explore schemas, user-defined types, MQT statements, and sequences.