IBM United States
Software Announcement 200-090
April 18, 2000

IBM QMF for Windows for DB2 Workstation Databases Version 7 — for All Your Operational and Warehouse Query Needs

 ENUS200-090.PDF (40KB)

(Corrected on October 19, 2000)

Changed Support Line Charge to does not apply.

At a Glance

Key enhancements include:

  • Java-based query from a Web browser
  • Aggregate, group, and format in the query results
  • Point-and-click, drag-and-drop interface to QMF Form creation
  • Sort results of a query on more than one non-contiguous column
  • Windows tree control for more intuitive navigation and location of QMF objects
  • A personal data portal for your desktop, for launching centrally shared queries and reports, sending results to desktop tools and browsers, and sharing already formatted spreadsheets with your workgroup
  • Large Object support
  • Procedures with REXX
  • Enhanced Form (report template) capability

It also delivers:

  • Ease-of-use for novice users as well as expert-level functionality
  • Transparent integration with other Windows applications
  • Centralized and secure protection of enterprise database resources
  • Server-based pricing, unlimited users per server, centralized install, and elimination of database gateways, middleware, and ODBC drivers
  • Support for DB2 stored procedures
  • Automation capabilities with QMF linear procedures and command line parameters

For ordering, contact:

Your IBM representative, an IBM Business Partner, or IBM Americas Call Centers at 800-IBM-CALL (Reference: SE001).

Overview

QMF™ for Windows™, Version 7 is a multipurpose enterprise query environment for large-scale business reporting, data sharing, server resource protection, powerful application development, and native connectivity to all of the DB2® workstation platforms.

QMF for Windows now gives you ease of use with a point-and-click/ drag-and-drop interface to QMF form creation. Aggregation, grouping, and formatting can be performed in the query results. Enhanced sorting allows the results of a query to be sorted on more than one non-contiguous column.

An enhanced object list window adds Windows tree control for more intuitive navigation and location of QMF objects. Java™-based query allows users to submit queries to DB2 via a browser, as well as the ability to view a user's queries and tables from a browser for ease of use.

  • Large object support
  • Many human factors enhancements
  • More compatibility with QMF Host and DB2 Forms

Designed for DB2 and for situations where the broadest range of needs must be met with the minimum number of tools, QMF for Windows strategically excels at delivering the most essential and most frequently required business reporting capabilities for a competitive advantage.

End users may work from the intuitive QMF for Windows "quick start" interface to build queries and business reports, share them with other QMF users, and publish them on the Web. They can also use QMF for Windows as the high-performance data manipulation engine behind their most important commercial or custom Windows applications — including:

  • Spreadsheets
  • Charting and analysis tools
  • Executive information systems
  • Desktop databases

For Administrators , QMF for Windows is a single product with capabilities needed to safely open all of the DB2 workstation database platforms to Windows and Web users without database gateways, middleware, or ODBC drivers to manage. QMF for Windows automatically blocks waste or abuse through detailed permissions organized on each server by group, by schedule, or by combinations of group and schedule.

Developers obtain a powerful Windows API with QMF for Windows that lets them rapidly build data access and data update applications. QMF for Windows lets them fully exploit DB2 performance, SQL syntax, and advanced database performance techniques such as static SQL, uncommitted read, and DB2 stored procedures.

QMF for Windows delivers native support for TCP/IP connectivity to DB2 Version 5 and above, and is architecturally coupled with DB2 across platforms by the enterprise data sharing standard Distributed Relational Database Architecture™ (DRDA®). Support for multivendor database environments through DB2 DataJoiner® allows users to access other vendor and nonrelational workstation databases.

Planned Availability Date

September 29, 2000

Description

