IBM DB2 QMF 11 Classic Edition and IBM DB2 QMF 11 Enterprise Edition features added to IBM DB2 10 for z/OS

IBM Europe, Middle East, and Africa Software Announcement ZP14-0183
May 6, 2014

Table of contents
 Overview Overview  Technical information Technical information
 Key prerequisites Key prerequisites  Ordering information Ordering information
 Planned availability date Planned availability date  Terms and conditions Terms and conditions
 Description Description  Prices Prices
 Program number Program number  Announcement countries Announcement countries


Top rule
At a glance
Bottom rule

IBM® DB2® QMF™ 11 Classic Edition and IBM DB2 QMF 11 Enterprise Edition priced optional features are added to IBM DB2 10 for z/OS®. DB2 10 for z/OS features now include DB2 QMF 11 Classic Edition and DB2 QMF 11 Enterprise Edition as well as DB2 QMF 10 Classic Edition and DB2 QMF 10 Enterprise Edition.



Back to topBack to top
 
Top rule
Overview
Bottom rule

IBM DB2 QMF 11 Classic Edition and IBM DB2 QMF 11 Enterprise Edition priced optional features are added to IBM DB2 10 for z/OS.

DB2 QMF 11 enables access to queries, reports, or dashboards through an ordinary web browser or mobile devices. This simplifies your ability to improve the customer experience and achieve business advantage.

DB2 QMF 11 delivers enhanced analysis, forecasting, reporting, and presentation capabilities, as well as improved storage management. It can help users manage data, find answers, and communicate those decisions.



Back to topBack to top
 
Top rule
Key prerequisites
Bottom rule

DB2 QMF 11 features operate on z10™, or later, processors running one of the following:



Back to topBack to top
 
Top rule
Planned availability date
Bottom rule

May 30, 2014



Back to topBack to top
 
Top rule
Description
Bottom rule

IBM DB2 QMF 11 Classic Edition and IBM DB2 QMF 11 Enterprise Edition priced optional features are added to IBM DB2 10 for z/OS.

The DB2 QMF 11 Classic Edition feature enables users working entirely on traditional mainframe terminals and emulators (including IBM Host On Demand) to access DB2 databases.

DB2 QMF 11 Classic Edition includes IBM DB2 QMF for TSO and CICS®, which supports business users and technical staff from a traditional mainframe terminal and offers fast, efficient access to DB2 for z/OS. QMF for TSO and CICS is an easy-to-use, menu-driven query, reporting, and graphics (requires GDDM/PGF) interface with extensive help facilities. It can run interactively or in batch. QMF objects are stored in a catalog for reuse and shared usage. QMF objects can be combined into a procedure for repetitive use as well. QMF is an enterprise business analytics solution. It can take advantage of other host functions and features such as REXX or DB2 Stored Procedures.

The DB2 QMF 11 Enterprise Edition feature includes the entire DB2 QMF family of products, enabling enterprise-wide business information across end-user and database platforms. DB2 QMF Enterprise Edition consists of these components:

Features for each product in the QMF family are as follows:

QMF for TSO and CICS offers the following features and benefits:

QMF Analytics for TSO delivers additional charting and statistical analysis capabilities directly to the mainframe. These capabilities have long been available in QMF for Workstation and QMF for WebSphere and are now available to QMF TSO users as well. QMF Analytics for TSO adds significant analysis capabilities for users with an existing TSO-based workflow or where data needs to be kept within the security of the z/OS environment. QMF Analytics for TSO is included as part of QMF 11 Enterprise Edition. It includes the following features and benefits:

In QMF High Performance Option:

In QMF for Workstation and QMF for WebSphere :

For more information, refer to DB2 11 for z/OS Software Announcement ZP13-0503, dated October 1, 2013.

Accessibility by people with disabilities

A US Section 508 Voluntary Product Accessibility Template (VPAT) containing details on accessibility compliance can be requested at

http://www.ibm.com/able/product_accessibility/index.html


Back to topBack to top
 
Top rule
Hardware and software support services
Bottom rule

SmoothStart/installation services

IBM SmoothStart and Installation Services are offered in conjunction with general availability of this product.



Back to topBack to top
 
Top rule
Availability of national languages
Bottom rule



 
Description           Availability date  Language

DB2 QMF 11 Classic    May 30, 2014       English
Edition, feature
of DB2 10 for z/OS
 
DB2 QMF 11            May 30, 2014       English
Enterprise Edition,
feature of DB2 10
for z/OS
 



Back to topBack to top
 
Top rule
Program number
Bottom rule

