IBM Db2 Query Management Facility (QMF)
Analytics, visualizations, data preparation and self-service business intelligence for virtually any data. QMF is optimized for IBM Z data sources like Db2, VSAM, IMS, ADABAS and IDMS
person on top of a mountain
What is IBM Db2 Query Management Facility?

QMF is designed to be a security-rich, easy-to-use business analytics and visualization solution optimized for IBM Z® data.

  • Delivers self-service business intelligence with interactive dashboards and intuitive visualizations
  • Supports disparate data sources such as relational, non-relational, flat files and web services data
  • Optimized for IBM Z sources such as information management systems (IMS), adaptable database system (ADABAS), IBM® Db2® for z/OS®, virtual storage access method (VSAM), integrated database management systems (IDMS) and system management facilities (SMF)
  • Includes data virtualization technology that allows real-time, in-place access to IBM Z data
  • Helps ensure secure, role-based access to various resources using IBM Resource Access Control Facility (RACF®) as the foundation
  • Allows enterprise-wide use through web, workstation and interactive system productivity facility (ISPF) interfaces
Benefits Surfaces actionable business insight

Creates enterprise-wide views by conflating multiple IBM Z data sources with other structured and non-structured data sources.

Expands analytics to everyone

Provides an intuitive user interface to enable your business users to automatically create visualizations across data sources and instantly share those insights with peers.

Consolidates and reduces costs

Eliminates the need for multiple business intelligence tools for different data sources and per user and source costs. Creates fast, in-place analytics for multiple users and data sources.

How customers use it
Collaborative analytics in the banking industry

Problem

You have to analyze and solve why there has been a decline in deposits over the past few months. The data is in multiple data sources including the mainframe and you need to collaborate with an extended team to find the problem and solution.

Solution

Use the QMF Vision interface to create a visualization across the different data sources. Use the visualization to find the problem, and use the integration of QMF and collaborative software, such as IBM Connections to solve the problem.


In-place analytics on LIVE VSAM data

Problem

VSAM is used to store your business transactional data. To analyze this data for business decisions, the data is moved off IBM Z daily. Moving the data incurs mainframe costs and does not allow for timely insights or decisions.

Solution

Do not move the VSAM data off IBM Z. Analyze it and visualize it in place with QMF modern dashboards and visualizations. Lower costs by diminishing data movement and by using the QMF data virtualization technology that exploits zIIP engines.

Feature spotlights Use JavaScript to enhance your QMF-based analytics and visualizations
 

With the REST API introduced in QMF 12, JavaScript can be used for rapid development of web-based front ends. A QMF JavaScript column allows for data manipulations that would not otherwise be practical or possible in SQL. QMF for Workstation, QMF for IBM® WebSphere®, and the QMF Z Client allow the use of JavaScript in Procedures to add logic ‘if-then’ statements, loops and more.

Read the product documentation
Use QMF Vision for self-service, intuitive dashboards to analyze data
 

QMF Vision is a user-friendly, self-service data preparation, data discovery and collaboration solution that provides multiple ways to present and analyze information. It allows users to incorporate a variety of data sources and generate customizable dashboards that can be easily shared with other users in the business community.

Read the product documentation
Resources Community

Be a part of the community that brings QMF enthusiasts together virtually.

Query Management Facility

Find documentation for specific editions of QMF.

IBM Redbook

Read about in-place analytics with live enterprise data using QMF.

Take the next step

Book a consultation with an IBM expert to discuss how it can advance your specific business needs.

More ways to explore Documentation Community