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
(Corrected on October 19, 2000)
Changed Support Line Charge to does not apply.
At a Glance
Key enhancements include:
It also delivers:
For ordering, contact:
Your IBM representative, an IBM Business Partner, or IBM Americas Call Centers at 800-IBM-CALL (Reference: SE001).
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.
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:
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.
September 29, 2000
QMF for Windows for DB2 Workstation Databases Version 7 key enhancements:
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:
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.
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.
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.
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.
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:
Two Apple Hill Drive
Natick, MA 01760
Product Information is available through Offering Information (OITOOL) at:
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
QMF for Windows implements the following key industry standards:
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).
This section describes the minimum software requirements for QMF for Windows.
QMF for Windows runs on Microsoft:
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.
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.
Two hardcopy publications are shipped: Getting Started with QMF for Windows and Installing and Managing QMF for Windows .
Also included in the package:
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.
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.
Part Description Number QMF for Windows, Version 7 11K6792 Program Package -- CD-ROM QMF for Windows, Version 7 11K6795 Additional Processor
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
Use Priority/Reference Code: SE001 Phone: 800-IBM-CALL Fax: 800-2IBM-FAX Internet: firstname.lastname@example.org 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.