Query Management Facility Version 3 Release 3 for MVS, VM & VSE

Software Announcement
May 13, 1997
Announcement Letter Number: 297-158


Table of Contents:



At a Glance

QMF Version 3 Release 3 offers:

  • Type 2 index support with DB2 for MVS V4

  • Comprehensive coverage for DB2 Family SQL codes

  • Export of QMF Reports in HTML format for Web browsing

  • Limit the number of rows returned from a query

  • Enhanced customization of the QMF session

  • Table Editor support for column defaults

  • Flexibility in completing QMF Reports when new commands are issued

  • Correlation Name added to the DRAW command

  • DB2 Uncommitted Read support for QMF Queries

  • Year 2000 ready
QMF HPO/Shuttle feature for the Windows environment provides:
  • TCP/IP support for DB2 V5

  • Static SQL support

  • Prompted Query GUI interface

  • Create and edit QMF Forms

  • Full screen Table Editor



Overview

IBM Query Management Facility (QMF (TM)), the tightly integrated, powerful, reliable query and reporting tool for IBM's DB2 (R) relational database management system family, now provides new capabilities for the workstation environment and enhancements for the mainframe that help you access and present mission-critical data better than ever before. QMF V3R3 enables you to work with data all over the enterprise -- from MVS (R), VSE and VM to workstation servers running OS/2 (R), Windows (R) NT, AIX (R) and other UNIX (R) operating systems, to massively parallel processors.

QMF and the QMF HPO/Shuttle feature offer a total solution that includes accessing large amounts of data, sharing central repositories of queries and enterprise reports, and/or implementing tightly controlled distributed or client/server solutions. Web enablement, useability and application enabling enhancements, as well as improvements to the QMF HPO/Shuttle feature for Windows, including TCP/IP support, prompted query GUI interface and static SQL are some of the additions in this release.



Intended Customers

  • MVS, VSE or VM prospects and customers who need a total decision support (DSS) and report writing solution that includes:
    • Accessing large amounts of data
    • Sharing a central repository of queries, reports and procedures, and/or
    • Implementing tightly controlled client/server DSS and report writing solutions
  • Customers currently using MVS, VSE or VM, who want to improve their DSS capability and application development productivity, both on the mainframe and from the Windows environment, using QMF HPO/Shuttle or the Lotus Approach QMF client

  • Current MVS, VSE or VM customers looking to exploit 16- and 32-bit Windows office "suites" and Windows desktop development environments (such as LotusScript and Visual Basic) for building robust, highly scalable DSS solutions; also those interested in transparent integration and sharing of QMF queries and reports from within Windows-based products

  • MVS customers looking to more tightly manage their QMF environment and increase their mainframe application development productivity



Key Prerequisites

Query Management Facility (QMF) Version 3.3 for MVS, VM or VSE are prerequisites for the QMF HPO/Shuttle features.

QMF HPO/Shuttle runs on Windows and communicates using Distributed Relational Database Architecture (TM) (DRDA (R)).

Planned Availability Dates

  • QMF V3.3 for MVS, VSE & VM: June 13, 1997
  • QMF V3.3 HPO/Shuttle Features for MVS, VSE & VM: July 18, 1997

------------------------------

This announcement is provided for your information only. For additional information, contact your IBM representative or call 800-IBM-4YOU.



DESCRIPTION

The following is a summary of the enhancements to Release 3 of QMF Version 3.



DB2 Support

SQLCODEs: QMF messages and help panels have been updated to support many new SQLCODEs, which QMF users might encounter from the following database servers:

  • DB2 VSE & VM (SQL/DS (TM)) Version 3.5 and Version 5.1
  • DB2 for MVS Version 4 and Version 5
  • DB2 Version 2.1 Common Server
  • DB2 Parallel Edition Version 1.2
  • DataJoiner (R) Version 1.2
DB2 MVS/ESA (TM) V4 Type 2 Index Support for QMF Control Tables: QMF 3.3 supports DB2 for MVS Version 4 Type 2 indexes on the QMF control tables. This upgrade is enabled upon install of QMF 3.3. The benefits of the Type 2 indexes apply to all QMF control tables.

Now, with Type 2 indexes, index page locks are reduced so your applications and maintenance activities can proceed with fewer deadlock and timeout situations.

National Language Support for DB2 PE and DataJoiner: A QMF 3.2 PTF provided support for DataJoiner and DB2 PE servers in English only. QMF 3.3 adds the full national language support for these database servers.

IBM's DataJoiner provides access to a broad range of data sources, such as the DB2 family, Oracle, Sybase and Informix, as well as non-relational data sources like VSAM and IMS (TM).

Uncommitted Read: A new global variable has been added to support DB2 Uncommitted Read. This allows administrators or users to customize the QMF session so that queries can be run using the Uncommitted Read isolation level, eliminating database lock processing.



Application Enabling

Worldwide Web: QMF has enhanced the Export Report command to produce reports in HTML format. The QMF report can then be made available to Web servers such as Lotus Domino for accessing by Web browsers.



Useability

Set Default for SHARE Option: QMF Version 3.3 makes it easier to share Procedures, Queries and Forms with other users. A new global variable lets the user or an administrator define the default for the SHARE (YES/NO) option for SAVED and IMPORTED QMF objects.

Greater Customization of QMF Session: A new session control facility is provided for administrators to customize the QMF session. A unique QMF Procedure will initialize each user session prior to the presentation of the QMF Home panel or execution of the procedure named in the parameter DSQSRUN. For example, administrators can change the SHARE option default for all users with just one command placed in the initialization procedure.

Table Editor Enhancements: The QMF Version 3.3 Table Editor provides support for column defaults. In ADD mode the panel will clearly indicate when a default for a column is available and allow the user to proceed without requiring additional input. A new special character is provided to indicate DEFAULT.

Users can control which special characters will be used by the Table Editor to symbolize NULL and DEFAULT. This permits operation with columns that use as actual data the QMF predefined special characters ('-' and '+', respectively).

Improved QMF Command Performance: When running a long QMF report, if the user wants to go on to execute the next command (such as saving a QMF query or form), this may result in the user having to wait for a current Report command to finish. QMF 3.3 provides an option to avoid this delay by adding a prompt panel and a global variable to control the displaying of the Prompt Panel, thereby saving valuable CPU resources.

The prompt panel states:

"Warning, your report is currently running"

"Do you want to RESET Report Y/N"

The Global Variable has three states:

  • Prompt

  • Always reset

  • Finish report (as in QMF Version 3.2)
Correlation Name Added to the DRAW Command: The QMF SQL interface allows the user to specify a correlation name when using the QMF DRAW command for database tables. This can prevent ambiguous column references and enhance the readability of the generated SQL.

Returned Row Limit: A ROWLIMIT option has been added to the QMF RUN QUERY command. Now a user can specify the maximum number of data rows that will be used to produce the QMF report. For example, take a query that produces a report of total sales for each sales person arranged from highest to lowest sales. Running the same query with a ROWLIMIT=10 would provide a "Top 10" report, listing the sales people with the highest total sales up to a maximum of 10 people.



QMF High Performance Option (HPO)/Shuttle

TCP/IP Support for DB2 Version 5: Native TCP/IP connectivity in DB2 Version 5 will be matched with native TCP/IP support in QMF HPO/Shuttle. Now users requiring any of QMF HPO/Shuttle's capabilities, including large scale performance and governed access to DB2 Version 5 and QMF objects (queries and forms), have it all available over native TCP/IP transport.

Prompted Query: In addition to executing SQL and running an existing QMF prompted query, users can build their own query using the QMF HPO/Shuttle prompted query graphical user interface (GUI). Users without knowledge of SQL can easily query DB2 using this point-and-click interface. QMF prompted queries and QMF HPO/Shuttle prompted queries are 100% compatible. That is, a query created in MVS, VM or VSE can be used in Windows and vice versa. Query results can also be embedded in any OLE 2 compliant desktop application such as Microsoft (R) Excel or Lotus 1-2-3 spreadsheet.

Static SQL Support: QMF HPO/Shuttle users and administrators may now pre-bind SQL queries to a DB2 package and run them directly from the Windows environment at any time. The performance gains and resource savings associated with static SQL over dynamic SQL can now be realized from within virtually all native Windows applications such as spreadsheets and desktop databases, and from within the native Windows QMF HPO/Shuttle interface. This is a true static SQL implementation within the Windows environment, and does not require triggering stored procedures at the server.

