QMF for Windows -- the Universal Interface to DB2 -- Connects and Protects Your Data

Software Announcement
October 28, 1997
Announcement Letter Number: 297-436


Table of Contents:



At a Glance

QMF for Windows, a universal interface to DB2, enables you to:

  • Create and globally share enterprise business reports

  • Access multiple DB2 server platforms

  • Transparently integrate data into virtually any commercial or custom Windows applications

  • Dramatically reduce scalability issues

  • Automate query and reporting tasks

  • Post and automatically refresh business reports on intranet and Web servers

  • Protect enterprise data with centralized governing

  • Enhance server performance management with resource controls and query execution options

  • Minimize or eliminate database gateways, middleware, and ODBC drivers

  • Connect natively via TCP/IP to DB2 V5

  • Rapidly build robust applications using Windows-based languages and OLE 2.0 automation controls

  • Leverage Windows 3.x, Windows 9x, Windows NT (TM) and WIN-OS/2 client bases
-----------------------------------------
For ordering, contact:
  Your IBM representative, an IBM
  Business Partner, or IBM North America
  Sales Centers at
    800-IBM-CALL  Reference: YE010



Overview

IBM Query Management Facility (QMF (TM)) for Windows (R) is a multi-purpose, multi-database query engine that provides a comprehensive user environment for formulating and sharing business reports, and a robust Windows-based application programming interface (API) for automating database querying, updating, and report distribution tasks, as well as centralized control over database resource consumption.

Customers with DB2 (R) databases of many sizes 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; and the ability to automate tasks and develop powerful native Windows applications over time. QMF for Windows allows you to open up DB2 enterprise servers and data warehouses to 16- and 32-bit Windows users and their Windows "suite" applications of choice, bringing them industrial-strength capabilities such as static SQL and the shared object space of host QMF.

Native support for TCP/IP connectivity to DB2 for OS/390 (TM) Version 5 coupled with comprehensive governing make QMF for Windows the way to transparently "connect and protect" the enterprise, regardless of user location or database querying skills.

QMF for Windows is architecturally coupled across platforms with DB2 through the enterprise distributed data standard Distributed Relational Database Architecture (TM) (DRDA (R)). QMF for Windows is designed to eliminate issues of scalability, control, performance, responsiveness, and reliability in the distribution of data to increasingly remote and diverse client platforms.



Intended Customers

New or existing DB2, MVS (R), VM, or VSE customers who want to safely extend their data to ubiquitous clients and improve their decision support productivity.

Customers interested in merging the capabilities of Windows office suites, such as Lotus (R) and Microsoft (R), and other Windows applications that provide OLE 2.0 automation controls, with the industrial strength of DB2 databases.

Customers who already are using the QMF HPO/Shuttle V3.3 feature of QMF will not need to upgrade, as the QMF for Windows product is functionally equivalent to the Shuttle feature, except for the DBCS enablement and installation process which is described in the Description section.

This product does not require QMF to be installed on the S/390 (R) system. It is intended for users of DB2 on OS/390, MVS, VM and VSE 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.



Key Prerequisites

There is virtually no limit to the size of your user base. It can be installed wherever there is a need for information and decision making.

QMF for Windows runs under the Windows versions described in the Software Requirements section.



Planned Availability Date

December 19, 1997

------------------------------

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

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 platforms and a native API that supports a variety of commercial or custom Windows applications, querying, reporting, sharing, and integrating data across the enterprise now become transparent. Now you can give ubiquitous users freer access to DB2 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 that have DB2 in their topology. It has been built by system architects who have worked with and understood both 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 for OS/390, DB2 for MVS and DB2 for VSE & VM.

Much like QMF for VM, VSE and MVS, QMF for Windows queries DB2 directly with no database gateways or middleware in between. QMF for Windows does so without TSO, CMS, or CICS (R) logons. Your existing objects (forms and queries) can be shared between QMF for Windows and QMF for VM, VSE or MVS (if you use QMF on S/390), so that you can extend directly from your host QMF platform into the robust world of QMF for Windows without interruption in the way you provide decision support today.