Program             Program
number              name

5605-DB2            IBM DB2 QMF 11 Classic Edition,
                    feature of IBM DB2 10 for z/OS

5605-DB2            IBM DB2 QMF 11 Enterprise Edition,
                    feature of IBM DB2 10 for z/OS


Back to topBack to top
 
Top rule
Education support
Bottom rule

IBM is committed to helping our clients achieve the skills and expertise to take their careers to the next level. We offer a comprehensive portfolio of technical training and education services designed for individuals, companies and public organizations to acquire, maintain and optimize their IT skills in IBM Software and IBM systems.

Please view more information about our training offerings at

http://www.ibm.com/training

IBM Professional Certification:

Information Management Professional Certification is a business solution for skilled IT professionals to demonstrate their expertise to the world. Certification validates skills and demonstrates proficiency with the most recent IBM technology and solutions.

For information about IBM's Professional Certification Program, see

http://www.ibm.com/certify

IBM Redbooks® :

IBM Redbooks offer deep technical insight from IBM and industry experts. These books highlight real-time experiences, and include sample code, typical scenarios, and step-by-step, "how-to" guidelines.

 
IBM Form No.       Title

SG24-7892          DB2 10 for z/OS Technical Overview
 

For additional Redbooks, visit

http://www.redbooks.ibm.com/

Contact your IBM representative for course information.



Back to topBack to top
 
Top rule
Technical information
Bottom rule

Specified operating environment

Hardware requirements

Processors: Function-dependent hardware requirements for QMF features

QMF runs on any processor that is supported by the operating system. However, some operations 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.

QMF can access 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 Version 11 libraries from the distribution media using SMP/E, refer to 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 QMF.

QMF for Workstation/WebSphere V11 installation platforms supported:

QMF for Workstation requires:

QMF for WebSphere requires:

Software requirements

The QMF 11 Classic Edition feature includes DB2 QMF for TSO and CICS.

The QMF 11 Enterprise Edition feature includes the following components:

For the QMF 11 version, the following releases of DB2 are supported:

All other operating requirements for QMF Version 11 can be found at

http://www-01.ibm.com/support/docview.wss?uid=swg27039374

Note: For DB2 QMF Analytics for TSO, GDDM-PGF, a component in z/OS, is required, for advanced graphical capabilities on TSO. Refer to the website above for other requirements of DB2 QMF Analytics for TSO and QMF for TSO and CICS.

Planning information

Customer responsibilities

Review the sections in this announcement that describe the hardware and software dependencies for DB2 QMF 11 Classic Edition and DB2 QMF 11 Enterprise Edition.

Packaging

Included with each optional feature is a Program Directory and other media, such as CD-ROM, as applicable:

DB2 QMF 11 Classic Edition (English)

                                       Order
Title                                  number

DB2 QMF 11 Classic Edition with
DB2 10 for z/OS: Program Directory     GI10-8991

DB2 QMF 11 Classic Edition (Multilingual)

                                       Order
Title                                  number

DB2 QMF 11 Classic Edition with
DB2 10 for z/OS: Program Directory     GI10-8992

DB2 QMF 11 Enterprise Edition (English)

                                       Order  
Title                                  number

 DB2 QMF 11 Enterprise Edition with
 DB2 10 for z/OS: Program Directory    GI10-8993

DB2 QMF 11 Enterprise Edition (Multilingual)

                                       Order
 Title                                 number

 DB2 QMF 11 Enterprise Edition with
 DB2 10 for z/OS: Program Directory    GI10-8994

Security, auditability, and control

DB2 10 for z/OS uses the security and auditability features of the host z/OS systems. It also provides facilities for the protection and control of its resources. These facilities include controls for

The customer is responsible for evaluation, selection, and implementation of security features, administrative procedures, and appropriate controls in application systems and communication facilities.



Back to topBack to top
 
Top rule
Ordering information
Bottom rule

Ordering z/OS through the Internet

ShopzSeries 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). ShopzSeries is available in the US, Canada, and several countries in Europe. In countries where ShopzSeries is not available yet, contact your IBM representative (or IBM Business Partner) to handle your order via the traditional IBM ordering process. For more details and availability, visit the ShopzSeries Website at

http://www14.software.ibm.com/webapp/ShopzSeries/ShopzSeries.jsp

The CBPDO order activation date is May 27, 2014.

Current® licensees

This feature can be ordered as an MES for installed users of DB2 10 for z/OS. The charge type selected must be the same as the base program; for example, one-time charge, monthly license charge, and graduated one-time charge.

