IBM United States
Software Announcement 201-256
September 11, 2001

IBM QMF Version 7 with DB2 Universal Database for OS/390 Versions 6 and 7 Facilitate Migration

 ENUS201-256.PDF (70KB)


At a Glance

These new features facilitate migration by providing:

  • QMF High Performance Option (HPO) as a direct feature of DB2 for OS/390 V6 and DB2 for z/OS and OS/390 V7
  • QMF, QMF for Windows, and QMF HPO for z/OS and OS/390 V7 as orderable features of DB2 for OS/390 V6

Key QMF V7 family enhancements include:

  • Improved command processing and defaults
  • New DB2 data types for large objects
  • VSE DRDA® RUOW Application Requestor and DB2 for AS/400® support
  • Java™-based query from a Web browser
  • Aggregation, grouping, and formatting in the query results
  • Point-and-click, drag-and-drop interface to QMF Form creation
  • A personal data portal for your desktop; for launching centrally shared queries and reports, for sending results to desktop tools and browsers, and for sharing already formatted spreadsheets with your workgroup

For ordering, contact:

Your IBM representative, an IBM Business Partner, or IBM Americas Call Centers at 800-IBM-CALL (Reference: LE001).

Overview

QMF™ for OS/390® Version 7 (V7), QMF for Windows® V7, and QMF High Performance Option (HPO) V7 as features of DB2® for OS/390 V6 are now available. QMF HPO V7 is a stand-alone feature of DB2 Universal Database® (UDB) for z/OS™ and OS/390 V7.

QMF is a tightly integrated, powerful, reliable, query and reporting tool set for the DB2 relational database management system family. It gives you new capabilities for the workstation environment and enhancements for the mainframe that help you access and present mission-critical data better than ever before.

QMF V7 enables you to work with data all over the enterprise, including from DB2 for OS/390, DB2 for VSE and VM, DB2 for AS/400 to workstation servers running OS/2®, Windows NT®, AIX®, and other UNIX® operating systems to massively parallel processors. QMF coupled with DB2 DataJoiner® allows access to non-relational and other vendor data sources as well.

Key Prerequisites

  • DB2 UDB for OS/390, V6
  • DB2 UDB for z/OS and OS/390, V7

Planned Availability Date

September 14, 2001

Description

The QMF Family includes the following as priced features of DB2 UDB for OS/390, V6 and DB2 UDB for z/OS and OS/390, V7:

  • QMF for OS/390
  • QMF for Windows
  • QMF High Performance Option (HPO)

These features offer a comprehensive data access and governing solution including:

  • Accessing large amounts of data
  • Sharing central repositories of queries and enterprise reports
  • Implementing tightly controlled distributed or client/server solutions

They also provide report publishing to the Web for viewing with your favorite Web browser.

QMF HPO V7 includes the QMF HPO/Compiler, QMF HPO/Manager, and QMF for Windows.

The QMF HPO/Compiler lets you automatically convert queries and reports into efficient programs in OS/VS COBOL or COBOL II. This reduces CPU consumption, DB2 catalog contention, DB2 Optimizer overhead, and security concerns as converted programs use static Structured Query Language (SQL) in place of dynamic SQL.

The QMF HPO/Manager consists of a group of functions that improves governing and object management capabilities, including a preemptive governor to analyze QMF queries. The governing capabilities allow you to establish controls that protect valuable resources. Among the many conditions available for governing are:

  • Time of day
  • Day of week
  • Maximum number of rows to fetch
  • Allow/disallow SQL verbs and QMF commands
  • Resource consumption based on the use of QMF commands and SQL statements

If you have DB2 databases of many sizes, QMF for Windows delivers a Windows-based, point-and-click query tool that gives you many benefits, including an intuitive GUI "quick start" user interface and a Java-based query capability. Using QMF for Windows, you can automate tasks and develop powerful native Windows applications. The tool includes a powerful Windows-based API to automate database querying, updating, and report distribution tasks, so you can centralize control over resource consumption. QMF for Windows also gives you support for TCP/IP, static SQL, create and edit QMF forms and procedures, and a full-screen table editor for updating enterprise data.

QMF for Windows can connect to the DB2 family of products including:

  • DB2 UDB for z/OS and OS/390
  • DB2 UDB for IBM e(logo)server iSeries (formerly AS/400)
  • DB2 UDB on UNIX, Windows, and OS/2
  • DB2 for VSE and VM

QMF for Windows connectivity options include SNA, TCP/IP, and CLI.