QMF for Windows for DB2 Workstation Databases Version 7 key enhancements:

  • Run SQL queries from a browser through Java servlet support
  • Aggregate, group, and format in the query results
  • Point-and-click, drag-and-drop interface to QMF form creation
  • Sort results of a query on more than one non-contiguous column
  • Windows tree control for more intuitive navigation and location of QMF objects
  • Built-in Report Center for easy access to favorite personal and shared reports
  • Enhanced Form (report template) capability
  • Human factors, which include a menu of items displayed with query results and more toolbar buttons
  • Option to use DB2 Forms when Table Editor invoked
  • Option to remember DB2 passwords when running on Windows NT™
  • Database feature supports:
    • Stored procedures that return multiple results sets over CLI connections. (For workstation databases, multiple result sets and LOBs are only supported over CLI connections.)
    • Large objects over CLI connections
  • QMF Host compatibility:
    • Procedures with REXX logic
    • Support of Form Detail variations
    • Support of Form Column definitions
    • Support of RESET GLOBAL command
    • Support of new toolbar/window in which single QMF commands can be entered and executed (analogous to the command line in QMF Host)
  • New National Language support:
    • Unicode
    • Arabic (including BIDI)
    • Belgian French
    • Canadian French
    • Portuguese
    • Swiss Italian
    • Traditional Chinese
  • CLI Connectivity enhancements:
    • Add CLI-specific information to the Connection Details box if the connection to the database server is via CLI.
    • Add CLI tracing to the trace types supported.

Note: The QMF for Windows, Version 7 "Try and Buy" can be obtained at planned availability of the product from the QMF Web site at:

As a general-purpose query environment for DB2 datamarts, data warehouses, and enterprise operational data, QMF for Windows is in many ways more powerful and more versatile than special-purpose database front ends and single-user query tools. This is because QMF for Windows is designed for multiuser, production level data access where the broadest base of business operations must be satisfied.

QMF for Windows strategically excels at the most commonly required data access and reporting functions, providing a range of capabilities fundamental to corporate-wide productivity. Building upon the fifteen-plus year history of the QMF family's development in parallel with DB2, QMF for Windows allows users to bring the same standards of performance, security, and reliability to Windows and the Web they might have traditionally expected only from entirely host-based technologies.

Windows users (Windows 95, Windows 98, Windows NT, and Windows 2000) can explore data within the point-and-click QMF for Windows query interface, build robust reports, automate even the most complex tasks with procedures, and automatically store the resulting QMF for Windows "objects" in a common object space shared by other QMF for Windows users across the enterprise. Alternatively, the QMF for Windows API allows users to stay entirely within their favorite Windows applications (such as Lotus® 1-2-3®, Microsoft™ Excel, or Microsoft Access) as they execute QMF for Windows objects, query multiple DB2 workstation databases, and merge the resulting data into the spreadsheet, database, or other OLE desktop application of choice. Users can issue queries from their Web browser or quickly convert an unlimited number of their existing QMF reports for publishing to their Web server of choice, and schedule unattended refreshes, rapidly creating "warehouses" of business reports accessible to all through any Web browser.

These powerful data distribution and integration capabilities are packaged with advanced administrative controls — accessible only to authorized database administrators — that prevent waste or abuse of database server resources. Administrators have a wealth of options available:

  • Closing access to a database server altogether
  • Restricting groups of users to a "read only" status (disallowing ad hoc query access)
  • Finely-tuned limits on rows fetched
  • Re-use of connections to the database

Database access techniques such as static SQL, uncommitted read, and DB2 stored procedures are supported to minimize contention for database resources and maximize the value obtained from any given database server. In addition, detailed object use tracking helps locate heavily used (or unused) queries and forms, and identify every object ever executed by a user, and how often.

A QMF for Windows fact sheet with a comprehensive summary of benefits to users, application developers, database administrators, and the enterprise can be found on the Web at:

Centralized Installation Options

Administrators can centralize the installation, configuration, and day-to-day client operation of QMF for Windows by opting to contain configuration settings (Server Definition Files (SDFs)), preconfigured client installation packages, or the QMF for Windows product itself on a networked Windows NT server. You can allow each user to run the product from the server, have their own SDF, or you can create a single SDF shared by multiple users over a file-sharing network.

The advantage to these approaches is they dramatically reduce installation and configuration of individual client PCs, reduce total cost of ownership, and allow for a "thin client" installation at each Windows workstation wherever desired.

Java-based querying requires no client install at all aside from a current Web browser.

Connectivity