New licensees

Orders for new licenses can be placed now.

Registered customers can access IBMLink for ordering information and charges.

Shipment will not occur before the 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.

New users of DB2 10 for z/OS should specify:

        Type: 5605       Model: DB2

For complete ordering information for IBM DB2 10 for z/OS refer to Software Announcement ZP10-0486, dated October 19, 2010.

Parallel Sysplex® license charge (PSLC) basic license

To order a basic license, specify the program number and quantity of MSU.

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 license options and quantity represented by the sum of the Service Units in Millions (MSUs) in your Parallel Sysplex. For all other program copies, specify the System Usage Registration No-Charge (SYSUSGREG NC) Identifier on the licenses.

Program name: DB2 10 for z/OS

Program PID: 5605-DB2

Entitlement                               License option/
identifier        Description             Pricing metric

S017HFV           QMF 11 Classic Edition  Basic MLC, PSLC(ABCD)
S017HFT           QMF 11 Enterprise       Basic MLC, PSLC(ABCD)
                  Edition
Advanced Workload License Charges (AWLC) basic license

To order a basic license, specify the program number and quantity of MSUs. 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 AWLC license options and quantity represented by the sum of the Service Units in Millions (MSUs) in your Parallel Sysplex. For all other program copies, specify the System Usage Registration No-Charge (SYSUSGREG NC) Identifier on the licenses.

Program name: DB2 10 for z/OS
 
Program PID:  5605-DB2
 
Entitlement                               License option/
identifier       Description              Pricing metric

 S017HFV           QMF 11 Classic Edition  Basic MLC, AWLC
 S017HFT           QMF 11 Enterprise       Basic MLC, AWLC
                   Edition
Advanced Entry Workload License Charges (AEWLC) basic license

The AEWLC pricing metric leverages the reporting mechanisms and existing Millions of Service Units per hour (MSU) tiers of the Entry Workload License Charges (EWLC) pricing metric while extending the software price/performance provided by EWLC and MWLC. For details, refer to Software Announcement ZP11-0311, dated July 12, 2011.

To order a basic license, specify the program number and quantity of MSUs.

Program name: DB2 10 for z/OS
 
Program PID:  5605-DB2
 
Entitlement                                  License option /
identifier        Description                pricing metric

S017HFV           QMF 11 Classic Edition     Basic MLC, AEWLC
S017HFT           QMF 11 Enterprise          Basic MLC, AEWLC
                   Edition
Workload License Charge (WLC) Basic License

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 WLC license options and quantity represented by the sum of the Service Units in Millions (MSUs) in your Parallel Sysplex. For all other program copies, specify the Workload Registration Variable WLC Identifier on the licenses.

Program name: DB2 10 for z/OS

Program PID: 5605-DB2

Entitlement                                 License option/
identifier        Description               Pricing metric

S017HFV           QMF 11 Classic Edition    Basic MLC, VWLC
S017HFT           QMF 11 Enterprise         Basic MLC, VWLC
                   Edition
Entry Workload License Charge (EWLC) Basic License

To order a basic license, specify the program number and the quantity of MSUs.

Entitlement                                 License option/
identifier        Description               Pricing metric

S017HFV           QMF 11 Classic Edition    Basic MLC, EWLC
                  Edition
S017HFT           QMF 11 Enterprise         Basic MLC, EWLC
                  Edition
System z® entry license charge (zELC)

To order zELC software, specify the program number and the corresponding machine capacity setting. zELC is available on the IBM zEnterprise® 114 and the IBM zEnterprise BC12 capacity setting A01.

Program name: DB2 10 for z/OS

Program PID: 5605-DB2

Specify the zELC monthly license option.

 
Entitlement                                 License option/
identifier        Description               Pricing metric

S017HFV           QMF 11 Classic Edition    Basic MLC, zELC
S017HFT           QMF 11 Enterprise         Basic MLC, zELC
                   Edition
 

Specify the zELC monthly charge feature number. Also, specify the feature number for the desired distribution medium.

Basic machine-readable material
 
Orderable
Supply ID: Language      Distribution medium  Description

S017HFN    US English    3590 Tape Cartridge  QMF 11 Classic Edition
S017HFP    Multilingual  3590 Tape Cartridge  QMF 11 Classic Edition
S017HFR    US English    3590 Tape Cartridge  QMF 11 Enterprise Edition
S017HFS    Multilingual  3590 Tape Cartridge  QMF 11 Enterprise Edition
 
Publications

A program directory is shipped with the basic machine-readable material.