QMF for OS/390 Enhancements

  • New default Edit codes for current DB2 Date (DD) and Time (TT) format. For QMF V7, these are the new default edit codes for date and time columns. Current QMF Forms default edit codes remain in effect.
  • New SHOW HOME QMF command.
  • Comprehensive command defaults for object type:
    • Commands include CONVERT, EDIT, ERASE, EXPORT, PRINT, RESET, RUN, and SAVE
  • Improved command prompting (better human factors), less typing, defaults preloaded in prompts.
  • Text option in the MSG command is extended — double quotes no longer need to be added when the text of a message has single quotes.
  • New DB2 datatypes:
    • ROWID and LOB datatype support. There are LOB length restrictions for the QMF Table Editor. Refer to the Using QMF manual for more information.
  • Support for DB2 for VSE DRDA RUOW Application Requestor (in CICS®) DB2 for AS/400, Version 4 Release 4, or later, server support.
  • Install improvements:
    • QMF is enabled to bind packages into each supported DB2 server for each supported QMF platform. That is, you can more easily use one QMF install base and simply bind (QMF) on other platforms.

QMF HPO Enhancements

  • Enhanced tracking of QMF objects to support very large numbers of simultaneous QMF users.
  • QMF processes can be preemptively governed based on estimated ASU time.
  • QMF batch processes can now be preemptively governed by QMF HPO/Manager.
  • Programs generated by QMF HPO/Compiler can be bound into packages in addition to or instead of plans.

