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

Advance your enterprise Journey to Hybrid Cloud and AI powered by AIOps on Z

2 min read - Thanks to rising costs, skills shortages and ever-growing security threats, businesses must adapt quickly to shifts in demand patterns brought on by a digital workforce and rapidly changing buyer behavior. That requires putting extra emphasis on the resiliency and performance of your business processes and supporting applications. For larger IT organizations with increasingly hybrid and complex application landscapes that often include IBM Z®, it’s essential to take a comprehensive approach to IT operations. The challenge becomes “How do you effectively sift through terabytes of…

IBM API Connect named a leader in the Forrester Wave: API Management Software, Q3 2024

4 min read - We are excited to announce that Forrester has recognized IBM API Connect® as a Leader in The Forrester Wave™: API Management Software, Q3 20241. Forrester conducted a 24-criteria evaluation of API management software providers to make their assessment and final results. IBM API Connect received the highest score possible in 17 out of the 24 criteria. [button link="https://www.ibm.com/account/reg/us-en/signup?formid=urx-52934"]Download a complimentary copy of the report here[/button] IBM: What to look for when shopping for API Management Software Transformation and integration initiatives…

Success and recognition of IBM offerings in G2 Summer Reports  

2 min read - IBM offerings were featured in over 1,365 unique G2 reports, earning over 230 Leader badges across various categories.   This recognition is important to showcase our leading products and also to provide the unbiased validation our buyers seek. According to the 2024 G2 Software Buyer Behavior Report, “When researching software, buyers are most likely to trust information from people with similar roles and challenges, and they value transparency above other factors.”  With over 90 million visitors each year and hosting more than 2.6…

IBM Newsletters

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