QMF for Windows, Version 7 implements Distributed Relational Database Architecture (DRDA) and provides native support for TCP/IP connectivity to DB2 Universal Databases Version 5 (or later). For connectivity to SNA environments, it employs the Advanced Program-to-Program Communication (APPC) language and the Common Programming Interface-Communications (CPI-C) interface. By using the CPI-C interface, QMF for Windows operates with the SNA connectivity solution of your choice, such as, eNetwork™ Personal Communications, Microsoft SNA Server, Novell NetWare for SAA, and others.

Year 2000

This product is Year 2000 ready. When used in accordance with its associated documentation, it is capable of correctly processing, providing, and receiving date data within and between the twentieth and twenty-first centuries, provided all products (for example, hardware, software, and firmware) used with the product properly exchange accurate date data with it.

The service end date for this Year-2000-ready product is September 29, 2002.

Product Positioning

Positioning of QMF for Windows is summarized by the phrase "Business Intelligence (BI) starts here." Easy to use and fast to implement, query and reporting tools remain important to DB2 customers for operational and data warehouse query and reporting. Offering such a tool designed specifically for the DB2 enterprise is expected to enhance the success of any BI or data warehouse strategy. By offering fast query performance from the Windows environment, browser-based querying, and extensive governing control over user actions and DB2 resource consumption, QMF for Windows is a natural selection over and above any other for customers who have or are interested in DB2 and want to quickly extend industrial-strength capabilities to Windows and the Web.

For customers with a mixed platform environment, QMF for Windows is also available as a S/390 license (OS/390®, VM, or VSE), which allows access to DB2 on any platform from Windows or the Web. It is also available as an AS/400® license, which allows access to DB2 for AS/400 databases only from Windows or the Web.

Trademarks

 
QMF, Distributed Relational Database Architecture, and eNetwork are trademarks of International Business Machines Corporation in the United States or other countries or both.
 
DB2, DRDA, DataJoiner, OS/390, and AS/400 are registered trademarks of International Business Machines Corporation in the United States or other countries or both.
 
Windows, Windows NT, and Microsoft are trademarks of Microsoft Corporation.
 
Java is a trademark of Sun Microsystems, Inc.
 
Lotus and 1-2-3 are registered trademarks of Lotus Development Corporation.
 
Other company, product, and service names may be trademarks or service marks of others.

Education Support

A QMF™ for Windows™ for End Users class (U4520) and a QMF for Windows for Advanced Users class (U4521) are available.

For IBM class schedules, call 800-IBM-TEACH (800-426-8322) or access the Web at:

QMF for Windows onsite product, administration, and configuration education is provided for a fee from the following IBM Business Partner:

    Rocket Software, Inc.
    Two Apple Hill Drive
    Natick, MA 01760
    508-655-4321

Offering Information

Product Information is available through Offering Information (OITOOL) at:

Publications

Publications can be ordered on September 29, 2000. To order, contact your IBM representative, or subscribe through Publication Notification System (PNS), or by direct order.

The PNS is available at:

                                 Order
Title                            Number      Language
 
Installing and Managing          GC27-0722   English
  QMF for Windows
Getting Started with             SC27-0723   English
  QMF for Windows

Open Enterprise

QMF for Windows implements the following key industry standards:

  • DRDA® — The Open Group's Distributed Relational Database Architecture™ is used to communicate with the DB2® family of relational databases.
  • TCP/IP and SNA — Communication protocols supported by QMF for Windows. The DRDA Application Requester (AR) and DRDA Application Server (AS) functionality can now be implemented using these standard protocols.
  • SQL 92 Entry Level — Level of SQL with which QMF for Windows is compliant.

Technical Information

Hardware Requirements

Server hardware requirements are those required to run DB2 PE, DB2 Common Server, or DB2 Universal Database®.

Workstation hardware requirements are those needed to run the Windows software as described in the Software Requirements section.

QMF for Windows for DB2 workstation databases requires approximately 10 MB of free disk space on each Windows workstation, and a minimum of 32 MB memory (improved performance is realized with additional memory).

Software Requirements

This section describes the minimum software requirements for QMF for Windows.

QMF for Windows runs on Microsoft™:

  • Windows 95
  • Windows 98
  • Windows NT™ (3.51 and 4.0)
  • Windows 2000

QMF for Windows may connect to DB2 Universal Database via native TCP/IP, or to the SNA environments of that or other DB2 versions on workstation platforms.