QMF for Windows Enhancements

  • Ease of Use
    • Point-and-click/drag-and-drop interface to QMF Form creation
      • Aggregation and grouping and formatting performed in the query result
    • Enhanced sorting
      • Sort results of a query on more than one non-contiguous column
    • Enhanced object list window
      • Add Windows tree control for more intuitive navigation and location of QMF objects
    • A personal data portal for your desktop
    • Java-based Query from a browser
    • Human factors enhancements
      • Menu of items displayed with query results
      • More toolbar buttons
    • Option to use DB2 Forms when Table Editor invoked
    • Support for Windows NT password function (remembers password)
    • Database/Connectivity for DB2 OS/390, DRDA, and CLI
      • Support stored procedures that return multiple results sets via the CLI interface
      • Large object support (over CLI and DRDA connections)
      • Enhancements to the server load-balancing algorithm (to support DB2's process of sending back addresses not available for connection)
    • QMF Host Compatibility
      • Procedures with REXX logic (all types of QMF host procedures now supported)
      • Support of Form Detail variations
      • Support of Form Column Definitions
      • Support of RESET GLOBAL command
      • New toolbar/window in which single QMF commands can be entered and executed (analogous to the command line in QMF host)
    • National Languages
      • UNICODE support
      • Arabic BIDI
      • Traditional Chinese
    • CLI Connectivity Enhancements
      • Add CLI-specific information to the Connection Details dialog box, if connecting to the database server via CLI
      • Add CLI tracing to the trace types supported; only valid for CLI connections

For more information on the QMF Family of integrated tools, including a QMF Family demo and a QMF for Windows Try and Buy download, access the QMF Web site at:

QMF Try and Buy in DB2 for OS/390 Version 6: DB2 for OS/390 Version 6 includes trial-use copies of many additional features, including QMF, QMF for Windows, and QMF HPO. These Version 6 "Try" features permit you to explore the value of these features for your business for a limited trial period, after which a permanent use license must be ordered and installed.

QMF, QMF for Windows, and QMF HPO Version 6 have been withdrawn from marketing. Refer to Software Withdrawal 901-231 , dated September 11, 2001. The QMF, QMF for Windows, and QMF HPO Version 7 features are compatible and can be ordered and installed to provide the permanent use licenses.

Note: Customers do not have to install the QMF V6 "Try" feature before installing the QMF V7 product.

Accessibility by People with Disabilities

The following features support use by people with disabilities:

  • Operation by keyboard alone
  • Optional font enlargement and high-contrast display settings
  • Screen readers and screen magnifiers tested for use by people with visual impairment
  • Speech recognition products tested for use by people with mobility impairment
  • Optional display of audio alerts for people with hearing impairment

Euro Currency

These programs are not impacted by euro currency.

Availability of National Languages

Note: The information in this release regarding availability of national language translations pertains only to QMF V7 availability with DB2 UDB for OS/390 Version 6.

Description                                  Countries
 
Availability Date:  September 14, 2001
 
QMF for OS/390
 
Brazilian Portuguese                         Worldwide
English Uppercase (SBCS)                     Worldwide
English U.S. (SBCS)                          Worldwide
Simplified Chinese                           China
Korean                                       Korea
Japanese                                     Japan
 
QMF for Windows
 
 
Brazilian Portuguese                         Worldwide
English U.S. (SBCS)                          Worldwide
Japanese                                     Japan
Korean                                       Korea
Simplified Chinese                           China
Traditional Chinese                          Taiwan

All national languages for QMF for Windows are contained on one CD-ROM. Publications have not been translated for Danish and Swedish. Therefore, ordering one of these languages will result in an English CD-ROM order.

Hardware and Software Support Services

SmoothStart/Installation Services

SmoothStart™ Services are provided for DB2 UDB for OS/390 by IBM Global Services or your IBM Business Partner at an additional cost. For additional information, contact your IBM representative and ask for Installation Services for DB2 UDB for OS/390.

Installation and technical support for the QMF Family are provided for a fee through the following IBM Business Partner:

    Rocket Software, Inc.
    Two Apple Hill Drive
    Natick, MA 01760
    508-655-4321
    email: support@rocketsoftware.com

Trademarks

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

Education Support

A QMF™ for Windows®: End User Workshop (CF800) is available. To obtain the class schedule, call 800-IBM-TEACH (426-8322) or access the Web at:

Use the following Web site to enroll for classes:

QMF for Windows on-site administration and configuration education are provided for a fee from the following IBM Business Partner:

    Rocket Software, Inc.
    Two Apple Hill Drive
    Natick, MA 01760
    508-655-4321
    email: support@rocketsoftware.com

Technical Information

Hardware Requirements

QMF for OS/390®, QMF for Windows, and QMF High Performance Option (HPO) have hardware dependencies as follows:

  • QMF for OS/390 requires a display station supported by GDDM®
  • QMF for Windows requires a workstation that:
    • Is capable of running Windows
    • Supports network connectivity
    • Has available at least 10 MB of disk space
  • QMF HPO requires a display station supported by ISPF

Software Requirements

The following QMF functions have software dependencies:

  • Use of QMF forms calculations requires a Windows 32-bit operating system and IBM Object REXX Interpreter Edition (5639-B73).
  • QMF for Windows and the QMF for Windows Administrator module require a 32-bit Windows operating system. QMF for Windows requires network communication software on each user machine, plus one or both of the following programs:
    • An SNA product that provides a CPI-C interface
    • A TCP/IP product that provides a WinSock Version 1.1 interface

    Use of QMF for Windows with English Wizard natural language query requires English Wizard Release 3.1 from Linguistic Technologies.

Planning Information

Direct Customer Support: Direct customer support is provided by IBM Operational Support Services — Support Line. This fee service can enhance your productivity by providing voice and electronic access into the IBM support organization. IBM Operational Support Services — Support Line will help answer questions pertaining to usage, how to, and suspected software defects for eligible products.

Installation and technical support is provided by IBM Global Services. For more information on services, call 800-IBM-4YOU (426-4968).

Packaging: The DB2® UDB Server for OS/390, except as noted below, will be shipped on 9-track magnetic tapes (written at 6,250 bpi), 3480 cartridges, or 4-mm DAT cartridges.

Also included will be a Program Directory, and under separate cover, one copy of the entitled publications.

The workstation client functions of DB2 Management Tools Package and DB2 Extenders® will be shipped on CD-ROM.

The QMF for Windows product CD-ROM also contains all supported national languages and all U.S. English and translated publications in softcopy format. Two publications are shipped:

  • Getting Started with QMF for Windows
  • Installing and Managing QMF for Windows

Security, Auditability, and Control

The announced program uses the security and auditability features of the host hardware or operating system software. 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

Current Licensees

These features can be ordered as an MES for installed users of DB2 UDB for OS/390, V6 or DB2 UDB for z/OS™ and OS/390, V7. The charge type selected must be the same as the base program; for example, monthly license charge.

New Licensees

Orders for new licenses can be placed now.

Shipment will not occur before availability date.

Unless a later date is specified, orders entered before the planned availability date will be assigned a schedule date of one week following availability.

Shipment will begin on the planned availability date.

New users of DB2 UDB for OS/390, V6 should specify:

Type      Model
 
5645      DB2

New users of DB2 UDB Server for z/OS and OS/390, V7 should specify:

Type      Model
 
5675      DB2

Basic License: To order a basic license, specify the program number and feature number 9001 for asset registration.

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.

Note: To avoid confusion, ESL feature numbers listed below for PID 5675-DB2 (V7) were omitted for QMF for Windows and QMF for OS/390 because they were previously announced.

                              DB2 V6              DB2 V7
                              ESL OTC             ESL OTC
                              Feature             Feature
Description                   Number              Number
 
QMF for OS/390 ESL            0416
QMF for Windows               0480
 (Requires QMF) ESL
QMF for Windows               0448
 (No Requirement) ESL
QMF High Performance          0513                0606
 Option (HPO) ESL

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

Parallel Sysplex® 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, and PSLC Level C, PSLC Level D 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.

Note: To avoid confusion, PSLC feature numbers listed below for PID 5675-DB2 (V7) were omitted for QMF for Windows and QMF for OS/390 because they were previously announced.

QMF for OS/390 Feature (PSLC)

                      DB2
Machine               V6 PSLC           PSLC Basic License
MSU                   Feature           MLC(1) Feature
Capacity              Number            Description
 
 
1                     0400              QMF PSLC Base, 1 MSU
2                     0401              QMF PSLC Base, 2 MSUs
3                     0402              QMF PSLC Base, 3 MSUs
 
4 -- 45               0403              QMF PSLC Level A, 1 MSU
                      0495              QMF PSLC Level A, 42 MSUs
 
46 -- 175             0404              QMF PSLC Level B, 1 MSU
                      0405              QMF PSLC Level B, 10 MSUs
                      0406              QMF PSLC Level B, 50 MSUs
 
176 -- 315            0407              QMF PSLC Level C, 1 MSU
                      0408              QMF PSLC Level C, 10 MSUs
                      0409              QMF PSLC Level C, 50 MSUs
 
316 or more           0410              QMF PSLC Level D, 1 MSU
                      0411              QMF PSLC Level D, 50 MSUs
 
Not applicable        0412              QMF PSLC NC Identifier
1
Monthly license charge

Example 1: For a single machine with 11 MSUs, the PSLC feature numbers would be:

  • 0402 — quantity 1
  • 0403 — quantity 8

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

  • PSLC chargeable license #1:
    • 0402 — quantity 1
    • 0495 — quantity 1
    • 0404 — quantity 5
    • 0405 — quantity 1
  • PSLC no-charge license #2:
    • 0412 — quantity 1

QMF for Windows Feature of QMF (PSLC) (Requires QMF for OS/390)

                      DB2
Machine               V6 PSLC           PSLC Basic License
MSU                   Feature           MLC Feature
Capacity              Number            Description
 
1                     0463              QMFW PSLC Base, 1 MSU
2                     0464              QMFW PSLC Base, 2 MSUs
 
3                     0465              QMFW PSLC Base, 3 MSUs
 
4 -- 45               0466              QMFW PSLC Level A, 1 MSU
                      0467              QMFW PSLC Level A, 42 MSUs
 
46 -- 175             0468              QMFW PSLC Level B, 1 MSU
                      0469              QMFW PSLC Level B, 10 MSUs
                      0470              QMFW PSLC Level B, 50 MSUs
 
176 -- 315            0471              QMFW PSLC Level C, 1 MSU
                      0472              QMFW PSLC Level C, 10 MSUs
                      0473              QMFW PSLC Level C, 50 MSUs
 
316 or more           0474              QMFW PSLC Level D, 1 MSU
                      0475              QMFW PSLC Level D, 50 MSUs
 
Not applicable        0476              QMFW PSLC NC Identifier

Example 1: For a single machine with 11 MSUs, the PSLC feature numbers would be:

  • 0465 — quantity 1
  • 0466 — quantity 8

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

  • PSLC chargeable license #1:
    • 0465 — quantity 1
    • 0467 — quantity 1
    • 0468 — quantity 5
    • 0469 — quantity 1
  • PSLC no-charge license #2:
    • 0476 — quantity 1

QMF for Windows Feature (PSLC) (Without QMF for OS/390 Requirement)

                      DB2
Machine               V6 PSLC           PSLC Basic License
MSU                   Feature           MLC Feature
Capacity              Number            Description
 
1                     0431              QMFW PSLC Base, 1 MSU
2                     0432              QMFW PSLC Base, 2 MSUs
 
3                     0433              QMFW PSLC Base, 3 MSUs
 
4 -- 45               0434              QMFW PSLC Level A, 1 MSU
                      0435              QMFW PSLC Level A, 42 MSUs
 
46 -- 175             0436              QMFW PSLC Level B, 1 MSU
                      0437              QMFW PSLC Level B, 10 MSUs
                      0438              QMFW PSLC Level B, 50 MSUs
 
176 -- 315            0439              QMFW PSLC Level C, 1 MSU
                      0440              QMFW PSLC Level C, 10 MSUs
                      0441              QMFW PSLC Level C, 50 MSUs
 
316 or more           0442              QMFW PSLC Level D, 1 MSU
                      0443              QMFW PSLC Level D, 50 MSUs
 
Not applicable        0444              QMFW PSLC NC Identifier

Example 1: For a single machine with 11 MSUs, the PSLC features would be:

  • 0433 — quantity 1
  • 0434 — quantity 8

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

  • PSLC chargeable license #1:
    • 0433 — quantity 1
    • 0435 — quantity 1
    • 0436 — quantity 5
    • 0437 — quantity 1
  • PSLC no-charge license #2:
    • 0444 — quantity 1

QMF HPO (PSLC)

                 DB2       DB2
                 V6 PSLC   V7 PSLC     PSLC Basic License
Machine          Feature   Feature     MLC Feature
MSU Capacity     Number    Number      Description
 
1                0496      0575        QMF PSLC Base, 1 MSU
2                0497      0576        QMF PSLC Base, 2 MSUs
3                0498      0577        QMF PSLC Base, 3 MSUs
 
4 -- 45          0499      0578        QMF PSLC Level A, 1 MSU
                 0500      0579        QMF PSLC Level A, 42 MSUs
 
46 -- 175        0501      0580        QMF PSLC Level B, 1 MSU
                 0502      0581        QMF PSLC Level B, 10 MSUs
                 0503      0582        QMF PSLC Level B, 50 MSUs
 
176 -- 315       0504      0583        QMF PSLC Level C, 1 MSU
                 0505      0604        QMF PSLC Level C, 10 MSUs
                 0506      0605        QMF PSLC Level C, 50 MSUs
 
316 or more      0507      0586        QMF PSLC Level D, 1 MSU
                 0508      0587        QMF PSLC Level D, 50 MSUs
 
Not applicable   0509      0588        QMF PSLC NC Identifier

Example 1 — V7: For a single machine with 11 MSUs, the PSLC feature numbers would be:

  • 0577 — quantity 1
  • 0578 — quantity 8

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

  • PSLC chargeable license #1:
    • 0577 — quantity 1
    • 0579 — quantity 1
    • 0580 — quantity 5
    • 0581 — quantity 1
  • PSLC no-charge license #2:
    • 0588 — quantity 1

Variable Workload License Charge (WLC) Basic License: To order a basic license, specify the program number and feature number 9001 for asset registration. Specify the WLC Base feature. If applicable, specify the WLC Level 1, WLC Level 2, WLC Level 3, and WLC Level 4 features with the appropriate quantity. Also, specify the feature number of the desired distribution medium.

The Variable WLC requires the use of the IBM License Use Management (LUM) tool.

Variable Workload License Charge (WLC) Aggregation: When z/OS is installed on two or more S/390® or IBM e(logo)server zSeries 900 (z900) machines comprising a sysplex, Variable WLC aggregation applies to z/OS and the S/390 software programs that have Variable WLC.

Whether there is only one license or more than one license of the program in the sysplex, the charge for all licenses is associated to the "aggregation license" by specifying the applicable WLC feature numbers and quantity represented by the sum of the MSUs (millions of service units) in the sysplex. The "aggregation license" is an additional program license that is ordered and serialized, although there is no shipment associated with it.

For the actual licenses, the charge is reflected as $0.00 by specifying the applicable "registration" Variable WLC feature numbers and the quantity equal to the MSUs of that license running on the designated machine.

Note: To avoid confusion, WLC feature numbers listed below for PID 5675-DB2 (V7) were omitted for QMF for Windows and QMF for OS/390 because they were previously announced.

QMF for OS/390 Feature (WLC)

                 DB2
                 V6 WLC    WLC Basic License
                 Feature   MLC Feature
MSU Capacity     Number    Description
 
0 -- 45          0417      VWLC Base, L1: incl 45 MSUs
 
46 -- 175        0418      VWLC Add Qty, L1: 46-175 MSUs
                 0419      WLC Reg Base, L1: incl 1 MSU
                 0420      WLC Reg Add Qty, L1: 46-175 MSUs
 
176 -- 315       0421      VWLC Add Qty, L2: 176-315 MSUs
                 0422      WLC Reg Add Qty, L2: 176-315 MSUs
 
316 -- 575       0423      VWLC Add Qty, L3: 316-575 MSUs
                 0424      WLC Reg Add Qty, L3: 316-575 MSUs
                 0425      L3: per 50 MSUs, 316-575 MSUs
                 0426      L3: Reg per 50 MSUs, 316-575 MSUs
 
576 or more      0427      VWLC Reg Add Qty, L4: 576+ MSUs
                 0428      WLC Reg Add Qty, L4: 576+ MSUs
                 0429      L4: per 50 MSUs, 576+ MSUs
                 0430      L4: Reg per 50 MSUs, 576+ MSUs

Example 1: For a single machine with the program running at 220 MSUs, the Variable WLC features would be:

  • 0417 — quantity 1
  • 0418 — quantity 130
  • 0421 — quantity 45

Example 2: If there are 2 machines in a sysplex, and a program is running on machine #1 at 190 MSUs and on machine #2 at 140 MSUs, the Variable WLC feature numbers and quantities to be ordered would be:

  • License on machine #1 for 190 MSUs:
    • 0419 — quantity 1
    • 0420 — quantity 174
    • 0422 — quantity 15
  • License on machine #2 for 140 MSUs:
    • 0419 — quantity 1
    • 0420 — quantity 139
  • Aggregation license for a total of 330 MSUs:
    • 0417 — quantity 1
    • 0418 — quantity 130
    • 0421 — quantity 140
    • 0423 — quantity 15

QMF for Windows Feature of QMF (WLC) (Requires QMF for OS/390)

                 DB2
                 V6 WLC    WLC Basic License
                 Feature   MLC Feature
MSU Capacity     Number    Description
 
0 -- 45          0481      VWLC Base, L1: incl 45 MSUs
 
46 -- 175        0482      VWLC Add Qty, L1: 46-175 MSUs
                 0483      WLC Reg Base, L1: incl 1 MSU
                 0484      WLC Reg Add Qty, L1: 46-175 MSUs
 
176 -- 315       0485      VWLC Add Qty, L2: 176-315 MSUs
                 0486      WLC Reg Add Qty, L2: 176-315 MSUs
 
316 -- 575       0487      VWLC Add Qty, L3: 316-575 MSUs
                 0488      WLC Reg Add Qty, L3: 316-575 MSUs
                 0489      L3: per 50 MSUs, 316-575 MSUs
                 0490      L3: Reg per 50 MSUs, 316-575 MSUs
 
576 or more      0491      VWLC Reg Add Qty, L4: 576+ MSUs
                 0492      WLC Reg Add Qty, L4: 576+ MSUs
                 0493      L4: per 50 MSUs, 576+ MSUs
                 0494      L4: Reg per 50 MSUs, 576+ MSUs

Example 1: For a single machine with the program running at 220 MSUs, the Variable WLC features would be:

  • 0481 — quantity 1
  • 0482 — quantity 130
  • 0485 — quantity 45

Example 2: If there are 2 machines in a sysplex, and a program is running on machine #1 at 190 MSUs and on machine #2 at 140 MSUs, the Variable WLC feature numbers and quantities to be ordered would be:

  • License on machine #1 for 190 MSUs:
    • 0483 — quantity 1
    • 0484 — quantity 174
    • 0486 — quantity 15
  • License on machine #2 for 140 MSUs:
    • 0483 — quantity 1
    • 0484 — quantity 139
  • Aggregation license for a total of 330 MSUs:
    • 0481 — quantity 1
    • 0482 — quantity 130
    • 0485 — quantity 140
    • 0487 — quantity 15

QMF for Windows Feature (WLC) (Without QMF for OS/390 Requirement)

                 DB2
                 V6 WLC    WLC Basic License
                 Feature   MLC Feature
MSU Capacity     Number    Description
 
0 -- 45          0449      VWLC Base, L1: incl 45 MSUs
 
46 -- 175        0450      VWLC Add Qty, L1: 46-175 MSUs
                 0451      WLC Reg Base, L1: incl 1 MSU
                 0452      WLC Reg Add Qty, L1: 46-175 MSUs
 
176 -- 315       0453      VWLC Add Qty, L2: 176-315 MSUs
                 0454      WLC Reg Add Qty, L2: 176-315 MSUs
 
316 -- 575       0455      VWLC Add Qty, L3: 316-575 MSUs
                 0456      WLC Reg Add Qty, L3: 316-575 MSUs
                 0457      L3: per 50 MSUs, 316-575 MSUs
                 0458      L3: Reg per 50 MSUs, 316-575 MSUs
 
576 or more      0459      VWLC Reg Add Qty, L4: 576+ MSUs
                 0460      WLC Reg Add Qty, L4: 576+ MSUs
                 0461      L4: per 50 MSUs, 576+ MSUs
                 0462      L4: Reg per 50 MSUs, 576+ MSUs

Example 1: For a single machine with the program running at 220 MSUs, the Variable WLC features would be:

  • 0449 — quantity 1
  • 0450 — quantity 130
  • 0453 — quantity 45

Example 2: If there are 2 machines in a sysplex, and a program is running on machine #1 at 190 MSUs and on machine #2 at 140 MSUs, the Variable WLC feature numbers and quantities to be ordered would be:

  • License on machine #1 for 190 MSUs:
    • 0451 — quantity 1
    • 0452 — quantity 174
    • 0454 — quantity 15
  • License on machine #2 for 140 MSUs:
    • 0451 — quantity 1
    • 0452 — quantity 139
  • Aggregation license for a total of 330 MSUs:
    • 0449 — quantity 1
    • 0450 — quantity 130
    • 0453 — quantity 140
    • 0455 — quantity 15

QMF HPO (WLC)

                 DB2       DB2
                 V6 WLC    V7 WLC   WLC Basic License
                 Feature   Feature  MLC Feature
MSU Capacity     Number    Number   Description
 
0 -- 45          0514      0592     VWLC Base, L1: incl 45 MSUs
 
46 -- 175        0515      0593     VWLC Add Qty, L1: 46-175 MSUs
                 0516      0594     WLC Reg Base, L1: incl 1 MSU
                 0517      0155     WLC Reg Add Qty, L1: 46-175 MSUs
 
176 -- 315       0518      0595     VWLC Add Qty, L2: 176-315 MSUs
                 0519      0596     WLC Reg Add Qty, L2: 176-315 MSUs
 
316 -- 575       0520      0597     VWLC Add Qty, L3: 316-575 MSUs
                 0521      0598     WLC Reg Add Qty, L3: 316-575 MSUs
                 0522      0160     L3: per 50 MSUs, 316-575 MSUs
                 0523      0599     L3: Reg per 50 MSUs, 316-575 MSUs
 
576 or more      0524      0600     VWLC Reg Add Qty, L4: 576+ MSUs
                 0525      0601     WLC Reg Add Qty, L4: 576+ MSUs
                 0526      0602     L4: per 50 MSUs, 576+ MSUs
                 0527      0603     L4: Reg per 50 MSUs, 576+ MSUs

Example 1 — V7: For a single machine with the program running at 220 MSUs, the Variable WLC features would be:

  • 0592 — quantity 1
  • 0593 — quantity 130
  • 0595 — quantity 45

Example 2 — V7: If there are 2 machines in a sysplex, and a program is running on Machine #1 at 190 MSUs and on machine #2 at 140 MSUs, the Variable WLC feature numbers and quantities to be ordered would be:

  • License on machine #1 for 190 MSUs:
    • 0594 — quantity 1
    • 0155 — quantity 174
    • 0596 — quantity 15
  • License on machine #2 for 140 MSUs:
    • 0594 — quantity 1
    • 0155 — quantity 139
  • Aggregation license for a total of 330 MSUs:
    • 0592 — quantity 1
    • 0593 — quantity 130
    • 0595 — quantity 140
    • 0597 — quantity 15

Growth Opportunity License Charge (GOLC): To order a GOLC software, specify the program number, feature number 9001 for asset registration, and the GOLC monthly charge feature number from the table below. Also, specify the feature number for the desired distribution medium.

Note: To avoid confusion, GOLC feature numbers listed below for PID 5675-DB2 (V7) were omitted for QMF for Windows and QMF for OS/390 because they were previously announced.

QMF for OS/390

                           DB2
                           V6 GOLC
GOLC                       Feature
Category                   Number
 
QMF GOLC H30               0413
QMF GOLC H50               0414
QMF GOLC H70               0415

QMF for Windows Feature (Requires QMF)

                           DB2
                           V6 GOLC
GOLC                       Feature
Category                   Number
 
QMFW GOLC H30              0477
QMFW GOLC H50              0478
QMFW GOLC H70              0479

QMF for Windows Feature (without Requirement of QMF)

                           DB2
                           V6 GOLC
GOLC                       Feature
Category                   Number
 
QMFW GOLC H30              0445
QMFW GOLC H50              0446
QMFW GOLC H70              0447

QMF HPO

                           DB2          DB2
 
                           V6 GOLC      V7 GOLC
GOLC                       Feature      Feature
Category                   Number       Number
 
QMF GOLC H30               0510         0589
QMF GOLC H50               0511         0590
QMF GOLC H70               0512         0591

Single-Version Charging: To elect single-version charging, the customer must notify and identify to IBM the prior program and replacement program and the designated machine the programs are operating on.

Basic Machine-Readable Material

                           9/6250     3480         4-mm
Feature Description        Tape       Cartridge    DAT       CD-ROM
 
5645-DB2
 
QMF HPO                    6100       6101         6102
 
5675-DB2
 
QMF HPO                    6191       6189         6190

NLS Features: The QMF NLS features will be available on the same date as the release code. The NLS features are as follows:

                           9/6250     3480         4-mm
Feature Description        Tape       Cartridge    DAT       CD-ROM
 
5645-DB2
 
QMF for OS/390
  English Upper Case       6015       6013         6014
    (SBCS)
  English US U/L           6018       6016         6017
    (SBCS)
  Japanese -- Kanji        6036       6034         6035
    (DBCS)
  Brazilian Portuguese     6042       6040         6041
 
QMF for Windows
  (Requires QMF)
    English -- US U/L                                        6073
      (SBCS)
    Japanese -- Kanji                                        6081
      (DBCS)
    Brazilian Portuguese                                     6083
 
QMF for Windows
  (Without QMF
  Requirement)
    English -- US U/L                                        6053
      (SBCS)
    Japanese -- Kanji                                        6061
      (DBCS)
    Brazilian Portuguese                                     6063

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)
 
