Feature spotlights

Real-time and historical monitoring

Track the health and status of your database on the Monitor Summary page. At a high level, your database status is represented by six stories, similar to how every airplane is equipped with six core instruments. Use these to understand the availability, responsiveness, throughput, resource use, user contention and time spent in each database from one screen. These same metrics are also available on the enterprise home page, which lists your databases and allows you to access their metrics.

Alerts and notifications

The console supports a wide range of alerts to ensure you can catch the problems before they impact the business. You can review alert information plus sort and share all received alerts from the Notification Center. Some of the supported alerts are threshold alerts, smart alerts for query optimization, HADR alerts, email and SNMP notifications. The console is also integrated with an IBM tool that apples machine learning (ML) algorithms to analyze some issues and propose auto-fixes.

Fully integrated SQL editor

Write and edit SQL with the help of an interactive type-ahead SQL parser. Run SQL scripts and view results right away or export them to a CSV or Excel worksheet. With the collaboration feature, share SQL scripts with your team by copying and sending them through a shared link. Improve team productivity by using templates and shared scripts. You can also collect a detailed history of the SQL statements running on your database locate inefficiencies and optimize performance.

Database object exploration and management

You can manage and explore objects to understand relationships between them. For example, you can view all tables under your schemas, look through table properties and definitions, and create new tables directly in the console. Other primary object types supported include view, remote tables, aliases, schemas, sequences and MQTs. Explore application objects, such as stored procedures, user-defined types and functions; manage databases by user, group or role; and run changes when needed.

Team collaboration with composable user interface

The user interface of the new console is built to allow you to compose your own interface by picking what you want to see. Each time you select a new page, the URL uniquely identifies that part of the interface. If you send that URL to other users of the console, they can go to the same page you are seeing. With a small modification to the URL, that page can be embedded into your Iframe, webpage or Jupyter notebook.

Support for RESTful services APIs

Access and configure all console capabilities with RESTful APIs and sample scripts in key programming languages for an open and extensible development experience. That includes APIs to run SQL, manage database objects and privileges, monitor performance, and load data and files. Complete and comprehensive documentation on how to use this functionality is built into the user interface. Examples of how to write your own code in Python to access and use these new interfaces are on GIT.

Customer case studies

Case study image

Learn how Nordea Bank optimized database performance to support critical banking systems.

Nordea Bank AB
Read the case study
Case study image

Learn how IBM Data Server Manager helps deliver comprehensive insight into database health.

Groupe France Mutuelle
Read the case study
Case study image

Read how a government research lab found new ways to boost HPC performance and availability.

A government research laboratory
Read the case study

You may also be interested in

Db2 on Cloud

IBM Db2® on Cloud is a transactional cloud database built for robust performance, providing a high-availability option with a 99.99% uptime service-level agreement (SLA). Scale up and down as needed to meet business demands, and leverage rolling security updates for peace of mind. Available on IBM Cloud™ and Amazon Web Services (AWS). What’s new with Db2 on Cloud: Now available on AWS – Read the blog Now offering point-in-time restore capabilities – Read the blog

Learn more

IBM Db2 Warehouse on Cloud

IBM Db2 Warehouse on Cloud is a fully-managed, cloud data warehouse service powered by IBM BLU Acceleration and built for high-performance analytics and machine learning.

Learn more

See how it works