Create/Edit QMF Forms: In addition to viewing and printing existing QMF forms within Windows, QMF HPO/Shuttle now allows end users to create new QMF forms, save them in QMF system tables, and then use them at any time later from within Windows or when using mainframe QMF. The QMF HPO/Shuttle forms editor makes building tabular, across, summary, and other QMF reports a simple point-and-click procedure with an interface that walks even novice users through the forms building process.

Table Editor: QMF HPO/Shuttle allows end users to run a query, view the results, change the results directly in the view, and save the changes back to the DB2 server, all in a short series of intuitive and easy steps. For queries accessing single tables, users can perform both in-place editing of single fields as well as editing of one row at a time.

Windows 16-bit and 32-bit Support: QMF HPO/Shuttle is available in 16 bit and 32 bit. Customers will have both products shipped to them as part of the QMF HPO/Shuttle feature (6 diskettes). The 16-bit version can be run in WinOS2 and any of Windows 3.1, 3.11, 95, and NT. The 32-bit version can be run in Windows 95 and NT.

Performance Improvements: QMF HPO/Shuttle's query engine handles very large query results at exceptionally high speed in the native Windows environment.

National Language Support: The following enhancements described above are not included in the QMF HPO/Shuttle National Language Versions (NLVs). The NLVs are described in the Planned Availability Dates section below.

  • TCP/IP Support for DB2 Version 5

  • Static SQL Support

  • Create/Edit QMF Forms

    Viewing and printing existing QMF forms from Windows is supported.

  • Table Editor



QMF Approach 97 Client

Customers using Lotus products will be interested in the QMF Approach 97 client which is available in Lotus Approach 97 and Lotus SmartSuite 97.

The QMF Approach Client allows you to display the results of QMF Queries and Procedures in Approach views, as well as to import QMF Queries and Forms to create an Approach report or crosstab view.

Approach can open these files:

  • QMF Query -- When you select a QMF Query, the query is run on the QMF server. The results appear in the Approach form and worksheet. The data is read-only.

  • QMF Procedure -- When you select a QMF Procedure, the procedure is run on the QMF Server. The last data result produced by the procedure appears in the Approach form and worksheet. The data is read-only.
Approach can import these files:
  • QMF Form -- When you select a QMF form to import, the form is downloaded from the QMF server. Its attributes are used to create a new approach report or cross-tab view.

  • QMF Query -- If you have the DB2 data source defined, you can import a QMF Query using the SQL Assistant. The SQL statement of the QMF Query is downloaded from the QMF server. The DB2 data source is used to connect to DB2 and submit the SQL statements to DB2 directly.
QMF files opened in Approach can be accessed using SRPI (LU 2) or APPC (LU 6.2) connections.



Planned Availability Dates

  • QMF V3.3 for MVS, VSE & VM: June 13, 1997
  • QMF V3.3 HPO/Shuttle Features for MVS, VSE & VM: July 18, 1997
QMF Version 3.3 for MVS, VSE & VM National Language Features:
  • July 18, 1997
    • French
    • German
    • Japanese
    • Upper Case English
  • August 15, 1997
    • Simplified Chinese
    • Brazilian Portuguese
    • Italian
    • Swedish (MVS and VM only)
    • Swiss German
  • September 12, 1997
    • Canadian French
    • Danish (MVS and VM only)
    • Korean
    • Spanish
    • Swiss French
QMF High Performance Option/Shuttle National Language Features for MVS, VSE & VM:
  • July 18, 1997
    • French
    • German
  • August 15, 1997
    • Italian
    • Brazilian Portuguese
  • September 12, 1997
    • Danish (MVS and VM only)
    • Spanish



Year 2000

This product is year 2000 ready. When used in accordance with its associated documentation, it is capable of correctly processing, providing, and/or receiving date data within and between the 20th and 21st centuries, provided all other products, (for example, software, hardware, and firmware) used with the product properly exchange date data with it.



PRODUCT POSITIONING

QMF is IBM's leading query and report writer for the S/390 (R). QMF is designed to work closely with and exploit the latest features of the DB2 Family of databases. QMF's architecture fulfills the role of an "intelligent server", which provides the ability to quickly share objects across the enterprise as well as provide the robustness to deal with large amounts of data and printing.

QMF's easy application development and distributed processing capabilities extend its useability beyond the S/390 platform and make QMF and its HPO features a cross-platform, client server solution for users ranging from the computer novice to the Information Systems professional.

QMF HPO/Shuttle complements DB2 and the QMF Family of products. By offering extremely high querying performance from the Windows environment, access to existing QMF objects (queries, forms), execution of QMF commands, and extensive governing control over user actions and DB2 resource consumption, QMF HPO/Shuttle is a natural selection over and above any other tool for customers who have DB2, QMF, or both. QMF HPO/Shuttle is for customers who wish to extend their industrial strength DB2 capabilities to applications in the Windows environment.

The QMF HPO/Manager and QMF HPO/Compiler features of the QMF High Performance Option have been available on the MVS platform for several years. Now, QMF HPO/Shuttle is included with any QMF HPO/Manager or QMF HPO/Compiler feature. In addition to integrating high-performance DB2 querying and QMF objects (queries and forms) into nearly all Windows applications, the combination of QMF HPO/Manager and QMF HPO/Shuttle will provide governing over users in the Windows and QMF MVS environments.

QMF HPO/Shuttle is also available as a feature for VM and VSE. QMF Version 3.3 offers VM and VSE users the full-function capabilities of QMF and QMF HPO/Shuttle as is offered to MVS users operating in corresponding environments.

QMF HPO/Shuttle for the Windows environment satisfies the need of QMF users for end-user productivity, for improving the QMF end-user interface, and for better control of their query environment.



EDUCATION SUPPORT

The appropriate curriculum will be updated, as necessary, to include the enhancements in this announcement.

Descriptions of all classroom and self-study courses are contained in the Catalog of IBM Education and Training catalogs.

Call IBM Education and Training at 800-IBM-TEACH (426-8322) for education catalogs, schedules, and enrollments.

To take full advantage of IBM software products, training is a critical step. With the IBM Education Card, an individual can take unlimited IBM Education and Training public classes or conferences for a whole year for the one flat price of $4,495. The IBM Education Card is an ideal, cost effective answer if you are getting ready to install new hardware or software and need to raise abilities and knowledge quickly or have new employees to train. The benefits to IBM customers are:

  • Save money as you increase learning

  • Get management approval once

  • Stretch a limited education budget

  • Convenient courses offered coast to coast

  • Choose from over 500 courses
For more information or to apply for your IBM Education Card, call 800-IBM-TEACH (426-8322) or visit us on the World Wide Web at:
    www.training.ibm.com/ibmedu



REFERENCE INFORMATION

  • Software Announcement 296-352, dated September 10, 1996 (QMF HPO/Shuttle Version 3.2 Client for VM, VSE and MVS)

  • Software Announcement 295-411, dated September 26, 1995 (QMF Version 3 Release 2)

  • Software Announcement 294-217, dated April 12, 1994 (Query Management Facility High Performance Options for MVS Version 3 Release 1 Modification 1)

  • Software Announcement 293-595, dated October 12, 1993 (Query Management Facility VSE/ESA (TM) Version 3 Release 1 Modification 1)

  • Software Announcement 291-497, dated September 11, 1991 (Query Management Facility Version 3 Release 1 Modification 1)

  • Software Announcement 290-527, dated September 5, 1990 (Query Management Facility Version 3 Release 1)

  • Software Announcement 294-154, dated April 6, 1994 (IBM System/390 (R) Parallel Sysplex (TM) Software Pricing)
Trademarks
      QMF, Distributed Relational Database Architecture, SQL/DS,
      MVS/ESA, IMS, VSE/ESA, and Parallel Sysplex are trademarks of
      International Business Machines Corporation in the United
      States or other countries or both.
      DB2, MVS, AIX, OS/2, DRDA, DataJoiner, S/390, and System/390
      are registered trademarks of International Business Machines
      Corporation in the United States or other countries or both.
      Windows and Microsoft are registered trademarks of Microsoft
      Corporation.
      UNIX is a registered trademark in the United States and other
      countries exclusively through X/Open Company Limited.
      Other company, product, and service names may be trademarks or
      service marks of others.