The following publications are shipped with DB2 QMF 11 Classic Edition, feature of DB2 10 for z/OS

                                        Order
Title                                   number

DB2 QMF 11 Classic Edition with DB2     GI10-8991
10 for z/OS Program Directory, US
English
DB2 QMF Classic Edition with DB2        GI10-8992
10 for z/OS Program Directory,
Multilingual

The following publications are shipped with DB2 QMF 11 Enterprise Edition feature of DB2 10 for z/OS.

                                        Order
Title                                   number

QMF Enterprise Edition V11 with DB2     GI10-8993
10 for z/OS Program Directory,
English
QMF Enterprise Edition V11 with DB2     GI10-8994
10 for z/OS Program Directory,
Multilingual
KKIT Collection: DB2 QMF for            LK5T-8888
Workstation/WebSphere V11 Kit
 KKIT Component: DB2 QMF for            LCD4-8498
 Workstation/WebSphere V11 Mac
 KKIT Component: DB2 QMF for            LCD4-8496
 Workstation/WebSphere V11 Windows
 KKIT Component: DB2 QMF for            LCD4-8497
 Workstation/WebSphere V11 Linux

The following QMF publications are delivered in softcopy only.

                                                            Order
Title                                                       number

DB2 QMF High Performance Option
   Users Guide for TSO and CICS                             SC19-3993
Installing and Managing DB2 QMF
   for Workstation and DB2 QMF
   for WebSphere                                            GC19-3994
Getting Started with DB2 QMF
   for Workstation and DB2 QMF
   for WebSphere                                            SC19-3995
Developing DB2 QMF Applications                             SC19-3996
Installing and Managing DB2 QMF
   for TSO and CICS                                         GC19-3997
Introducing DB2 QMF                                         GC19-3998
DB2 QMF Messages and Codes                                  GC19-3999
DB2 QMF Reference                                           SC19-4000
Using DB2 QMF                                               SC19-4001

DB2 10 product information, except the licensed documentation, is viewable from the Information Management Software for z/OS Solutions Information Center at

http://pic.dhe.ibm.com/infocenter/dzichelp/v2r2/index.jsp
Licensed documentation

The following licensed materials are available only to customers with a DB2 10 license. The licensed material can be ordered through the IBM Publications Center. In addition, the Diagnosis Guide and Reference is shipped in a DB2 data set that is updated during post general availability maintenance updates. (DSNA10.SDSNIVPD data set member DSNDR. FTP the data set to the workstation and open it with Adobe™ Acrobat Reader.)

                                         Order
Title                                    number
 
DB2 10 for z/OS
Diagnosis Guide and Reference            LY37-3220

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.

Customized offerings

Product deliverables are shipped only via CBPDO, ServerPac, SystemPac.

CBPDO and ServerPac are offered for Internet delivery in countries where ShopzSeries 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, refer to the ShopzSeries help information at

http://www.software.ibm.com/ShopzSeries

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 for CBPDO, ServerPac, SystemPac include:

Most products can be ordered in ServerPac and SystemPac the month following their availability on CBPDO. z/OS can be ordered via all three offerings at general availability. Production of software product orders will begin on the planned general availability date.

Global Technology Services®

Contact your IBM representative for the list of selected services available in your country, either as standard or customized offerings for the efficient installation, implementation, and integration of this product.



Back to topBack to top
 
Top rule
Terms and conditions
Bottom rule

The terms for DB2 10 for z/OS, as previously announced in Software Announcement ZP10-0486, dated October 19, 2010, licensed under the IBM Customer Agreement are unaffected by this announcement.



Back to topBack to top
 
Top rule
IBM Electronic Services
Bottom rule

Electronic Service Agent™ and the IBM Electronic Support web portal are dedicated to providing fast, exceptional support to IBM Systems customers. The IBM Electronic Service Agent tool is a no-additional-charge tool that proactively monitors and reports hardware events, such as system errors, performance issues, and inventory. The Electronic Service Agent tool can help you stay focused on your company's strategic business initiatives, save time, and spend less effort managing day-to-day IT maintenance issues. Servers enabled with this tool can be monitored remotely around the clock by IBM Support, all at no additional cost to you.

Now integrated into the base operating system of AIX® V5.3, AIX V6.1, and AIX V7.1, Electronic Service Agent is designed to automatically and electronically report system failures and utilization issues to IBM, which can result in faster problem resolution and increased availability. System configuration and inventory information collected by the Electronic Service Agent tool also can be viewed on the secure Electronic Support web portal, and used to improve problem determination and resolution by you and the IBM support team. To access the tool main menu, simply type smitty esa_main, and select Configure Electronic Service Agent. In addition, ESA now includes a powerful web user interface, giving the administrator easy access to status, tool settings, problem information, and filters. For more information and documentation on how to configure and use Electronic Service Agent, refer to