Windows users can create, access, browse, run, edit, and save queries and forms stored in host QMF (if you use QMF on S/390). Queries can be launched from within Windows applications (such as Lotus 1-2-3, 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 even automatically 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 Windows applications

  • Run ad hoc queries or stored queries

  • Save new queries to a local drive, network drive or as shared QMF host 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 server at a time

  • Limit size of query results

  • View resource limits in effect

  • Access information about query (remarks, tracking data, and so on)

  • 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
For the Developer
  • No database gateways, middleware or ODBC drivers required

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

  • Use 20+ QMF commands, including Save Data, Draw, Convert

  • Print QMF reports from Windows applications

  • Eliminate manual export/import procedures from host to PC
For the Administrator
  • Robust governing protects DB2 from runaway queries, novice users

  • Relies on existing DB2 security

  • Identifies users, safely stores Windows user resource limits at the DB2 server

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

  • Governing limits are specific to DB2 server being 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 to fetch

    • Maximum connections to a DB2 server

    • Amount of time a cursor can remain open without being used

    • Amount of time to wait for a response from the DB2 server

    • Amount of time a connection to a DB2 server can remain unused

    • Time of day, day of week
  • Provides governing that allows/disallows SQL verbs:
    • ALTER, CREATE, DELETE, DROP, GRANT, INSERT, REVOKE, UPDATE, COMMENT, EXPLAIN, LABEL, LOCK, SELECT, SET
For the Enterprise: QMF for Windows is built for the networked enterprise with the understanding that you need to both connect and protect your data sources. QMF for Windows is completely unlike any other Windows querying tool you will find in the industry, providing top performance, extensive control, features for optimizing access to large databases, and compatibility with host QMF objects.

Governor settings are controlled from the QMF for Windows administrator. 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 automatically change 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 of QMF objects.

Now your enterprise can:

  • Centralize control over server resources
  • Eliminate runaway queries
  • Eliminate extended open cursors
  • Track user access to queries
  • Eliminate TSO, CMS and CICS logons
  • Maintain full security, standard authorizations
  • Exploit DB2 performance, system integrity
  • Support a variety of DB2 database servers
Centralized Installation Options: Administrators may centralize the installation, configuration, and day-to-day client operation of QMF for Windows by opting to contain configuration settings (Server Definition Files, or 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 that 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 for OS/390 Version 5. For connectivity to host 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's PComm, Microsoft SNA Server, or Novell NetWare for SAA (R), 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 20th and 21st centuries, provided all other products (for example, software, hardware, and firmware) used with the product properly exchange accurate date data with it.



PRODUCT POSITIONING

QMF for Windows is tightly positioned with DB2 and the QMF Family of products. By offering fast query performance from the Windows environment, access to existing QMF objects (queries, forms), 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 wish 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 stand-alone product, QMF for Windows provides a query manager for S/390 DB2 databases where QMF is not available. For those who use QMF on OS/390, MVS, VM or VSE, the QMF for Windows feature for QMF is available as an equivalent offering.



STATEMENT OF GENERAL DIRECTION

It is IBM's intent to provide QMF for Windows customers support for additional DB2 family databases, including those on the workstation, in order to offer them the options needed to deliver distributed, e-business, and data warehouse solutions across platforms.



EDUCATION SUPPORT

The appropriate curriculum will be updated, as necessary, to include the enhancements in this announcement.

Descriptions of all classroom and self-study courses are contained in the Catalog of IBM Education and Training.

Call IBM Education and Training at 800-IBM-TEACH (426-8322) for education catalogs, schedules, and enrollments.



REFERENCE INFORMATION

Refer to:

  • Software Announcement 297-435 297-435,:elink. dated October 28, 1997 (Query Management Facility for Windows Feature for QMF for MVS, VSE and VM)

  • Software Announcement 297-158 297-158,:elink. dated May 13, 1997 (Query Management Facility Version 3 Release 3 for MVS, VM and VSE)

  • Software Announcement 296-352 296-352,:elink. dated September 10, 1996 (QMF HPO/Shuttle Version 3.2 Client for VM, VSE and MVS)

  • Software Announcement 295-411 295-411,:elink. dated September 26, 1995 (QMF Version 3 Release 2)

  • Software Announcement 294-154 294-154,:elink. dated April 6, 1994 (IBM System/390 (R) Parallel Sysplex (TM) Software Pricing)

  • Software Announcement 294-217 294-217,:elink. dated April 12, 1994 (Query Management Facility High Performance Options for MVS Version 3 Release 1 Modification 1)

  • Software Announcement 293-595, dated October 12, 1993 (Query Management Facility VSE/ESA (TM) Version 3 Release 1 Modification 1)

  • Software Announcement 291-497, dated September 11, 1991 (Query Management Facility Version 3 Release 1 Modification 1)

  • Software Announcement 290-527, dated September 5, 1990 (Query Management Facility Version 3 Release 1)
Trademarks
      QMF, OS/390, Distributed Relational Database Architecture,
      Parallel Sysplex, and VSE/ESA are trademarks of International
      Business Machines Corporation in the United States or other
      countries or both.
      DB2, DRDA, MVS, S/390, WIN-OS/2, CICS, SAA, and System/390 are
      registered trademarks of International Business Machines
      Corporation in the United States or other countries or both.
      Windows NT is a trademark of Microsoft Corporation.
      Windows and Microsoft are registered trademarks of Microsoft
      Corporation.
      Lotus and Lotus Notes are registered trademarks of Lotus
      Development Corporation.
      Other company, product, and service names may be trademarks or
      service marks of others.



SUPPLEMENTAL INFORMATION



OPEN ENTERPRISE

QMF (TM) for Windows (R) Version 3.3 provides support for numerous industry standards, including those of the Distributed Relational Database Architecture (TM) (DRDA (R)).



TECHNICAL INFORMATION



Specified Operating Environment

Hardware Requirements: Host hardware requirements are those required in order to run DB2 (R) for MVS (R), DB2 for OS/390 (TM) or DB2 for VSE & VM.

Workstation hardware requirements are those needed to run the Windows software, as described in the Software Requirements section.

Software Requirements: Host software requirements are those required in order to run DB2 for MVS, DB2 for OS/390 or DB2 for VSE & VM.

QMF for Windows runs on:

  • Microsoft (R) Windows 3.1
  • Microsoft Windows for Workgroups 3.1 or 3.11
  • Microsoft Windows 95
  • Microsoft Windows NT (TM)
QMF for Windows for a DBCS language can only be run on Windows 95 and Windows NT (32 bit).

QMF for Windows 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.

QMF for Windows may connect to DB2 for OS/390 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, 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

Attachmate EXTRA! APPC 16-bit Client 3.11 IBM APPC Networking 16-bit Services for Windows 1.0 IBM Communications 16-bit Server for OS/2 (R) Warp 4.1 IBM Personal 32-bit Communications AS/400 (R) & 3270 4.1 for Windows 95 IBM Personal 32-bit Communications AS/400 & 3270 4.1 for Windows NT IBM Personal 16-bit Communications AS/400 & 3270 4.1 for OS/2 Microsoft SNA Server 2.11 16-bit 16-bit 16-bit or 3.0 Windows 3.X Client Microsoft SNA Server 2.11 32-bit or 3.0 Windows 95 Client Microsoft SNA Server 2.11 32-bit or 3.0 Windows NT Client NetSoft DynaComm/ 16-bit Elite 3.51 APPC Novell NetWare for 32-bit 32-bit SAA (R) 2.2 Wall Data Rumba 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 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

Microsoft Windows 95 TCP 16-bit Protocol 32-bit Microsoft Windows NT TCP 16-bit Protocol 32-bit Microsoft TCP/IP-32 for 16-bit Windows for Workgroups 2.11b Attachmate EXTRA! for 32-bit Windows 95 6.2 Attachmate EXTRA! for 32-bit Windows NT 6.2 Novell NetWare for SAA 2.0 16-bit

Compatibility: QMF for Windows was previously known as QMF HPO/Shuttle feature and is still available as a QMF host feature. Software Announcement 297-435 297-435,:elink. dated October 28, 1997 (Query Management Facility for Windows Feature for QMF for MVS, VSE and VM) renames QMF HPO/Shuttle to QMF for Windows on all platforms (MVS, VM and VSE).

This announcement adds a new QMF for Windows separately orderable product.

The QMF for Windows V3.3 feature and the QMF for Windows V3.3 product are functionally equivalent.

Performance Considerations: All factors relevant to performance are described in the Getting Started with QMF for Windows book which ships with the product.

User Group Requirements: This announcement satisfies or partially satisfies requirements from one or more of the worldwide user group communities, which include Australasian SHARE/GUIDE (ASG), COMMON, COMMON Europe, GUIDE International, G.U.I.D.E. Europe, Japan GUIDE/SHARE (JGS), Guide Latin American (LAG), SHARE EUROPE, and SHARE Incorporated.



Planning Information

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 feature uses the security and auditability features of the MVS, VM and VSE operating systems and the supported database servers.

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



New Licensees

Orders for new licenses will be accepted now.

Shipment will begin on the planned availability date.

New users of Query Management Facility for Windows should specify:

                                   Type                    Model

QMF for Windows 5697 D27

Basic License

Table A: To order this product for the basic license, specify the program number and feature number 9001 for asset registration. For a graduated OTC or graduated monthly license charge, specify one of the feature numbers below that corresponds to the group that contains the designated machine.

Also, specify the feature number of the desired distribution medium.

QMF for Windows

                       Basic                         Basic
                     Graduated                 Graduated Monthly
                  One-Time Charge                License Charge
Group              Feature Number                Feature Number

18 2555 2540 20 2556 2541 25 2557 2542 28 2558 2543 29 2559 2544 30 2560 2545 31 2561 2546 32 2562 2547 35 2563 2548 38 2564 2549 40 2565 2550 50 2566 2551 60 2567 2552 70 2568 2553 80 2569 2554

Table C

Multiple Operating System -- PR/SM (TM) (MOSP): For a graduated one-time charge or graduated monthly license charge, specify the feature number below that corresponds to the group that contains the designated machine.

QMF for Windows

                     MOSP Basic                    MOSP Basic
                     Graduated                 Graduated Monthly
                  One-Time Charge                License Charge
Group              Feature Number                Feature Number

18 2585 2570 20 2586 2571 25 2587 2572 28 2588 2573 29 2589 2574 30 2590 2575 31 2591 2576 32 2592 2577 35 2593 2578 38 2594 2579 40 2595 2580 50 2596 2581 60 2597 2582 70 2598 2583 80 2599 2584

Note: The group can be determined by referring to the Exhibit for IBM System/390 (R) Machines (Z125-3901) that are associated with the IBM Customer Agreement (Z125-4575).

Entry Support License (ESL): To order an ESL license, specify the program number, feature number 9001 for asset registration, and the applicable ESL OTC feature number. Also specify the feature number of the desired distribution medium.

Program                                      ESL One-Time Charge
Number             Description                  Feature Number

5697-D27 QMF for Windows 2600

Note: ESL machines can be determined by referring to the IBM Entry End User/390 Attachment (Z125-4379).

Parallel Sysplex (TM) License Charge (PSLC) Basic License: To order a basic license, specify the program number and feature number 9001 for asset registration. Specify the PSLC Base feature. If applicable, specify the PSLC Level A and PSLC Level B features and quantity.

If there is more than one program copy in a Parallel Sysplex, the charge for all copies is associated to one license by specifying the applicable PSLC feature numbers and quantity represented by the sum of the Service Units in Millions (MSUs) in your Parallel Sysplex. For all other program copies, specify the PSLC No-Charge (NC) Identifier feature on the licenses.

Also, specify the feature number of the desired distribution medium.

                        PSLC               PSLC Basic License
Machine                 Feature            MLC Feature
MSU Capacity            Number             Description

1 2661 PSLC Base, 1 MSU 2 2662 PSLC Base, 2 MSUs

3 2663 PSLC Base, 3 MSUs

4 -- 45 2664 PSLC Level A, 1 MSU 2665 PSLC Level A, 42 MSUs

46 or more 2666 PSLC Level B, 1 MSU 2667 PSLC Level B, 10 MSUs 2668 PSLC Level B, 50 MSUs

NA 2669 PSLC N/C ID

Example 1: For a single machine with 11 MSUs, the PSLC features would be 2663 -- quantity 1 and 2664 -- quantity 8.

Example 2: For two machines in a Parallel Sysplex which have an aggregation of 60 MSUs, the PSLC features would be:

  • PSLC chargeable license #1: 2663 -- quantity 1, 2665 -- quantity 1, 2666 -- quantity 5, and 2667 -- quantity 1

  • PSLC no-charge license #2: 2669 -- quantity 1
Indexed Monthly License Charge (IMLC) Basic License: To order a basic license, specify the program number and feature number 9001 for asset registration. Specify the IMLC Base 80 MSU feature and the applicable additional IMLC MSU features and quantity corresponding to the MSU rating of the designated machine.

Also, specify the feature number of the desired distribution medium.

IMLC                                          IMLC Basic License
Feature                                       MLC Feature
Number                                        Description

2670 IMLC Base 80 MSUs 2671 IMLC 1 MSU 2672 IMLC 10 MSUs 2673 IMLC 50 MSUs

Basic Machine-Readable Material: To order, select the feature number of the desired distribution medium:

                       Feature
Environment            Number             Distribution Medium

Windows 5805 3.5-inch diskettes (4)

Customization Options: Select the appropriate feature numbers to customize your order to specify the delivery options desired. These features can be specified on the initial or MES orders.

Example: If publications are not desired for the initial order, specify feature number 3470 to ship media only. For future updates, specify feature number 3480 to ship media updates only. If, in the future, publication updates are required, order an MES to remove feature number 3480; then, the publications will ship with the next release of the program.

                                                    Feature
Description                                         Number

Initial Shipments

Serial Number Only (suppresses shipment 3444 of media and documentation)

Ship Media Only (suppresses initial 3470 shipment of documentation)

Ship Documentation Only (suppresses 3471 initial shipment of media)

Update Shipments

Ship Media Updates Only (suppresses 3480 update shipment of documentation)

Ship Documentation Only (suppresses 3481 update shipment of media)

Suppress Updates (suppresses update 3482 shipment of media and documentation)

Expedite Shipments

Local IBM Office Expedite 3445 (for IBM use only)

Customer Expedite Process Charge 3446 ($30 charge for each product)

Expedite shipments will be processed to receive 72-hour delivery from the time IBM Software Manufacturing Solutions (SMS) receives the order. SMS will then ship the order via overnight air transportation.

DSLO License: To order this product for the DLSO license, specify the program number, feature number 9901 for asset registration, and the feature number below for a graduated one-time charge or graduated monthly license charge that corresponds to the group containing the designated machine.

                        DSLO                          DSLO
                     Graduated                 Graduated Monthly
                  One-Time Charge                License Charge
Group              Feature Number                Feature Number

18 2616 2601 20 2617 2602 25 2618 2603 28 2619 2604 29 2620 2605 30 2621 2606 31 2622 2607 32 2623 2608 35 2624 2609 38 2625 2610 40 2626 2611 50 2627 2612 60 2628 2613 70 2629 2614 80 2630 2615

Multiple Operating System -- PR/SM (MOSP): For a graduated one-time charge or graduated monthly license charge, specify the following feature number below that corresponds to the group that contains the designated machine.

                     MOSP DSLO                     MOSP DSLO
                     Graduated                 Graduated Monthly
                  One-Time Charge                License Charge
Group              Feature Number                Feature Number

18 2646 2631 20 2647 2632 25 2648 2633 28 2649 2634 29 2650 2635 30 2651 2636 31 2652 2637 32 2653 2638 35 2654 2639 38 2655 2640 40 2656 2641 50 2657 2642 60 2658 2643 70 2659 2644 80 2660 2645

Ordering a DSLO feature will result in IBM maintaining a record of this customer location as a DSLO user only. All material for the DSLO license will be provided through the basic license location. If a user selects DSLO, no other feature numbers are valid for this order and no program materials or updates will be shipped.

Unlicensed Documentation: A memo and one copy of the following publications are supplied automatically with the basic machine-readable material:

                                                       Order
Title                                                  Number

Getting Started with QMF for Windows SC26-9152 Installing and Managing QMF for Windows GC26-9153 QMF for Windows Licensed GC26-9230 Program Specification

Additional copies of unlicensed publications will be available for a fee after availability. These copies may be ordered from your IBM representative, through the System Library Subscription Service (SLSS), or by direct order.

Subsequent updates (technical newsletters or revisions between releases) to the publications shipped with the product will be distributed to the user of record for as long as a license for this software remains in effect. A separate publication order or subscription is not needed.

The following publications will be available after availability:

                                   Order
Title                              Number               Language

Installing and Managing GD88-7033 Japanese QMF for Windows

Getting Started with SD88-7029 Japanese QMF for Windows



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.

Agreement: IBM Customer Agreement

Variable Charges Apply: Yes

Location License Applies: No

Use Limitation Applies: No

Educational Allowance Available: Yes, to qualified education customers

Volume Orders: Not applicable

Version-To-Version Upgrade Credits Apply: No

Warranty Applies: Yes

Licensed Program Materials Availability

  • Restricted Materials of IBM: None
  • Non-Restricted Source Materials: None
  • Object Code Only (OCO): All
Testing Period: Two months (basic license only)

Program Services

Support Center applies:              Yes

Access is available through the IBM Support Center

Available until discontinued: 12 months written notice

APAR Mailing Address: IBM Corporation APAR Processing 161 Worcester Road Framingham, MA 01701

Services for DSLO Licenses: Provided through Basic License location

Support Line: S/390 (R)



CHARGES

The charges 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.

Program Number 5697-D27

                                      Basic         DSLO
          Basic         DSLO          Graduated     Graduated
          Graduated     Graduated     Monthly       Monthly
          One-Time      One-Time      License       License
Group     Charge        Charge        Charge        Charge

18 $ 8,450 $ 6,340 $ 176 $ 132 20 12,250 9,190 255 191 25 15,930 11,950 332 249 28 21,830 16,370 455 341 29 28,380 21,290 591 443 30 36,890 27,670 768 576 31 45,370 34,030 945 709 32 58,070 43,550 1,210 908 35 66,780 50,090 1,390 1,045 38 76,800 57,600 1,600 1,200 40 88,320 66,240 1,840 1,380 50 110,400 82,800 2,300 1,725 60 138,000 103,500 2,875 2,155 70 172,500 129,400 3,595 2,695 80 215,650 161,750 4,495 3,370

Program Number 5697-D27

                                      MOSP          MOSP
          MOSP          MOSP          Basic         DSLO
          Basic         DSLO          Graduated     Graduated
          Graduated     Graduated     Monthly       Monthly
          One-Time      One-Time      License       License
Group     Charge        Charge        Charge        Charge

18 $ 8,450 $ 6,340 $ 176 $ 132 20 10,350 7,765 216 162 25 14,090 10,570 294 221 28 18,880 14,160 394 296 29 25,110 18,830 523 392 30 32,640 24,480 680 510 31 41,130 30,850 857 643 32 51,720 38,790 1,080 810 35 62,430 46,820 1,300 975 38 71,790 53,840 1,495 1,120 40 82,560 61,920 1,720 1,290 50 99,360 74,520 2,070 1,555 60 124,200 93,150 2,590 1,945 70 155,250 116,450 3,235 2,425 80 194,100 145,600 4,045 3,035

                                                        One Time
                                                        Charge

Entry End User/390 Entry Support License: $2,823

MSU Capacity            Description                       Charge

1 PSLC Base, 1 MSU $ 456 2 PSLC Base, 2 MSUs 768

3 PSLC Base, 3 MSUs 1,213

4 -- 45 PSLC Level A, 1 MSU 55 PSLC Level A, 42 MSUs 2,310

46 or more PSLC Level B, 1 MSU 22 PSLC Level B, 10 MSUs 220 PSLC Level B, 50 MSUs 1,100

                                                          IMLC
IMLC Description                                          Charge

IMLC Base 80 MSUs $4,182 IMLC 1 MSU 22 IMLC 10 MSUs 220 IMLC 50 MSUs 1,100

One-Time Charge: Customers who pay a one-time charge for a licensed program receive enhancements and future releases, if any, at no additional charge. Significant new function may be offered as an optional feature and charged for separately. If a replacement program is announced and the customer elects to license the replacement program for a one-time charge and replace the prior program, an upgrade charge may apply.

Variable Charges: The applicable graduated one-time charge or graduated monthly license charge will be based on the group of the designated machine on which the licensed program is licensed for use. If the program is designated to a processor in a group for which no charge is listed above, the charge of the next higher group listed applies.

For upgrades of one-time charge licenses to a machine in a higher group, the upgrade charge will be the difference in the then current charges between the two groups.

For downgrades of one-time charge licenses to a machine in a lower group, there will be no adjustment or refund of one-time charges paid.

For upgrades or downgrades of monthly license charge licenses, the monthly license charge applicable to the higher or lower group will apply.

Entry Support License One-Time Charge: One-time charge authorizes use only on IBM Entry End User/390 machines.



CALL NOW TO ORDER

To order, contact the IBM North America Sales Centers, your local IBM representative, or your IBM Business Partner (TM).

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
 Fax:       800-2IBM-FAX
 Internet:  ibm_direct@vnet.ibm.com
 Mail:      IBM North America Sales Centers
            Dept. YE010
            P.O. Box 16848
            Atlanta, GA  30321-0848
 Reference: YE010

To identify your local IBM Business Partner or IBM representative, call 800-IBM-4YOU.

Note: Shipments will begin after the planned availability date.

Trademarks

      QMF, Distributed Relational Database Architecture, OS/390,
      PR/SM, Parallel Sysplex, and Business Partner are trademarks of
      International Business Machines Corporation in the United
      States or other countries or both.
      DRDA, MVS, DB2, OS/2, AS/400, SAA, System/390, and S/390 are
      registered trademarks of International Business Machines
      Corporation in the United States or other countries or both.
      Windows NT is a trademark of Microsoft Corporation.
      Windows and Microsoft are registered trademarks of Microsoft
      Corporation.
      Other company, product, and service names may be trademarks or
      service marks of others.