Version 3.1.6

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

WLM dashboard

Users can now use the new Monitor > Workload management dashboard to manage workloads.
  • The workload management feature is not enabled by default. It can be enabled by calling the API:
    Put API call to /dbapi/v4/settings/uc/enable_wlm_feature
    {
"value": "true"
}
  • This feature is supported only for Db2 databases version 11.5.0 or later.
  • The data in this feature content is derived from Statistics event monitor.

Job sharing support

User with job owner privilege can now share the job to different user(s) or group(s) with job owner or job viewer privilege based on the credential type that is defined in the job. User with job owner privilege can copy, edit, delete, update, control access, run, and view history of the job. User with job viewer privilege can copy, run, and view history of the job.

User can add a shared credential, which can be used for job execution.

Pruning customizations

Db2 Data Management Console now supports retrieving or modifying the pruning rule settings for the job, blackout, and report history data in the respective pages. In the data pruning setting page, you can select one of the following pruning rules for data pruning:
  • Prune by status - select this option to set the pruning rules based on success and failed execution status for the job, blackout, or report.
  • Prune by schedule - select this option to set the pruning rules based on schedule and on-demand types for job, blackout, or report.
  • Prune by the number of records - select this option to set the pruning rules based on the number of records and the runs of each job.
  • Disable pruning - select this option to disable data pruning.

Enhancement to reports

Added more KPIs to Database performance report
  • Added sort information
    • Sorts per minute
    • Sorts per transaction
    • Sort time (milliseconds)
  • Added log information
    • Log buffer wait time (milliseconds)
    • Log disk wait time (milliseconds)
  • Added buffer pool information
  • Added table space information
  • Added SQL execution-time breakdown
  • Increased the script size of a custom (user-defined) alert.
  • Supports migration of custom alerts from Data Server Manager to Db2 Data Management Console.

Additional job scheduling capabilities

Using the job scheduling feature, users can now create complex cron schedules and define the interval to run their jobs. The following schedules are available:
  • Every minute - run job every x minute
  • Hourly - run job every x hour
  • Daily - run job every day
  • Daily interval - run job every x day
  • Weekly - run job on specified days of the week. For example, every Monday and Tuesday of the week.
  • Monthly - run job on specified days of the week every month in a year. For example, Monday and Tuesday of the week in the months of January and May in a year or every 10th and 20th day in the months of January and May in a year.

Query tuning

Db2 Data Management console now supports query tuning for Linux®, Unix, and Windows platforms. Users can now create tuning tasks from the SQL editor. It can work on a single query or multiple queries. Users can also monitor statement dashboards and query performance related alert integrated pages.

Query tuning provides the following two major functions:
  • Statistics advisor - Provides recommendations to use RUNSTATS command for collecting the statistics.
  • Index advisor - Provides recommendations to create valuable indexes for improving the query performance.
User can view the tuning task result in the Tuning result tab.
Note: Tuning capabilities in Db2 Data Management Console is a technology preview and is not yet supported for use in production environments.

Support for Db2 databases

Db2 Data Management Console now supports the following databases:
  • Db2 10.1.0.2 and later
  • Db2 11.5.7
Db2 10.1 database is not enabled by default. It can be enabled by calling the API:
Put /dbapi/v4/settings/uc/support_db2_v1001
{
"value": "true"
}
The columns of table functions in Db2 10.1 database that is used by the console is incompatible with Db2 10.5 and later versions. The limitations include:
  • Some columns in the monitor pages might not contain data.
  • For Dbstatus alert, only unreachable threshold is supported.
  • Alerts are not supported for io_catalog_cache_hit_ratio, io_package_cache_hit_ratio, sorting_post_threshold_sorts, sorting_sort_overflows, workload_rows_read_per_fetched_row, and workload_rollback_transactions.