Satellite Electronic Delivery                       3450
 
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 Delivery and Fulfillment (SDF) receives the order. SDF will then ship the order via overnight air transportation.

Unlicensed Documentation: A memo, program directory, and one copy of the following publications are supplied automatically with the basic machine-readable material when the QMF for OS/390 optional feature is ordered:

                                                  Order
Title                                             Number
 
QMF for OS/390, Version 7
 
Installing and Managing QMF                       GC27-0719
  on OS/390
QMF Messages and Codes                            GC27-0717
QMF High Performance Option User's                SC27-0724
   Guide for OS/390
Getting Started with QMF for Windows              SC27-0723
Installing and Managing QMF                       GC27-0722
    for Windows

The following optional publications are available:

                                                  Order
Title                                             Number
 
QMF for OS/390, Version 7
 
Introducing QMF                                   GC27-0714
QMF Reference                                     SC27-0715
Using QMF                                         SC27-0716
Developing QMF Applications                       SC27-0718

Additional copies of unlicensed publications are available and may be ordered via direct order or you may contact your IBM representative.

Displayable Softcopy Publications: DB2 UDB Server for OS/390 publications are offered in displayable softcopy form. All unlicensed manuals are included. The displayable manuals are part of the basic machine-readable material. The files are shipped on CD-ROM.

