Working with integrated databases using the Db2 Data Management Console

With IBM® Db2 Data Management Console, you can administer, monitor, manage, and optimize the performance of integrated databases. These integrated databases include Db2, Db2 Warehouse, Db2 Big SQL, and Watson™ Query.

Service This service is not available by default. An administrator must install this service on the IBM Cloud Pak® for Data platform, and you must be given access to the service. To determine whether the service is installed, open the Services catalog and check whether the service is enabled.

Watch the following video for an overview of Db2 Data Management Console.

This video provides a visual method as an alternative to following the written steps in this documentation.

If you created a Db2 Data Management Console database deployment in your IBM Cloud Pak for Data cluster, you can access the console and complete the following tasks based on the database type.

Accessing the console

To access the console:
  1. Sign in to the Cloud Pak for Data web client.
  2. From the navigation menu, go to Services > Instances.

    You see the Instances page. The Provisioned instances tab is in front. Your instances are listed in a table.

  3. Click the Data Management Console instance with type dmc.
  4. Click the action icon that is located at the right end of the page and select Open.

    Your connections are listed in a table.

Monitoring integrated databases

You can use the Db2 Data Management Console to monitor the integrated databases.

To monitor the integrated databases:

  1. Access the console.
  2. In the connections table, click the database connection that you want to work on.

    You can get a high-level view of the health of the database.

    Metric Description
    Availability Indicates whether the database is up or down, and the relevant alerts.
    Responsiveness Indicates whether the system is responding well to the incoming requests.
    Throughput Indicates how much work the system is handling.
    Resource usage Indicates the resource usage of the database in terms of CPU, memory, storage, and log space.
    Contention Indicates whether there is any contention between connections.
    Time spent Indicates the percentage of time that is taken for database calls.
  3. From the navigation menu, select Monitor.
  4. To get more detailed information about the database, select one of the monitoring metrics option from the Monitor menu.

Exploring integrated databases

You can visualize the schema, tables, views, and columns in the integrated databases by using the Explorer feature. You can also see the groups, roles, and users that have permissions to the objects in the database.

To explore the integrated database:

  1. Access the console.
  2. In the connections table, click the database connection that you want to work on.
  3. From the navigation menu, select Data.

Loading data

You can load data from the following sources:
  • From your local file system, you can load a single delimited text file (CSV or TXT).
  • From Amazon S3, you can load delimited text files (CSV and TXT).
  • From IBM Cloud Object Storage, you can load delimited text files (CSV and TXT).
Note:
  • Load option is available only for Db2 and Db2 Warehouse database types.
  • Amazon S3 and IBM Cloud Object Storage are available only on x86_64 platforms.

Before you load data, make sure to scan the data to find potential security vulnerabilities.

To load data into the integrated database:
  1. Access the console.
  2. In the connections table, click the database connection that you want to work on.
  3. From the navigation menu, select Load.

Running SQL

SQL is a standardized language for defining and manipulating data in a relational database.

You can use the Run SQL feature to run SQL statements and scripts against the database.

To run SQL:
  1. Access the console.
  2. In the connections table, click the database connection that you want to work on.
  3. From the navigation menu, select Run SQL.
  4. Create your SQL statement or script.

Tuning

To create tuning tasks:
  1. Access the console.
  2. In the connections table, click the database connection that you want to work on.
  3. From the navigation menu, select Tuning.

Reports

To generate reports:
  1. Access the console.
  2. In the connections table, click the database connection that you want to work on.
  3. From the navigation menu, select Reports.

Jobs

To create jobs:
  1. Access the console.
  2. In the connections table, click the database connection that you want to work on.
  3. From the navigation menu, select Jobs.

Monitor profile

To create a monitor profile:
  1. Access the console.
  2. In the connections table, click the database connection that you want to work on.
  3. From the navigation menu, go to Settings > Monitoring profile.

Event monitor profile

To create an event monitor profile:
  1. Access the console.
  2. In the connections table, click the database connection that you want to work on.
  3. From the navigation menu, go to Settings > Event monitor profile.