DB2 query Management Utility

The DB2 query Management Utility is included in DB2 WM for query and report generation. The following describes the DB2 query management utility for your reference.

DB2 WM contains QMF, a query management utility for Windows. QMF provides a multi-purpose query tool, for business report generation, data sharing, server resource protection, robust application development, and local connectivity to all DB2 workstation platforms.

QMF is a tightly integrated, powerful, and reliable collection of query and report generation tools for distributed and host platform DB2 databases. It provides an environment that is not only easy for new users, but also powerful enough for application programmers. QMF provides detailed management and control over the enterprise query environment to restrict user access and protect valuable system resources.

In short, QMF also allows you:

Easily build queries and reports through the Quick Start Interface

Use Java-based query capabilities to start queries from your favorite Web Browser

Integrate query results with desktop tools such as workbooks and personal databases

Quickly build data access and update applications

Make full use of DB2 performance, SQL syntax, and advanced database performance technologies such as static SQL)

Introduction to DB2 information directory Center

Provides you with an in-depth understanding of the DB2 data warehouse.

Implementation of DB2 Paging

How to manage DB2 tablespaces

DB2 database Permissions