http://www.ibm.com/support/electronic

The IBM Electronic Support portal is a single Internet entry point that replaces the multiple entry points traditionally used to access IBM Internet services and support. This portal enables you to gain easier access to IBM resources for assistance in resolving technical problems. The My Systems and Premium Search functions make it even easier for Electronic Service Agent tool-enabled customers to track system inventory and find pertinent fixes.

Benefits

Increased uptime: The Electronic Service Agent tool is designed to enhance the Warranty or Maintenance Agreement by providing faster hardware error reporting and uploading system information to IBM Support. This can translate to less wasted time monitoring the symptoms, diagnosing the error, and manually calling IBM Support to open a problem record. Its 24x7 monitoring and reporting mean no more dependence on human intervention or off-hours customer personnel when errors are encountered in the middle of the night.

Security: The Electronic Service Agent tool is designed to be secure in monitoring, reporting, and storing the data at IBM. The Electronic Service Agent tool securely transmits via either the Internet (HTTPS or VPN) or modem, and can be configured to communicate securely through gateways to provide you a single point of exit from your site. Communication is one way. Activating Electronic Service Agent does not enable IBM to call into your system. System inventory information is stored in a secure database, which is protected behind IBM firewalls. It is viewable only by you and IBM. Your business applications or business data is never transmitted to IBM.

More accurate reporting: Because system information and error logs are automatically uploaded to the IBM Support Center in conjunction with the service request, you are not required to find and send system information, decreasing the risk of misreported or misdiagnosed errors. Once inside IBM, problem error data is run through a data knowledge management system and knowledge articles are appended to the problem record.

Customized support: Using the IBM ID entered during activation, you can view system and support information in the My Systems and Premium Search sections of the Electronic Support website at

http://www.ibm.com/support/electronic

My Systems provides valuable reports of installed hardware and software using information collected from the systems by Electronic Service Agent. Reports are available for any system associated with your IBM ID. Premium Search combines the function of search and the value of Electronic Service Agent information, providing advanced search of the technical support knowledgebase. Using Premium search and the Electronic Service Agent information that has been collected from your system, you are able to see search results that apply specifically to your systems.

For more information on how to utilize the power of IBM Electronic Services, contact your IBM Systems Services Representative, or visit

http://www.ibm.com/support/electronic


Back to topBack to top
 
Top rule
Prices
Bottom rule

Sub-capacity charges for WLC products

Sub-capacity charges for WLC products are based on product LPAR utilization capacity. Product LPAR utilization capacity for a WLC product is the highest number of MSUs utilized by the combined LPARs in which a WLC product runs concurrently during a reporting period. The number of MSUs is based on the highest observed rolling 4-hour average utilization used by the combination of the relevant LPARs during the reporting period.

Sub-capacity charges terms and conditions

System z software charges at less than full machine capacity for eligible WLC products apply when z/OS is running in z/Architecture® (64-bit) mode on an IBM System z server, no other MVS-based operating system is licensed to that server, and the required information is provided by the customer in accordance with the applicable terms.

Sub-capacity charges for a WLC product is based on the utilization of the LPARs where/when the product executes. To obtain charges at less than full machine capacity for WLC products, the customer is required to:

For all local charges, contact your IBM representative.



Back to topBack to top
 
Top rule
Announcement countries
Bottom rule

All European, Middle Eastern, and African countries except Iran, Sudan, and Syria.

Trademarks

QMF, z10 and Electronic Service Agent are trademarks of IBM Corporation in the United States, other countries, or both.

IBM, DB2, z/OS, CICS, WebSphere, Redbooks, GDDM, Current, Parallel Sysplex, System z, zEnterprise, Global Technology Services, AIX and z/Architecture are registered trademarks of IBM Corporation in the United States, other countries, or both.

Microsoft and Windows are trademarks of Microsoft 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.

Adobe is a trademark of Adobe Systems Incorporated in the United States, and/or 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. Reference to other products in this announcement does not necessarily imply those products are announced, or intend to be announced, in your country. Additional terms of use are located at:

http://www.ibm.com/legal/us/en/

For the most current information regarding IBM products, consult your IBM representative or reseller, or visit the IBM worldwide contacts page

http://www.ibm.com/planetwide/

Contact IBM

Feedback