SUPPLEMENTAL INFORMATION

Open Enterprise: QMF (TM) Version 3.3 and its QMF HPO/Shuttle features provide support for numerous industry standards, including those of the Distributed Relational Database Architecture (TM) (DRDA (R)).



TECHNICAL INFORMATION



Specified Operating Environment

Hardware Requirements: QMF Version 3.3 runs on any processor supported by the operating systems listed in Software Requirements section.

The processors must have sufficient real storage to satisfy the combined requirements of the operating system and support programs. The configuration must include sufficient I/O devices to support the requirements for system output, systems residence, and system data sets.

Sufficient direct-access storage must be available to satisfy the user information storage requirements and can consist of any direct-access facility supported by the system configuration and the programming system.

DASD or Tape

QMF can access all storage devices supported by the operating system and the supported databases.

QMF uses disk devices for the following objects in the MVS (R) and VM environments:

  • Spill file data set, which holds the data for the report that a user is viewing (but only when the data does not fit in virtual storage)

  • Database objects managed by DB2 (R) or SQL/DS (TM)

  • Import data sets that hold data, queries, forms, or procedures

  • Export data sets that hold data, queries, forms, procedures, reports, or charts

  • Temporary files created for editing a SQL query or procedure

  • Print and debug (trace) data sets

    Optionally, QMF can use tape devices for the print and debug (trace) data sets.

Data Communication Devices

QMF can display on all terminals supported by GDDM (R).

Virtual Storage Considerations

The storage requirements in this section are based upon development laboratory measurements using the following releases of support products:

For TSO/MVS:

  • ISPF Version 3 Release 3
  • GDDM Version 3 Release 1.1
  • DB2 Version 3 Release 1
For CICS/MVS (R):
  • CICS (R) Version 2 Release 1
  • GDDM Version 2 Release 3
  • DB2 Version 3 Release 1
For CICS/VSE (R):
  • CICS Version 2 Release 2
  • GDDM Version 2 Release 3 or Version 3 Release 1.1
  • VSE SQL/DS Version 3 Release 4
For CMS/VM:
  • ISPF Version 3 Release 2
  • GDDM Version 2 Release 3 or Version 3 Release 1.1
  • VM SQL/DS Version 3 Release 5
Storage requirements might vary when using versions or releases other than those shown above.

TSO/MVS

In the OS/390 (TM), MVS/ESA (TM) and MVS/XA (TM) environments, minimum storage for users to execute QMF queries and hold QMF report data is between 0.5MB and 1.0MB. As an example, if you run in a standard TSO environment with ISPF and GDDM, you need about 6.0MB of storage. The generation of complex reports, or the use of TSO CLIST commands to run other functions within a QMF session, might require additional storage. The use of graphics (for example, CHART) requires additional storage.

The MVS/ESA and the MVS/XA 31-bit virtual storage addressing capability allows most QMF modules to reside in the EPLPA or PLPA.

If QMF modules are placed in the MVS/ESA or in the MVS/XA EPLPA/PLPA, up to 2.8MB can be located in the EPLPA, and 52KB can be located in the PLPA, decreasing the demand for space in the user's region. The size of the region may be further reduced by placing ISPF and GDDM into the PLPA, which increases the common area accordingly.

CICS/MVS Environment

QMF runs as a conversational transaction in CICS, and there are multiple users of QMF in the same CICS address space. Each user that runs a QMF transaction requires at least 1.0MB of storage from the CICS region. All but 24KB can be allocated to storage above 16.0MB. A single copy of the QMF module, up to 2.7MB, can be placed in the EPLPA, or within the CICS region above 16.0MB, and 52KB can be located in PLPA or within the CICS region below 16.0MB.

CICS/VSE Environment

The minimum acceptable partition size for any QMF system is 18.0MB, regardless of the number of users. The recommended size for a system with up to 20 QMF users is 24.0MB. For systems with more than 20 QMF users, the partition size should be increased by 0.5MB to 1.0MB for each additional user, to execute queries and produce reports. Some users might require more or less storage, depending on the amount of data requested and the QMF formatting options used for the report. The IBM book, Installing QMF on VSE/ESA (TM) helps you calculate direct access storage device (DASD) storage and virtual storage requirements.

VM/ESA (R) Environment

In the VM/ESA environment QMF must be in a discontinuous shared segment (DCSS). All QMF modules (in a 31-bit shared segment) require approximately 2.8MB storage. User storage required to run QMF is approximately 0.5 to 1MB. Additional storage is required for other applications. For example, when running a standard CMS environment with ISPF and GDDM, approximately 6MB total is needed.

The QMF DCSS may be located above 16.0MB. If the user generates complex reports or uses CMS EXECs to run other functions within a QMF session, more storage may be required. Graphics (for example, CHART) requires additional storage.

Software Requirements: Prerequisite products to support QMF vary by operating system. This section shows the program requirements for QMF Version 3.3 by operating environment. The minimum release level for each product is listed; later releases are also supported unless stated otherwise.

Later releases that are not available at the QMF Version 3 Release 3 announcement time are not supported, unless specifically stated otherwise.

The tables also show a Program Products Required for Optional Functions section to identify other program products you might need to use for certain QMF functions. Consult the Licensed Program Specifications for each product shown for individual program requirements and prerequisites.

.--------------------------------------------------------.
|TABLE 1                                                 |
|--------------------------------------------------------|
|Prerequisite Software For QMF For MVS/ESA               |
|-------------------------+---------------------+--------|
|Required Products        |Version  Release     |Number  |
|-------------------------+---------------------+--------|
|o MVS/ESA SP(TM) JES2,   |Version 4 Release 2  |5695-047|
|  or MVS/ESA SP JES3     |Version 4 Release 2  |5695-048|
|o MVS/Data Facility      |Version 3 Release 1  |5665-XA3|
|  Product (DFP)          |                     |        |
|o DATABASE 2(TM) (DB2)   |Version 3 Release 1  |5685-DB2|
|o GDDM/MVS               |Version 2 Release 3  |5665-356|
|-------------------------+---------------------+--------|
|For installation only:   |                     |        |
|-------------------------+---------------------+--------|
|o Interactive System     |Version 3 Release 5  |5685-054|
|  Product Facility       |                     |        |
|  (ISPF)-MVS             |                     |        |
|o System Modification    |Version 1 Release 8  |5668-949|
|  Program Extended       |                     |        |
|   (SMP/E)               |                     |        |
|-------------------------+---------------------+--------|
|For the TSO environment: |                     |        |
|-------------------------+---------------------+--------|
|o TSO/Extensions (TSO/E) |Version 2 Release 4  |5685-025|
|-------------------------+---------------------+--------|
|For the CICS             |                     |        |
| environment:            |                     |        |
|-------------------------+---------------------+--------|
|o CICS/ESA(R), or        |Version 4 Release 1.1|5655-018|
|  CICS/ESA, or           |Version 3 Release 1  |5683-083|
|  CCS/MVS                |Version 2 Release 1.1|5665-403|
'-------------------------+---------------------+--------'

.----------------------------------------------------------.
|TABLE 2                                                   |
|----------------------------------------------------------|
|Prerequisite Software For QMF For OS/390                  |
|--------------------------+----------------------+--------|
|Required Products         |Version Release       |Number  |
|--------------------------+----------------------+--------|
|o Database 2 (DB2)        |Version 3 Release 1   |5685-DB2|
|--------------------------+----------------------+--------|
|For the CICS environment: |                      |        |
|--------------------------+----------------------+--------|
|o CICS/ESA, or            |Version 3 Release 3   |5683-083|
|  CICS/ESA                |Version 4 Release 1.1 |5655-018|
'--------------------------+----------------------+--------'

