IBM United States
Software Announcement 202-046
February 26, 2002
IBM QMF for Windows for IBM iSeries, V7.2 Business Intelligence Starts Here!
At a Glance
QMF V7.2 Family enhancements include:
For ordering, contact:
Your IBM representative, an IBM Business Partner, or IBM Americas Call Centers at 800-IBM-CALL (Reference: AE001).
QMF for Windows® for iSeries, 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 DB2® iSeries databases.
QMF for Windows provides 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. A point-and-click, drag-and-drop interface to QMF form creation makes it easy to aggregate, group, and format 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.
Key QMF for Windows for iSeries, V7.2, enhancements include:
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.
Server-based pricing, unlimited users per server, and centralized install make this a top choice in Business Intelligence tools.
QMF for Windows V7.2 offers:
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.
Connectivity: 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:
Administrative Enhancements: 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." Reliable query and reporting tools that are easy to set up and use remain important to DB2 customers. Offering such a tool designed specifically for the DB2 enterprise can be expected to enhance the success of any BI strategy. By offering fast query performance from the Windows environment, execution of QMF for Windows commands, 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 want to extend their industrial-strength capabilities to applications in the Windows environment and on the Web.
QMF for Windows is also offered as a separately orderable product, licensed to access DB2 UDB workstation databases (such as DB2 for Windows NT®, DB2 for AIX®, and so on) as well as an S/390® license to access any DB2.
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 iSeries, 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. The files are shipped on a single 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® for iSeries (V4R4, or later).
Workstation hardware requirements are those needed to run the Windows software as described in the Software Requirements section.
This section describes the minimum software requirements for QMF for Windows.
QMF for Windows runs on 32-bit platforms as follows:
QMF for Windows can connect to DB2 via a direct connection over TCP/IP or SNA LU 6.2 or via the Call Level Interface (CLI) provided by the DB2 UDB Runtime Client. The following DB2 servers are supported:
Product Version DB2 for AS/400(R) V4.3, V4.4 DB2 for iSeries V5.1
In addition, QMF for Windows can connect to DB2 for IBM iSeries 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 3.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/400 Migration Tool: Rocket Software developed the Query Manager/400 Migration Tool to allow businesses that have accumulated libraries of query objects (queries and forms) in Query Manager for AS/400 to immediately convert and use those objects in the QMF for Windows query environment.
This tool quickly creates copies of existing Query Manager/400 objects and saves them as QMF for Windows objects. The new objects can be used immediately in QMF for Windows while the Query Manager/400 objects remain intact.
To obtain a copy of the Query Manager/400 Migration Tool, access the following Web site:
You may also contact Rocket Software at 508-655-4321 in Natick, Massachusetts, USA.
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 uses the iSeries tiered pricing model.
Program Name: QMF for Windows for iSeries, V7.2 (5697-G24)
The billing features for QMF for Windows for iSeries, V7.2, are unchanged from V7.1. Refer to Software Announcement 200-179 , dated June 12, 2000.
The V7.1 supply features have been replaced with a single V7.2 supply feature as indicated below.
Feature Media Number Multilingual CD-ROM 5869 National Language Version (NLV) Features Language Description Feature Multilingual CD-ROM 2924
Customization Options: Select the appropriate feature numbers to customize your order with delivery options desired. These features can be specified on the initial or MES orders.
Feature Description Number Initial Shipments Serial number only (suppresses shipment 3444 of media and documentation) Ship media only (suppresses initial 3470 shipment of documentation) Ship documentation only (suppresses 3471 initial shipment of media) Expedite Shipments Local IBM office expedite 3445 (for IBM use only) Customer expedite process charge 3446 ($30 charge for each product)
Expedite shipments will be processed to receive 72-hour delivery from the time IBM Software Delivery and Fulfillment (SDF) receives the order. SDF will then ship the order via overnight air transportation.
Terms and Conditions
You must acquire a license for each iSeries server you wish to access. For each QMF for Windows for iSeries license you may attach an unlimited number of QMF for Windows clients, which can access an unlimited number of DB2 for iSeries databases residing on the licensed iSeries server.
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 iSeries, V7.2 (5697-G24): Charges for QMF for Windows for iSeries, V7.2, features are unchanged from the previous release. Refer to Software Announcement 200-179 , dated June 12, 2000.
Note: You must acquire a license for each iSeries server you wish to access. For each QMF for Windows for iSeries license you may attach an unlimited number of QMF for Windows clients, which can access an unlimited number of DB2 for iSeries databases residing on the licensed iSeries server.
Variable Charges: The applicable processor based one-time charge will be based on the group of the designated machine on which the program is licensed for use. If the program is designated to a processor in a group for which no charge is listed above, the charge of the next higher group listed applies. For movement to a machine in a higher group, an upgrade charge equal to the difference in the then current charges between the two groups will apply. For movement to a machine in a lower group, there will be no adjustment or refund of charges paid.
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;
Use Priority/Reference Code: AE001 Phone: 800-IBM-CALL Fax: 800-2IBM-FAX Internet: firstname.lastname@example.org Mail: IBM Atlanta Sales Center Dept. AE001 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.