Version 3.1.9

This section includes the new features and functions that are included in IBM® Db2® Data Management Console v3.1.9.

Replication

You can now use IBM Db2 Data Management Console to monitor end-to-end operation and performance of Q Replication.

After you activate replication on your Db2 source and target systems, you can use the IBM Data Management Console to do the following replication tasks:

  • Define connection profiles and create monitoring groups.
  • View the status and activities of your Q Replication consistency groups and table subscriptions.

Metrics and graphs display both real-time and historical data that include average throughputs, average latencies, and the current consistency point of the target database.

For more information, see Replication.

Monitoring

  • Enhanced the Availability widget on the Monitor summary page to display the availability of all the database partitions and all nodes in a Db2 pureScale® environment.

    When you enable the database partition availability type in the alert configuration settings of a monitor profile, the Availability widget now displays an alert icon when a database partition availability alert is generated. Also, the availability percentage calculation that is displayed in the historical available time section reflects the database partition unavailability.

  • Enhanced the Event monitoring profile page with the following options:
    • View the list of event motoring objects.
    • View the CREATE EVENT MONITOR statement in the object list.
    • Delete a table space.
    • Delete event monitoring objects.
    • Customize table space size.
  • Introduced the following options in the Monitoring profile page to configure the collection of storage metric data for a monitored database:
    • Collect storage data - Collects table performance and table storage data for both tables and indexes.
    • Storage data collection time - Specifies the collection time (hh:mm)
  • The Package cache page now includes the following improvements:
    • The Package cache page now displays the current statement execution data in real-time mode. Users can now view the accumulated data since the time the statement was placed in package cache and overall status of the statements that were executed in real-time mode. The data that is displayed in real-time mode is not persisted in the repository. Only the data changes between two fetches from the package cache are persisted.
    • The query from package cache in historical mode now captures more statements to provide accurate results of top consumers.

Alerts

Db2 Data Management Console now supports File system utilization alert for Db2 with Data Partitioning Feature (DPF). When you monitor a Db2 partitioned database, the console generates the File system utilization alert when the file system usage exceeds the threshold on any of the partitions.

Run SQL

Db2 Data Management Console now supports the official version of SQL editor with database object tree view. The classic version of SQL editor is no longer supported.

Enhanced the Run SQL page with the new SQL Builder to enable users to easily build SQL queries for Db2 database without the need for manual SQL coding. The SQL Builder offers drag-and-drop and point-and-click interfaces that allow even non-experts to build SQL queries quickly. Users can now generate query statements of varying complexity, create table joins, and save builds to retrieve them for future use.

For more information, see Run SQL.

Other improvements

Users can now view the details of Job and Custom alerts without the need to use edit mode.

High availability

Db2 Data Management Console now includes the scripts to set up high availability (HA) with Pacemaker in the console installation image.

For more information, see Setting up high availability (HA) with Pacemaker.