IBM United States
Software Announcement 202-045
February 26, 2002

IBM QMF for Windows for DB2 Workstation Databases, V7.2 — Business Intelligence Starts Here!

 ENUS202-045.PDF (39KB)


At a Glance

  • New capabilities for visualizing data spatially and with charts
  • Connection options to ODBC-compliant data sources; new administrative options
  • Significant new functions for creating and running QMF objects with Java-enabled browsers
  • Intelligent Miner (IM) Scoring support via custom easy-to-use function
  • Addition of inner, outer, left, right, and full joins
  • SQL Expression Builder
  • Support for the @IF REXX function
  • Secondary authorization ID improvements
  • Improved catalog administration

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® 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:

  • New capabilities for visualizing data spatially and with charts
  • Connection options to ODBC-compliant data sources
  • Significant new functions for creating and running QMF objects with Java-enabled browsers
  • Intelligent Miner™ (IM) Scoring support via custom easy-to-use functions
  • Addition of inner, outer, left, right, and full joins in Prompted Query
  • SQL Expression Builder
  • Support for the @IF REXX function
  • Secondary authorization ID improvements
  • Improved catalog administration

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.

Key Prerequisites

Refer to the Hardware Requirements and Software Requirements sections.

Planned Availability Date

March 29, 2002

Description

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
  • Significant new functions for creating and running QMF objects with Java-enabled browsers

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:

  • Apply the most appropriate marketing tactics for a new customer situation
  • Identify cross selling opportunities for preferred customers
  • Perform risk assessment "on the fly"
  • Predict propensity to buy, probability of abuse, or likelihood of customer attrition

The result is improved decision making.

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:

  • New ODBC data sources (described above) appear to the end user in the QMF for Windows database server list, expanding the choice of disparate data sources while keeping them easy to manage and target for use.
  • A new Expression Builder (available when manually authoring SQL and at locations within the Prompted Query environment of QMF for Windows) assists users in creating valid SQL, however complex, including new commands required for supporting spatial data. The Expression Builder is sensitive to the context of cursor location in a partially-built query and is "platform sensitive" by only offering expressions that are valid for the DB2 database server version the user is connected to at the time.
  • Multiple enhancements to the QMF for Windows Report Center, including the ability to:
    • View query and procedure text
    • Create comments for reports, preset and create charts and pivot tables in Lotus® 1-2-3® or Microsoft Excel
    • Specify servers to be displayed
  • Prompted Query includes:
    • Expression Builder capabilities described above
    • The addition of inner, outer, left, right, and full joins
    • Expanded sort conditions that include columns not selected, as well as expressions, spatial predicates
    • New displayed column information to include data type and label
  • Query result display improvements include:
    • The addition of support for wrapping displayed values within a column, a vertical (bottom, middle, top) alignment option
    • The ability to "go to" a certain point in the data such as a page break or search within highlighted data
    • An option to display data in hex or binary format
    • A "zoom edit" feature that assists in editing hex or binary format values
    • The allowance of a secondary currency symbol specified by the user within a report
  • Miscellaneous improvements, including:
    • Ability to use the DRAW command in an already open query, which allows the addition of more tables to existing SQL on the fly
    • Ability to open multiple documents in one File-Open operation
    • Displaying recently used objects along with recently used files in the File menu
    • Support for the REXX @IF function
    • Using the Fast Save Data function within a QMF procedure
    • Displaying descriptions for Global Variables

Administrative Enhancements

In addition to governing and tracking of browser-based users, the QMF for Windows Administrator has the following new capabilities:

  • Support for maintaining the entire QMF catalog on a single DB2 server. The QMF objects in the catalog appear and behave as before to the user, but administrators do not need to maintain a catalog on each DB2 server that is to be accessed by QMF for Windows. This catalog centralization includes queries designed for ODBC data sources, which will by default query the designated ODBC data source unless explicitly redirected to another data source by the end user at the time of query execution.
  • Other administrative improvements include:
    • Improved interface for defining and maintaining database servers
    • Improved support for Secondary AUTHIDs

For further details on new features found in QMF for Windows, V7.2, consult the product online help facility.

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 IBM e(logo)server iSeries license, which allows access to DB2 for iSeries databases only from Windows or the Web.

