Version 3.1.3

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

Job management and scheduling

IBM Db2 Data Management Console now supports job creation, job scheduling, and job management for your connected databases. Users can now use Settings > Jobs page to manage jobs. With this feature, users can:
  • Create jobs based on SQL/CLP scripts.
  • Create and schedule jobs to run at a specific time, or to repeat at certain intervals for one or more databases.
  • View the history of all jobs that run on your databases.
  • Configure email notifications to be sent to one or more users depending on the success or failure of the job.

Reporting

IBM Db2 Data Management Console now supports report generation. Users can now use the Settings > Reports page to create monitor reports that assist in comparing and analyzing original data by displaying information in a graphical format.

Audit logs

IBM Db2 Data Management Console now supports logging of certain event types as audit records using REST API. The audit records are stored either in the repository or in the server's file system as log files.

User-defined alerts

IBM Db2 Data Management Console now supports custom alerts. Through the connection's monitoring profile, users can now define custom alerts and specify corresponding action. With this feature, users can:
  • Create alerts based on SQL/Shell scripts.
  • Schedule alerts to run at a specific time, or to repeat at certain intervals for one or more databases listed in the monitoring profile.
  • View the history of all alerts that run on your databases.
  • Configure email notifications to be sent to one or more users depending on the success of the alert.

Monitoring

  • Support for monitoring of prefetcher and table space performance.
  • APIs to set up monitoring blackout periods.
  • Support for Indexes.

Db2WHoC and Db2oC repository support

Support for Db2 on Cloud and Db2 Warehouse on Cloud as a repository database. Users can now use cloud databases to store historical data.

IBM zLinux support

IBM Db2 Data Management console now supports Linux® on System z®.

Enhancement to dmctop

Bundled dmctop v1.0.0.0 with Db2 v11.5.5. Made multiple fixes and enhancements to dmctop v1.0.1.0 to improve performance and usability which includes:
  • AIX® and MacOS support.
  • Added filtering, tracing data functionality for views and hide/show menu and gauge components.
  • Users can now set threshold for metrics to enable visual alerts on the views with swimlane and grid layout.

Extended Insight® monitoring

IBM OMEGAMON® for Db2 Performance Expert on z/OS® Extended Insight is available as an add-on for IBM Db2 Data Management Console 3.1.3. Extended Insight provides end-to-end monitoring of your entire database application system. This first release of the Extended Insight add-on provides a subset of the Extended Insight functionality that was delivered with IBM InfoSphere® Optim™ Performance Manager.

For more information, see Extended Insight overview.