IBM Query Management Facility (QMF) for Windows for DB2 Workstation Databases -- Connects, Protects, and Extends Access to Your Data and the Web
May 12, 1998
Announcement Letter Number: 298-158
Table of Contents:
- At a Glance
- PRODUCT POSITIONING
- SUPPLEMENTAL INFORMATION
- EDUCATION SUPPORT
- TECHNICAL INFORMATION
- ORDERING INFORMATION
- TERMS AND CONDITIONS
- CALL NOW TO ORDER
At a Glance
QMF for Windows for DB2 workstation databases Version 3.3, a universal interface to DB2, enables you to:
- Access multiple DB2 workstation database server platforms
- Create and share business reports
- Transparently integrate data into Windows applications
- Dramatically reduce scalability issues
- Automate query and reporting tasks
- Post and automatically refresh business reports on intranet and
- Protect enterprise data with centralized governing and resource
- Minimize or eliminate database gateways, middleware, and ODBC
- Connect natively via TCP/IP to DB2 UDB Version 5
- Rapidly build robust applications using Windows-based languages
and OLE 2.0 automation controls
- Leverage Windows 3.x, Windows 9x, Windows NT (R), and WIN-OS/2
- Download a free 60-day evaluation copy
----------------------------------------- For ordering, contact: Your IBM representative, an IBM Business Partner, or IBM North America Sales Centers at 800-IBM-CALL Reference: SE010
The IBM Query Management Facility (QMF (TM)) for Windows (TM) Version 3 Release 3 for DB2 (R) workstation databases is a multipurpose, multidatabase query engine that provides a comprehensive user environment for formulating and sharing business reports. It is a robust Windows-based API for automating database querying, updating, and report distribution tasks, as well as centralized control over database resource consumption.
Customers with DB2 workstation databases or DataJoiner (R) now have a Windows-based point-and-click query tool that provides several strategic benefits in one package, including:
- A remarkably intuitive "quick start" user interface
- The ability to automate tasks and develop powerful native Windows applications over time
Native support for TCP/IP connectivity to DB2 Universal Database (R) (UDB) Version 5, coupled with comprehensive governing, make QMF for Windows the way to transparently "connect and protect" the enterprise, even with widely distributed user locations and varying levels of database querying skills.
QMF for Windows for DB2 workstation databases is architecturally coupled across platforms with DB2 through the enterprise distributed data standard Distributed Relational Database Architecture (TM) (DRDA (R)). QMF for Windows for DB2 workstation databases is designed to eliminate issues of scalability, control, performance, responsiveness, and reliability in the distribution of data to increasingly remote and diverse client platforms.
- New or existing DB2 customers who want to safely extend their data
to ubiquitous clients and improve their decision support
- Customers interested in merging the capabilities of Windows office
suites, such as Lotus (R) and Microsoft (TM), and other Windows
applications that provide OLE 2.0 automation controls, with the
industrial strength of DB2 databases
- Customers using the QMF HPO/Shuttle Version 3.3 feature of QMF
need not upgrade, as the QMF for Windows product is functionally
equivalent to the Shuttle feature (except for the DBCS enablement
and installation process described in the Description section)
- Users of DB2 workstation databases who have neither QMF nor its HPO features, and who need ad-hoc query, report writing, query management, and OLE 2.0 interfaces to DB2 data from Windows and WIN-OS/2 (R) PCs
Windows versions described in the Software Requirements section
Planned Availability Date
May 15, 1998
This announcement is provided for your information only. For additional information, contact your IBM representative, call 800-IBM-4YOU, or visit the IBM home page at: http://www.ibm.com
QMF for Windows for DB2 Workstation Databases
With DB2 as the server and TCP/IP as the transport, the day of the networked enterprise has fully arrived, but as you distribute data more universally, the need for control increases. You need to "connect and protect."
QMF for Windows was created for this purpose. With native access to multiple DB2 workstation platforms and a native API supporting a variety of commercial or custom Windows applications, querying, reporting, sharing, and integrating data across the enterprise now becomes transparent. Now you can give ubiquitous users freer access to DB2 workstation databases with confidence because QMF for Windows is a unique Windows tool that combines ease-of-use, large-scale performance, and centralized governing and control over user actions and resource consumption.
QMF for Windows presents extensive benefits for existing and new data centers with DB2 in their topology. It has been built by system architects who have worked with and understood DB2 relational databases and host QMF since their first release.
QMF for Windows provides access from 16- or 32-bit Windows environments via DRDA to DB2 Parallel Edition, Common Server, UDB and DataJoiner workstation databases (refer to the Software Requirements section for a list of supported DB2 databases).
QMF for Windows has many of the same capabilities as host QMF (QMF for OS/390 (TM), MVS (TM), VM, and VSE), including querying multiple DB2 platforms directly with no database gateways or middleware in between, and the ability to share centrally stored objects (queries and forms) among users. Environments with the appropriate host QMF and QMF for Windows licensing can transparently share query and form objects between workstations and the host. This allows QMF customers a robust extension of business reports to QMF for Windows without interruption in the way they provide decision support today.
Windows users can create, access, browse, run, edit, and save queries and forms stored at the server. Queries can be launched from within Windows applications (such as Lotus 1-2-3 (R), Lotus Notes (R), or Microsoft Excel) without leaving the application. Multiple queries can be run simultaneously. "Power users" and developers can use the robust QMF for Windows API to enable their Windows applications to work directly with the QMF objects they share across the enterprise, and leverage large database techniques such as static SQL.
QMF for Windows provides many benefits for the user, the developer, the administrator, as well as the enterprise. Here are just a few:
For the User
- Run queries directly to DB2 from Windows applications
- Integrate QMF objects (queries and forms) and commands into
- Run ad hoc queries or stored queries
- Save new queries to a local drive, network drive, or as shared QMF
- Select QMF objects from drop-down lists
- Control queries, run QMF commands in the foreground or in the
- Run more than one query or command at a time
- Connect to more than one DB2 workstation database server at a time
- Limit size of query results
- View resource limits in effect
- Access information about queries, such as remarks and tracking
- Use the QMF for Windows interface or your favorite application
- Integrate with Excel, Visual Basic, Powerbuilder -- all OLE 2.0-compliant applications -- using simple application macros or environments such as Visual Age for Basic and Visual Basic
- Eliminates database gateways, middleware, or ODBC drivers
- Integrate with any Windows OLE 2.0 automation client application
- Call on QMF for Windows services with its API
- Use supplied sample code as templates or as-is
- Bring industrial strength to ordinary desktop languages
- Leverage skills of desktop development community
- Query in DB2 native distributed syntax (the server's SQL)
- Get the reliability, performance, and security of DB2
- Let QMF for Windows automatically manage DB2 resources (threads,
conversations, states) in the background
- Use performance enhancing technologies such as static SQL directly
in your Windows applications
- Shield users from complexity of connections
- Retrieve QMF queries stored on servers and launch from within
- Use 20+ QMF commands, including Save Data, Draw, Convert
- Print QMF reports from Windows applications
- Eliminate manual export/import procedures from host to PC
- Protects DB2 from runaway queries and novice users with robust
- Relies on existing DB2 security
- Identifies users, safely stores Windows user resource limits at
the DB2 workstation database server
- Supports different limits for different users, groups, and
- Governs specific to the DB2 workstation database
server being accessed
- Allows administrator to temporarily suspend a user's limits
- Allows automatic assignment of QMF User Profiles and Resource
- Provides many governing parameters, including:
- Maximum rows to fetch
- Maximum connections to a DB2 workstation database server
- Amount of time a cursor can remain open without being used
- Amount of time to wait for a response from the DB2 workstation
- Amount of time a connection to a DB2 workstation database
server can remain unused
- Time-of-day, day-of-week
- Maximum rows to fetch
- Provides governing that allows/disallows SQL verbs:
- ALTER, CREATE, DELETE, DROP, GRANT, INSERT, REVOKE, UPDATE, COMMENT, EXPLAIN, LABEL, LOCK, SELECT, SET
- Top performance
- Extensive control
- Features for optimizing access to large databases
In addition, QMF for Windows allows you to specify whether or not it will track usage of QMF objects.
Now your enterprise can:
- Centralize control over server resources
- Eliminate runaway queries
- Eliminate extended open cursors
- Track user access to queries
- Maintain full security, standard authorizations
- Exploit DB2 performance, system integrity
- Support a variety of DB2 workstation database servers
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.
QMF for Windows implements DRDA and provides native support for TCP/IP connectivity to DB2 UDB Version 5. 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 the IBM PComm, Microsoft SNA Server, or Novell NetWare for SAA (R), and others.
This product is Year 2000 ready. When used in accordance with its associated documentation, it is capable of correctly processing, providing, and/or receiving date data within and between the twentieth and twenty-first centuries, provided all other products (for example, software, hardware, and firmware) used with the product properly exchange accurate date data with it.
The maintenance end date for this Year-2000-ready product is January 31, 2001.
Positioning of QMF for Windows is summarized by the phrase "Business Intelligence starts here." Query and report tools 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 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 have DB2, QMF, or both, and want to extend their industrial-strength capabilities to applications in the Windows environment.
QMF for Windows offers customers extensive control of their query and report creation environment and an enhanced graphical QMF end-user interface.
As a separately orderable product, QMF for Windows provides a query manager for DB2 workstation databases where QMF is not available.
For those who use QMF on S/390 (R) (OS/390, MVS, VM, or VSE), the QMF for Windows feature for QMF is available as an equivalent offering. The feature license provides access to any DB2 database except AS/400 (R), which is currently only accessible via the IBM DataJoiner product.
For those who do not use QMF on the S/390 platform, but want to access DB2 S/390 databases, QMF for Windows is available as a separately orderable product, licensed to access DB2 S/390 databases. Refer to Software Announcement 297-436 dated October 28, 1997, QMF for Windows -- The Universal Interface to DB2 -- Connects and Protects Your Data.
QMF, Distributed Relational Database Architecture, MVS, and OS/390 are trademarks of International Business Machines Corporation in the United States or other countries or both. DB2, DataJoiner, DB2 Universal Database, DRDA, WIN-OS/2, SAA, S/390, and AS/400 are registered trademarks of International Business Machines Corporation in the United States or other countries or both. Windows and Microsoft are trademarks of Microsoft Corporation. Windows NT is a registered trademark of Microsoft Corporation. Lotus, Lotus Notes, 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.
Courses are being developed in support of this product and will be available within three months following this announcement.
Visit the following Web site for additional information:
Call IBM Education and Training at 800-IBM-TEACH (426-8322) for catalogs, schedules, and enrollments.
The following publications can be ordered immediately. To order, contact your IBM representative or subscribe through the System Library Subscription Service (SLSS), or by direct order.
Order Title Number Language
Getting Started with QMF (TM) SC26-9152 for Windows (TM)
Installing and Managing QMF GC26-9153 for Windows
Installing and Managing GD88-7033 Japanese QMF for Windows
Getting Started with SD88-7029 Japanese QMF for Windows
Open Blueprint (R): QMF for Windows provides support for numerous industry standards, including those of the Distributed Relational Database Architecture (TM) (DRDA (R)). It supports the DRDA protocol from IBM to facilitate open, distributed, multivendor interoperability.
Specified Operating Environment
Hardware Requirements: Server hardware requirements are those required in order to run DB2 (R) PE, DB2 Common Server or DB2 UDB as described in the Software Requirements section.
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 about the same memory as needed by a typical Windows suite application.
Software Requirements: Server software requirements are those required in order to run DB2 PE, DB2 Common Server, DB2 UDB, or DataJoiner (R) as described in this section.
QMF for Windows runs on:
- Microsoft (TM) Windows 3.1
- Microsoft Windows for Workgroups 3.1 or 3.11
- Microsoft Windows 95
- Microsoft Windows NT (R)
- WIN-OS/2 (R) environment under OS/2 (R)
QMF for Windows may connect to DB2 UDB Version 5 via native TCP/IP, or to the SNA environments of that or other DB2 versions.
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 16- and 32-bit WinSock products, including those provided with Windows 95 and Windows NT.
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.
The following table indicates the configurations that QMF for Windows has been tested with and supports. The columns under WIN 3.x, WIN 95, and WIN NT indicate whether or not the 16-bit or the 32-bit version of QMF for Windows works with the listed SNA product on that platform.
.-----------------------+--------+-------+-------+----------. |SNA PRODUCT |WIN 3.X |WIN 95 |WIN NT | WIN-OS/2 | |-----------------------+--------+-------+-------+----------| |Attachmate EXTRA! APPC | 16-bit | | | | | Client 3.11 | | | | | |-----------------------+--------+-------+-------+----------| |IBM APPC Networking | 16-bit | | | | | Services for Windows | | | | | | Version 1.0 | | | | | |-----------------------+--------+-------+-------+----------| |IBM Communications | | | | 16-bit | | Server for OS/2 Warp | | | | | | Version 4.1 | | | | | |-----------------------+--------+-------+-------+----------| |IBM Personal | | 32-bit| | | | Communications AS/400| | | | | | and 3270 Version 4.1 | | | | | | for Windows 95 | | | | | |-----------------------+--------+-------+-------+----------| |IBM Personal | | | 32-bit| | | Communications AS/400| | | | | | and 3270 Version 4.1 | | | | | | for Windows NT | | | | | '-----------------------+--------+-------+-------+----------'
.-----------------------+--------+-------+-------+----------. |IBM eNetwork(TM) | | 32-bit| 32-bit| | | Personal | | | | | | Communications | | | | | | Version 4.21 for | | | | | | Windows 95 and | | | | | | Windows NT | | | | | |-----------------------+--------+-------+-------+----------| |IBM Personal | | | | | | Communications AS/400| | | | 16-bit | | and 3270 Version 4.1 | | | | | | for OS/2 | | | | | |-----------------------+--------+-------+-------+----------| |IBM eNetwork Personal | | | | 16-bit | | Communications | | | | | | Version 4.21 | | | | | | for OS/2 Warp | | | | | |-----------------------+--------+-------+-------+----------| |Microsoft SNA Server | 16-bit | 16-bit| 16-bit| | | 2.11 or 3.0 | | | | | | Windows 3.X Client | | | | | |-----------------------+--------+-------+-------+----------| |Microsoft SNA Server | | 32-bit| | | | 2.11 or 3.0 | | | | | | Windows 95 Client | | | | | |-----------------------+--------+-------+-------+----------| |Microsoft SNA Server | | |32-bit | | | 2.11 or 3.0 | | | | | | Windows NT Client | | | | | |-----------------------+--------+-------+-------+----------| |NetSoft DynaComm/Elite | 16-bit | | | | | 3.51 APPC | | | | | |-----------------------+--------+-------+-------+----------| |Novell NetWare for | | 32-bit| 32-bit| | | SAA(R) 2.2 | | | | | |-----------------------+--------+-------+-------+----------| |Wall Data Rumba | | 32-bit| 32-bit| | | 95/NT 5.0 | | | | | '-----------------------+--------+-------+-------+----------'
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 following table indicates the configurations that QMF for Windows has been tested with and supports. The columns under WIN 3.x, WIN 95, and WIN NT indicate whether or not the 16-bit or 32-bit version of QMF for Windows works with the listed TCP/IP product on that platform.
.-----------------------+--------+-------+-------+----------. |TCP/IP Stack |WIN 3.X |WIN 95 |WIN NT | WIN-OS/2 | |-----------------------+--------+-------+-------+----------| |Microsoft Windows 95 | | 16-bit| | | | TCP Protocol | | 32-bit| | | |Microsoft Windows NT | | | 16-bit| | | TCP Protocol | | | 32-bit| | |Microsoft TCP/IP-32 | 16-bit | | | | | for Windows for | | | | | | Workgroups 2.11b | | | | | '-----------------------+--------+-------+-------+----------'
The following table indicates the DB2 workstation databases that QMF for Windows supports:
Product/ Part Product Version Release Number
DB2 Parallel Edition Version 1 Release 2 5765-328 for AIX (R) DataJoiner for AIX Version 1 Release 2 84H1212 DB2 DataJoiner for AIX, Version 2 Release 1 5231200 and Windows NT Product/ Part Product Version Release Number
DB2 Common Server for: Windows NT Version 2 Release 1 53H7474 OS/2 Version 2 Release 1 41H2114 AIX Version 2 Release 1 41H2128 HP-UX Version 2 Release 1 10H2366 Solaris Version 2 Release 1 10H2421 SCO Open Server Version 2 Release 1 79H5359 SINIX Version 2 Release 1 79H4133
DB2 Universal Database (R) Version 5 0795113 (UDB) for AIX, OS/2, 0795114 Windows NT, HP-UX, 0795115 and Solaris
QMF for Windows can install spreadsheet add-in buttons and menu commands for direct access from within these popular spreadsheet applications:
- Lotus (R) 1-2-3 (R) Release 5 (16-bit)
- Microsoft Excel V5 (16-bit)
- Microsoft Excel V7 or 97 (32-bit)
Software Announcement 297-436 dated October 28, 1997 (QMF for Windows), provided QMF for Windows as a separately orderable product, licensed to access DB2 S/390 servers (OS/390 (TM), MVS, VM, and VSE).
This announcement adds a new QMF for Windows as a separately orderable product, licensed to access DB2 workstation databases (DB2 PE, Common Server, UDB, and DataJoiner).
The QMF for Windows Version 3.3 feature and the QMF for Windows Version 3.3 products are functionally equivalent.
Performance Considerations: All factors relevant to performance are described in the Getting Started with QMF for Windows book that ships with the product.
Packaging: QMF for Windows is shipped on four diskettes for 16-bit support and four diskettes for 32-bit support. A total of eight diskettes are shipped.
For DBCS languages (Chinese Simplified, Japanese, and Korean), only four 32-bit diskettes are shipped.
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 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 DataJoiner). Access to host databases, including via IBM 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.
Order Feature Part Description Type Number Number
QMF for Windows Program Package 5801-AAR 2833 04L6651 1 Additional Processor 5807-AAR 0984 04L7207 5 Additional Processors 5807-AAR 8743 04L9228 10 Additional Processors 5807-AAR 8744 04L9229 50 Additional Processors 5807-AAR 8745 04L9230
Licensing: IBM International Program License Agreement. Proofs of Entitlement (PoE) are required for all authorized use.
Limited Warranty: Yes
- Support Center applies: Yes
- Available until discontinued: January 31, 2001
- APAR Mailing Address:
One Innovation Drive
Natick, MA 01760
Copy and Use on Home/Portable Computer: No
Support Line: Personal Systems
Complimentary Introductory Support: Not available for OS/2 platform
Upgrades: Customers may acquire upgrades up to the currently authorized level of use of the qualifying programs.
Volume Orders: Yes, contact your IBM representative.
Passport Advantage Applies: Yes
AIX/UNIX (R) Upgrade Protection Applies: No
Entitled Upgrade for Current AIX/UNIX Upgrade Protection Licensees: No
Variable Charges Apply: No
For prices, contact an IBM representative.
To order, contact the IBM North America Sales Centers, your local IBM representative, or your IBM Business Partner.
IBM North America Sales Centers, our national direct marketing organization, can add your name to the mailing list for catalogs of IBM products.
Phone: 800-IBM-CALL (TM) Fax: 800-2IBM-FAX Internet: email@example.com Mail: IBM North America Sales Centers Dept. SE010 P.O. Box 16848 Atlanta, GA 30321-0848 Reference: SE010
To identify your local IBM Business Partner or IBM representative, call 800-IBM-4YOU.
Note: Shipments will begin after the planned availability date.
QMF, Distributed Relational Database Architecture, eNetwork, MVS, OS/390, and 800-IBM-CALL are trademarks of International Business Machines Corporation in the United States or other countries or both. Open Blueprint, DRDA, DB2, DataJoiner, OS/2, WIN-OS/2, SAA, AIX, and DB2 Universal Database are registered trademarks of International Business Machines Corporation in the United States or other countries or both. Windows and Microsoft are trademarks of Microsoft Corporation. Windows NT is a registered trademark of Microsoft Corporation. UNIX is a registered trademark in the United States and other countries exclusively through X/Open Company Limited. 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.