.----------------------------------------------------------. |TABLE 3 | |----------------------------------------------------------| |Prerequisite Software For QMF For MVS/XA | |--------------------------+----------------------+--------| |Required Products |Version Release |Number | |--------------------------+----------------------+--------| |o MVS/SP(TM)-JES2, or |Version 2 Release 2 |5740-XC6| | MVS/SP-JES3 |Version 2 Release 2.1 |5665-291| |o MVS/XA Data Facility |Version 2 Release 1 |5665-XA2| | Product (DFP) | | | |o Database 2 (DB2) |Version 3 Release 1 |5685-DB2| |o GDDM/MVS |Version 2 Release 3 |5665-356| |--------------------------+----------------------+--------| |For installation only: | | | |--------------------------+----------------------+--------| |o Interactive System |Version 2 Release 3 |5665-319| | Product Facility | | | | (ISPF)-MVS | | | |o System Modification |Version 1 Release 8 |5668-949| | Program Extended | | | | (SMP/E) | | | |--------------------------+----------------------+--------| |For the TSO Environment(1)| | | |--------------------------+----------------------+--------| |o TSO/Extensions (TSO/E) |Version 2 Release 1 |5685-025| |--------------------------+----------------------+--------| |For the CICS environment: | | | |--------------------------+----------------------+--------| |o CICS/MVS |Version 2 Release 1 |5665-403| '--------------------------+----------------------+--------'

.----------------------------------------------------------. |TABLE 4 (Part 1 of 6) | |----------------------------------------------------------| |Program Products Required For Optional Functions For QMF | |For MVS | |----------------------+----------------------+------------| |Product |Version Release |Number | |----------------------+----------------------+------------| |ISPF-Related Functions -- One of the following releases is| |required, depending on the version and release supported | |in your MVS environment: | |----------------------------------------------------------| |QMF Document Interface, Default editor for QMF EDIT | |command, display printed report application (DPRE), SPF | |command, and DXT(TM)/End User Dialogs bridge support: | |----------------------+----------------------+------------| |o ISPF for MVS |Version 3 Release 5 |5685-054 | |----------------------+----------------------+------------| |Logic in procedures, report calculations and conditions, | |form column definition, and use of the IBM-supplied | |command synonyms (DPRE, ISPF, BATCH, LAYOUT): | |----------------------+----------------------+------------| |o TSO/Extensions |Version 2 Release 4 |5685-025 | | (TSO/E) | | | |----------------------+----------------------+------------| |Charts (Interactive Chart Utility) | |----------------------+----------------------+------------| |o GDDM Presentation |Version 2 Release 1.1 |5668-812 | | Graphics Facility | | | | (PGF) | | | |----------------------+----------------------+------------| |QMF Document Interface | |The following editor is required: | |----------------------+----------------------+------------| |o Personal |Release 1 |5665-346 | | Services/TSO | | | | (PS/TSO) | | | |----------------------+ ---------------------+------------| |Data Extract (DXT), End User Dialogs and the QMF | |EXTRACT COMMAND: | |----------------------+----------------------+------------| |o Data Extract |Version 2 Release 5 |5668-788 | '----------------------+----------------------+------------'

.----------------------------------------------------------.
| TABLE 4 (Part 2 of 6)                                    |
|----------------------------------------------------------|
|Program Products Required For Optional Functions For QMF  |
| For MVS                                                  |
|-----------------------+----------------------+-----------|
| Product               | Version  Release     | Number    |
|-----------------------+----------------------+-----------|
| QMF High Performance Option (HPO)/Compiler or            |
| QMF High Performance Option (HPO)/Manager:               |
|-----------------------+----------------------+-----------|
| o   ISPF for MVS      | Version 3            | 5685-054  |
|-----------------------+----------------------+-----------|
| QMF HPO/Shuttle for the Windows(R) environment:          |
|-----------------------+----------------------+-----------|
| o   Microsoft(R)      | Version 3 Release 1  |           |
|     Windows,          |                      |           |
|        or             |                      |           |
| o   Microsoft         | Version 3 Release 1  |           |
|     Windows for       |        or            |           |
|     Workgroups,       | Version 3 Release 1.1|           |
|        or             |                      |           |
| o   Microsoft         |                      |           |
|     Windows 95        |                      |           |
|        or             |                      |           |
| o   Microsoft         |                      |           |
|     Windows NT        |                      |           |
|                       |                      |           |
| o   IBM APPC          | Version 1            |           |
|     Networking        |                      |           |
|     Services for      |                      |           |
|     Windows,          |                      |           |
|        or             |                      |           |
| o   Microsoft SNA     | Version 2, or        |           |
|     Server            | Version 2.1, or      |           |
|                       | Version 2.11         |           |
|        or             |                      |           |
| o   Novell NetWare    | Version 2            |           |
|     for SAA(R)        |                      |           |
|        or             |                      |           |
| o   Attachmate EXTRA! | Version 3.11         |           |
|     APPC Client       |                      |           |
'-----------------------+----------------------+-----------'

.----------------------------------------------------------. | TABLE 4 (Part 3 of 6) | |----------------------------------------------------------| |Program Products Required For Optional Functions For QMF | | For MVS | |-----------------------+----------------------+-----------| | Product | Version Release | Number | |-----------------------+----------------------+-----------| |Callable Interface Programs written in the callable | | interface can be written in: | |-----------------------+----------------------+-----------| | o IBM C/370(TM) | Version 2 | 5688-187 | | Compiler and | | | | C/370 Library | Version 2 | 5688-188 | | o IBM HLASM | Version 1 Release 1 | 5696-234 | | | or Release 2 | | | o VS COBOL II | Version 1 Release 4 | 5688-023 | | Compiler and | | | | Library | | | |-----------------------+----------------------+-----------| | o VS COBOL II | Version 1 Release 4 | 5668-958 | | Compiler, Library | | | | and Debugging | | | | Facility | | | | o IBM COBOL for MVS | Version 1 Release 2 | 5688-197 | | and VM | | | | o AD/Cycle(R) C/370 | Version 1 Release 1 | 5688-216 | | Compiler | | | | o VS FORTRAN(1) | Version 2 Release 5 | 5668-806 | | o OS PL/I | Version 2 Release 3 | 5668-909 | | o IBM PL/I for MVS | Version 1 Release 1.1| 5688-235 | | and VM | | | | o Assembler H | Version 2 Release 1 | 5668-962 | | o IBM C/C++ for | Version 3 | 5655-121 | | MVS/ESA(2) | | | '-----------------------+----------------------+-----------' Note: (1) REXX and the SAA callable interface for FORTRAN are not supported in the QMF/CICS environment. (2) In conjunction with Language Environment (R) for MVS and VM (MVS feature).

.----------------------------------------------------------.
|TABLE 4 (Part 4 of 6)                                     |
|----------------------------------------------------------|
|Program Products Required For Optional Functions For QMF  |
| For MVS                                                  |
|------------------------+----------------------+----------|
| Product                | Version   Release    | Number   |
|------------------------+----------------------+----------|
| User Edit Routines can be written in:                    |
|------------------------+----------------------+----------|
| o IBM HLASM            |Version 1             |5696-234  |
| o VS COBOL II Compiler |Version 1 Release 4   |5688-023  |
|   and Library          |                      |          |
|------------------------+----------------------+----------|
| o COBOL/370(TM)        |Version 1 Release 1   |5688-197  |
|   Compiler and         |                      |          |
|   Library              |                      |          |
| o IBM COBOL for MVS    |Version 1 Release 2   |5688-197  |
|   and VM               |                      |          |
| o VS COBOL II Compiler |Version 1 Release 3.1 |5688-023  |
|   and Library          |                      |          |
| o VS COBOL II          |Version 1 Release 3.1 |5668-958  |
|   Compiler, Library    |                      |          |
|   and Debugging        |                      |          |
|   Facility             |                      |          |
| o OS PL/I              |Version 2 Release 3   |5668-909  |
| o IBM  PL/I for MVS    |Version 1 Release 1.1 |5688-235  |
|   and VM               |                      |          |
| o Assembler H or       |Version 2 Release 1   |5668-962  |
|   standard assembler   |                      |          |
|------------------------+----------------------+----------|
| Governor Exit Routine                                    |
|------------------------+----------------------+----------|
| o IBM HLASM            |Version 1             |5696-234  |
|------------------------+----------------------+----------|
| o Assembler H or       |Version 2 Release 1   |5668-962  |
|   standard assembler   |                      |          |
'------------------------+----------------------+----------'

