IBM United States
Software Announcement 202-045
February 26, 2002
IBM QMF for Windows for DB2 Workstation Databases, V7.2 Business Intelligence Starts Here!
At a Glance
For ordering, contact:
Your IBM representative, an IBM Business Partner, or IBM Americas Call Centers at 800-IBM-CALL (Reference: SE001).
QMF for Windows® for DB2® Workstation Databases, V7.2 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, including Linux on S/390® platforms.
QMF for Windows gives you an intuitive "quick start" interface to build queries and business reports and share them with other QMF users. Java-based query allows users to create queries or execute predefined queries. An easy to use point-and-click, drag-and-drop interface to QMF Form creation allows aggregation, grouping, and formatting to be performed directly in the query results.
QMF for Windows can also be used as the high-performance data manipulation engine behind most important commercial or custom Windows applications such as spreadsheets, desktop databases, and executive information systems.
QMF for Windows V7.2 offers new capabilities for visualizing data spatially and with charts, connection options to ODBC-compliant data sources, new administrative options, great ease of use, and significant new functions for creating and running QMF objects with Java-enabled browsers.
Key QMF for Windows, V7.2 enhancements include:
The QMF for Windows powerful API allows developers to rapidly build data access, update applications, and fully exploit DB2 performance, SQL syntax, and advanced database performance techniques such as static SQL, uncommitted read, and DB2 stored procedures. QMF for Windows server-based pricing, unlimited users per server, and centralized install make it a top choice in Business Intelligence tools.
QMF for Windows, V7.2 offers:
Data Visualization with DB2 Spatial Extender and IM Scoring
QMF for Windows now offers data visualization and business analysis capabilities with Direct Support for spatially-enabled DB2 data and DB2 Spatial Extender.
Organizations can spatially enable existing data with the DB2 Spatial Extender V7.2, a feature of DB2 Extended Edition and DB2 Extended Enterprise Edition V7.2. Spatial data can then be accessed along with normal business data using ordinary and familiar SQL query techniques and immediately begin viewing this data geographically and dimensionally. For example, existing customer lists can be visualized in seconds by location, layered with multiple categories of topographical features including roads, natural formations, or political boundaries, analyzed for key characteristics such as proximity, and these visualizations saved for later reuse or published to an intranet. Transparent support for spatial data in QMF for Windows represents a powerful competitive and productivity advantage for organizations everywhere.
QMF for Windows users can improve the quality and timeliness of business intelligence available to analysts via use of the DB2 Intelligent Miner (IM) Scoring feature of DB2 Extended Edition and Enterprise Extended Edition. Using the new QMF for Windows V7.2 Expression Builder, users can easily invoke IM Scoring to apply the latest mining analytics in real time.
Behind the scene, mining is used to analyze high volumes of data to discover the latest business trends or patterns. The results are represented in a model think of the model as a set of rules or a formula for predicting the most likely outcome based on past history. The new V7.2 Expression Builder helps QMF users build the SQL expression to invoke DB2 IM Scoring which, in turn, applies these rules to new business situations. For example, to:
Browser-Based Querying and Charting
Users may now perform more operations in their QMF objects using a Web browser, including creating and sharing queries and formatting results. A Java-based charting component is also available on demand when using QMF for Windows browser-based querying.
Users may now create, save, and run QMF prompted queries with their browsers, and use QMF forms to format query results with either a default or a previously saved QMF form.
QMF queries created in the Windows interface of QMF for Windows and formatted with summaries, roll-ups, colors, and other features may now be run using the QMF for Windows browser interface with all formatting intact.
Administrators may now also govern and track queries run by QMF for
Windows browser-based users, using the same administrative interface
presently used to track Windows-based and OS/390®-based QMF users.
In addition to existing support for multiple DB2 database platforms through DRDA® and CLI connectivity, QMF for Windows users can now use their QMF objects to read data from ODBC-compliant data sources. This makes simultaneously available, through a single, powerful interface, the DB2 databases that serve the entire enterprise as well as departmental servers in mixed environments such as Informix and Microsoft SQL Server. In addition, ODBC-compliant PC applications, such as desktop databases and spreadsheets, become available as query data sources.
This new capability adds considerable breadth to the portability and
compatibility of QMF objects across hardware, network, operating system,
and database platforms, and dramatically expands end-user options for
business intelligence gathering.
Ease-of-Use and Interface Enhancements
Multiple interface enhancements bring even greater productivity to QMF for Windows users:
In addition to governing and tracking of browser-based users, the QMF for Windows Administrator has the following new capabilities:
For further details on new features found in QMF for Windows, V7.2, consult the product online help facility.
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 IBM iSeries license, which allows access to DB2 for iSeries 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:
To enroll in IBM internal classes, 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:
Displayable Softcopy Publications: QMF for Windows for DB2® Workstation Databases, V7.2, publications are offered in displayable softcopy form. All unlicensed manuals are included. The displayable manuals are part of the basic machine-readable material and are shipped on the product CD-ROM.
To order hardcopy publications, contact your IBM representative or visit the IBM Publications Web site at:
To view or download a free PDF version of the publication, visit the QMF Web site at:
Server hardware requirements are those required to run DB2 Universal Database® (UDB) V7.2 workstation databases.
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
35 MB of free disk space on each Windows workstation, and a minimum
of 32 MB memory (improved performance is realized with additional
This section describes the minimum software requirements for QMF for Windows.
QMF for Windows runs on:
QMF for Windows can connect to DB2 via a direct connection over TCP/IP or SNA LU 6.2 or via the DB2 UDB Runtime Client. The following DB2 servers are supported:
Product Version DB2 UDB V5.1, V5.2, V6.1, V7.1, V7.2 DB2 Common Server V2.1 DB2 DataJoiner(R) for AIX(R) and V2.1 Windows NT (license restrictions may apply) DB2 DataJoiner for AIX (license V1.2 restrictions may apply) DB2 Parallel Edition for AIX V1.2
In addition, QMF for Windows can connect to DB2 and non-DB2 workstation data sources via ODBC.
QMF for Windows requires at least one of the following on each user machine:
Use of QMF for Windows with natural language queries requires English Wizard 3.1 or EasyAsk 6.0 from IBM Business Partner Linguistic Technologies.
Use of spreadsheet application add-ins with QMF for Windows requires one or both of:
Use of charting in spreadsheet applications with QMF for Windows requires one or both of:
QMF Query for Java requires WebSphere Application Server V3.02 or 3.5, running on one of the following platforms:
In addition, a JDBC driver must be installed and configured on the application server, enabling connections to any of the database server products supported by QMF for Windows.
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, USA.
Included in the package:
This program when downloaded from a Web site, contains the applicable IBM
license agreement, and License Information (LI), if appropriate and will
be presented for acceptance at the time of installation of the program.
The license and LI will be stored in a directory such as LICENSE.TXT for
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 product with a single charge unit, 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. Access to host databases, including via DB2 Federated (DataJoiner) capability, is not authorized.
Part Program Name Number QMF for Windows for DB2 Workstation 45P8192 Multilingual Program Pack Processor English QMF for Windows for DB2 Workstation 45P7478 Net Delivery Processor
Part Program Name Number QMF for Windows for DB2 Workstation BB00UML multilingual Media Pack Processor QMF for Windows for DB2 Workstation D5ASTLL Processor LIC/S W MAINT 1 ANNIV QMF for Windows for DB2 Workstation D5ASULL Processor LIC/S W MAINT 2 ANNIV QMF for Windows for DB2 Workstation D5ASWLL Processor S W MAINT RNWL 1 ANNIV QMF for Windows for DB2 Workstation E1ASVLL Processor S W MAINT AFT LIC 1 ANNIV
Passport Advantage Customer
Media Pack Entitlement Details
Customers with active Maintenance or subscription for the products listed below are entitled to receive the corresponding media pack.
Entitled Maintenance Offerings Description DB2 QMF WIN 1st Processor (DB2QMF1PROC) Media Pack Part Description Number QMF for Windows for DB2 Workstation BB00UML Multilingual Media Pack Processor
Terms and Conditions
Licensing: IBM International Program License Agreement. Proofs of Entitlement are required for all authorized use. Part number products only, offered outside of Passport Advantage, where applicable, are license only and do not include Software Maintenance.
The prices 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.
QMF for Windows for DB2 Workstation Databases is a product with one charge unit, based on SMP processor install. QMF for Windows is licensed to access, on a per-server basis, machines running DB2 workstation databases only (including DB2 Federated Support, formerly DataJoiner). Access to host databases, including via DB2 Federated Support, is not authorized.
Part Program Name/Description Number OTC(1) QMF for Windows for 45P8192 $2,500 DB2 Workstation Multilingual Program Pack Processor QMF for Windows for 45P7478 2,470 DB2 Workstation Net Delivery Processor
Passport Advantage: For Passport Advantage and charges, contact your authorized IBM Lotus Business Partner. Additional information is also available on the Passport Advantage Web site:
Customer Financing: IBM Global Financing offers attractive financing to credit-qualified commercial and government customers and Business Partners in more than 40 countries. IBM Global Financing is provided by the IBM Credit Corporation in the United States. Offerings, rates, terms, and availability may vary by country. Contact your local IBM Global Financing organization. Country organizations are listed on the Web at:
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.