IBM DB2 Analytics Accelerator for z/OS , V2.1 enables a new class of business intelligence and data warehousing workloads for the IBM System z platformIBM United States Software Announcement 211-454
October 12, 2011
|Table of contents|
(Corrected on January 26, 2012)The Overview and Hardware requirements sections are revised.
|At a glance|
DB2® Analytics Accelerator for z/OS®, V2.1 offers fast and predictable query response times on unpredictable query workloads.
- Includes a design that can help lower overall operating costs by reducing database tuning efforts and off-loading query workload to a platform optimized for price and performance
- Delivers significant improvement in the performance of analytic queries on existing IBM® data systems
- Capitalizes on data in existing systems
For ordering, contact your IBM representative, an IBM Business Partner, or IBM Americas Call Centers at 800-IBM-CALL (Reference: LE001).
Back to top
DB2 Analytics Accelerator for z/OS, V2.1, together with related, prerequisite hardware, is a high performance, software offering that is part of an integrated hardware/software solution designed to work with IBM System z® to deliver dramatically faster analytic query responses transparently to users. It integrates into DB2 9 for z/OS or DB2 10 for z/OS data warehouse environments, forming, along with the prerequisite hardware, a high-performance analytic query appliance that is powered by Netezza® technology. The total solution is an integration of IBM hardware, software, storage and advanced technologies focused on business analytics that combine to give IBM clients a high performance analytic capability, to extract business insight from information assets, to help users provide the right answers to the right questions at the right time. It extends System z qualities of service of manageability, security, and availability to analytic applications, working seamlessly with the prerequisite IBM hardware.
DB2 Analytics Accelerator for z/OS, V2.1 when combined with the Netezza technology using DB2 for z/OS (the "Solution") provides:
- Extreme performance for complex business analysis
- Helps deliver analytic information to decision makers faster through breakthrough technologies.
- Helps enable decision makers to perform business analysis to help analyze trends, better predict outcomes, and help produce better business results.
- Database performance appliance
- The DB2 Analytics Accelerator for z/OS, V2.1, with the related, prerequisite hardware, is a database performance appliance, providing high speed query performance coupled with the ease of installation of an appliance.
- DB2 Analytics Accelerator for z/OS, V2.1 software is integrated with the Netezza technology to make it easy to get the software up and running on the Netezza hardware.
- Capitalizes on the hardware and software accelerators in the Netezza hardware, dramatically accelerating DB2 query responses.
- Helps substantially reduce operational costs by removing the need for complex query tuning.
- Allows for rapid addition of new applications which can help drive greater business value.
- Reduces costs by leveraging the price/performance of multiple system technologies combined into an integrated and optimized IBM solution.
- Demonstrated operational characteristics
- Extends the qualities of service in security and availability of System z, enabling operational business analytics to deliver analytics to key business processes by extending the attributes of DB2 into the Netezza data.
- Leverages the solid leading edge technologies of the Smart Analytics Optimizer V1 with the Netezza technology to create the next evolution of DB2 query acceleration - the new DB2 Analytics Accelerator for z/OS 1 v2.1.
The DB2 Analytics Accelerator for z/OS V 2.1, when pared with the prerequisite hardware, offers a query accelerator solution that consists of:
- New IBM software -- DB2 Analytics Accelerator for z/OS, V2.1.
This software is built from these major parts:
- DB2 Analytics Accelerator - server kit. This software runs on the IBM Netezza 1000 technology.
- DB2 Analytics Accelerator - stored procedures. These are stored procedures for loading and managing the data from the System z environment.
- DB2 Analytics Accelerator Studio. This client resident, Eclipse-based GUI is used by database administrators for data mart definitions and other administration tasks.
- An IBM System Netezza 1000 - Providing a combination of massively parallel processing with hardware I/O accelerators.
The total DB2 Analytics Accelerator Solution is designed to help mitigate database administration costs while speeding up the performance of typical data warehouse or OLAP-specific workloads by an order-of-magnitude when compared to traditional database only access. The DB2 Analytics Accelerator Solution uses the DB2 optimizer to direct queries to an optimal environment for execution. It does this without requiring any modification to the DB2 applications.
The DB2 Analytics Accelerator for DB2 for z/OS V2 can only be is only used in conjunction with the prerequisite products (refer to Key prerequisites, Hardware requirements, and Software requirements) as an integrated solution.
Back to top
Back to top
|Planned availability date|
November 25, 2011
Back to top
DB2 Analytics Accelerator for z/OS addresses the following customer challenges:
- Long-running queries with unpredictable response time that do not allow for ad hoc processing
- Need for top database administrator (DBA) expertise to tune the database management system (DBMS) system, with increasingly inadequate results, due to the ad hoc, unpredictable nature of the data warehouse and business intelligence requests
- Escalating and uncontrollable costs with existing systems infrastructure
- The need to migrate data to another platform to achieve train-of-thought analysis of large complex data stores
DB2 Analytics Accelerator provides:
- Faster query response times on unpredictable and long-running query workloads
- Lower operating costs by reducing database tuning efforts
- Improved performance at a lower overall cost by offloading query workload to price/performance-optimized platform
To accomplish these results, the DB2 Analytics Accelerator solution does not always require changes in the BI/DW application or the application framework because DB2 remains the query engine and will offload the specific query to the accelerator. Thus, due to the transparent integration with DB2 data server, changes are not always required to existing business applications. The implementation and administration of the DB2 Analytics.
Accelerator solution is supported by graphical tooling. This allows for a simple initial deployment, assisted by graphical tools followed by largely administration-free operations.
To ensure that the proposed solution addresses your needs, it is important to complete a free-of-charge workload assessment process before acquiring DB2 Analytics Accelerator.
Contact your IBM representative for further information.
The DB2 Analytics Accelerator is a query accelerator solution designed to increase your business's agility by quickly delivering insight customers can use where and when it's of value. It enables the ability to process complex, long running queries that have traditionally been the bane of organizations, without additional tuning, indices, or materialized query tables (MQTs), providing greater speed, enabling them to quickly enhance business value.
The DB2 Analytics Accelerator is a high-performance, integrated hardware and software accelerator for IBM System z, delivering dramatically faster analytic query responses transparently to all users.
- Marries the best Netezza technologies with the DB2 for z/OS transaction and query abilities to provide extreme performance for a variety of workloads
- Removes the costs of traditional performance tuning such as indices, MQTs and query plan tuning that had required extensive time and expensive resources
- Optimized for complex analytic queries that frequently do full table scans that better enable customers to get quick results to gain business insights
- Enables the ability to run queries that were removed from the system in the past, due to their long-running, high-resource requirements
All components leverage the same foundation system making it easier to maintain, preserving existing investments, while routinely delivering results in sub-seconds rather than hours. The DB2 Analytics Accelerator plugs into a DB2 for z/OS environment to complement traditional query processing. This add-on offering interfaces directly with DB2, enabling deeply embedded capabilities behind the application layer, providing full transparency to applications that submit queries to DB2 for z/OS. No changes are required to the application to take immediate advantage of the DB2 Analytics Accelerator
Like the zIIP engine, the DB2 Analytics Accelerator is a workload-optimized platform designed for special purpose processing. The DB2 Analytics Accelerator accelerates DB2 queries without incurring system z usage charges, while enabling dramatically faster response times. The DB2 Analytics Accelerator V2 exploits two of the major trends in data warehouse technology; massively parallel processing and efficient data filtering by early SQL projections and restrictions through Field Programmable Gate Arrays (FPGAs).
Utilizing this breakthrough technology, the DB2 Analytics Accelerator accelerates business analytics to quickly deliver business insights in unprecedented speed and scales based on the company's ever-changing analytics needs. It offers faster business value at lower cost by combining the simplicity and rapid deployment characteristics of an appliance, while retaining the benefits of having the data managed and secured by the reliable database platform DB2 for z/OS.
DB2 Analytics Accelerator is part of the System z analytics family. The DB2 Analytics Accelerator joins a comprehensive IBM data warehousing and business intelligence (BI) solution for System z (including InfoSphere® Warehouse for System z and Cognos® 10 BI for Linux , Query Management Facility (QMF), Mashup Center, and SPSS®), giving customers that have the majority of their data on System z the opportunity to further leverage the platform to support a more complete and cost-effective data warehousing and BI solution.
The DB2 Analytics Accelerator software is implemented as a logical extension of DB2 for z/OS, and thus is deeply integrated with the DB2 for z/OS. The DB2 Analytics Accelerator software is shipped as SMP/E installable for the DB2-related stored procedures and the acceleration software is preinstalled on the IBM Netezza 1000. Updates to the software are installed as PTFs, which are then propagated to the Netezza 1000 appliance by calling a stored procedure.
The DB2 Analytics Accelerator for z/OS is only offered as an integrated solution that combines IBM software and hardware.
Accessibility by people with disabilities
A US Section 508 Voluntary Product Accessibility Template (VPAT) containing details on accessibility compliance can be requested at
Back to top
DB2 Analytics Accelerator is part of the System z analytics family. The DB2 Analytics Accelerator joins a comprehensive IBM data warehousing and BI solution for System z (including InfoSphere Warehouse for System z and Cognos 10 BI for Linux , QMF, Mashup Center, and SPSS), giving customers that have the majority of their data on System z the opportunity to further leverage the platform to support a more complete and cost-effective data warehousing and business intelligence solution.
Back to top
Program Program number VRM name 5697-SAO 2.1.0 DB2 Analytics Accelerator for z/OS
Product identification number
Subscription and Program PID number Support PID number 5697-SAO 5697-SAS
Back to top
Product information is available via the Offering Information website
Back to top
The IBM Publications Center portal is at
The Publications Center is a worldwide central repository for IBM product publications and marketing material with a catalog of 70,000 items. Extensive search facilities are provided. Payment options for orders are via credit card or customer number. A large number of publications are available online in various file formats. They can all be downloaded free of charge.
One copy of the following publications is supplied automatically with the basic machine-readable material.
The following publications are English only, except as noted.
DB2 Analytics Accelerator for z/OS V2.1 Form number Document GI19-0052 - Program Directory GH12-6956 - License Information (17 languages) GH12-6957 - Quick Start Guide (English, French, and Japanese)
The following product publications are available at the IBM Publications Center portal at:
DB2 Analytics Accelerator for z/OS V2.1 Form number Document SH12-6960 - User's Guide SH12-6958 - Installation Guide SH12-6959 - Stored Procedures Reference
For additional publications visit the product's website at
Back to top
Specified operating environment
DB2 Analytics Accelerator for z/OS requires an appropriately sized Netezza 1000 appliance.
The size is determined by the required performance given the amount of data, number of users, the complexity of queries and their arrival rate. This drives the configuration of the IBM Netezza 1000 that is needed.
DB2 Analytics Accelerator Studio is a component of the DB2 Analytics Accelerator for z/OS program, providing a GUI. for the administration of DB2. Analytics Accelerator. DB2 Analytics Accelerator Studio consists of a number of administration plug-ins and is hosted by an integrated IBM Data Studio V18.104.22.168 (stand-alone) client.
For the latest hardware requirements, and Netezza 1000 configurations supported with this offering, refer to the following websites.
For DB2 Analytics Accelerator for z/OS
For Data Studio V22.214.171.124 (stand-alone) at
The DB2 Analytics Accelerator for z/OS software requires:
- z/OS 1.11, or later
- DB2 V9.1 for z/OS, or
- DB2 V10.1 for z/OS
- DB2 Utilities Suite for z/OS, V9.1 or
- DB2 Utilities Suite for z/OS, V10.1
- XML Toolkit for z/OS, V1.10
- IBM Ported Tools for z/OS, V1.2.0
To enable DB2 for z/OS to route queries to an attached IBM DB2 Analytics Accelerator a particular PTF needs to be applied. For details and for additional information regarding hardware and software requirements refer to the DB2 Analytics Accelerator for z/OS support website at
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.
The value and benefits of this offering depends on your BI or data warehouse environment and data structure. To ensure that the proposed solution best fits your needs it is important to complete a free-of-charge workload assessment before acquiring DB2 Analytics Accelerator. Contact your IBM representative or business partner for further information.
DB2 Analytics Accelerator for z/OS, V2.1:
- DB2 Analytics Accelerator for z/OS, V2.1- 3590 Cartridge
- One DVD with DB2 Analytics Accelerator for z/OS, V1.1 (including DB2 Analytics Accelerator Studio V2.1) (LCD7-2619)
- Hardcopy Quick Start Guide (Installation overview document) (GH12-6957)
- Hardcopy License Information document (GH12-6956)
- Hardcopy Program Directory document (GI19-0052)
Security, auditability, and control
DB2 Analytics Accelerator for z/OS, V2.1 uses the security and auditability features of the host hardware or software. 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 top
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 or to contact a Software Services sales specialist, visit
Back to top
Part number or Program name PID number Charge metric DB2 Analytics Accelerator 5697-SAO Per Blade for z/OS, V2.1 DB2 Analytics Accelerator 5697-SAS Per Blade for z/OS, V2.1 S&S
Blade is a unit of measure by which the program can be licensed. A blade is a separable physical device that is comprised of processing units, memory, and input/output capabilities and that may be incorporated into a rack or blade enclosure. Licensee must obtain Blade entitlements for each activated blade in the rack or blade enclosure in which a blade made available to the program is installed.
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: DB2 Analytics Accelerator for z/OS, V2.1 Program PID: 5697-SAO Entitlement identifier Description License option/Pricing metric S016VRX DB2 Analytics Accelerator Basic OTC, per blade for z/OS, V2.1 Orderable supply ID Language Distribution medium S016T92 English 3590 tape Subscription and Support PID: 5697-SAS Entitlement identifier Description License option/Pricing metric S016VRZ DB2 Analytics Basic ASC, per blade Orderable supply ID Language Distribution medium S016T94 English Hardcopy pub
For trade-ups from IBM Smart Analytics Optimizer for DB2 for z/OS, V1.1 to DB2 Analytics Accelerator for z/OS, V2.1 please contact your IBM representative
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
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, and 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.
- CBPDO shipments will begin one week after general availability.
- ServerPac shipments will begin two weeks after general availability
- SystemPac shipments will begin four weeks after general availability due to additional customization, and data input verification.
Back to top
|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.
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.
Agreement for Acquisition of Software Maintenance
The IBM Agreement for Acquisition of Software Maintenance (Z125-6011) agreement applies for Software Subscription and Support (Software Maintenance) and does not require customer signatures.
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 System z Operational Support Services - SoftwareXcel is an option if you desire added services.
License Information form number
License information form number: L-PVIS-8JYCTW
Document Product form number number Product name GH12-6956 5697-SAO DB2 Analytics Accelerator for z/OS, V2.1
The program's License Information will be available for review on the IBM Software License Agreement website
Limited warranty applies
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, consult the IBM Software Support Handbook found at
IBM will maintain this information for at least one year after the original licensee acquires the program (warranty period).
Enhanced support, called Subscription and Support, includes telephone assistance, as well as access to updates, releases, and versions of the program as long as support is in effect. You will be notified of discontinuance of support with 12 months' notice.
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)
Passport Advantage applies
Software Subscription and Support applies
No. 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, visit
IBM Operational Support Services - SoftwareXcel
System i Software Maintenance applies
Variable charges apply
Educational allowance available
Yes. A 15% education allowance applies to qualified education institution customers.
Back to top
|IBM Electronic Services|
IBM has transformed its delivery of hardware and software support services to help you achieve higher system availability. Electronic Services is a web-enabled solution that offers an exclusive, no-additional-charge enhancement to the service and support available for IBM servers. These services are designed to provide the opportunity for greater system availability with faster problem resolution and preemptive monitoring. Electronic Services comprises two separate, but complementary, elements: Electronic Services news page and Electronic Services Agent.
The Electronic Services news page is a single Internet entry point that replaces the multiple entry points traditionally used to access IBM Internet services and support. The news page enables you to gain easier access to IBM resources for assistance in resolving technical problems.
The Electronic Service Agent is no-additional-charge software that resides on your server. It monitors events and transmits system inventory information to IBM on a periodic, client-defined timetable. The Electronic Service Agent automatically reports hardware problems to IBM. Early knowledge about potential problems enables IBM to deliver proactive service that may result in higher system availability and performance. In addition, information collected through the Service Agent is made available to IBM service support representatives when they help answer your questions or diagnose problems. Installation and use of IBM Electronic Service Agent for problem reporting enables IBM to provide better support and service for your IBM server.
To learn how Electronic Services can work for you, visit
Back to top
Information on charges is available at
Choose the option entitled Purchase/upgrade tools.
Program name: DB2 Analytics Accelerator for z/OS, V2.1 Program PID: 5697-SAO Entitlement identifier Description License option/Pricing metric S016VRX DB2 Analytics Accelerator Basic OTC, per blade for z/OS Orderable supply ID Language Distribution medium S016T92 English 3590 tape Subscription and Support PID: 5697-SAS Entitlement identifier Description License option/Pricing metric S016VRZ DB2 Analytics Basic ASC, per blade Accelerator No charge, decline SW S&S for z/OS S&S Orderable supply ID Language Distribution medium S016T94 English Hardcopy pub
For additional information and current prices, contact your local IBM representative.
IBM Global Financing
IBM Global Financing offers competitive financing to credit-qualified customers 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 customer segments: small, medium, and large enterprise), rates, terms, and availability can vary by country. Contact your local IBM Global Financing organization or visit
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 customers. Rates are based on a customer'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, permits accelerated 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 customers.
For more financing information, visit
Back to top
To order, contact the Americas Call Centers or 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).
Phone: 800-IBM-CALL (426-2255) Fax: 800-2IBM-FAX (242-6329) Internet: email@example.com Mail: IBM Teleweb Customer Support ibm.com® Sales Execution Center, Americas North 3500 Steeles Ave. East, Tower 3/4 Markham, Ontario Canada L3R 2Z1
The Americas Call Centers, 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.
Query Management Facility, QMF and Electronic Service Agent are trademarks of IBM Corporation in the United States, other countries, or both.
DB2, z/OS, IBM, System z, InfoSphere, Cognos, SPSS, SystemPac, Passport Advantage and ibm.com 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.
Other company, product, and service names may be trademarks or service marks of others.
For the most current information regarding IBM products, consult your IBM representative or reseller, or visit the IBM worldwide contacts page