.----------------------------------------------------------. |TABLE 4 (Part 5 of 6) | |----------------------------------------------------------| |Program Products Required For Optional Functions For QMF | | For MVS | |----------------------------------------------------------| | Remote Unit of Work (MVS) | |-----------------------+----------------------+-----------| | Product | Version Release | Number | |-----------------------+----------------------+-----------| |Connection to remote DB2 on MVS DRDA Application Server: | |-----------------------+----------------------+-----------| | At the local DB2 for | | | | MVS/ESA location: | | | | | | | | o DB2 for MVS | Version 3 Release 1 | 5685-DB2 | | o QMF for MVS | Version 3 Release 3 | 5706-254 | | | | | | At the remote DB2 | | | | database: | | | | | | | | o DB2 for MVS | Version 3 Release 1 | 5685-DB2 | | o QMF for MVS | Version 3 Release 3 | 5706-254 | |-----------------------+----------------------+-----------| |Connection to remote SQL/DS on VM DRDA Application Server:| |-----------------------+----------------------+-----------| | At the local DB2 for | | | | MVS/ESA location: | | | | | | | | o DB2 for MVS | Version 3 Release 1 | 5685-DB2 | | o QMF for MVS | Version 3 Release 3 | 5706-254 | | | | | | At the remote SQL/DS | | | | database: | | | | | | | | o SQL/DS for VM | Version 3 Release 5 | 5688-103 | | o QMF for VM | Version 3 Release 3 | 5706-255 | |-----------------------+----------------------+-----------| |Connection to remote SQL/DS on VSE DRDA Application Server| |-----------------------+----------------------+-----------| | At the local DB2 for | | | | MVS/ESA location: | | | | | | | | o DB2 for MVS | Version 3 Release 1 | 5685-DB2 | | o QMF for MVS | Version 3 Release 3 | 5706-254 | | | | | | At the remote SQL/DS | | | | for VSE database: | | | | | | | | o SQL/DS for VSE | Version 3 Release 4 | 5688-103 | | o QMF for VSE | Version 3 Release 3 | 5648-061 | '----------------------------------------------------------'

.---------------------------------------------------------.
|TABLE 4 (Part 6 of 6)                                    |
|---------------------------------------------------------|
|Program Products Required For Optional Functions For QMF |
| For MVS                                                 |
|-----------------------+----------------------+----------|
|Product                | Version  Release     |Number    |
|-----------------------+----------------------+----------|
|Connection to DB2 PE, DataJoiner(R), Common Server:      |
|-----------------------+----------------------+----------|
| At the local DB2 for  |                      |          |
| MVS/ESA location:     |                      |          |
|                       |                      |          |
| o   DB2 for MVS       | Version 3 Release 1  |5685-DB2  |
|                       |  with PTF UP75959    |          |
|                       |       PTF UN54601    |          |
| o   QMF for MVS       | Version 3 Release 3  |5706-254  |
|                       |                      |          |
| At the remote database|                      |          |
|  configured for APPC  |                      |          |
|  communications:      |                      |          |
|                       |                      |          |
| o   DB2 Parallel      | Version 1 Release 2  |5765-328  |
|     Edition for AIX(R)|                      |          |
|       or              |                      |          |
| o   DataJoiner for AIX| Version 1 Release 2  |84H1212   |
|       or              |                      |          |
| o   DB2 for Windows NT| Version 2 Release 1  |53H7474   |
|       or              |                      |          |
| o   DB2 for OS/2(R)   | Version 2 Release 1  |41H2114   |
|       or              |                      |          |
| o   DB2 for AIX or    | Version 2 Release 1  |41H2128   |
| o   DB2 for HP-UX or  | Version 2 Release 1  |10H2366   |
| o   DB2 for Solaris or| Version 2 Release 1  |10H2421   |
| o   DB2 for SCO       | Version 2 Release 1  |79H5359   |
|     OpenServer or     |                      |          |
| o   DB2 for SINIX     |  Version Release 1   |79H4133   |
'-----------------------+----------------------+----------'

.-----------------------------------------------------------.
|TABLE 5                                                    |
|-----------------------------------------------------------|
|Prerequisite Software For QMF For VM/ESA                   |
|--------------------------+----------------------+---------|
|Required Products         |Version   Release     |Number   |
|--------------------------+----------------------+---------|
| o IBM VM/ESA             |Version 1 Release 2.2 |5684-112 |
|   for the ESA feature, or|                      |         |
|   IBM VM/ESA for the 370 |Version 1 Release 1.5 |5684-112 |
|   feature                |                      |         |
| o SQL/DS for VM          |Version 3 Release 5   |5688-103 |
| o GDDM/VMXA or           |Version 2 Release 3   |5684-007 |
|   GDDM/VM                |Version 3 Release 1.1 |5684-168 |
'--------------------------+----------------------+---------'

.---------------------------------------------------------.
|TABLE 6 (Part 1 of 6)                                    |
|---------------------------------------------------------|
|Program Products Required For Optional Functions For QMF |
| For VM                                                  |
|----------------------+----------------------+-----------|
|Product               | Version   Release    | Number    |
|----------------------+----------------------+-----------|
| o ISPF               |Version 3 Release 2   | 5684-043  |
|----------------------+----------------------+-----------|
| CHARTS (Interactive Chart Utility)                      |
|----------------------+----------------------+-----------|
| o GDDM Presentation  | Version 2 Release 1.1| 5668-812  |
|   Graphics Facility  |                      |           |
|   (PGF) (for GDDM/   |                      |           |
|    VM/XA(TM) V2 R3)  |                      |           |
|     or               |                      |           |
| o GDDM Presentation  |Version 2 Release 1.2 | 5668-812  |
|   Graphics Facility  |                      |           |
|   (PGF) (for GDDM/   |                      |           |
|    VM V3 R1.1)       |                      |           |
|----------------------+----------------------+-----------|
|Default editor for QMF EDIT command, display printed     |
|report application, ISPF command, and DXT/End User       |
|Dialogs bridge support:                                  |
|----------------------+----------------------+-----------|
| o ISPF/Program       | Version 3 Release 2  | 5684-123  |
|   Development        |                      |           |
|   Facility for VM    |                      |           |
'----------------------+----------------------+-----------'
.---------------------------------------------------------.
|TABLE 6 (Part 1 of 6 continued)                          |
|---------------------------------------------------------|
| QMF Document Interface                                  |
|----------------------+----------------------+-----------|
| o VM/SP System       |                      |           |
|   Product Editor     |                      |           |
|   (XEDIT)            |                      |           |
| o IBM                | Version 1 Release 2  | 5684-084  |
|   OfficeVision/VM(TM)|                      |           |
| o ISPF/PDF for VM    | Version 3 Release 2  | 5684-123  |
'----------------------+----------------------+-----------'

.------------------------------------------------------. |TABLE 6 (Part 2 of 6) | |------------------------------------------------------| |Program Products Required For Optional Functions For | | QMF For VM | |---------------------+----------------------+---------| |Product | Version Release | Number | |---------------------+----------------------+---------| |Callable Interface Programs using the callable | | interface can be written in: | |---------------------+---------------------+----------| | o IBM C/370 |Version 2 |5688-187 | | Compiler and | | | | C/370 Library |Version 2 |5688-188 | | o IBM HLASM |Version 1 Release 1 |5696-234 | | |or Release 2 | | | o VS COBOL II |Version 1 Release 4 |5688-023 | | Compiler and | | | | Library | | | | o VS COBOL II |Version 1 Release 4 |5668-958 | | Compiler, Library | | | | and Debugging | | | | Facility | | | | o IBM COBOL for MVS |Version 1 Release 2 |5688-197 | | and VM | | | | o AD/Cycle C/370 |Version 1 Release 1 |5688-216 | | Compiler | | | | o VS FORTRAN(1) |Version 2 Release 5 |5668-806 | | o OS PL/I |Version 2 Release 3 |5668-909 | | o IBM PL/I for MVS |Version 1 Release 1.1|5688-235 | | and VM | | | | o REXX: TSO |Version 2 Release 1 |5685-025 | | Extensions | | | | (TSO/E)(1) | | | | o REXX(1) |in VM/ESA | | | o Assembler H |Version 2 Release 1 |5668-962 | | o IBM C/C++ for |Version 3 |5655-121 | | MVS/ESA(2) | | | '---------------------+---------------------+----------' NOTE: (1) REXX and the SAA callable interface for FORTRAN are not supported in the QMF/CICS environment. (2) In conjunction with Language Environment for MVS and VM (MVS feature).