These displayable manuals can be used with the BookManager® READ licensed programs in any of the supported environments. Terms and conditions for use of the machine-readable files are shipped with the files.

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 are available:

                                 Order
Title                            Number           Language
 
DB2 Universal Database(R) for OS/390, Version 7
 
Introducing QMF                  GC12-2858        German
QMF Reference                    SC12-2849        German
Using QMF                        SC12-2850        German
Installing and Managing          GC12-2859        German
 
  QMF for Windows
Getting Started with             SC12-2847        German
  QMF for Windows
 
Introducing QMF                  GC88-8618        Japan (DBCS)
QMF Reference                    SC88-8619        Japan (DBCS)
Using QMF                        SC88-8620        Japan (DBCS)
QMF Messages and                 GC88-8621        Japan (DBCS)
  Codes
Developing QMF                   SC88-8622        Japan (DBCS)
  Applications
Installing and Managing          GC88-8623        Japan (DBCS)
  QMF for OS/390
Installing and Managing          GC88-8669        Japan (DBCS)
  QMF for Windows
Getting Started with             SC88-8670        Japan (DBCS)
  QMF for Windows
 
Installing and Managing          GC40-0530        Traditional
  QMF for Windows                                   Chinese
Getting Started with             SC40-0531        Traditional
  QMF for Windows                                   Chinese
 