For TCP/IP connectivity, QMF for Windows must be able to establish a TCP connection from the Windows workstation to the remote host and remote port (the port on which DB2 is listening). This can be established with many 32-bit WinSock products, including those provided with Windows 95, Windows 98, Windows NT, and Windows 2000.

For SNA connectivity, QMF for Windows requires an SNA/CPI-C product on each Windows workstation. These products are the interface between QMF for Windows and the APPC verb set used by the SNA environment to manage server/requester relationships.

Customers should ensure they have the latest corrective service or maintenance for their SNA product. Contact your SNA software vendor's technical support services personnel for this information.

QMF for Windows requires a WinSock 1.1 interface to the installed TCP protocol stack. The Microsoft TCP/IP protocol provided with each Windows 9x, Windows NT, and Windows 2000 provides the required support.

The following table indicates the DB2 workstation databases that QMF for Windows supports:

Product                           Version        Release
 
DB2 Parallel Edition for AIX(R)  Version 1      Release 2
DataJoiner(R) for AIX            Version 1      Release 2
DB2 DataJoiner for AIX           Version 2      Release 1
  and Windows NT
DB2 Common Server                Version 2      Release 1
DB2 Universal Database           Version 5
DB2 Universal Database           Version 5      Release 2
DB2 Universal Database           Version 6      Release 1
DB2 Universal Database           Version 7      Release 1

QMF for Windows can install spreadsheet add-in buttons and menu commands for direct access from within Microsoft Excel Version 7, Microsoft Excel 97, or Microsoft Excel 2000.

Java™ Support: The Java SQL query support provided with QMF for Windows requires an application server product that supports the Java servlet standard. Following is a list of supported application server products, although products not on this list that provide Java servlet support should also work. In addition, a JDBC driver providing connectivity to any of the database products support by QMF for Windows is required (such a driver is included with the supported database products) on the application server platform.

  • WebSphere™ Application Server for AIX, Sun Solaris, and Windows NT, Version 2.0, or later
  • Sun Java Web Server Version 1.1.3, or later

Performance Considerations: All factors relevant to performance are described in the Installing and Managing QMF for Windows publication, which ships with the product.

Planning Information

Query Manager/2 Migration Tool: Rocket Software, Inc., an IBM Business Partner, developed the Rocket Query Manager/2 Migration Tool to allow businesses that have accumulated libraries of query objects (queries and forms) in IBM Query Manager for OS/2® to immediately convert and use those objects in the QMF for Windows query environment.

This tool quickly creates copies of existing IBM Query Manager/2 objects and saves them as QMF for Windows objects. The new objects can be used immediately in QMF for Windows while the IBM Query Manager/2 objects remain intact.

To obtain a copy of the Rocket Query Manager/2 Migration Tool, access the following Web site:

You may also contact Rocket Software at 508-655-4321 in Natick, Massachusetts.

Packaging: QMF for Windows, Version 7 (32-bit only) is shipped on one CD-ROM. It contains:

  • The product in English and all supported national languages
  • The publications, in English and other languages, in PDF format

Two hardcopy publications are shipped: Getting Started with QMF for Windows and Installing and Managing QMF for Windows .

Also included in the package:

  • License Information Booklet (GC27-0843)
  • Proof of Entitlement

Security, Auditability, and Control

The announced product uses the security and auditability features of the supported database servers and their 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

QMF for Windows for DB2 Workstation Databases is a client/server product with two charge units, based on SMP processor install. The base program package includes the first processor. QMF for Windows is licensed to access, on a per-DB2 server basis, machines running DB2 workstation databases only (including DB2 DataJoiner). Access to host databases, including via DB2 DataJoiner, is not authorized.

For example:

  • To license QMF for Windows for a machine running DB2 on a 4-way SMP, a customer buys one Program Package (one processor) and three Additional Processor Installs.
  • To license QMF for Windows to access two uniprocessor DB2 workstation database servers, a customer buys two Program Packages.

                                                       Part
Description                                            Number
 
QMF for Windows, Version 7                             11K6792
  Program Package -- CD-ROM
 
QMF for Windows, Version 7                             11K6795
  Additional Processor

Passport Advantage

                                                       Part
Description                                            Number
 
QMF for Windows, V7.1 Media Package --                 BB6KFML
  Multilingual
