IBM QMF for Windows for DB2 Workstation Databases Version 6 -- Business Intelligence Starts Here
December 1, 1998
Announcement Letter Number: 298-433
Table of Contents:
- At a Glance
- PRODUCT POSITIONING
- SUPPLEMENTAL INFORMATION
- EDUCATION SUPPORT
- TECHNICAL INFORMATION
- ORDERING INFORMATION
- TERMS AND CONDITIONS
At a Glance
QMF for Windows for DB2 Workstation Databases Version 6 key enhancements include:
- Support for DB2 stored procedures
- Automation capabilities with QMF linear procedures and command line parameters
- Additional Web publishing capabilities with HTML forms
- Enhancements to object tracking, governing, formatting/editing of data
- Ease-of-use for novice users as well as expert-level functionality
- Native access to multiple DB2 workstation database server platforms
- Transparent integration with other Windows applications
- Setup in minutes to TCP/IP-enabled DB2 V5 and V6 database servers
- Centralized and secure protection of enterprise database resources
- Server-based pricing, unlimited users per server, centralized install, and elimination of database gateways, middleware, and ODBC drivers
- Download a 60-day trial version:
EXTRA! EXTRA! . . .
Subscribe to IBM iSource, your electronic source for customized IBM information! Go to our web site at http://www.ibm.com/isource or send an e-mail to email@example.com with the word SUBSCRIBE in the body.
QMF (TM) for Windows (TM) Version 6 is a multi-purpose enterprise query environment for large scale business reporting, data sharing, server resource protection, robust application development, and native connectivity to all of the DB2 (R) workstation platforms.
New functions in Version 6 include support for QMF linear procedures, DB2 stored procedures, a command line interface for enhanced automation, and new levels of governing available to administrators. Report Form calculations (requires IBM Object REXX and 32-bit) and specialized form variables for Web publishing let you build advanced features into your reports.
Designed for DB2 and for corporate 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 spreadsheets, charting and analysis tools, executive information systems, and desktop databases.
For Administrators, QMF for Windows is a single product with capabilities needed to safely open all of the DB2 workstation database platforms to Windows users (3.x, 9x, NT, and WIN-OS/2 (R)) 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 robust Windows application programming interface (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 provides 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 (TM) (DRDA (R)). Support for multi-vendor database environments through IBM's DataJoiner (R) allows users to access other vendor and nonrelational workstation databases.
Planned Availability Date
December 11, 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 V6 provides support for:
- DB2 stored procedures.
- Creating and running QMF linear procedures.
- Command line parameters, which allow you to more easily automate
start-up procedures and integration with other applications, such
as Visual Warehouse.
- Enhanced object tracking, which allows you to view a detailed run
history for all QMF objects to locate unused objects, determine
frequently accessed data sources (tables/columns), and spot
potential problem areas.
- Web publishing, which allows you to convert a standard QMF form to
an HTML format.
- Specialized form variables for HTML publishing, which lets you
build advanced Web features into your QMF report, such as
hyperlink, e-mail link, and embedding images in reports. Includes
report preview feature.
- Global Variables for use in QMF for Windows procedures, forms,
queries, and session variables.
- QMF Form calculations (requires 32-bit QMF for Windows and IBM
- The most commonly used attributes of form components, now grouped
together on a new form dialog for ease of use.
- Custom edit codes can be added to QMF (requires 32-bit QMF for
Windows and IBM Object REXX). A sample user edit code routine is
supplied that formats U.S. social security numbers, telephone
numbers, and zip codes.
- Euro currency symbol.
- Control of formatting of date and time values in your QMF reports.
- Multiple formatted reports displayed on your desktop at the same
time, while performing other application functions.
- Control over what tables and QMF objects are displayed when users
- Import/Export data, using the IXF format, that allows you to use
your QMF query results to create new (or append to existing) DB2
- Changing database passwords from within QMF for Windows.
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 corporate users to bring the same standards of performance, security, and reliability to Windows and the Web that they might have traditionally expected only from entirely host-based technologies.
Windows users (Windows 3.x, WIN-OS/2, Windows 95, Windows 98, and Windows NT (R)) may 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 "objects" in a common object space shared by other QMF users across the enterprise. Alternatively, the QMF API allows users to stay entirely within their favorite Windows applications (such as Lotus (R) 1-2-3 (R), Microsoft (TM) Excel, or Microsoft Access) as they execute QMF objects, query multiple DB2 workstation databases, and merge the resulting data into the spreadsheet, database, or other desktop application of choice. Users can 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 robust 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, from closing access to a database server altogether, restricting groups of users to a "read only" status (disallowing ad hoc query access), to finely-tuned limits on rows fetched and re-use of connections to the database. 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 summary of benefits to users, application developers, database administrators, and the enterprise follows.
- Run queries directly to DB2 from Windows applications
- Integrate QMF objects (queries, forms, and procedures) and
commands into Windows applications
- 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
- Eliminate 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 objects stored on servers and launch from within
- Create 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
- Safely stores Windows user resource limits at the DB2 workstation
- Supports different limits for different users, groups, and
- Governs specific to the DB2 workstation database server 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/bytes 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 database
- Amount of time a connection to a DB2 workstation database
server can remain unused
- Time of day, day of week
- Set query isolation level
- Allow/disallow running static SQL or stored procedures
- Allow/disallow ad hoc query capability
- Allow/disallow SQL verbs including:
- ALTER, CALL, CREATE, DELETE, DROP, GRANT, INSERT, REVOKE, UPDATE, COMMENT, EXPLAIN, LABEL, LOCK, SELECT, SET
- Maximum rows/bytes to fetch
QMF for Windows is built for the networked enterprise with the understanding that you need to connect and protect your data sources. QMF for Windows is a unique Windows querying tool, providing:
- 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 and execution 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
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)), pre-configured 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 that is 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.
QMF for Windows V6 implements distributed relational database architecture (DRDA) and provides native support for TCP/IP connectivity to DB2 Universal Databases V5 (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, IBM eNetwork (TM) 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/or receiving date data within and between the twentieth and twenty-first centuries, provided that 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 January 31, 2001.
Positioning of QMF for Windows is summarized by the phrase "Business Intelligence (BI) starts here." Easy to use, fast to implement, 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 and on the Web.
As a separately orderable product, QMF for Windows provides a query manager for DB2 workstation databases where host QMF is not available.
QMF, Distributed Relational Database Architecture, and eNetwork are trademarks of International Business Machines Corporation in the United States or other countries or both. DB2, WIN-OS/2, DRDA, and DataJoiner 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 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.
A QMF (TM) for Windows (TM): End User Workshop (CF800) is available. To obtain the class schedule, call 800-IBM-TEACH (426-8322), or access the Web at:
Rocket Software, Inc.
One Innovation Drive
Natick, MA 01760
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
Getting Started with QMF SC26-9582 for Windows
Installing and Managing QMF GC26-9583 for Windows
The following publications will be available after availability:
Order Title Number Language
Installing and Managing GC26-9583 English QMF for Windows Getting Started with SC26-9582 English QMF for Windows
QMF for Windows implements the following key industry standards:
- DRDA (R) -- The Open Group's Distributed Relational Database
Architecture (TM) is used to communicate with the DB2 (R) family
of relational databases.
- TCP/IP and SNA -- Communication protocols supported by host QMF
and QMF for Windows. The DRDA Application Requester (AR) and DRDA
Application Server (AS) functionality can now be implemented using
these standard protocols.
- SQL 92 Entry Level -- Level of SQL with which QMF (or QMF for Windows) is compliant.
Specified Operating Environment
Hardware Requirements: Server hardware requirements are those required to run DB2 PE, DB2 Common Server, or DB2 UDB.
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: This section describes the minimum software requirements for QMF for Windows.
QMF for Windows runs on:
- Microsoft (TM) Windows 3.1
- Microsoft Windows for Workgroups 3.1 or 3.11
- WIN-OS/2 (R) environment under OS/2 (R)
- Microsoft Windows 95
- Microsoft Windows 98
- Microsoft Windows NT (R)
QMF for Windows for a DBCS language can only be run on Windows 95, Windows 98, and Windows NT (32 bit).
QMF for Windows may connect to DB2 Universal Database (R) 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, Windows 98, 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 9x, 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.
Windows Windows Windows WIN- SNA Product 3.x 9x NT OS/2
Attachmate EXTRA! APPC Client 3.11 16-bit IBM APPC Networking Services for 16-bit Windows Version 1.0 IBM Communications Server for OS/2 16-bit Warp Version 4.1 IBM Personal Communications 32-bit AS/400 (R) & 3270 Version 4.1 for Windows 95 IBM Personal Communications 32-bit AS/400 & 3270 Version 4.1 for Windows NT IBM eNetwork (TM) Personal 32-bit 32-bit Communications Version 4.21 for Windows 95 and Windows NT IBM Personal Communications 16-bit AS/400 & 3270 Version 4.1 for OS/2 IBM eNetwork Personal 16-bit Communications Version 4.21 for OS/2 Warp Microsoft SNA Server 2.11 or 3.0 16-bit 16-bit 16-bit Windows 3.X Client Microsoft SNA Server 2.11 or 3.0 32-bit Windows 95 Client Microsoft SNA Server 2.11 or 3.0 32-bit Windows NT Client NetSoft DynaComm/Elite 3.51 APPC 16-bit Novell NetWare for SAA 2.2 32-bit 32-bit Wall Data Rumba 95/NT 5.0 32-bit 32-bit
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 Windows 3.x, Windows 9x, and Windows 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.
Windows Windows Windows TCP/IP Stack 3.x 9x NT
Microsoft Windows 95 TCP Protocol 16-bit 32-bit Microsoft Windows NT TCP Protocol 32-bit 16-bit Microsoft TCP/IP-32 for Windows 16-bit for Workgroups 2.11b
The following table indicates the DB2 workstation databases that QMF for Windows supports:
Product Version Release
DB2 Parallel Edition Version 1 Release 2 for AIX (R) 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 Version 5 Database (UDB) DB2 Universal Version 5 Release 2 Database (UDB)
Note: Access to DB2 UDB Personal Edition is not supported.
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)
QMF for Windows V6 is the last version that will support the 16-bit Windows platforms.
Packaging: QMF for Windows V6 is shipped on one CD-ROM containing 16-bit and 32-bit support.
For DBCS languages, (Chinese Simplified, Japanese and Korean), only 32-bit code is provided.
Two publications are shipped: Getting Started with QMF for Windows and Installing and Managing QMF for Windows.
Note: All supported languages are shipped on the same CD-ROM.
Note: QMF for Windows V6 is the last version that provides 16-bit support.
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 DataJoiner). Access to host databases, including via IBM DataJoiner, is not authorized.
- 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 Program Name/ Type Feature Part Description Number Number Number
QMF for Windows V6 5801-AAR 4060 31L2030 Program Package 1 Add'l Processor 5807-AAR 2833 39L8415 5 Add'l Processors 5807-AAR 2834 39L8416 10 Add'l Processors 5807-AAR 2835 39L8417 50 Add'l Processors 5807-AAR 2836 39L8418
QMF for Windows is made up of three components:
- Client (PC code that users use to connect to the DB2 server)
- Administrator tool (PC code that administrators use to configure
QMF for Windows)
- Host enabler (code that administrators upload to the database server via the administrator's tool, enabling the client to connect to DB2)
Licensing: IBM International Program License Agreement. Proofs of Entitlement (PoE) are required for all authorized use.
Limited Warranty Applies: Yes
Support Center Applies: Yes
Available until Discontinued: January 31, 2001
APAR Mailing Address: IBM Corporation APAR Processing One Innovation Drive Natick, MA 01760
Money-back Guarantee: 30-day, money-back guarantee
Copy and Use on Home/Portable Computer: No
Support Line: Personal Systems
Upgrades: Customers can 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
QMF, Distributed Relational Database Architecture, and eNetwork are trademarks of International Business Machines Corporation in the United States or other countries or both. DRDA, DB2, OS/2, WIN-OS/2, DB2 Universal Database, AS/400, AIX, and DataJoiner 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.