IBM QMF for Windows for DB2 Workstation Databases Version 6 -- Business Intelligence Starts Here

Software Announcement
December 1, 1998
Announcement Letter Number: 298-433


Table of Contents:



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
QMF for Windows for DB2 Workstation Databases also provides:
  • 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 info@isource.ibm.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



DESCRIPTION

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 Object REXX).

  • 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 view lists.

  • Import/Export data, using the IXF format, that allows you to use your QMF query results to create new (or append to existing) DB2 tables.

  • Changing database passwords from within QMF for Windows.
Note that the QMF for Windows V6 "Try and Buy" can be obtained at general availability of the product from the QMF Web site at: As a general-purpose query environment for DB2 datamarts, data warehouses, and enterprise operational data, QMF for Windows is in many ways more powerful and more versatile than special-purpose database front ends and single-user query tools. This is because QMF for Windows is designed for multi-user, production level data access where the broadest base of business operations must be satisfied.

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.

User Benefits

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

  • Select QMF objects from drop-down lists

  • Control queries, run QMF commands in the foreground or in the background

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

  • 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
Developer Benefits
  • 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 Windows applications

  • Create QMF reports from Windows applications

  • Eliminate manual export/import procedures from host to PC
Administrator Benefits
  • Protects DB2 from runaway queries and novice users with robust governing

  • Relies on existing DB2 security

  • Safely stores Windows user resource limits at the DB2 workstation database server

  • Supports different limits for different users, groups, and schedules

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

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

    • 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
Enterprise Benefits

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
Governor settings are controlled from the QMF for Windows Administrator which is included with the product. You can easily add to the list of servers available to your users, bind database packages, grant authority, and administer resource limits by groups and schedules, giving you control over user actions and resource consumption that can easily be changed by day-of-week and by time-of-day.

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
Centralized Installation Options

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.

Connectivity

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.



Year 2000

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.



PRODUCT POSITIONING

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.

Trademarks

      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.



SUPPLEMENTAL INFORMATION



EDUCATION SUPPORT

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:

QMF for Windows onsite administration and configuration education are provided for a fee from the following IBM Business Partner:
    Rocket Software, Inc.
    One Innovation Drive
    Natick, MA 01760
    508-655-7677



PUBLICATIONS

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



OPEN ENTERPRISE

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.



TECHNICAL INFORMATION



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)
Note: The QMF for Windows Administrator module is 32 bit only.

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)
Performance Considerations: All factors relevant to performance are described in the Installing and Managing QMF for Windows publication which ships with the product.



Planning Information

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.



ORDERING INFORMATION

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.

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



TERMS AND CONDITIONS

QMF for Windows is made up of three components:

  1. Client (PC code that users use to connect to the DB2 server)

  2. Administrator tool (PC code that administrators use to configure QMF for Windows)

  3. Host enabler (code that administrators upload to the database server via the administrator's tool, enabling the client to connect to DB2)
This program is licensed on a per server (machine running DB2) basis, with unlimited clients. The host computer running DB2 is the designated machine. A separate license is required for each designated machine in which the licensed program materials will be used, except as otherwise provided by IBM. You may install and use the Administrator's tool on an unlimited number of Windows-based client PCs. You may install and use the client component on an unlimited number of Windows-based client PCs to access the host computer.

Licensing: IBM International Program License Agreement. Proofs of Entitlement (PoE) are required for all authorized use.

Limited Warranty Applies: Yes

Program Services

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

Trademarks

      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.