Trademarks

 
iSeries is a trademark of International Business Machines Corporation.
 
The e-business logo, QMF, Intelligent Miner, and Direct Support are trademarks of International Business Machines Corporation in the United States or other countries or both.
 
DB2, S/390, OS/390, and DRDA are registered trademarks of International Business Machines Corporation in the United States or other countries or both.
 
Microsoft is a trademark of Microsoft Corporation.
 
Windows is a registered trademark of Microsoft Corporation.
 
Java is a trademark of Sun Microsystems, Inc.
 
Lotus and 1-2-3 are registered trademarks of Lotus Development Corporation and/or IBM 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:

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:

    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

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:

Technical Information

Hardware Requirements

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 memory).

Software Requirements

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

QMF for Windows runs on:

  • Microsoft™ Windows 95
  • Microsoft Windows 98
  • Microsoft Windows NT® 4.0
  • Microsoft Windows 2000
  • Microsoft Windows ME
  • Microsoft Windows XP

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:

  • An SNA product that provides a CPI-C interface
  • A TCP/IP product that provides a WinSock Version 1.1 interface
  • DB2 UDB Runtime Client, V6.1, or later
  • One or more ODBC 2.x or 3.x drivers

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:

  • Microsoft Excel 7.0, or later
  • Lotus® 1-2-3® Millennium Edition, or later

Use of charting in spreadsheet applications with QMF for Windows requires one or both of:

  • Microsoft Excel 97, or later
  • Lotus 1-2-3 Millennium Edition, or later

QMF Query for Java™ requires WebSphere™ Application Server V3.02 or 3.5, running on one of the following platforms:

  • Microsoft Windows NT 4.0 or Microsoft Windows 2000
  • AIX
  • Linux
  • IBM e(logo)server iSeries V4R4, or later
  • OS/390® V2.5, or later (with UNIX System Services)
  • z/OS™ V1.1, or later (with UNIX System Services)

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.

Performance Considerations: All factors relevant to performance are described in the Installing and Managing QMF for Windows publication, which ships on CD-ROM 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, USA.

Packaging: QMF for Windows, V7.2 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 softcopy format

Included in the package:

  • License Information Booklet (GC27-0843) in softcopy format
  • Proof of Entitlement (PoE)

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 future reference.

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 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

Passport Advantage

                                                       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.

LI Form Number: GC27-0843

Limited Warranty: Yes

Program Services

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

Money-Back Guarantee: 30-day, money-back guarantee, applicable to the first instance per customer enterprise. The money-back guarantee will commence on the invoice date.

Copy and Use on Home/Portable Computer: No

Volume Orders (IVO): No

Passport Advantage Applies: Yes, and through the Passport Advantage Web site at:

IBM Operational Support Services — Support Line: No

AIX/UNIX® Upgrade Protection Applies: No

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

iSeries Software Subscription Applies: No

Variable Charges Apply: No

Educational Allowance Available: Not applicable

Prices

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.

For example:

  • To license QMF for Windows for a machine running DB2 on a 4-way SMP, a customer buys four Program Packages (each including one processor).
  • To license QMF for Windows to access two uniprocessor DB2 workstation database servers, a customer buys two Program Packages.

                                      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
1
One-time charge

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:

Order Now

 Use Priority/Reference Code: SE001
 
 Phone:     800-IBM-CALL
 Fax:       800-2IBM-FAX
 Internet:  ibm_direct@vnet.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

 
iSeries is a trademark of International Business Machines Corporation.
 
The e-business logo, QMF, WebSphere, and z/OS are trademarks of International Business Machines Corporation in the United States or other countries or both.
 
DB2, DB2 Universal Database, AIX, DataJoiner, OS/390, and OS/2 are registered trademarks of International Business Machines Corporation in the United States or other countries or both.
 
Microsoft is a trademark of Microsoft Corporation.
 
Windows and Windows NT are registered trademarks of Microsoft Corporation.
 
Java is a trademark of Sun Microsystems, Inc.
 
UNIX is a registered trademark is a registered trademark of the Open Company in the United States and other countries.
 
Lotus and 1-2-3 are registered trademarks of Lotus Development Corporation and/or IBM Corporation.
 
Other company, product, and service names may be trademarks or service marks of others.