IBM Db2 Query Management Facility for z/OS, V12.2 delivers a new TSO Client and QMF Server to enhance cross-QMF client interoperability, provide additional data access, and improve cost-effectiveness
IBM United States Software Announcement 218-221May 15, 2018
Table of contents | ||||||||||||||||||||||||
|
Revised Description section.
At a glance
IBM® Db2® Query Management Facility for z/OS® is a comprehensive business analytics solution that provides interactive dashboards, graphical reports, self-service BI, batch reports, and analytics through web, workstation, and mobile interfaces. It supports most structured and unstructured data sources, and is optimized for IBM Z® sources such as IBM Db2 for z/OS and Virtual Storage Access Method (VSAM).
New in version 12.2:
- A TSO Client and QMF Server to enhance cross-QMF client interoperability, provide additional data access, and improve cost-effectiveness
- Self-service BI capabilities with augmented analytics and visualizations
- Support for more data types and programs
Overview
IBM Db2 Query Management Facility (QMF) for z/OS, V12.2 offers significant performance improvements:
- The new QMF Server interconnects objects created across all QMF clients, making any QMF object accessible from any QMF client, regardless of which client created the object. It also improves cost-effectiveness, as the processing of the queries are zIIP eligible, including TSO and batch queries. The new QMF Server runs on IBM z/OS, Linux®, or Microsoft Windows.
- The new QMF Z Client delivers significant usability and productivity additions to give TSO users a user experience that has a more modern look and feel. Multiple queries can be opened, with seamless toggle between them, and a new QMF Home Panel.
- The self-service BI capabilities are enhanced with augmented analytics and visualization that help users discover, analyze, and make decisions on data in a collaborative and intuitive environment.
Key prerequisites
Db2 QMF operates on any IBM Z hardware configuration that supports the required software. See the Hardware requirements and Software requirements sections for details.
Planned availability date
June 15, 2018
See the Availability of national languages section for national language availability.
Description
TSO client helps deliver CPU savings
A new TSO client gives users the ability to deliver CPU savings as work submitted from this new TSO interface is zIIP eligible. This is of significant importance as the zIIP eligibility may extend to batch workloads, procedures, and ad hoc queries, which makes the new TSO interface an important method of minimizing costs as workload increases.
The TSO client offers usability and productivity features designed to help QMF users edit and administer QMF objects such as intuitive list filtering and simultaneous multiple object editing. It also offers the ability to seamlessly share objects created in the new client across the other QMF clients (TSO, web, workstation, and Vision) without the need for client-specific configuration or tuning.
Common centralized server connects the entire QMF ecosystem
QMF introduces a common centralized server to connect the entire QMF ecosystem, simplify installation and configuration, and help you leverage your data and queries. The QMF Server is written in Java and architected to exploit the advantages delivered by IBM Z for Java workloads.
The new TSO client is referred to as the QMF Z Client and delivers significant productivity improvements to QMF TSO users, including major improvements for working with QMF objects and integration with the wider QMF ecosystem. A new, customizable home panel provides instant access to your favorite and recently used QMF objects and recent commands. When listing objects, you can quickly and easily filter and sort the list, add an object to your favorites, and filter to objects modified within a number of days, months, and so on, all interactively and while supporting screen sizes up to 98 x 160.
You can now have multiple QMF objects open and easily switch between them, including between multiple edit windows using the improved built-in Query and Procedure Editor. Mouse support, along with right-click context-sensitive menus and drop-down menus, helps both the experienced and novice user to complete tasks in less time. QMF Workstation and IBM WebSphere® objects previously limited to distributed platform users can now be used by your TSO users, enabling QMF objects to be shared across all UIs and the ability to build QMF objects once and use them anywhere.
Common QMF Server: Key benefits
- The QMF Server runs on zIIP engines, making MSU savings and improved performance possible.
- The server can be deployed on z/OS, Linux, UNIX®, and Windows. This gives QMF users the ability to individually choose the best platform deployment option for the QMF Server, QMF clients, and QMF workloads.
- Users can choose to put the QMF Server close to the data to reduce the load on the network and improve performance.
- Multiple QMF Servers are supported to bring the execution closer to the data. For example, if you need to query data on Db2 on the Linux platform and data on IBM Db2 for z/OS, you could set up a QMF Server on the z/OS platform for the Db2 for z/OS queries and one on the Linux platform for Db2 queries. QMF will route the work to the QMF Server you chose, improving performance.
- Direct database support to relational data sources using JDBC on IBM Z or distributed platforms. This is in addition to existing data source access using the QMF Data Service, which can access relational and nonrelational data sources.
- One instance of the QMF Server can handle multiple user components: TSO, Workstation, Web, and Vision. This eliminates the need to set up servers for each of the specific QMF components.
- Mainframe users can create, access, and reuse the newer QMF objects, such as Visual Queries and JavaScript procedures.
- Simple and consistent setup for all users, both mainframe and distributed.
- JavaScript is now supported for QMF procedures.
- To experience the benefits of the new QMF Server, batch jobs need to be updated to run under the new QMF Server.
New QMF TSO user experience: Key benefits
- Productivity and usability improvements for TSO users:
- New Home Panel provides instant access to your favorite and recently used QMF objects and commands.
- Major improvements for listing and editing your QMF objects.
- Easily switch between open QMF objects and actions.
- Mouse support with right-click, context-sensitive menus and drop-down menus.
- Seamless integration with QMF Workstation and WebSphere and the broader QMF ecosystem.
- Share QMF objects across all UIs: build it once, use it anywhere.
- Do QMF tasks in less time, including tasks previously not possible.
The Self-Service BI capabilities of the QMF Vision component are enhanced with new automatic dashboarding, JSON support, and multi-tenancy.
QMF Vision key highlights:
- Automatic dashboarding capabilities that are driven by analytics, which can be used as a starting point in discovery, analysis, and decision-making processes.
- Expands platform support to Linux.
- Dashboard publishing that can enable embedding in web pages.
- Support for Network Relationship diagram/chart.
- Support for annotations on dashboards.
- Support for JSON format data sources.
- Support for QMF-prompted queries.
- Simplified adding of multiple data sources to a dashboard.
Section 508 of the US Rehabilitation Act
The product in this announcement is capable as of June 15, 2018, when used in accordance with IBM's associated documentation, of satisfying the applicable requirements of Section 508 of the Rehabilitation Act, provided that any assistive technology used with the product properly interoperates with it. A US Section 508 Voluntary Product Accessibility Template (VPAT) can be found on the Product accessibility information website.
Value Unit-based pricing
Value Unit pricing for eligible IBM z Systems® IBM International Program License Agreement (IPLA) programs enables a lower cost of incremental growth and enterprise aggregation. Each z Systems® IPLA product with Value Unit pricing has a single price per Value Unit and a conversion matrix, called Value Unit Exhibit, for converting from some designated measurement to Value Units. Most commonly, Millions of Service Units (MSUs) is the measurement designated by IBM to be converted to Value Units. Some other measurements are engines or messages. Since MSUs are the most common measurement, that measurement will be used for the remainder of this description.
Value Unit pricing offers price benefits for you. For each z Systems IPLA program with Value Unit pricing, the quantity of that program needed to satisfy applicable IBM terms and conditions is referred to as the required license capacity. Each of the various Value Unit Exhibits stipulate that the larger your required license capacity, the fewer Value Units per MSU you will need. Value Unit Exhibits are uniquely identified by a three digit code and referred to using the nomenclature VUExxx, where xxx is the three digit code.
Subsequent acquisitions of Value Unit priced programs offer additional price benefits. The quantity of each z Systems IPLA program that you have acquired is referred to as entitled license capacity. If you wish to grow your entitled license capacity for a z Systems IPLA program, the calculation to determine additional needed Value Units is based upon the number of Value Units already acquired.
For each z Systems IPLA program with Value Unit pricing, you should:
- Determine the required license capacity, in MSUs.
- Aggregate the MSUs across the enterprise.
- Convert the total MSUs to Value Units, using the applicable Value Unit Exhibit.
- Multiply the price per Value Unit by the total number of Value Units to determine the total cost.
To simplify conversion from the designated measurement to Value Units or vice versa, use the Value Unit Converter Tool. For additional information or to obtain a copy of the Value Unit Converter Tool, visit the Value Unit Converter Tool, go to the IBM System z® Software Pricing website.
Note that Value Units of a given product cannot be exchanged, interchanged, or aggregated with Value Units of another product.
To determine the required license capacity for the z Systems IPLA program you selected, see the Terms and conditions section.
Availability of national languages
Translation information, if available, can be found at the Translation Reports website.
Program number
Program number | VRM | Program name |
---|---|---|
5697-QM2 | 12.2.0 | IBM Db2 Query Management Facility for z/OS |
Product identification number
Program number | Subscription and Support PID number |
---|---|
5697-QM2 | 5697-QSS |
Offering Information
Product information is available on the IBM Offering Information website.
Business Partner information
If you are a Direct Reseller - System Reseller acquiring products from IBM, you may link directly to Business Partner information for this announcement. A PartnerWorld® ID and password are required (use IBMid).
Publications
The following publications are shipped with the product.
Title | Order number |
---|---|
Db2 Query Management Facility for z/OS, V12.2 | |
License Information | GC27-9105 |
Program Directory (US English) | GI13-4645 |
Program Directory (Multilanguage) | GI13-4646 |
Program Directory - Z Client (US English and MUL) | GI13-5004 |
Accessing QMF distributed components on Linux, Unix and Windows CD | LCD4-8602 |
The Query Management Facility for z/OS, V12.2 distributed components are not provided on physical media. The source files and ISO images are available to licensed customers for download from the IBM Web Membership (IWM) site. See the Memo to Users on the Accessing QMF distributed components on IWM CD for more information.
The following publications cannot be ordered in hardcopy. These publications are available on the Db2 Query Management Facility Library page.
Title | Order number |
---|---|
Db2 Query Management Facility for z/OS, V12.2 | |
Introducing Db2 QMF | GC27-8876 |
Installing and Managing Db2 QMF for TSO and CICS® | GC27-8877 |
Developing Db2 QMF applications | SC27-8878 |
Db2 QMF Reference | SC27-8880 |
Db2 QMF Messages and Codes | GC27-8881 |
Using Db2 QMF | SC27-8879 |
QMF High Performance Option User's Guide for TSO and CICS | SC27-8882 |
Installing and Managing QMF for Workstation and QMF for WebSphere® | GC27-8883 |
Getting Started with QMF for Workstation and QMF for WebSphere | SC27-8884 |
Getting Started with QMF Vision | GC27-8889 |
Db2 QMF Data Service Getting Started Guide | GC27-8885 |
Db2 QMF Data Service Studio User's Guide | SC27-8886 |
Db2 QMF Data Service Customization Guide | GC27-8888 |
Db2 QMF Data Service Solution Guide | GC27-8887 |
Getting Started with QMF Z Client | GC27-9133 |
Installing and Managing Db2 QMF Server | GC27-9134 |
Services
Software Services
IBM Software Services has the breadth, depth, and reach to manage your services needs. You can leverage the deep technical skills of our lab-based, software services team and the business consulting, project management, and infrastructure expertise of our IBM Global Services team. Also, we extend our IBM Software Services reach through IBM Business Partners to provide an extensive portfolio of capabilities. Together, we provide the global reach, intellectual capital, industry insight, and technology leadership to support a wide range of critical business needs.
To learn more about IBM Software Services, contact your Lab Services Sales or Delivery Leader.
Technical information
Specified operating environment
Hardware requirements
There are eight installation entities across QMF for z/OS.
QMF Server requirements:
- A minimum of one zIIP
QMF Z Client, QMF TSO, and CICS client requirements:
- Operates on any Z hardware configuration that supports the required software.
- Runs on any processor that is supported by the operating system. Some operations, however, will not work with columns that contain decimal floating point data if the processor on which QMF is running does not support decimal floating point instructions.
- Accesses all of the DASD devices that are supported by z/OS and Db2 for z/OS, as well as all display devices supported by Graphical Data Display Manager (GDDM).
- To implement a national language feature that uses a double-byte character set (DBCS), you need a workstation that supports DBCS. Ensure that this device is supported by GDDM. For the amount of storage required to copy the QMF V12.1 libraries from the distribution media using SMP/E, see the QMF program directory that is appropriate for your QMF edition and national language.
- When you plan your region size, consider the storage required to load modules during initialization and the virtual storage requirements for report operations.
- Restriction: For TSO only, consider the amount of space required to run applications other than Db2 QMF.
Db2 QMF for Workstation requires:
- A hardware configuration that supports the Windows operating system
- Network connectivity
- Minimum of 1 GB disk space and 1 GB of RAM
Db2 QMF for WebSphere requires:
- Hardware configuration that supports the Windows or Linux operating systems
- Minimum of 500 MB disk space
- Minimum of 1 GB of RAM on each server in which it is installed and an additional 50 MB of RAM for each concurrent user
Db2 QMF Vision requires:
- Hardware configuration that supports the Windows software
- Minimum of 250 GB disk space and 8 GB of RAM
- 4-core microprocessor
Db2 QMF Data Service requires:
- Any Z hardware configuration that supports the required software
- Any processor that is supported by the operating system
Db2 QMF Data Service Studio requires:
- Any hardware configuration that supports the required Windows software
- Approximately 1 GB of disk space (single language installation)
- Minimum of 1 GB of RAM
- Network connectivity
Software requirements
Mandatory installation requisites
TSO and CICS clients require z/OS, V2.1 (5650-ZOS), or later, and one of the following Db2 for z/OS releases:
- Db2 for z/OS, V11 (5615- DB2®)
- Db2 for z/OS Value Unit Edition V11 (5697-P43)
- Db2 for z/OS, V12 (5650-DB2)
- Db2 for z/OS Value Unit Edition V12 (5770-AF3)
QMF for Workstation requires one of the following operating systems:
- Windows 7
- Windows 8 .1
- Windows Server 2008
- Windows Server 2012
- Windows 10
QMF for WebSphere requires:
- One of the following application web servers:
- IBM WebSphere Application Server V8.5.5 or V9.0 configured to use Java 8
- Apache Tomcat 8, 8.5, or 9 configured to use Java 8
QMF Server Web Deployment requires:
- One of the following application web servers:
- WebSphere Application Server V8.5.5 or V9.0 configured to use Java 8
- Apache Tomcat 8, 8.5, or 9 configured to use Java 8
QMF Server Standalone requires:
- Any operating system that supports Java 8
- Java SE 8
QMF Vision V12.1 installation entity requires:
- One of the following operating systems:
- Windows 7 64-bit, Windows Server 2008 R2 Service Pack 1, or Windows Server 2012 with .NET Framework 3.5 enabled
- One of the following browsers:
- Chrome version 50.0.2661.102, or later
- Firefox version 47.0.1, or later
- Microsoft Edge version 25.10586.0.0, or later
- Safari version 9.0.3, or later
Db2 QMF Data Service V12.1 installation entity requires one of the following:
- IBM zEnterprise® 114 (z114), IBM zEnterprise 196 (z196), or more recent zEnterprise system
- z/OS V2.1 (5650-ZOS), or later
Data Service load library
- The load library for Data Service is allocated as a partitioned data set extended (PDSE). When a PDSE is used to store load modules, it stores them in structures called program objects.
- You cannot copy a PDSE to a partitioned data set (PDS). For more information, see the z/OS documentation.
Program Temporary Fixes (PTFs)
- When you use VSAM data access with Data Service, you need to add the following PTFs:
- RLS OA44111:
- z/OS V1.13 UA75045
- z/OS V2.1 UA75046
- VSAM:
- z/OS V1.13 UA75272
- RLS OA44111:
Db2 QMF Data Service Studio V12.1 installation entity requires one of the following operating systems:
- Windows 7
- Windows 8.1
- Windows Server 2012
- Windows Server 2008
- Windows 10
QMF Z Client requires the following:
- z/OS 2.1, or later
- IBM Graphical Data Display Manager (GDDM)
Mandatory operational requisites
TSO and CICS clients of QMF V12.1 operate with any of the following:
- DB2 for z/OS, V10 (5605-DB2) (all modes except CM8, CM8, ENFM8, ENFM8) with APARs PM50434 and PM72274
- DB2 for z/OS Value Unit Edition, V10 (5697-P31) (all modes except CM8, CM8, ENFM8, ENFM8) with APARs PM50434 and PM72274
- Db2 for z/OS, V11 (5615- DB2)
- Db2 for z/OS Value Unit Edition, V11 (5697-P43)
- Db2 for z/OS, V12 (5650-DB2)
- Db2 for z/OS Value Unit Edition, V12 (5770-AF3)
In addition:
- For advanced graphical capabilities of the QMF Analytics for TSO client, GDDM-PGF, a component in z/OS, is required.
- Db2 QMF for TSO and CICS running under CICS require CICS Transaction Server for z/OS.
- QMF Vision requires MongoDB 3.x, or later, to be installed. This is done when the optional QMF Vision component is selected during the QMF installation and you are asked to download/install Mongo during this part of the QMF installation.
The program's specifications and specified operating environment information may be found in documentation accompanying the program, if available, such as a readme file, or other information published by IBM, such as an announcement letter. Documentation and other program content may be supplied only in the English language.
Planning information
Packaging
The programs in this announcement are distributed with the following content:
- Basic machine-readable material
- Program Directory
- IBM International Program License Agreement (IPLA)
- IBM Agreement for Acquisition of Software Maintenance (IAASM)
Ordering information
Consult your IBM representative.
The programs in this announcement all have Value Unit-Based pricing.
Program number | Program name | Value Unit exhibit |
---|---|---|
5697-QM2 | IBM Db2 Query Management Facility for z/OS | VUE001 |
For each Z IPLA program with Value Unit pricing, the quantity of that program needed to satisfy applicable IBM terms and conditions is referred to as the required license capacity. Your required license capacity is based upon the following factors:
- The Z IPLA program you select.
- The applicable Value Unit Exhibit.
- The applicable terms.
- Whether your current mainframes are full capacity or subcapacity.
Level | Minimum | Maximum | Value Units/MSU |
---|---|---|---|
Base | 1 | 3 | 5.25 |
Tier A | 4 | 45 | 0.83 |
Tier B | 46 | 175 | 0.35 |
Tier C | 176 | 315 | 0.26 |
Tier D | 316 | + | 0.20 |
Ordering z/OS through the internet
Shopz provides an easy way to plan and order your z/OS ServerPac or CBPDO. It will analyze your current installation, determine the correct product migration, and present your new configuration based on z/OS. Additional products can also be added to your order (including determination of whether all product requisites are satisfied). For more details and availability, go to the Shopz website.
The products in this announcement have one charge unit - Value Units.
MSUs | Value Units/MSU | |
---|---|---|
Base | 1-3 | 5.25 |
Tier A | 4-45 | .83 |
Tier B | 46-175 | .35 |
Tier C | 176-315 | .26 |
Tier D | 316+ | .20 |
Note: For the actual translation from MSUs to Value Units for this product, see the table that follows.
Ordering example:
The total number of Value Units is calculated according to the following example.
If the client has installed 1,000 MSUs, the applicable Value Units would be:
MSUs | * | Value Units/MSU | = | Value Units | |
---|---|---|---|---|---|
Base | 3 | * | 5.25 | = | 15.75 |
Tier A | 42 | * | .83 | = | 34.86 |
Tier B | 130 | * | .35 | = | 45.50 |
Tier C | 140 | * | .26 | = | 36.40 |
Tier D | 685 | * | .20 | = | 137 |
Total | 1,000 | 270 |
When calculating the total number of Value Units, the total is to be rounded up to the next integer.
Value Units for non-MSU-based S/390® processors using VUE001:
Model | Value Units per machine |
---|---|
H30 | 21.00 |
H50 | 22.00 |
H70 | 26.00 |
ESL models | 9 |
Charge metric
Program name | Part number or PID number | Charge metric |
---|---|---|
IBM Db2 Query Management Facility for z/OS | 5697-QM2 | Value Unit |
Basic license
Db2 Query Management Facility for z/OS, V12.2 is eligible for On/Off CoD with a temporary use charge calculated based on MSUs per-day usage.
Translation from MSUs to Value Units
MSUs | Value Units/MSU | |
---|---|---|
Base | 1-3 | 5.25 |
Tier A | 4-45 | 0.83 |
Tier B | 46-175 | 0.35 |
Tier C | 176-315 | 0.26 |
Tier D | 316 or greater | 0.20 |
To order, specify the program product number and the appropriate license or charge option. Also, specify the desired distribution medium. To suppress shipment of media, select the license-only option in CFSW.
Program name: IBM Db2 Query Management Facility for z/OS
Program PID: 5697-QM2
Entitlement identifier | Description | License option/Pricing metric |
---|---|---|
S018016 | Db2 QMF for z/OS, V12.2 | Multi-Version Measurement No Charge Value Units |
Basic OTC, Per Value Unit | ||
Basic OTC, Per MSU-day TUC |
Orderable supply ID | Language | Distribution medium |
---|---|---|
S018019 | US English | 3590 Tape cartridge |
S01801B | Multilanguage | 3590 Tape cartridge |
Subscription and Support PID: 5697-QSS
Entitlement identifier | Description | License option/Pricing metric |
---|---|---|
S017M8V | Db2 QMF for z/OS S&S | Basic ASC, Per Value Unit SW S&S |
No charge, decline SW S&S | ||
Multi-Version Measurement S&S No Charge | ||
Per MSU SW S&S registration |
Orderable supply ID | Language | Distribution medium |
---|---|---|
S017M8T | US English | Hardcopy publication |
To receive voice technical support via telephone and future releases and versions at no additional charge, Subscription and Support must be ordered. The capacity of Subscription and Support (Value Units) must be the same as the capacity ordered for the product licenses.
To order, specify the Subscription and Support program number (PID) referenced above and the appropriate license or charge option.
IBM is also providing Subscription and Support for these products via a separately purchased offering under the terms of the IBM International Agreement for Acquisition of Software Maintenance. This offering:
- Includes and extends the support services provided in the base support to include technical support via telephone.
- Entitles you to future releases and versions, at no additional charge. Note that you are not entitled to new products.
When Subscription and Support is ordered, the charges will automatically renew annually unless canceled by you.
The combined effect of the IPLA license and the Agreement for Acquisition of Software Maintenance gives you rights and support services comparable to those under the traditional ICA S/390® and z Systems license or its equivalent. To ensure that you continue to enjoy the level of support you are used to in the ICA business model, you must order both the license for the program and the support for the selected programs at the same Value Unit quantities.
Customized Offerings
Product deliverables are shipped only through CBPDO and ServerPac. These customized offerings are offered for internet delivery in countries where Shopz product ordering is available. Internet delivery reduces software delivery time and allows you to install software without the need to handle tapes. For more details on Internet delivery, go to the Help section on the Shopz website.
You choose the delivery method when you order the software. IBM recommends internet delivery. In addition to internet and DVD, the supported tape delivery options include:
- 3590
- 3592
Most products can be ordered in ServerPac the month following their availability in CBPDO. z/OS can be ordered through CBPDO and ServerPac at general availability. Many products will also be orderable in a Product ServerPac without also having to order the z/OS operating system or subsystem.
Shopz and CFSW will determine the eligibility based on product requisite checking. For more details on the product ServerPac, go to the Help section on the Shopz website.
For additional information about the Product ServerPac option, see Software Announcement 212-272, dated July 31, 2012.
Production of software product orders will begin on the planned general availability date.
- CBPDO shipments will begin one week after general availability.
- ServerPac shipments will begin four weeks after general availability.
Terms and conditions
The information provided in this announcement letter is for reference and convenience purposes only. The terms and conditions that govern any transaction with IBM are contained in the applicable contract documents such as the IBM International Program License Agreement, IBM International Passport Advantage® Agreement, and the IBM Agreement for Acquisition of Software Maintenance.
Licensing
IBM International Program License Agreement including the License Information document and Proof of Entitlement (PoE) govern your use of the program. PoEs are required for all authorized use.
Software Maintenance
The following agreement applies for Software Subscription and Support (Software Maintenance) and does not require client signatures:
- IBM Agreement for Acquisition of Software Maintenance (Z125-6011)
These programs are licensed under the IBM Program License Agreement (IPLA) and the associated Agreement for Acquisition of Software Maintenance, which provide for support with ongoing access to releases and versions of the program. These programs have a one-time license charge for use of the program and an annual renewable charge for the enhanced support that includes telephone assistance (voice support for defects during normal business hours), as well as access to updates, releases, and versions of the program as long as support is in effect. IBM z Systems Operational Support Services - SoftwareXcel is an option if you desire added services.
License Information number
GC27-9105
See the License Information documents page on the IBM Software License Agreement website for more information.
Limited warranty applies
Yes
Limited warranty
IBM warrants that when the program is used in the specified operating environment, it will conform to its specifications. The warranty applies only to the unmodified portion of the program. IBM does not warrant uninterrupted or error-free operation of the program or that IBM will correct all program defects. You are responsible for the results obtained from the use of the program.
IBM provides you with access to IBM databases containing information on known program defects, defect corrections, restrictions, and bypasses at no additional charge. For further information, see the IBM Software Support Handbook.
IBM will maintain this information for at least one year after the original licensee acquires the program (warranty period).
Money-back guarantee
If for any reason you are dissatisfied with the program and you are the original licensee, you may obtain a refund of the amount you paid for it, if within 30 days of your invoice date you return the program and its PoE to the party from whom you obtained it. If you downloaded the program, you may contact the party from whom you acquired it for instructions on how to obtain the refund.
For clarification, note that for programs acquired under any of IBM's On/Off Capacity on Demand (On/Off CoD) software offerings, this term does not apply since these offerings apply to programs already acquired and in use by you.
Volume orders (IVO)
No
Passport Advantage applies
No
Software Subscription and Support applies
Yes. During the Software Subscription and Support period, for the unmodified portion of a program, and to the extent problems can be recreated in the specified operating environment, IBM will provide the following:
- Defect correction information, a restriction, or a bypass.
- Program updates: Periodic releases of collections of code corrections, fixes, functional enhancements and new versions and releases to the program and documentation.
- Technical assistance: A reasonable amount of remote assistance by telephone or electronically to address suspected program defects. Technical assistance is available from the IBM support center in the organization's geography.
Additional details regarding Technical Assistance, which includes IBM contact information, are provided in the IBM Software Support Handbook.
Software Subscription and Support does not include assistance for:
- The design and development of applications.
- Your use of programs in other than their specified operating environment.
- Failures caused by products for which IBM is not responsible under the IBM Agreement for Acquisition of Software Maintenance.
Software Subscription and Support is provided only if the program is within its support timeframe as specified in the Software Support Lifecycle policy for the program.
For operating system software, the revised IBM Operational Support Services - SoftwareXcel offering will provide support for those operating systems and associated products that are not available with the Software Subscription and Support (Software Maintenance) offering.
This will ensure total support coverage for your enterprise needs, including IBM and selected non-IBM products. For complete lists of products supported under both the current and revised offering, go to the Supported product list website.
IBM Operational Support Services - SoftwareXcel
Yes
Variable charges apply
No
Educational allowance available
Yes. A 15% education allowance applies to qualified education institution clients.
Multi-Version Measurement
Multi-Version Measurement (MVM) replaces the previously announced Migration Grace Period time limit of six months and allows unlimited time for clients to run more than one eligible version of a software program. Clients may run multiple versions of a program simultaneously for an unlimited duration during a program version upgrade. Clients may also choose to run multiple versions of a program simultaneously for an unlimited duration in a production environment. MVM does not extend support dates for programs withdrawn from service.
For more information about MVM, including requirements for qualification, see the MVM web page. For a list of eligible programs, see the IPLA Execution-Based web page.
Sub-capacity terms and conditions
For each z Systems IPLA program with Value Unit pricing, the quantity of that program needed to satisfy applicable IBM terms and conditions is referred to as the required license capacity. Your required license capacity is based upon the following factors:
- The z Systems IPLA program you select.
- The applicable Value Unit Exhibit.
- The applicable terms.
- Whether your current mainframes are full capacity or sub-capacity.
For more information on the Value Unit Exhibit for the z Systems IPLA program you selected, see the Ordering information section.
Program number | Program name | Terms | Parent, if applicable |
---|---|---|---|
5697-QM2 | IBM Db2 Query Management Facility for z/OS | Reference-based | Db2 for z/OS, V12 (5650-DB2) |
Db2 for z/OS Value Unit Edition, V12 (5770-AF3) | |||
Db2 for z/OS, V11 (5615-DB2) | |||
Db2 for z/OS Value Unit Edition, V11 (5697-P43) |
Full-capacity mainframes
In cases where full capacity is applicable, the following terms apply.
Execution based, z/OS based, full machine based: The required capacity of a z Systems IPLA program with these terms equals the MSU-rated capacity of the machines where the z Systems IPLA program executes.
For more information on mainframe MSU-rated capacities, go to the IBM System z Software Contracts website.
Reference based: The required license capacity of a z Systems IPLA program with these terms equals the license capacity of the applicable monthly license charge (MLC) program. This MLC program is called the parent program.
Sub-capacity mainframes
In cases where sub-capacity is applicable, the following terms apply.
Execution based: The required capacity of a z Systems IPLA sub-capacity program with these terms equals the capacity of the LPARs where the z Systems IPLA program executes.
z/OS based: The required license capacity of a z Systems IPLA program with these terms equals the license capacity of z/OS on the machines where the z Systems IPLA program executes.
Reference based: The required license capacity of a z Systems IPLA program with these terms equals the license capacity of the applicable monthly license charge (MLC) program. This MLC program is called the parent program.
Full machine based: The required license capacity of a z Systems IPLA program with full machine based terms equals the MSU-rated capacity of the machines where the z Systems IPLA program executes.
For more information on mainframe MSU-rated capacities, see The IBM z Systems Machines Exhibit, Z125-3901, or see the Mainframes section of the z Systems Exhibits website.
For additional information for products with reference-based terms, z Systems IPLA sub-capacity programs with reference-based terms adds value to the parent program across the environment, regardless of where in the environment the z Systems IPLA program executes.
An environment is defined as either a single or stand-alone machine or a qualified Parallel Sysplex®. You may have one or more different environments across the enterprise. To determine the required license capacity for each z Systems IPLA program with referenced-based terms, each environment should be assessed separately.
When a z Systems IPLA sub-capacity program with reference-based terms is used in a qualified Parallel Sysplex environment, the required license capacity of the z Systems IPLA program must equal with the license capacity of the parent program across the Parallel Sysplex. Qualified Parallel Sysplex refers to one:
- Where MLC pricing is aggregated across the sysplex.
Sub-capacity eligibility
To be eligible for sub-capacity charging on select z Systems IPLA programs, you must first implement and comply with all terms of either sub-capacity Workload License Charges (WLC) or sub-capacity Entry Workload License Charges (EWLC). To implement sub-capacity WLC or EWLC, a machine must be z Systems (or equivalent). On that machine:
- All instances of the OS/390® operating system must be migrated to the z/OS operating systems.
- Any licenses for the OS/390 operating system must be discontinued.
- All instances of the z/OS operating systems must be running in z/Architecture® (64-bit) mode.
For that machine, you must create and submit a Sub-Capacity Report to IBM each month. Sub-Capacity Reports must be generated using the Sub-Capacity Reporting Tool (SCRT). For additional information or to obtain a copy of SCRT, go to the IBM System z Software Pricing website.
You must comply with all of the terms of the WLC or EWLC offering, whichever is applicable:
- The complete terms and conditions of sub-capacity WLC are defined in the IBM Customer Agreement - Attachment for z Systems Workload License Charges (Z125-6516).
- The complete terms and conditions for sub-capacity EWLC are defined in the IBM Customer Agreement - Attachment for EWLC, TWLC, zELC, and z/OS.e License Charges (Z125-6587).
Additionally, you must sign and comply with the terms and conditions specified in the amendment to the IPLA contract - Amendment for Amendment for IBM z Systems Programs Sub-Capacity Pricing (Z125-6929). Once the amendment is signed, the terms in the amendment replace any and all previous z Systems IPLA sub-capacity terms and conditions.
Sub-capacity utilization determination
Sub-capacity utilization is determined based on the utilization of a sub-capacity eligible reference product and machine.
On/Off CoD
To be eligible for On/Off CoD pricing, you must be enabled for temporary capacity on the corresponding hardware, and the required contract, Attachment for IBM z Systems On/Off Capacity on Demand (Z125-7883) must be signed prior to use.
Statement of good security practices
IT system security involves protecting systems and information through intrusion prevention, detection, and response to improper access from within and outside your enterprise. Improper access can result in information being altered, destroyed, or misappropriated or can result in misuse of your systems to attack others. Without a comprehensive approach to security, no IT system or product should be considered completely secure and no single product or security measure can be completely effective in preventing improper access. IBM systems and products are designed to be part of a regulatory compliant, comprehensive security approach, which will necessarily involve additional operational procedures, and may require other systems, products, or services to be most effective.
Important: IBM does not warrant that any systems, products, or services are immune from, or will make your enterprise immune from, the malicious or illegal conduct of any party.
Prices
For additional information and current prices, contact your local IBM representative.
Registered external clients and IBM Business Partners can access IBMLink to view pricing information.
Specify "Price type," "Search type," and "Search value," then click "Search."
Note: Enter the program number in the "Search value."
You can also contact your local IBM representative or IBM Business Partner for the applicable charges.
IBM Global Financing
IBM Global Financing offers competitive financing to credit-qualified clients to assist them in acquiring IT solutions. Offerings include financing for IT acquisition, including hardware, software, and services, from both IBM and other manufacturers or vendors. Offerings (for all client segments: small, medium, and large enterprise), rates, terms, and availability can vary by country. Contact your local IBM Global Financing organization or go to the IBM Global Financing website for more information.
IBM Global Financing offerings are provided through IBM Credit LLC in the United States, and other IBM subsidiaries and divisions worldwide to qualified commercial and government clients. Rates are based on a client's credit rating, financing terms, offering type, equipment type, and options, and may vary by country. Other restrictions may apply. Rates and offerings are subject to change, extension, or withdrawal without notice.
Financing from IBM Global Financing helps you preserve cash and credit lines, enables more technology acquisition within current budget limits, can help accelerate implementation of economically attractive new technologies, offers payment and term flexibility, and can help match project costs to projected benefits. Financing is available worldwide for credit-qualified clients.
Order now
To order, contact the IBM Digital Sales Center, your local IBM representative, or your IBM Business Partner. To identify your local IBM representative or IBM Business Partner, call 800-IBM-4YOU (426-4968). For more information, contact the IBM Digital Sales Center.
Phone: 800-IBM-CALL (426-2255)
Fax: 800-2IBM-FAX (242-6329)
For IBM representative: askibm@ca.ibm.com
For IBM Business Partner: pwcs@us.ibm.com
IBM Digital Sales Offices
1177 S Belt Line Rd
Coppell, TX 75019-4642, US
The IBM Digital Sales Center, our national direct marketing organization, can add your name to the mailing list for catalogs of IBM products.
Note: Shipments will begin after the planned availability date.
Trademarks
Query Management Facility and QMF are trademarks of IBM Corporation in the United States, other countries, or both.
IBM, Db2, z/OS, IBM Z, z Systems, PartnerWorld, Passport Advantage, WebSphere, IBM z Systems, System z, CICS, DB2, zEnterprise, S/390, Parallel Sysplex, OS/390 and z/Architecture are registered trademarks of IBM Corporation in the United States, other countries, or both.
Linux is a registered trademark of Linus Torvalds in the United States, other countries, or both.
Microsoft and Windows are trademarks of Microsoft Corporation in the United States, other countries, or both.
Oracle and Java are trademarks of Oracle and/or its affiliates in the United States, other countries, or both.
UNIX is a registered trademark of The Open Group in the United States and other countries.
Other company, product, and service names may be trademarks or service marks of others.
Terms of use
IBM products and services which are announced and available in your country can be ordered under the applicable standard agreements, terms, conditions, and prices in effect at the time. IBM reserves the right to modify or withdraw this announcement at any time without notice. This announcement is provided for your information only. Additional terms of use are located at
For the most current information regarding IBM products, consult your IBM representative or reseller, or go to the IBM worldwide contacts page