QMF for Windows, V7.1 Documentation                    BB6KGNA
  Package -- English
 
Volume Purchase Option
 
VPO Instl QMF for Windows, V7.1 for                    D466VML
  1 Processor
VPO Instl/SW Sub QMF for                               D467AML
  Windows, V7.1 for 1 Processor
  1 Year
VPO Instl/SW Sub QMF for                               D467CML
  Windows, V7.1 for 1 Processor
  2 Years
VPO SW Sub Rnwl QMF for                                E167QML
  Windows, V7.1 for 1 Processor
VPO SW Sub QMF for Windows, V7.1                       D467SML
  for 1 Processor 1 Year
 
                                                       Part
Description                                            Number
 
VPO SW Sub QMF for Windows, V7.1                       D467ZML
  for 1 Processor 2 Years
 
Contract Option
 
CO Instl/SW Sub QMF for Windows, V7.1                  D46AZML
  for 1 Processor 1st Anniv
CO Instl/SW Sub QMF for Windows, V7.1                  D46B2ML
  for 1 Processor 2nd Anniv
CO SW Sub Rnwl QMF for Windows, V7.1                   E16B8ML
  for 1 Processor
CO SW Sub QMF for Windows, V7.1 for                    D46BAML
  1 Processor 1st Anniv
CO SW Sub QMF for Windows, V7.1 for                    D46BGML
  1 Processor 2nd Anniv
CO Supt QMF for Windows, V7.1 for                      E16BSML
  1 Processor 1st Anniv
CO Instl/SW Sub/Supt QMF for                           D46BVML
  Windows, V7.1 for 1 Processor
  1st Anniv
CO Instl/SW Sub/Supt QMF for                           D46BXML
  Windows, V7.1 for 1 Processor
  2nd Anniv
CO SW Sub/Supt QMF for Windows, V7.1                   D46BZML
  for 1 Processor 1st Anniv
CO SW Sub/Spt Rnwl QMF for                             E16C3ML
  Windows, V7.1 for 1 Processor

Terms and Conditions

Licensing: IBM International Program License Agreement. Proofs of Entitlement (PoE) are required for all authorized use.

License Information Form Number: GC27-0843

Limited Warranty: Yes

Program Services

  • Support Center applies: Yes
  • Available until discontinued: September 29, 2002
  • APAR Mailing Address:
      IBM Corporation
      APAR Processing
      Two Apple Hill Drive
      Natick, MA 01760

Money-Back Guarantee: 30-day, money-back guarantee

Copy and Use on Home/Portable Computer: No

Volume Orders (IVO): No

Passport Advantage Applies: Yes

Passport Advantage Subscription Applies: Yes

Support Line: Does not apply

AIX/UNIX® Upgrade Protection Applies: No

Entitled Upgrade for Current AIX/UNIX Upgrade Protection Licensees: No

AS/400® Software Subscription Applies: No

Variable Charges Apply: No

Educational Allowance: Not applicable

Prices

Contact your IBM representative for charges information for this announcement.

Order Now

 Use Priority/Reference Code: SE001
 
 Phone:     800-IBM-CALL
 Fax:       800-2IBM-FAX
 Internet:  ibm_direct@us.ibm.com
 Mail:      IBM Atlanta Sales Center
            Dept. SE001
            P.O. Box 2690
            Atlanta, GA  30301-2690

You can also contact your local IBM Business Partner or IBM representative. To identify them, call 800-IBM-4YOU.

Note: Shipments will begin after the planned availability date.

Trademarks

 
QMF, Distributed Relational Database Architecture, and WebSphere are trademarks of International Business Machines Corporation in the United States or other countries or both.
 
DRDA, DB2, DB2 Universal Database, AIX, DataJoiner, OS/2, and AS/400 are registered trademarks of International Business Machines Corporation in the United States or other countries or both.
 
Windows, Microsoft, and Windows NT are trademarks of Microsoft Corporation.
 
Java is a trademark of Sun Microsystems, Inc.
 
UNIX is a registered trademark in the United States and other countries exclusively through X/Open Company Limited.
 
Lotus is a registered trademark of Lotus Development Corporation.
 
Other company, product, and service names may be trademarks or service marks of others.