QMF HPO

QMF HPO consists of three major components:

• QMF HPO/Manager
• QMF HPO/Compiler
• QMF for Windows

QMF HPO/Manager

The QMF HPO/Manager consists of a group of functions that improves governing and object management capabilities, including a preemptive governor to analyze QMF queries. The governing capabilities allow you to establish controls that protect production applications, while delivering "on demand" information. Many governing parameters are included:

• Scheduling by time of day or day of week
• Fetching the maximum number of rows
• Allowing and disallowing SQL verbs and QMF commands
• Controlling resource consumption based on the use of QMF commands and SQL statements

QMF HPO/Compiler

The QMF HPO/Compiler lets you convert queries and reports into efficient programs in OS/VS COBOL or COBOL II. This reduces:

• CPU consumption
• DB2 catalog contention
• DB2 Optimizer overhead
• Security concerns, because converted programs use static Structured Query Language (SQL) in place of dynamic SQL

QMF for Windows

For customers with DB2 databases of varied sizes, QMF for Windows provides a Windows-based, point-and-click query tool.

With QMF for Windows, you can perform ad hoc queries or automate DB2 queries by using existing QMF queries and forms. You can also integrate the results into a favorite Windows OLE 2 desktop tool, such as a Lotus^(R) 1-2-3^(R) or Microsoft^(R) Excel^(R) spreadsheet.

QMF for Windows includes a robust Windows-based API to automate database querying, updating, and report distribution tasks, so you can centralize control over resource consumption.

QMF for Windows also provides support for key functions such as the following:

• TCP/IP
• Static SQL
• Creating and editing QMF forms and procedures
• Full-screen table editor for updating enterprise data