Installing and Managing          SB84-0252        Simplified
  QMF for Windows                                   Chinese
Getting Started with             SB84-0253        Simplified
  QMF for Windows                                   Chinese
 
Introducing QMF                  GC10-3530        Spanish
QMF Reference                    SC10-3531        Spanish
Using QMF                        SC10-3532        Spanish
Getting Started with             SC10-3533        Spanish
  QMF for Windows
 
Introducing QMF                  S517-6997        Brazilian
                                                    Portuguese
QMF Reference                    S517-6998        Brazilian
                                                    Portuguese
Using QMF                        S517-6999        Brazilian
                                                    Portuguese
Getting Started with             S517-7008        Brazilian
  QMF for Windows                                   Portuguese
 
Getting Started with             SB20-2151        Egyptian
  QMF for Windows
 
Introducing QMF                  GA30-1047        Korean
QMF Reference                    SA30-1048        Korean
Using QMF                        SA30-1049        Korean
QMF Messages and                 GA30-1050        Korean
  Codes
Developing QMF                   SA30-1051        Korean
  Applications
Getting Started with             SA30-1046        Korean
  QMF for Windows
 
Introducing QMF                  GC11-1685        French
Using QMF                        SC11-1687        French
Getting Started with             SC11-1694        French
  QMF for Windows
 
