The Db2® Big SQL service provides a
dashboard for monitoring and managing the service instance. This dashboard is powered by IBM®
Db2 Data Management Console.
Before you begin
Before you use the Monitor dashboard capabilities in Db2 Big SQL, ensure that the IBM
Db2 Data Management Console service is installed (see Db2 Data Management Console). Any Cloud Pak for Data user who is navigating the Db2 Data Management Console must hold the necessary permissions to
About this task
Db2 Data Management Console is a browser-based console that
helps you monitor and manage the performance of your Db2 Big SQL service instance by using one or more of the
key performance indicators that are known as metrics.
From the instances list, find the instance that you want to monitor. Click the options menu and
select Open to get a summary of the Db2 Big SQL service health, based on the following
Indicates whether the service is up or down, and the relevant alerts.
Indicates whether the system is responding well to the incoming requests.
Indicates how much workload the system is handling.
Indicates the resource consumption of the service in terms of CPU, memory, storage, and log
Indicates the percentage of time that is taken for service calls.
Open the menu and click Statement to get performance data about
queries that are running in Db2 Big SQL, based
on the following metrics:
See a list of the SQL statements that are currently running or that ran recently on
Db2 Big SQL.
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.
Displays the details of running SQL statements as system activity.
See information about statements that previously ran on Db2 Big SQL. 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.
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.
Open the menu and click Locking to get lock data about
applications that are running in Db2 Big SQL,
based on the following metrics:
Blocking and waiting connections
Displays lock wait times, numbers of locks held, lock modes, and numbers of waiting
connections for running applications.
Displays connection, resource consumption, performance, and lock data for running
Locked objects with waiting connectionsd
Displays locked object and waiting connections data for running applications.
Find locked objects
Displays data about locked objects that are impacting running applications.
Open the menu and click Applications to get an overview of the
service usage, based on the following metrics:
Displays the top consumers of the system resources.
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
Units of Work (UOW)
Displays data about UOW activities, locks, and wait times that are impacting running
Open the menu and click Throughput to get an overview of query
performance, based on the following metrics:
Displays a summary of all connections established to the console.
Displays data about each data partition that is used by Db2 Big SQL.
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
WLM service class summary
Represents the accumulation of all metrics for requests that have executed under the
indicated service subclass.
Operating system time spent
Displays performance data pertaining to operating system activities that support Db2 Big SQL.
Open the menu and click Storage to get an overview of table read
performance and storage sizes, based on the following metrics:
Displays performance data for each table.
Displays logical and physical sizes (in kilobytes) for each table.
Open the menu and click Settings to get information about the
Displays information about the profile that was created to monitor historical data for your
Db2 Big SQL connection. For details, see Monitor
Event monitor profile
Displays information about the profile that was created to monitor specific event types
that occur on Db2 Big SQL. For details, see