.------------------------------------------------------. |TABLE 6 (Part 3 of 6) | |------------------------------------------------------| |Program Products Required For Optional Functions For | | QMF For VM | |---------------------+----------------------+---------| |Product |Version Release |Number | |---------------------+----------------------+---------| |User Edit Routines can be written in: | |---------------------+----------------------+---------| | o IBM HLASM |Version |5696-234 | | o VS COBOL II |Version 1 Release 4 |5688-023 | | Compiler and | | | | Library | | | | o COBOL/370 |Version 1 Release 1 |5688-197 | | Compiler and | | | | Library | | | | o VS COBOL II |Version 1 Release 3.1 |5688-023 | | Compiler and | | | | Library | | | | o VS COBOL II |Version 1 Release 3.1 |5668-958 | | Compiler, Library | | | | and Debugging | | | | Facility | | | | o IBM COBOL for MVS |Version 1 Release 2 |5688-197 | | and VM | | | | o OS PL/I |Version 2 Release 3 |5668-909 | | o IBM PL/I for MVS |Version 1 Release 1.1 |5688-235 | | and VM | | | | o Assembler H or |Version 2 Release 1 |5668-962 | | standard | | | | assembler | | | |---------------------+----------------------+---------| |Governor Exit Routine | |---------------------+----------------------+---------| | o IBM HLASM |Version 1 |5696-234 | '---------------------+----------------------+---------'

.--------------------------------------------------.
|TABLE 6 (Part 4 of 6)                             |
|--------------------------------------------------|
|Program Products Required For Optional Functions  |
| For QMF For VM                                   |
|-------------------+----------------------+-------|
|Product            | Version  Release     |Number |
|-------------------+----------------------+-------|
|QMF HPO/Shuttle for the Windows environment:      |
|-------------------+----------------------+-------|
| o Microsoft       |Version 3 Release 1   |       |
|   Windows,        |                      |       |
|      or           |                      |       |
| o Microsoft       |Version 3 Release 1   |       |
|   Windows for     |       or             |       |
|   Workgroups,     |Version 3 Release 1.1 |       |
|      or           |                      |       |
| o Microsoft       |                      |       |
|   Windows 95      |                      |       |
|      or           |                      |       |
| o Microsoft       |                      |       |
|   Windows NT      |                      |       |
|                   |                      |       |
| o IBM APPC        |Version 1             |       |
|   Networking      |                      |       |
|   Services for    |                      |       |
|   Windows,        |                      |       |
|      or           |                      |       |
| o Microsoft SNA   |Version 2, or         |       |
|   Server          |Version 2.1, or       |       |
|                   |Version 2.11          |       |
|      or           |                      |       |
| o Novell NetWare  |Version 2             |       |
|   for SAA         |                      |       |
|      or           |                      |       |
| o Attachmate      | Version 3.11         |       |
|   EXTRA! APPC     |                      |       |
|   Client          |                      |       |
'-------------------+----------------------+-------'

.------------------------------------------------------. |TABLE 6 (Part 5 of 6) | |------------------------------------------------------| |Program Products Required For Optional Functions For | | QMF For VM | |------------------------------------------------------| |Remote Unit of Work (VM): | |------------------------------------------------------| |Connection to remote SQL/DS on VM DRDA Application | | Server | |-----------------------+--------------------+---------| | At the local SQL/DS | | | | location: | | | | | | | | o SQL/DS for VM |Version 3 Release 5 |5688-103 | | o QMF for VM |Version 3 Release 3 |5706-255 | | | | | | At the remote SQL/DS | | | | for VM database: | | | | | | | | o SQL/DS for VM |Version 3 Release 5 |5688-103 | | o QMF for VM |Version 3 Release 3 |5706-255 | |-----------------------+--------------------+---------| |Connection to remote DB2 for MVS/ESA DRDA Application | | Server | |-----------------------+--------------------+---------| | At the local SQL/DS | | | | location: | | | | | | | | o SQL/DS for VM |Version 3 Release 5 |5688-103 | | o QMF for VM |Version 3 Release 3 |5706-255 | | | | | | At the remote DB2 for | | | | MVS/ESA database: | | | | | | | | o DB2 for MVS |Version 3 Release 1 |5685-DB2 | | o QMF for MVS |Version 3 Release 3 |5706-254 | '-----------------------+--------------------+---------'

.------------------------------------------------------.
|TABLE 6 (Part 6 of 6)                                 |
|------------------------------------------------------|
|Program Products Required For Optional Functions For  |
| QMF For VM                                           |
|-----------------------+--------------------+---------|
|Product                | Version   Release  | Number  |
|-----------------------+--------------------+---------|
|Connection to remote SQL/DS on VSE DRDA Application   |
| Server                                               |
|-----------------------+--------------------+---------|
| At the local SQL/DS   |                    |         |
| location:             |                    |         |
|                       |                    |         |
| o  SQL/DS for VM      |Version 3 Release 5 |5688-103 |
| o  QMF for VM         |Version 3 Release 3 |5706-255 |
|                       |                    |         |
| At the remote SQL/DS  |                    |         |
| for VSE database:     |                    |         |
|                       |                    |         |
| o  SQL/DS for VSE     |Version 3 Release 4 |5688-103 |
| o  QMF for VSE        |Version 3 Release 3 |5648-061 |
|-----------------------+--------------------+---------|
|Connection to DB2 PE, DataJoiner, Common Server:      |
|-----------------------+--------------------+---------|
| At the local SQL/DS   |                    |         |
| location:             |                    |         |
|                       |                    |         |
| o  SQL/DS             |Version 3 Release 5 |5688-103 |
|                       |                    |         |
| o  QMF for VM         |Version 3 Release 3 |5706-255 |
|                       |                    |         |
|At the remote database |                    |         |
|  configured for APPC  |                    |         |
|  communications:      |                    |         |
|                       |                    |         |
| o  DB2 Parallel       |Version 1 Release 2 |5765-328 |
|    Edition for AIX or |                    |         |
| o  DataJoiner for AIX |Version 1 Release 2 |84H1212  |
|    or                 |                    |         |
| o  DB2 for Windows NT |Version 2 Release 1 |53H7474  |
|    or                 |                    |         |
| o  DB2 for OS/2 or    |Version 2 Release 1 |41H2114  |
| o  DB2 for AIX or     |Version 2 Release 1 |41H2128  |
| o  DB2 for HP-UX or   |Version 2 Release 1 |10H2366  |
| o  DB2 for Solaris or |Version 2 Release 1 |10H2421  |
| o  DB2 for SCO        |Version 2 Release 1 |79H5359  |
|    OpenServer or      |                    |         |
| o  DB2 for SINIX      |Version 2 Release 1 |79H4133  |
'-----------------------+--------------------+---------'

.--------------------------------------------------------.
|TABLE 7                                                 |
|--------------------------------------------------------|
|Prerequisite Software for QMF for VSE/ESA               |
|------------------------+----------------------+--------|
|Required Products       | Version   Release    |Number  |
|------------------------+----------------------+--------|
| o IBM Virtual Storage  |Version 1 Release 3.1 |5750-ACD|
|   Extended/Enterprise  |                      |        |
|   Systems Architecture |                      |        |
|   (VSE/ESA)            |                      |        |
| o CICS/VSE             |Version 2 Release 2   |5686-026|
| o GDDM/VSE             |Version 3 Release 1   |5686-057|
| o  SQL/DS for VSE      |Version 3 Release 4   |5688-103|
'------------------------+----------------------+--------'

