July 13, 2022 By Pooja Vettical
Vijaya Katikireddy
2 min read

We are happy to announce that IBM Db2 Data Management Console v3.1.8 is officially out.

Our focus has always been on the customer, and this release is no different. A significant chunk of the new features has been built as a direct result of our advocate team’s engagement with customers.

We have built this release around addressing a plethora of customer requirements and fixing minor gaps between the previous DSM and DMC. This release is yet another step towards our goal of providing the best database management experience through a single unified console.

New features and enhancements

  • Query Tuning: Our exciting Query Tuning feature has been a trailblazer in optimizing queries within the product. As part of this release, the Query Tuning page has been ramped up with an array of new changes. We have enhanced the user experience for viewing tuning recommendations to make it as easy as possible to review recommendations on improving a query. The recommendation report now displays the access plan summary and catalog information sections. The generated access plan graphs can include actual access path cost information to help you analyze the efficacy of the query. We also provided a way to get recommendations on converting a table from row-stored to column-stored, given a workload. Finally, the Query Index What-if analysis now displays a revised access plan graph with virtual indexes.
  • SQL editor: Our Run SQL page now features a saved scripts tab where users can easily access their saved scripts from the landing page for our SQL editor. The new auto-completion feature provides hints for schema and table names to improve the experience of writing a query from the console. Lastly, we have enhanced the process of exploring data objects.
  • Monitoring and alerts: This release includes support monitoring for non-ROS HADR databases. Users can now monitor the memory usage at the instance and database levels. We have improved the database time spent page for workloads and can provide asynchronous I/O data at the database level. Users can specify privileges for alerts so that only authorized users can view and manage alerts. Lastly, we have added an additional column so that Custom Alert script output can include the reason in addition to severity.
  • Configuration management: Users have the ability to view, compare and update DBM and DB configuration parameters across SMP, DPF, HADR and pureScale.
  • Jobs: We have implemented customized email notifications that can be based on job execution status. This release comes with the ability to delete a job while it is running. Users can convert an on-demand to a scheduled job dynamically instead of having to manually enter the previous job’s details again as a scheduled job.
  • dmctop: Finally, dmctop monitoring utility V1.0.4.1 was also released in conjunction with this update to enhance Db2 pureScale statistics at the member level.

Get started

To download IBM Db2 Data Management Console, go to the Db2 Download CenterFix Central or Db2 console DockerHub.  

More from

Enhancing triparty repo transactions with IBM MQ for efficiency, security and scalability

3 min read - The exchange of securities between parties is a critical aspect of the financial industry that demands high levels of security and efficiency. Triparty repo dealing systems, central to these exchanges, require seamless and secure communication across different platforms. The Clearing Corporation of India Limited (CCIL) recently recommended (link resides outside ibm.com) IBM® MQ as the messaging software requirement for all its members to manage the triparty repo dealing system. Read on to learn more about the impact of IBM MQ…

Enhance your data security posture with a no-code approach to application-level encryption

4 min read - Data is the lifeblood of every organization. As your organization’s data footprint expands across the clouds and between your own business lines to drive value, it is essential to secure data at all stages of the cloud adoption and throughout the data lifecycle. While there are different mechanisms available to encrypt data throughout its lifecycle (in transit, at rest and in use), application-level encryption (ALE) provides an additional layer of protection by encrypting data at its source. ALE can enhance…

Attention new clients: exciting financial incentives for VMware Cloud Foundation on IBM Cloud

4 min read - New client specials: Get up to 50% off when you commit to a 1- or 3-year term contract on new VCF-as-a-Service offerings, plus an additional value of up to USD 200K in credits through 30 June 2025 when you migrate your VMware workloads to IBM Cloud®.1 Low starting prices: On-demand VCF-as-a-Service deployments begin under USD 200 per month.2 The IBM Cloud benefit: See the potential for a 201%3 return on investment (ROI) over 3 years with reduced downtime, cost and…

IBM Newsletters

Get our newsletters and topic updates that deliver the latest thought leadership and insights on emerging trends.
Subscribe now More newsletters