Introducing QMF                  GC13-2904        Italian
QMF Reference                    SC13-2905        Italian
Using QMF                        SC13-2906        Italian
Getting Started with             SC13-2907        Italian
  QMF for Windows
 
Getting Started with             SC17-5378        Portuguese
  QMF for Windows

Customized Offerings

Most product media is shipped only via Customized Offerings (for example, CBPDO, ServerPac, Systempac®). Non-customized items (CDs, diskettes, source media, media kits) will continue to be shipped via the stand-alone product.

Terms and Conditions

The terms for DB2 UDB, previously announced:

  • 5645-DB2 — DB2 UDB for OS/390 Version 6 (refer to Software Announcement 299-154 , dated June 15, 1999)
  • 5675-DB2 — DB2 UDB for z/OS and OS/390 Version 7 (refer to Software Announcement 201-054 , dated March 6, 2001)

licensed under the IBM Customer Agreement, are unaffected by this announcement.

Prices

Contact your IBM representative for charges information for this announcement.

Order Now

 Use Priority/Reference Code: LE001
 
 Phone:     800-IBM-CALL
 Fax:       800-2IBM-FAX
 Internet:  ibm_direct@vnet.ibm.com
 Mail:      IBM Atlanta Sales Center
            Dept. LE001
            P.O. Box 2690
            Atlanta, GA  30301-2690

You can also contact your local IBM Business Partner or IBM representative. To identify them, call 800-IBM-4YOU.

Note: Shipments will begin after the planned availability date.

Trademarks

 
zSeries is a trademark of International Business Machines Corporation.
 
The e-business logo, QMF, and z/OS are trademarks of International Business Machines Corporation and is used under license by IBM Canada Ltd.
 
OS/390, GDDM, DB2, DB2 Extenders, Parallel Sysplex, S/390, BookManager, DB2 Universal Database, and Systempac are registered trademarks of International Business Machines Corporation in the United States or other countries or both.
 
Windows is a registered trademark of Microsoft Corporation.
 
Other company, product, and service names may be trademarks or service marks of others.