.----------------------------------------------------.
| TABLE 8                                            |
|----------------------------------------------------|
|Program Products Required For Optional Functions For|
| QMF For VSE                                        |
|--------------------+----------------------+--------|
| Product            | Version   Release    |Number  |
|--------------------+----------------------+--------|
| Charts (Interactive Chart Utility):                |
|--------------------+----------------------+--------|
| o GDDM-PGF (for    |Version 2 Release 1.2 |5668-812|
|   GDDM Version 3   |                      |        |
|   Release 1.1), or |                      |        |
|   GDDM-PGF (for    |Version 2 Release 1.1 |5668-812|
|   GDDM Version 2   |                      |        |
|   Release 3        |                      |        |
|--------------------+----------------------+--------|
|Callable Interface Programs using the callable      |
| interface can be written in:                       |
|--------------------+----------------------+--------|
| o IBM C/370        |Version 2             |5688-187|
|   Compiler and     |                      |        |
|   C/370 Library    |Version 2             |5688-188|
| o IBM HLASM        |Version 1 Release 1   |5696-234|
|                    |or Release 2          |        |
| o VS COBOL II      |Version 1 Release 4   |5688-023|
|   Compiler and     |                      |        |
|   Library          |                      |        |
| o COBOL for VSE    |Version 1 Release 1   |5686-068|
| o PL/I for VSE     |Version 1 Release 1   |5686-069|
|--------------------+----------------------+--------|
| User Edit Routines can be written in:              |
|--------------------+----------------------+--------|
| o IBM HLASM        |Version 1             |5696-234|
| o VS COBOL II      |Version 1 Release 4   |5688-023|
|   Compiler and     |                      |        |
|   Library          |                      |        |
| o COBOL for VSE    |Version 1 Release 1   |5686-068|
| o PL/I for VSE     |Version 1 Release 1   |5686-069|
|--------------------+----------------------+--------|
| Governor Exit Routine                              |
|--------------------+----------------------+--------|
| o IBM HLASM        |Version 1             |5696-234|
|                    |                      |        |
'--------------------+----------------------+--------'



Operating Environment for QMF HPO Features

The QMF HPO/Compiler generates programs in OS/VS COBOL and VS COBOL II. Since VS COBOL II is source compatible with AD/Cycle COBOL/370 and COBOL for MVS, those products are supported also.

The QMF HPO/Compiler for MVS runs only under TSO/ISPF, but generates programs that run under TSO/ISPF, batch, or CICS. The QMF HPO/Manager for MVS runs only under TSO/ISPF (with the exception of the enhanced HPO Governor Module supplied with the feature, that runs under TSO/ISPF, batch, or CICS).

QMF HPO/Shuttle runs under Windows 3.1 and higher, Windows 95, Windows NT and WIN-OS/2 (R), and accesses DB2 for MVS, DB2 for VM, DB2 for VSE, DB2 for AIX, DB2 Parallel Edition, DB2 for OS/2, DB2 for Windows NT and DataJoiner on AIX. Separate network connectivity requirements must be satisfied.

Products Required to Support Remote Unit of Work

Remote unit of work (RUW) support is not available in all environments in which QMF operates. For example, when running QMF in VSE/ESA, you cannot connect to another location. However, the QMF objects stored in a VSE SQL/DS database can be accessed by other QMF requesters in a Distributed Relational Database Architecture (DRDA) network. To see if RUW is supported in your operating environment, see the documentation for the database you are using.



QMF Product Limitations in the CICS Environment

Some functions provided by QMF are dependent on underlying system services and other program products that are available in VM/CMS and MVS/TSO, but not in CICS (including both CICS/MVS and CICS/VSE). The following commands require ISPF and are not available in CICS:

  • ISPF command synonym
  • DPRE command synonym
  • BATCH command synonym
  • LAYOUT command synonym
  • EXTRACT command
  • QMF command interface
Existing applications and procedures containing commands requiring ISPF will run only if QMF 3.3 is started as an ISPF dialog.

Existing QMF 3.1.0 programs must be relinked. Refer to Developing QMF Applications for more information.

These functions depend on REXX and are not supported by QMF in CICS:

  • Report calculations
  • Conditional formatting
  • Column definition
  • Procedures with logic
Other products not available in CICS:
  • Document Interface
The EDIT PROC and EDIT QUERY commands are not available in CICS. However, it is possible to edit procedures and queries using the DISPLAY command with QMF.



QMF Product Differences for VSE/ESA

The function of QMF for the VSE/ESA operating system is similar to that of QMF on other QMF V3.3 platforms. As a result, some functions that existed in Version 1 are changed or not supported in QMF VSE/ESA V3.3. This section lists those differences. Refer to the QMF Product Limitations in the CICS Environment section in this document for more information on the limitations related to QMF for VSE running exclusively in CICS.

Changed Functions for QMF VSE/ESA: The following commands have changed since QMF Version 1:

  • DISPLAY now displays charts and new forms panels.

  • HELP displays help for a particular message number.

  • IMPORT imports a QMF object from CICS temporary storage or a transient data queue into QMF temporary storage, or directly into the database.

    The IMPORT ISQL command is not supported in QMF V3.3. However, a QMF VSE/ESA V3.3 migration utility can copy ISQL queries into QMF control tables.

    For information on the migration utility, refer to Managing QMF for VSE/ESA.

  • PRINT directs objects to CICS temporary storage queues or transient data queues, depending on the setup at your installation (it can use QMF services exclusively, GDDM services, or a combination of the two). For more information, refer to Managing QMF for VSE/ESA.

  • RESET restores the current object in temporary storage to its original state.

  • SAVE allows you to specify a language for saving forms (English or a National Language Feature used at your installation). This command's ACTION parameter allows you to replace or append to existing objects. This is in addition to this command's previous (Version 1) function.

  • SET now allows you to set global variables.

  • DRAW creates an SQL or a QBE query by retrieving the description of a table.
Functions in QMF VSE Version 1 Not in QMF VSE/ESA V3.3: The following functions, which were supported in QMF VSE Version 1, are not supported in QMF VSE/ESA V3.3:
  • Canceling commands
  • Importing ISQL queries
  • Table plot utility (To create charts, refer to the chapter on charts in Using QMF)
  • QMF VSE V1 defaults module for starting QMF
  • VSE/POWER support (use methods supplied by CICS or GDDM to print your objects)
  • QMF-supplied views
  • QMF sample queries from QMF VSE V1 (QMF V3.3 does not supply sample objects except for tables)
QMF VSE/ESA V3.3 provides a utility for migrating Version 1 queries, forms, procedures, and ISQL queries to Version 3.3. The migration utility is provided with QMF VSE/ESA migration utility.

QMF for VSE/ESA V3.3 does not use the control table Q.PRINTER, which was used in QMF VSE Version 1.

Compatibility

Performance Considerations: Factors relevant to performance are described in the Managing QMF for MVS, Managing QMF for VM, Managing QMF for VSE and QMF HPO/Shuttle Getting Started books which ship with the product.

User Group Requirements: This announcement satisfies or partially satisfies requirements from one or more of the worldwide user group communities, which include Australasian SHARE/GUIDE (ASG), COMMON, COMMON Europe, GUIDE International, G.U.I.D.E. Europe, Japan GUIDE/SHARE (JGS), Guide Latin American (LAG), SHARE EUROPE, and SHARE Incorporated. Requirements satisfied include:

  • Ability to change NULL indicator in Table Editor
    • 2680 (RJGS551), 61210
  • Remove QMF Table Editor restriction with columns defined Not Null
    • 9125, 9125_1, 5667 (I518), 5458 (GU256090034), 7287 (RJI1203)
  • Give users ability to change default of SHARE=N and give DBA ability to globally set SHARE=Y/N default.
    • 41417, 41112, 38409, 5952 (RJIA678), 3837 (SARDBX89717) 3472 (SDRDBX87602), 5935 (RJIG293), 5932 (RJCE660), 5913 (RJIK571)
  • Year 2000 support
    • 20587
  • Provide QMF facility to limit number of rows on a query
    • 38532, 6868 (RJHJ915, RJIY135, RJIK043, RJIY155, RKJ7982), 12306, 5585 (GU256089027), 5560 (GU256088007), 4928 (CMDABA91005)
  • Fetch of data in QMF -- prompt the user for a reset data to avoid CPU-consumption
    • 38532



Planning Information

Customer Responsibilities: QMF Version 3.3 is the last QMF release that will support the MVS/XA operating system.

Packaging: The QMF HPO/Shuttle feature is shipped on three diskettes for 16-bit support and three diskettes for 32-bit support. A total of six diskettes are shipped.



Security, Auditability, and Control

The announced program and features use the security and auditability features of the MVS, VM and VSE operating systems.

The customer is responsible for evaluation, selection, and implementation of security features, administrative procedures, and appropriate controls in application systems and communication facilities.



ORDERING INFORMATION



Current Licensees

Current licensees of Query Management Facility will be sent a program reorder form that may be returned directly to IBM Software Manufacturing Solutions (SMS). These reorder forms are scheduled to be mailed by May 28, 1997. Reorder forms returned to SMS will be processed within 10 workdays of receipt. When QMF Version 3.3 is available, QMF Version 3.2 will no longer be available.



New Licensees

Orders for new licenses will be accepted now.

Shipment will begin on the planned availability date.

New users of Query Management Facility should specify:

                         Type           Model

QMF for MVS 5706 254 QMF for VM 5706 255 QMF for VSE 5648 061

The ordering information previously announced in the following letters are unaffected by this announcement except as specifically stated in this announcement.

  • Software Announcement 296-352, dated September 10, 1996 (QMF HPO/Shuttle Version 3.2 Client for VM, VSE and MVS)
  • Software Announcement 295-411, dated September 26, 1995 (QMF Version 3 Release 2)
  • Software Announcement 294-217, dated April 12, 1994 (Query Management Facility High Performance Options for MVS Version 3 Release 1 Modification 1)
  • Software Announcement 293-595, dated October 12, 1993 (Query Management Facility VSE/ESA Version 3 Release 1 Modification 1)
  • Software Announcement 291-497, dated September 11, 1991 (Query Management Facility Version 3 Release 1 Modification 1)
  • Software Announcement 290-527, dated September 5, 1990 (Query Management Facility Version 3 Release 1)
  • Software Announcement 294-154, dated April 6, 1994 (IBM System/390 (R) Parallel Sysplex (TM) Software Pricing)



Unlicensed Documentation

A memo, program directory and one copy of the following publications are supplied automatically with the basic machine-readable material. When ordering a national language version of QMF, the national language version of the publications are supplied. Where a national language version of a publication is not available the English version is supplied.

QMF/MVS (5706-254)

Order Title Number

QMF Licensed Program Specifications GC26-4724 Introducing QMF GC26-4713 - Japanese GC88-7157 QMF Reference SC26-4716 - Japanese SC88-7068 Using QMF SC26-8078 - Japanese SC88-7529 QMF Messages and Codes SC26-4834 Installing QMF on MVS SC26-4719 - Japanese SC88-7525 Managing QMF for MVS SC26-8218 - Japanese SC88-7527 Developing QMF Applications SC26-4722 - Japanese SC88-7528

QMF HPO/Shuttle for MVS

Order Title Number

QMF High Performance Option SC26-3499 User's Guide for MVS QMF HPO/Shuttle Getting Started SC26-8921

QMF/VM (5706-255)

Order Title Number

QMF Licensed Program Specifications GC26-4724 Introducing QMF GC26-4713 - Japanese GC88-7157 QMF Reference SC26-4716 - Japanese SC88-7068 Using QMF SC26-8078 - Japanese SC88-7529 QMF Messages and Codes SC26-4834 Installing QMF on VM/ESA SC26-4718 - Japanese SC88-7524 Managing QMF for VM/ESA SC26-8219 - Japanese SC88-7526 Developing QMF Applications SC26-4722 - Japanese SC88-7528

QMF HPO/Shuttle VM

Order Title Number

QMF HPO/Shuttle Getting Started SC26-8921

QMF/VSE (5648-061)

Order Title Number

QMF Licensed Program Specifications GC26-4724 Introducing QMF GC26-4713 - Japanese GC88-7157 QMF Reference SC26-4716 - Japanese SC88-7068 Using QMF SC26-8078 - Japanese SC88-7529 QMF Messages and Codes SC26-4834 Installing QMF on VSE/ESA SC26-3254 - Japanese SC88-7531 Managing QMF for VSE/ESA SC26-3252 - Japanese SC88-7530 Developing QMF Applications SC26-4722 - Japanese SC88-7528

QMF HPO/Shuttle VSE

Order Title Number

QMF HPO/Shuttle Getting Started SC26-8921

Additional copies of unlicensed publications will be available for a fee after product availability. These copies may be ordered from your IBM representative, through the System Library Subscription Service (SLSS) or by direct order.

Subsequent updates (technical newsletters or revisions between releases) to the publications shipped with the product will be distributed to the user of record for as long as a license for this software remains in effect. A separate publication order or subscription is not needed.

All of the above publications may be ordered by using the following bill of forms numbers:

               Order
Description    Number

All of QMF SBOF-3005 QMF/MVS SBOF-7338 QMF/VM SBOF-3008 QMF/VSE SBOF-4828

Displayable Softcopy Publications

QMF Version 3.3 publications are offered in displayable softcopy form. All unlicensed manuals are included, except for the QMF High Performance Option User's Guide for MVS (SC26-3499). The files are shipped on CD-ROM. The displayable manuals availability and no-charge feature numbers are:

Order
Number         Description                   Available

SK2T-0730 IBM Online Library: 3Q97 Transaction Processing Data SK2T-0710 IBM Online Library: 3Q97 MVS Collection Kit SK2T-2067 IBM Online Library: 3Q97 VM Collection Kit SK2T-0060 IBM Online Library: 3Q97 VSE Collection Kit

             MVS               VM           VSE
           Feature          Feature       Feature
Order       Number           Number        Number
Number    (5706-254)       (5706-255)    (5648-061)

SK2T-0730 7300 7320 7003 SK2T-0710 7301 SK2T-2067 7321 SK2T-0060 7006

These displayable manuals can be used with the BookManager (R) READ licensed programs in any of the supported environments. Terms and conditions for use of the machine-readable files are shipped with the files.



TERMS AND CONDITIONS

The terms for Query Management Facility Version 3, as previously announced in the IBM Software Announcement listed below, licensed under the IBM Customer Agreement are unaffected by this announcement.

QMF HPO/Shuttle is licensed by the server, not per use, so there is no limit to the size of your user base.

  • Software Announcement 296-352, dated September 10, 1996 (QMF HPO/Shuttle Version 3.2 Client for VM, VSE and MVS)

  • Software Announcement 295-411, dated September 26, 1995, (QMF Version 3 Release 2)

  • Software Announcement 294-217, dated April 12, 1994, (Query Management Facility High Performance Options for MVS Version 3 Release 1 Modification 1)

  • Software Announcement 293-595, dated October 12, 1993, (Query Management Facility VSE/ESA Version 3 Release 1 Modification 1)

  • Software Announcement 291-497, dated September 11, 1991 (Query Management Facility Version 3 Release 1 Modification 1)

  • Software Announcement 290-527, dated September 5, 1990 (Query Management Facility Version 3 Release 1)

  • Software Announcement 294-154, dated April 6, 1994 (IBM System/390 Parallel Sysplex Software Pricing)



CHARGES

The charges provided in this announcement are suggested retail prices for the U.S. only and are provided for your information only. Dealer prices may vary, and prices may also vary by country. Prices are subject to change without notice. For additional information and current prices, contact your local IBM representative.

The charges for Query Management Facility Version 3.3 and its features are unaffected by this announcement.

For additional product information, refer to the Program Announcements listed in the Ordering Information section or the Terms and Conditions section of this announcement. Trademarks

      QMF, Distributed Relational Database Architecture, SQL/DS,
      MVS/ESA, MVS/XA, OS/390, VSE/ESA, SP, DATABASE 2, MVS/SP, DXT,
      C/370, COBOL/370, VM/XA, OfficeVision/VM, and Parallel Sysplex
      are trademarks of International Business Machines Corporation
      in the United States or other countries or both.
      DRDA, MVS, DB2, GDDM, CICS/MVS, CICS, CICS/VSE, VM/ESA,
      CICS/ESA, SAA, AD/Cycle, Language Environment, DataJoiner, AIX,
      OS/2, WIN-OS/2, System/390 and BookManager are registered
      trademarks of International Business Machines Corporation in
      the United States or other countries or both.
      Windows and Microsoft are registered trademarks of Microsoft
      Corporation.
      Other company, product, and service names may be trademarks or
      service marks of others.