Optimizing resource-intensive operations with QMF HPO/Compiler

QMF HPO/Compiler provides utilities for generating, preparing, and running report programs for QMF.

The QMF HPO/Compiler performs these tasks:
  • Provides a stored-procedure development environment to create stored procedures
  • Reduces resource contention by optimizing resource-intensive queries, forms, and procedures
  • Converts dynamic SQL to static SQL, which helps reduce Db2® catalog contention and Db2 optimization overhead

    The compiled applications run faster and more efficiently, lowering your production costs.

  • Converts queries, reports, and procedures into efficient COBOL programs, generating structured, stand-alone, documented source code that is easy to modify and portable to other platforms

    Using a COBOL precompiler, you can run the program on a personal workstation for use with Db2 for Linux®, UNIX, and Windows or other database management systems.

The QMF HPO/Compiler contains a program generator and an end-user facility.
Program generator
The program generator is used by programmers to convert QMF reports (queries, forms, and procedures) into compiled programs. In addition, this facility can automatically register report programs with the end-user facility.

CICS® programs are pseudo-conversational: they appear to the user as a continuous conversation, but actually consist of multiple tasks. As with TSO programs, you can generate two types of CICS programs: display programs and print programs.

End-user facility
The end-user facility is used to run compiled report programs. When programs are generated and prepared for running, they are automatically registered with the end-user facility. After programs are registered, the nontechnical user interface makes it easy to list, locate, and process reports.

After selecting a report, you are prompted to supply any runtime variable values. If the report will run in batch mode, JCL is automatically generated and optionally submitted. Otherwise, the interactive report is run online in the appropriate environment, TSO or CICS.