IBM DB2 10.5 with BLU Acceleration, the multi-workload database software for the era of big data, improves performance while helping to reduce storage costs
IBM Europe, Middle East, and Africa Software Announcement ZP13-0262April 23, 2013
(Corrected on August 15, 2013)
Revised a table in the Description section.(Corrected on May 28, 2013)
Added information to the Description section.(Corrected on May 21, 2013)
Revised the planned availability date and made minor text clarifications.
|
At a glance |
IBM® DB2® 10.5 for Linux , UNIX , and Windows delivers powerful new capabilities and streamlined packaging that can help reduce database costs while improving performance, reliability, and flexibility. DB2 10.5 for Linux , UNIX , and Windows offers:
- Analytics at the speed of thought - New in-memory hybrid technology yields faster analytics without the costs or limits of in-memory only systems.
- Always available transactions - Boost operations and decrease costly downtime with improved availability and enhanced disaster recovery up to thousands of kilometers.
- Future-proof versatility - Expand and modernize applications and infrastructure with new mobile capabilities; work even more seamlessly with applications originally written for Oracle Database.
- Unprecedented affordability - Take advantage of analytics at the speed of thought, always available transactions, and future-proof versatility - all in one product! No extras are needed.
- Easy choices - Fast, reliable, affordable, future-proof capabilities in six easy packages are tailored for your business needs by features and capacity.
|
Overview |
Business strategies are driving applications that are more diverse than ever. Growth and innovation strategies push the need to explore big data, analytics, mobile, cloud, and social. At the same time, funds are not limitless and data management investments must be fast, reliable, affordable, future-proof, and versatile - even multi-purpose. That is why DB2 10.5 with new BLU Acceleration is a game changer for clients looking to accomplish more with less.
Analytics at the speed of thought. DB2's new BLU Acceleration feature is in-memory hybrid column-organized table technology designed to yield faster analytics from data warehousing without the costs or limits of in-memory only systems. It speeds analytics and reporting with a combination of in-memory and column store data retrieval, maximized CPU processing, and data skipping that allows for faster input/output.
Always available transactions. Stuff happens. Keep your business up and running with DB2's pureScale® clustering technology. It helps to ensure your transaction processing is highly available and extremely scalable no matter what life brings. It is designed to avoid both planned and unplanned outages and provide disaster recovery up to thousands of kilometers, which means virtually no costly downtime even with maintenance. Perform maintenance during the week, or add a node during application testing, and users will never know the difference. With high availability disaster recovery, and online fix pack updates as well as application transparency, managing your data just got a whole lot easier.
Future-proof versatility. The addition of mobile and enhancements to NoSQL capabilities allow clients to expand and modernize applications now and ensure IT infrastructure is ready for the future. Expanded Oracle database compatibility continues DB2's legacy of infrastructure flexibility and differentiates DB2 from stack-only vendors' products.
Unprecedented affordability. Unlike in-memory alternatives, DB2 10.5 with new BLU Acceleration uses an in-memory hybrid column-organized table approach. Placing only the most-used data in memory means money is not wasted on RAM for data rarely accessed. Many in-memory analytics accelerators come only as an appliance, forcing you to buy costly hardware you may not need. DB2 with BLU Acceleration offers flexibility to deploy in-memory speed on infrastructure you already have.
Easy choices. Take advantage of fast, reliable, affordable, future-proof capabilities in six easy packages. Access the functionality you need, with no "cherry picking" required. DB2 10.5 editions are tailored for your business needs by features and capacity.
|
Key prerequisites |
Refer to the Hardware requirements and Software requirements sections.
|
Planned availability date |
June 14, 2013: Electronic delivery
July 26, 2013: Media availability
|
Description |
Whether the business strategy is to increase growth, drive operational results, reduce costs, attract or retain customers, improve IT applications and infrastructure, or create new products, DB2 10.5 with new BLU Acceleration offers features and flexibility uniquely designed to help IT and business executives accomplish more with less.
New and improved capabilities
Analytics at the speed of thought
Increase growth. Attract customers. DB2's new BLU Acceleration feature is in-memory hybrid column-organized table technology that yields faster analytics from data warehousing without the costs or limits of in-memory only systems. It speeds analytics and reporting with a combination of in-memory and column store data retrieval, maximized CPU processing, and data skipping that allows for faster input/output.
Not only does DB2's new BLU Acceleration feature deliver faster insights, it may also drive consistently better warehouse performance, helping you to meet service level agreements and significantly reduce storage costs. It provides the ability to run a multi-terabyte data warehouse on a single server, which helps lower hardware, setup, and administration costs.
DB2's new BLU Acceleration feature is designed to be transparent, which means it can be deployed with a wide variety of data warehouse applications. In addition, enhancements to the Optim Query Workload Tuner tool help you to analyze your workload and decide which tables would yield the greatest benefits when converted to BLU Acceleration column-oriented tables. A reporting tool is also included that helps you track the percentage of your user data that resides in BLU Acceleration column-oriented tables.
DB2's new BLU Acceleration is included in DB2 Advanced Enterprise Server Edition, DB2 Advanced Workgroup Server Edition, and DB2 Developer Edition.
Always available transactions
The pureScale clustered database technology now includes support for high availability disaster recovery (HADR). Use HADR to mirror data from your primary pureScale database cluster to a second local or remote standby pureScale cluster. If your entire primary cluster goes offline, the standby cluster is fully synchronized and is designed to take over the load in seconds, minimizing impact to your business.
The pureScale capability also now includes online fix pack update support. Online fix pack update support means that you can apply DB2 10.5 fix packs to individual members running DB2 10.5 in a pureScale cluster without having to take the entire cluster offline. This enhancement allows you to perform fix pack maintenance operations on your pureScale cluster with minimal impact to your users.
pureScale clustered database technology is included in DB2 Advanced Enterprise Server Edition, DB2 Advanced Workgroup Server Edition, and DB2 Developer Edition.
Future-proof versatility
The addition of mobile capabilities allows clients to expand and modernize applications now and ensure IT infrastructure is ready for the future. Enhanced Oracle Database compatibility continues DB2's legacy of infrastructure flexibility and differentiates DB2 from stack-only vendors' products.
DB2 10.5 is mission-critical for mobile. It includes IBM Mobile Database and IBM Mobile Database Sync, a relational database and synchronization solution for managing and using data on mobile and embedded devices. Currently, the most popular mobile platform, Android, is supported. IBM Mobile Database Sync Server synchronizes data between DB2 and IBM Mobile Database running on mobile and embedded devices.
DB2 10.5 is even more versatile than before with enhanced Oracle PL/SQL compatibility.
IBM Mobile Database, IBM Mobile Database Sync, and PL/SQL compatibility are included in all DB2 Editions.
Easy choices
Streamlined packaging
DB2 10.5 for Linux , UNIX , and Windows makes it easier to choose a single edition that includes the capabilities and tools required to meet your organization's data management needs. All of the functionality and tools offered in the prior generation of the DB2 for Linux , UNIX , and Windows and InfoSphere® Warehouse editions and features are now included in the following lineup of six editions and one feature:
- DB2 Advanced Enterprise Server Edition
- DB2 Enterprise Server Edition
- DB2 Advanced Workgroup Server Edition
- DB2 Workgroup Server Edition
- DB2 Express® Server Edition
- DB2 Developer Edition
- DB2 Advanced Recovery Feature
This simplified packaging structure makes it easier for you to choose one or two DB2 editions that will fulfill all of your enterprise's data management requirements. For example, DB2 Advanced Enterprise Server Edition and DB2 Advanced Workgroup Server Edition can be deployed in a single-server or multi-server clustered environment and can handle OLTP, warehouse, and mixed workloads. As a result, both the DB2 Advanced Enterprise Server Edition and DB2 Advanced Workgroup Server Edition give you incredible deployment flexibility without having to compromise on functionality or performance.
Other benefits of the simplified DB2 packaging include fewer editions to deploy and administer, easier entitlement tracking, and greater utilization of the functionality included in the DB2 editions that you license. Refer to the Product positioning section for details on what capabilities and tools are included in each DB2 edition.
Hassle-free DB2 edition upgrades
If you already use DB2 for Linux , UNIX , and Windows and would like to upgrade to a more capable edition, select DB2 10.5 for Linux , UNIX , and Windows editions now share a common install image which means moves between those DB2 editions can be achieved with a simple license key update. There is no need to install new DB2 code on these DB2 10.5 edition upgrades. Furthermore, test cycles are reduced because the edition upgrade simply unlocks new capabilities in your existing DB2 installation. This makes it easy to deploy and start taking advantage of the more advanced DB2 editions in your enterprise. The following upgrade paths can all be achieved with a license update. In order to acquire the appropriate trade-up license, trade-up parts corresponding to these paths are available for purchase.
Source edition Target edition -------------------------------------- ------------------------------ DB2 Workgroup Server Edition DB2 Advanced Workgroup Server Edition DB2 Enterprise Server Edition -------------------------------------- ------------------------------ DB2 Enterprise Server Edition DB2 Advanced Enterprise Server Edition -------------------------------------- ------------------------------
For DB2 Advanced Edition customers who want to start taking advantage of DB2 10.5 for Linux, UNIX, and Windows capabilities or tools while having the flexibility to continue using earlier versions of DB2 for Linux, UNIX, and Windows or InfoSphere Warehouse, the following prior level programs are included as supporting programs with DB2 Advanced Workgroup Server Edition 10.5, DB2 Advanced Enterprise Server Edition for Linux, UNIX, and Windows 10.5, and DB2 Developer Edition 10.5:
- DB2 Advanced Workgroup Server Edition for Linux, UNIX, and Windows 10.5
- DB2 Workgroup Server Edition 9.7
- DB2 Workgroup Server Edition 10.1
- InfoSphere Warehouse Departmental Base Edition V9.7
- InfoSphere Warehouse Departmental Base Edition V10.1
- InfoSphere Warehouse Departmental Edition V9.7
- InfoSphere Warehouse Departmental Edition V10.1
- InfoSphere Warehouse Advanced Departmental Edition V9.7
- InfoSphere Warehouse Advanced Departmental Edition V10.1
- DB2 Advanced Enterprise Server Edition for Linux, UNIX, and Windows 10.5
- DB2 Enterprise Server Edition 9.7
- DB2 Enterprise Server Edition 10.1
- DB2 Storage Optimization Feature 9.7
- DB2 Storage Optimization Feature 10.1
- DB2 pureScale Feature 9.8
- DB2 pureScale Feature 10.1
- DB2 for Linux, UNIX, and Windows for SAP Applications 1.0
- DB2 for Linux, UNIX, and Windows for SAP Applications 2.0
- IBM Base Warehouse Feature for DB2 9.7
- IBM Base Warehouse Feature for DB2 10.1
- IBM Enterprise Warehouse Feature for DB2 9.7
- IBM Enterprise Warehouse Feature for DB2 10.1
- InfoSphere Warehouse Enterprise Base Edition V9.7
- InfoSphere Warehouse Enterprise Base Edition V10.1
- InfoSphere Warehouse Enterprise Edition V9.7
- InfoSphere Warehouse Enterprise Edition V10.1
- InfoSphere Warehouse Advanced Enterprise Edition V9.7
- InfoSphere Warehouse Advanced Enterprise Edition V10
- DB2 Developer Edition 10.5
- InfoSphere Warehouse Developer Edition V9.7
- InfoSphere Warehouse Developer Edition V10.1
These supporting programs may be used in addition to or instead of the bundling DB2 10.5 program, subject to the terms and conditions of the bundling program license, provided the cumulative use of DB2 10.5 and these supporting programs is within the customer's entitlement to DB2 10.5. The above supporting programs and the bundling DB2 10.5 program and their respective components may be used together only when supported for use together in accordance with the program's specifications. Support and maintenance for the above DB2 and InfoSphere Warehouse V9.7 and V10.1 supporting programs, as part of Software Subscription and Support for IBM DB2 10.5, will only be available until the general end of support date for the listed supporting program, and, therefore, may not be supported during the full support period for DB2 10.5. After that date, extended support for the supporting programs will be available for purchase.
Advanced Recovery feature for Linux , UNIX , and Windows
DB2 for Linux , UNIX , and Windows 10.5 introduces the DB2 Advanced Recovery feature. This feature is a bundle of advanced database backup, recovery, and data extraction tools that can help you improve data availability, mitigate risk, and accelerate crucial administrative tasks when time is of the essence. The feature bundle contains the following tools:
- IBM DB2 Merge Backup for Linux , UNIX , and Windows V2.1
- IBM DB2 Recovery Expert for Linux , UNIX , and Windows V4.1
- IBM Optim High Performance Unload for DB2 for Linux , UNIX , and Windows V5.1
The DB2 Advanced Recovery feature is a separately purchasable product that may be used with all DB2 Editions except DB2 Express-C.
Advanced tools for DB2 Linux , UNIX , and Windows
InfoSphere Optim tools are updated to accelerate adoption and enhance the value of key DB2 features, including BLU Acceleration, pureScale , and compression. Refer to the Product positioning section for details about which Optim tools are included in each DB2 edition.
New releases supporting DB2 10.5 Linux , UNIX , and Windows are:
Data Studio V4.1 InfoSphere Data Architect V9.1 InfoSphere Optim Query Workload Tuner V4.1 InfoSphere Optim pureQuery® Runtime V3.3 InfoSphere Optim Performance Manager V5.3 InfoSphere Optim Configuration Manager V3.1 InfoSphere Optim High Performance Unload V5.1 DB2 Merge Backup V2.1 DB2 Recovery Expert V4.1
Get a unified view of your heterogeneous data with InfoSphere Federation Server
InfoSphere Federation Server V10.5 offers data virtualization through a robust SQL interface and a full relational database engine designed for global optimization of data access. It helps you quickly prototype and implement solutions involving disparate databases by virtualizing access so that data can remain in place. InfoSphere Federation Server V10.5 delivers support for Version 10.5 of DB2 for Linux , UNIX , and Windows , as well as improved support for data virtualization. Data virtualization enhancements include improved performance and increased compatibility with data sources.
Enhancements to InfoSphere Federation Server for use with DB2 include improved compatibility with data sources via three-part name access, easing migration and application portability.
Grandfathered functionality
DB2 Workgroup Server Edition no longer contains the pureScale clustering capability. Instead pureScale clustering is now available only in the DB2 Advanced editions. DB2 Workgroup Server Edition customers are eligible to have their entitlements upgraded to restricted DB2 Advanced Workgroup Server entitlements so that they may continue to use the pureScale functionality. To be eligible for this upgrade, you must be an existing DB2 Workgroup Server Edition customer who is current on your Subscription and Support as of April 23, 2013. You must also notify IBM by April 23, 2014, and demonstrate that you are using the DB2 Workgroup Server Edition pureScale clustering functionality.
Customers that used IBM Database Developer Edition to work with Informix® databases will no longer be able to do so with DB2 Developer Edition 10.5. Instead, the no-charge Informix Developer edition may be downloaded from
Accessibility by people with disabilities
A US Section 508 Voluntary Product Accessibility Template (VPAT) containing details on accessibility compliance can be requested at
|
Product positioning |
IBM DB2 Editions for production deployment
IBM DB2 Advanced Enterprise Server Edition for Linux , UNIX , and Windows 10.5
DB2 Advanced Enterprise Server Edition includes the functionality and tools needed for large, complex enterprise environments, and is ideal for both transactional and data warehouse workloads. The edition combines all the functionality from the DB2 Enterprise Server Edition with full data compression functionality, BLU Acceleration, pureScale clustering, workload management, distributed partitioning functionality (DPF), federation between DB2 for Linux , UNIX , and Windows databases and databases from other vendors including Oracle database and SQL Server, queue-based replication (Q Replication) between three DB2 for Linux , UNIX , and Windows systems, Change Data Capture (CDC) replication between a DB2 for Linux , UNIX , and Windows source and up to two DB2 for Linux , UNIX , and Windows 10.5 targets for the purpose of HADR, solidDB® and solidDB Universal Cache, Cognos® Business Intelligence, warehouse model packs, as well as the following rich set of tools:
- IBM Data Studio
- InfoSphere Optim Performance Manager Extended Edition
- InfoSphere Optim Query Workload Tuner
- InfoSphere Optim Configuration Manager
- InfoSphere Data Architect (10 authorized users)
- InfoSphere Optim pureQuery Runtime for Linux , UNIX , and Windows
The six tools listed above can be used with any supported version of DB2 Advanced Enterprise Server Edition. Similarly, any of these tools that were included with prior versions of DB2 Advanced Enterprise Server Edition can be used with DB2 Advanced Enterprise Server Edition 10.5, if supported.
DB2 Advanced Enterprise Server Edition can be deployed on Linux , UNIX , or Windows servers of any size, from one processor to hundreds of processors, and on both physical and virtual servers.
Program charges: DB2 10.5 Advanced Enterprise Server Edition is available on a PVU, per Authorized User Single Install (AUSI), or per Terabyte charge metric. Under the AUSI charge metric, you must acquire a minimum of 25 AUSI licenses per 100 PVUs. Under the per Terabyte charge metric, you must:
- Use the database for a data warehouse and run a data warehouse workload. A data warehouse is a subject-oriented, integrated, time-variant collection of data that integrates data from multiple data sources for historical ad hoc data reporting and querying. A data warehouse workload is a workload that typically scans thousands or millions of rows in a single query in order to support the analysis of data in a data warehouse;
- Have user data from a single database spread across two or more active data partitions or at least 75% of the user data residing in BLU Acceleration column-organized tables with a majority of the workload accessing the BLU Acceleration column-organized tables;
- Not use DB2 for Linux , UNIX , and Windows built-in high availability disaster recovery (HADR) or pureScale capabilities.
You can upgrade from DB2 Enterprise Server Edition to DB2 Advanced Enterprise Server Edition using a Processor Value Unit (PVU) based upgrade part number.
IBM DB2 Enterprise Server Edition for Linux , UNIX , and Windows 10.5
DB2 Enterprise Server Edition is designed to meet the data server needs of midsize to large-size businesses and is ideal for transactional and mixed workloads. It can be deployed on Linux , UNIX , or Windows servers of any size, from one processor to hundreds of processors, and on both physical and virtual servers. The edition includes IBM Data Studio, Label Based Access Control, Row and Column Access Control, Multi-Temperature Data Management, Time Travel Query, Table Partitioning, High Availability Disaster Recovery, Online Reorganization, Materialized Query Tables (MQTs), Multidimensional Clustering (MDC), Query Parallelism, Scan Sharing, Connection Concentrator, pureXML® , backup compression, and Tivoli® System Automation for Multiplatforms for use with high availability. The product also includes DB2 Homogeneous Federation and Homogeneous SQL Replication allowing federated data access and replication between DB2 for Linux , UNIX , and Windows servers as well as web services federation.
Program charges: DB2 10.5 Enterprise Server Edition is available on a PVU or per Authorized User Single Install (AUSI) charge metric. Under the AUSI charge metric, you must acquire a minimum of 25 AUSI licenses per 100 PVUs.
IBM DB2 Advanced Workgroup Server Edition for Linux , UNIX , and Windows 10.5
DB2 Advanced Workgroup Server Edition includes the capabilities needed for medium-sized business environments, and is ideal for both transactional and data warehouse workloads. The edition includes largely the same functionality and tools as DB2 Advanced Enterprise Server Edition. The main difference is that DB2 Advanced Workgroup Server Edition has processor core, socket, memory, and terabyte restrictions described below. In addition, DB2 Advanced Workgroup Server Edition supports federation only with DB2 for Linux , UNIX , and Windows and Informix data sources.
Program charges: DB2 10.5 Advanced Workgroup Server Edition is available on a PVU, per Authorized User Single Install (AUSI), or per Terabyte charge metric. Under the AUSI charge metric, you must acquire a minimum of 25 AUSI licenses per 100 PVUs. Under the PVU and AUSI charge metrics, you are restricted to 16 processor cores and 128 GB of instance memory while under the per Terabyte charge metric, you are restricted to 4 processor sockets. These restrictions are per physical or, where partitioned, virtual server except in a pureScale or DPF cluster where the restrictions apply to the entire cluster. Under all charge metrics, you are restricted to 15 terabytes of user data per database. Under the Terabyte charge metric, you must also:
- Use the database for a data warehouse and run a data warehouse workload. A data warehouse is a subject-oriented, integrated, time-variant collection of data that integrates data from multiple data sources for historical ad hoc data reporting and querying. A data warehouse workload is a workload that typically scans thousands or millions of rows in a single query in order to support the analysis of data in a data warehouse;
- Have user data from a single database spread across two or more active data partitions or at least 75% of the user data residing in BLU Acceleration column-organized tables with a majority of the workload accessing the BLU Acceleration column-organized tables;
- Not use DB2 for Linux , UNIX , and Windows built-in high availability disaster recovery (HADR) or pureScale capabilities.
IBM DB2 Workgroup Server Edition for Linux , UNIX , and Windows 10.5
DB2 Workgroup Server Edition is suitable for transactional database workloads in a departmental, workgroup, or medium-sized business environment. The edition shares significant functionality with DB2 Enterprise Server Edition but has processor core and memory restrictions described below. DB2 Workgroup Server Edition can be deployed in Linux , UNIX , and Windows server environments. If using multiple virtual servers on a physical server, there is no limit on the cores or memory available to the physical server providing the processor and memory restrictions are observed by the virtual servers running DB2 . This makes DB2 Workgroup Server Edition ideal for consolidating multiple workloads onto a large physical server running DB2 Workgroup Server Edition in multiple virtual servers.
Program charges: DB2 10.5 Workgroup Server Edition is available on a per Limited Use Socket, PVU, or Authorized User Single Install (AUSI) charge metric. Under the AUSI metric you must acquire a minimum of five AUSI licenses per Install. Under all metrics, you are restricted to 16 processor cores and 128 GB of instance memory and 15 terabytes of user data per database. In addition, under the Socket metric, you are also restricted to no more than 4 processor sockets. These restrictions are per physical or, where partitioned, virtual server.
IBM DB2 Express Server Edition for Linux , UNIX , and Windows 10.5
DB2 Express Server Edition is a full-function transactional data server, which provides very attractive entry-level pricing for the small and medium business (SMB) market. It comes with simplified packaging and is easy to transparently install within an application. With DB2 Express Server Edition, it is easy to subsequently upgrade to the other editions of DB2 10.5 since DB2 Express Server Edition includes most of the same features, including security and HADR, as the more scalable editions. DB2 Express Server Edition can be deployed in x64 server environments and is restricted to 8 processor cores and 64 GB of memory per physical or, where partitioned, virtual server. If using multiple virtual servers on a physical server, there is no limit on the cores or memory available to the physical server providing the processor and memory restrictions are observed by the virtual servers running DB2 . This makes DB2 Express Server Edition ideal for consolidating multiple workloads onto a large physical server running DB2 Express Server Edition in multiple virtual servers.
Program charges: DB2 10.5 Express Server Edition is available on a per Authorized User Single Install (AUSI), PVU, Limited Use Virtual Server, or 12-month Fix Term licensing model. If licensed under the AUSI metric, you must acquire a minimum of five AUSI licenses per Install. DB2 Express Server Edition can also be licensed on a yearly Fixed Term License pricing model. Under all charge metrics, you are restricted to 15 terabytes of user data per database.
IBM DB2 Community Edition
IBM DB2 Express-C Edition for Linux and Windows 10.5
DB2 10.5 Express-C is a no-charge, entry-level edition of the DB2 data server for the developer and partner community. It is designed to be up and running in minutes, and easy to use and embed. It includes self-management features, and embodies all of the core capabilities of DB2 for Linux , UNIX , and Windows such as Time Travel Query. One notable difference between DB2 Express-C and the production editions of DB2 for Linux , UNIX , and Windows is that you can't cluster together servers for the purposes of high availability. Solutions developed using DB2 Express-C can be seamlessly deployed using more scalable DB2 editions without modifications to the application code.
Program charges: DB2 10.5 Express-C can be used for development and deployment at no charge. It can be installed on x64-based physical or virtual systems and may use up to a maximum of 2 processor cores and 16 GB of memory with no more than 15 terabytes of user data per database. DB2 Express-C comes with online community-based assistance. Users requiring more formal support, access to fix packs, or additional capabilities such as high availability, Homogeneous Federation, and replication can purchase an optional yearly subscription for DB2 Express Server Edition (Fixed Term License) or upgrade to other DB2 editions. In addition, IBM Data Studio is also available to facilitate solutions deployment and management.
IBM DB2 Edition for non-production deployment
IBM DB2 Developer Edition for Linux , UNIX , and Windows 10.5
IBM DB2 Developer Edition offers a package for a single application developer to design, build, test, and prototype applications for deployment on any of the IBM DB2 client or server platforms. This comprehensive developer offering includes DB2 Workgroup Server Edition, DB2 Advanced Workgroup Server Edition, DB2 Enterprise Server Edition, DB2 Advanced Enterprise Server Edition, DB2 Connect Enterprise Edition, and all of the built-in DB2 10.5 capabilities, allowing you to build solutions that utilize the latest data server technologies.
Program charges: The software in this package cannot be used for production systems. You must acquire a separate Authorized User license for each unique person who is given access to the Program.
IBM DB2 10.5 for Linux , UNIX , and Windows purchasable features
IBM DB2 Advanced Recovery Feature for Linux , UNIX , and Windows 10.5
DB2 Advanced Recovery feature is a bundle of advanced database backup, recovery, and data extraction tools that can help enterprises improve data availability, mitigate risk, and accelerate crucial administrative tasks when time is of the essence. The feature bundle contains the following tools:
- IBM DB2 Merge Backup for Linux , UNIX , and Windows V2.1
- IBM DB2 Recovery Expert for Linux , UNIX , and Windows V4.1
- IBM Optim High Performance Unload for DB2 for Linux , UNIX , and Windows V5.1
Program charges: DB2 10.5 Advanced Recovery feature is available under Authorized User Single Install, PVU, and per Terabyte charge metrics. You must acquire the same Metric and number of entitlements as you have acquired for the DB2 for Linux , UNIX , and Windows server that you will be running this feature against.
Detailed DB2 10.5 package comparison
The following table summarizes the functionality available in each edition of DB2 10.5 for Linux , UNIX , and Windows :
EXP-C = DB2 Express-C EXP = DB2 Express Server Edition WSE = DB2 Workgroup Server Edition AWSE = DB2 Advanced Workgroup Server Edition ESE = DB2 Enterprise Server Edition AESE = DB2 Advanced Enterprise Server Edition DE = DB2 Developer Edition -------------------------- ---- ---- ----- ---- ----- ---- ----- Function EXP-C EXP WSE AWSE ESE AESE DE -------------------------- ---- ---- ----- ---- ----- ---- -----
BLU Acceleration (1) - - - Yes - Yes Yes (2) (2) pureScale (1) - - - Yes - Yes Yes (3) (3) Data Partitioning (1) - - - Yes - Yes Yes (2) (2) solidDB & solidDB UC - - - Yes - Yes Yes IBM Mobile Database Sync Yes Yes Yes Yes Yes Yes Yes IBM Mobile Database Support Yes Yes Yes Yes Yes Yes Yes pureXML Storage Yes Yes Yes Yes Yes Yes Yes Time Travel Query Yes Yes Yes Yes Yes Yes Yes Compression (row, Adaptive) - - - Yes - Yes Yes Compression (Backup) Yes Yes Yes Yes Yes Yes Yes Row & Column Access Control - Yes Yes Yes Yes Yes Yes Label Based Access Control - Yes Yes Yes Yes Yes Yes SQL Replication - Yes Yes Yes Yes Yes Yes (4) (4) (4) (4) (4) (4) Federation Capabilities Yes Yes Yes Yes Yes Yes Yes (5,6)(5,6)(5,6)(5,6)(5,6) (6,7) (6,7)
WebSphere MQ - Yes Yes Yes Yes Yes Yes High Availability - Yes Yes Yes Yes Yes Yes Disaster Recovery (3) (3) Tivoli System Automation - Yes Yes Yes Yes Yes Yes Online Reorg - Yes Yes Yes Yes Yes Yes Advanced Copy Services - Yes Yes Yes Yes Yes Yes Multi-temperature Storage - - - Yes Yes Yes Yes Materialized Query Tables - - - Yes Yes Yes Yes Multi-Dimensional Clustering - - - Yes Yes Yes Yes Query Parallelism - - - Yes Yes Yes Yes Connection Concentrator - - - Yes Yes Yes Yes Table Partitioning - - Yes Yes Yes Yes Yes Plan Lockdown - - - Yes Yes Yes Yes Scan Sharing - - - Yes Yes Yes Yes Workload Management - - - Yes - Yes Yes MQ Replication - - - Yes - Yes Yes (8) (8) (8) CDC Replication - - - Yes - Yes Yes (8,9) (8,9) (8,9) Continuous Data Ingest - - - Yes - Yes Yes DB2 Connect - - - Yes - Yes Yes (10) (10)
Notes: 1. BLU Acceleration, pureScale, and Data Partitioning capabilities cannot be combined in a DB2 10.5 for Linux, UNIX, and Windows deployment. 2. Must use at least one of the BLU Acceleration or Data Partitioning capabilities if licensed by the TB price metric. 3. May be used only if licensed by PVU or AUSI charge metrics. 4. To IBM data source only. Requires DB2 Connect (excluding Personal Edition) or InfoSphere Replication when replicating with DB2 for z and/or DB2 for i. 5. Federation includes only DB2 and Informix data sources. 6. Requires DB2 Connect (excluding Personal edition) or InfoSphere Federation Server when federating with DB2 for z and/or DB2 for i. 7. Federation includes all supported IBM and non-IBM data sources. 8. Restricted to a source DB2 for Linux, UNIX, and Windows server and no more than two other DB2 for Linux, UNIX, and Windows servers. 9. Restricted to unidirectional replication without data transformations between DB2 for Linux, UNIX, and Windows servers of the same version for the purpose of HADR. 10. For the purposes of using SQW tooling to access DB2 for z.
The following table summarizes the tools available in each edition of DB2 10.5 for Linux , UNIX , and Windows :
EXP-C = DB2 Express-C EXP = DB2 Express Server Edition WSE = DB2 Workgroup Server Edition AWSE = DB2 Advanced Workgroup Server Edition ESE = DB2 Enterprise Server Edition AESE = DB2 Advanced Enterprise Server Edition DE = DB2 Developer Edition -------------------------- ---- ---- ----- ---- ----- ---- ----- Feature / Tool EXP-C EXP WSE AWSE ESE AESE DE -------------------------- ---- ---- ----- ---- ----- ---- -----
Advanced Recovery Feature - OPT OPT OPT OPT OPT OPT (1) (1) (1) (1) (1) (1) Optim Performance Manager - - - Yes - Yes Yes Extended Edition Optim Query Workload Tuner - - - Yes - Yes Yes Optim Configuration Manager - - - Yes - Yes Yes InfoSphere Optim pureQuery - - - Yes - Yes Yes Runtime for Linux, UNIX, and Windows Warehouse Model Packs - - - Yes - Yes Yes WHS Design Studio - - - Yes Yes Yes Yes WHS SQW - - - Yes Yes Yes Yes WHS Mining & text Analytics - - - Yes - Yes Yes Cognos 5 authorized Users - - - Yes - Yes Yes WHS Cubing Services - - - Yes - Yes Yes Data Studio Yes Yes Yes Yes Yes Yes Yes InfoSphere Data Architect - - - Yes - Yes Yes Capabilities (2) (2)
Notes: 1. Optional, separately priced DB2 feature 2. Limit to 10 authorized users in Data Architect
The following table summarizes the charge metrics and resource limits applicable to each edition of DB2 10.5 for Linux , UNIX , and Windows :
EXP-C = DB2 Express-C EXP = DB2 Express Server Edition WSE = DB2 Workgroup Server Edition AWSE = DB2 Advanced Workgroup Server Edition ESE = DB2 Enterprise Server Edition AESE = DB2 Advanced Enterprise Server Edition DE = DB2 Developer Edition -------------------------- ----- ----- ----- ----- ----- ----- ----- Attribute EXP-C EXP WSE AWSE ESE AESE DE -------------------------- ---- ----- ----- ----- ----- ----- -----
Pricing Metric (1) N/A AUSI AUSI AUSI AUSI AUSI AU LUVS LUS PVU PVU PVU PVU PVU TB TB FTL -------------------------- ---- ----- ----- ----- ----- ----- ----- Processor Core Limit 2 8 16 16 N/A N/A N/A (number of cores) (3) -------------------------- ---- ----- ----- ----- ----- ----- ----- Processor Socket Limit N/A N/A 4 4 N/A N/A N/A (number of sockets) (2) (4) -------------------------- ---- ----- ----- ----- ----- ----- ----- DB2 Instance Memory 16GB 64 GB 128 GB 128 GB N/A N/A N/A Limitation (3) -------------------------- ---- ----- ----- ----- ----- ----- ----- TB Limit 15 TB 15 TB 15 TB 15 TB N/A N/A N/A (terabytes of user data (4) per database) -------------------------- ---- ----- ----- ----- ----- ----- -----
Notes: 1. Key: AUSI - Authorized User Single Install LUVS - Limited Use Virtual Server PVU - Processor Value Unit FTL - Fixed Term License LUS - Limited Use Socket TB - Terabyte AU - Authorized User 2. Applies to the LUS metric only 3. Applies to the AUSI and PVU metrics only 4. Applies to the TB metric only
|
Program number |
Program Program number VRM name 5725-L47 10.5.0 IBM DB2 Advanced Enterprise Server Edition for Linux, UNIX, and Windows 5765-F41 10.5.0 IBM DB2 Enterprise Server Edition for Linux, UNIX, and Windows 5725-L15 10.5.0 IBM DB2 Advanced Workgroup Server Edition for Linux, UNIX, and Windows 5765-F35 10.5.0 IBM DB2 Workgroup Server Edition for Linux, UNIX, and Windows 5724-E49 10.5.0 IBM DB2 Express Server Edition for Linux, UNIX, and Windows 5724-N97 10.5.0 IBM InfoSphere Federation Server 5724-N76 10.5.0 IBM DB2 Developer Edition 5725-L16 10.5.0 IBM DB2 Advanced Recovery Feature for Linux, UNIX, and Windows 5724-R28 IBM DB2 CEO 5725-E89 IBM DB2 Advanced CEO
|
Education support |
IBM training provides education to support many IBM offerings. Descriptions of courses for IT professionals and managers are on the IBM training website
Contact your IBM representative for course information.
Available from IBM training, the newest offerings to support your training needs, enhance your skills, and boost your success with IBM software:
IBM offers a range of training options from traditional classroom to Instructor-Led Online to meet your demanding schedule. Instructor-Led Online (ILO) is an innovative learning format where students get the benefit of being in a classroom with the convenience and cost savings of online training. Take advantage of our ILO formats: ILO Classic - high-quality classroom content taught live and online by our expert instructors; ILO Flex Time - shorter sessions over multiple weeks; and ILO Select - two- to three-hour lectures on key technical topics.
Go green with IBM Onsite training for groups as small as three or as large as fourteen. Choose from the same quality training delivered in classrooms, or customize a course or a selection of courses to best suit your business needs. Enjoy further savings when you purchase training at a discount with an IBM Education Pack - online account -- a flexible and convenient way to pay, track, and manage your education expenses online.
Courses
The following key education resources are available. Check your local Information Management Training and Education website or with your training representative for the most recent training schedule.
Course Course title Course type code CL314 DB2 10.5 for Linux, UNIX, and Classroom Windows New Features and Database Upgrade Considerations 3L314 DB2 10.5 for Linux, UNIX, and Instructor-Led Online Windows New Features and Database Upgrade Considerations CL285 Fast Path to DB2 10.5 for Classroom Experienced Relational DBAs 3L285 Fast Path to DB2 10.5 for Instructor-Led Online Experienced Relational DBAs CL485 DB2 10.5 for LUW Quickstart for Classroom Experienced Relational DBAs 3L485 DB2 10.5 for LUW Quickstart for Instructor-Led Online Experienced Relational DBAs CL801 DB2 10.5 pureScale Implementation Classroom and Control for DB2 Linux UNIX and Windows Administrators 3L801 DB2 10.5 pureScale Implementation Instructor-Led Online and Control for DB2 Linux UNIX and Windows Administrators
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 certification information, refer to
|
Offering Information |
Product information is available via the Offering Information website
|
Publications |
No hardcopy publications are shipped with this program.
IBM Publications Center
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 (in the US) or customer number for 20 countries. A large number of publications are available online in various file formats, and they can all be downloaded by all countries, free of charge.
News of many publications may be subscribed to via Mysupport.
The following books are available for the DB2 10.5 for Linux , UNIX , and Windows products:
Description Language form number --------------------------------------------- --------------------- Administrative API Reference English SC27-5506-00 Spanish SC11-8364-00 Japanese SA88-5277-00 --------------------------------------------- --------------------- Administrative Routines and Views English SC27-5507-00 Spanish SC11-8364-00 Japanese SA88-5277-00 --------------------------------------------- --------------------- Call Level Interface Guide and Reference Volume 1 English SC27-5511-00 Japanese SA88-5278-00 --------------------------------------------- --------------------- Call Level Interface Guide and Reference Volume 2 English SC27-5512-00 Japanese SA88-5279-00 --------------------------------------------- ---------------------
Command Reference English SC27-5508-00 Spanish SC11-8362-00 Japanese SA88-5275-00 --------------------------------------------- --------------------- Data Movement Utilities Guide and Reference English SC27-5528-00 German SC12-4902-00 Japanese SA88-5296-00 Simplified Chinese S151-1992-00 --------------------------------------------- --------------------- Data Recovery and High Availability Guide and Reference English SC27-5529-00 German SC12-4903-00 Japanese SA88-5297-00 Simplified Chinese S151-1993-00 --------------------------------------------- --------------------- Database Administration Concepts and Configuration Reference English SC27-4546-00 German SC12-4884-00 Japanese SA88-5264-00 Simplified Chinese S151-1970-00 --------------------------------------------- ---------------------
Database Monitoring Guide and Reference English SC27-4547-00 German SC12-4885-00 Japanese SA88-5265-00 Simplified Chinese S151-1971-00 --------------------------------------------- --------------------- Database Security Guide English SC27-5530-00 German SC12-4904-00 Japanese SA88-5298-00 Simplified Chinese S151-1994-00 --------------------------------------------- --------------------- DB2 Connect User's Guide English SC27-5518-00 Bulgarian SC19-1808-00 Czech SC19-3563-00 German SC12-4892-00 Spanish SC11-8370-00 French SC11-7327-00 Croatian SC19-1810-00 Hungarian SC22-1190-00 Japanese SA88-5286-00 Korean SA30-4537-00 Dutch SC14-2096-00 Polish SC85-0508-00 Brazilian Portuguese S517-1448-00 Romanian SC19-1706-00 Russian SC89-1277-00 Slovakian SC19-1444-00 Slovenian SC19-1576-00 Simplified Chinese S151-1984-00 Traditional Chinese SC27-3196-00
--------------------------------------------- --------------------- DB2 Workload Management Guide and Reference English SC27-5520-00 German SC12-4894-00 Spanish SC11-8372-00 Japanese SA88-5288-00 Simplified Chinese S151-1986-00 --------------------------------------------- --------------------- Developing ADO.NET and OLE DB Applications English SC27-4549-00 Japanese SA88-5270-00 Simplified Chinese S151-1977-00 --------------------------------------------- --------------------- Developing Embedded SQL Applications English SC27-4550-00 Japanese SA88-5269-00 Simplified Chinese S151-1975-00 --------------------------------------------- --------------------- Developing Java Applications English SC27-5503-00 Spanish SC11-8356-00 Japanese SA88-5280-00 --------------------------------------------- --------------------- Developing Perl, PHP, Python, and Ruby on Rails Applications English SC27-5504-00 Spanish SC11-8358-00 Japanese SA88-5272-00
--------------------------------------------- --------------------- Developing User-defined Routines (SQL and External) English SC27-5501-00 Japanese SA88-5268-00 Simplified Chinese S151-1974-00 --------------------------------------------- --------------------- Getting Started with Database Application Development English GI13-2084-00 Japanese GI88-4306-00 Simplified Chinese G151-1976-00 --------------------------------------------- --------------------- Getting Started with DB2 Installation and Administration on Linux and Windows English GI13-2085-00 Czech GI13-2406-00 German GI11-3309-00 Spanish GI13-1963-00 French GI11-7454-00 Japanese GI88-4307-00 Korean GA30-4531-00 Polish GI11-8412-00 Brazilian Portuguese G517-1442-00 Russian GI43-0117-00 Simplified Chinese G151-1978-00 Traditional Chinese GI13-1162-00
--------------------------------------------- --------------------- Globalization Guide English SC27-5531-00 German SC12-4905-00 Japanese SA88-5299-00 Simplified Chinese S151-1995-00 --------------------------------------------- --------------------- Installing and Configuring DB2 Connect English SC27-5516-00 Personal Edition Bulgarian SC19-1806-00 Czech SC19-3561-00 German SC12-4890-00 Spanish SC11-8368-00 French SC11-7325-00 Croatian SC19-1570-00 Hungarian SC22-1188-00 Japanese SA88-5284-00 Korean SA30-4535-00 Dutch SC14-2095-00 Polish SC85-0509-00 Brazilian Portuguese S517-1446-00 Romanian SC19-1704-00 Russian SC89-1275-00 Slovakian SC19-1442-00 Slovenian SC19-1574-00 Simplified Chinese S151-1982-00 Traditional Chinese SC27-3194-00
--------------------------------------------- --------------------- Installing and Configuring DB2 Connect Servers English SC27-5517-00 Bulgarian S19-1807-00 Czech SC19-3562-00 German SC12-4891-00 Spanish SC11-8369-00 French SC11-7326-00 Croatian SC19-1571-00 Hungarian SC22-1189-00 Japanese SA88-5285-00 Korean SA30-4536-00 Polish SC85-0510-00 Brazilian Portuguese S517-1447-00 Romanian SC19-1705-00 Russian SC89-1276-00 Slovakian SC19-1443-00 Slovenian SC19-1575-00 Simplified Chinese S151-1983-00 Traditional Chinese SC27-3195-00
--------------------------------------------- --------------------- Installing DB2 Servers English GC27-5514-00 Czech GC19-3559-00 German GC12-4888-00 Spanish GC11-8366-00 French GC11-7333-00 Japanese GA88-5282-00 Korean GA30-453-00 Polish GC85-0507-00 Brazilian Portuguese G517-1444-00 Russian GC89-1272-00 Simplified Chinese G151-1980-00 Traditional Chinese GC27-3192-00
--------------------------------------------- --------------------- Installing IBM Data Server Clients English GC27-5515-00 Bulgarian GC19-1805-00 Czech GC19-3560-00 German GC12-4889-00 Spanish GC11-8367-00 French GC11-7324-00 Croatian GC19-1569-00 Hungarian GC22-1187-00 Japanese GA88-5283-00 Korean GA30-4534-00 Dutch GC14-2094-00 Polish GC85-0505-00 Brazilian Portuguese G517-1445-00 Romanian GC19-1703-00 Russian GC89-1273-00 Slovakian GC19-1441-00 Slovenian GC19-1573-00 Simplified Chinese G151-1981-00 Traditional Chinese GC27-3193-00
--------------------------------------------- --------------------- Message Reference Volume 1 English SC27-5523-00 Czech SC19-3564-00 German SC12-4897-00 Spanish SC11-8373-00 French SC11-7329-00 Japanese SA88-5291-00 Dutch SC14-2098-00 Simplified Chinese S151-1989-00 Traditional Chinese SC27-3198-00 --------------------------------------------- --------------------- Message Reference Volume 2 English SC27-5524-00 Czech SC19-3565-00 German SC12-4898-00 Spanish SC11-8374-00 French SC11-7330-00 Japanese SA88-5292-00 Dutch SC14-2099-00 Simplified Chinese S151-1990-00 Traditional Chinese SC27-3199-00
--------------------------------------------- --------------------- Net Search Extender Administration and User's Guide English SC27-5526-00 German SC12-4900-00 Spanish SC11-8376-00 French SC11-7331-00 Hungarian SC22-1191-00 Japanese SA88-5294-00 Russian SC89-1278-00 Simplified Chinese S151-1991-00 --------------------------------------------- --------------------- Partitioning and Clustering Guide English SC27-5532-00 German SC12-4906-00 Japanese SA88-5300-00 Simplified Chinese S151-1996-00 --------------------------------------------- --------------------- pureXML Guide English SC27-5521-00 German SC12-4895-00 Japanese SA88-5289-00 Simplified Chinese S151-1987-00
--------------------------------------------- --------------------- RDF Application Development for IBM Data Servers Spanish SC11-8357-00 Japanese SA88-5271-00 --------------------------------------------- --------------------- Spatial Extender User's Guide and Reference English SC27-5525-00 German SC12-4899-00 Spanish SC11-8375-00 Japanese SA88-5293-00 Brazilian Portuguese S517-1450-00 Simplified Chinese S151-1991-00 --------------------------------------------- --------------------- SQL Procedural Languages: Application English SC27-5502-00 Enablement and Support Japanese SA88-5267-00 Simplified Chinese S151-1973-00 --------------------------------------------- --------------------- SQL Reference Volume 1 English SC27-5509-00 Spanish SC11-8361-00 Japanese SA88-5274-00
--------------------------------------------- --------------------- SQL Reference Volume 2 English SC27-5510-00 Spanish SC11-8360-00 Japanese SA88-5273-00 --------------------------------------------- --------------------- Text Search Guide English SC27-5527-00 German SC12-4901-00 Spanish SC11-8377-00 Japanese SA88-5295-00 Russian SC89-1280-00 --------------------------------------------- --------------------- Troubleshooting and Tuning Database Performance English SC27-4548-00 German SC12-4886-00 Japanese SA88-5266-00 Simplified Chinese S151-1972-00
--------------------------------------------- --------------------- Upgrading to DB2 Version 10.5 English SC27-5513-00 Czech SC19-3558-00 German SC12-4887-00 Spanish SC11-8365-00 French SC11-7332-00 Japanese SA88-5281-00 Korean SA30-4532-00 Polish SC85-0506-00 Brazilian Portuguese S517-1443-00 Russian SC89-1274-00 Simplified Chinese S151-1979-00 Traditional Chinese SC27-3191-00
--------------------------------------------- --------------------- What's New for DB2 Version 10.5 English SC27-5519-00 Bulgarian SC19-1809-00 German SC12-4893-00 Spanish SC11-8371-00 French SC11-7328-00 Croatian SC19-1811-00 Japanese SA88-5287-00 Korean SA30-4538-00 Dutch SC14-2097-00 Brazilian Portuguese S517-1449-00 Romanian SC19-1707-00 Russian SC89-1279-00 Slovakian SC19-1445-00 Slovenian SC19-1577-00 Simplified Chinese S151-1985-00 Traditional Chinese SC27-3197-00
--------------------------------------------- --------------------- XQuery Reference English SC27-5522-00 German SC12-4896-00 Japanese SA88-5290-00 Simplified Chinese S151-1988-00 --------------------------------------------- ---------------------
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.
Form number Title SG24-7821-00 Best Practices for DB2 on AIX® 6.1 for POWER® Systems TIPS0926 Continuous Availability with the IBM DB2 pureScale Feature SG24-8036-00 DB2 10 for Linux on System z® Using z/VM® v6.2, Single System Image Clusters and Live Guest Relocation SG24-7653-00 DB2 Deployment Guide SG24-7301-00 DB2 Express-C: The Developer Handbook for XML, PHP, C/C++, Java, and .NET SG24-7555-00 DB2 Security and Compliance Solutions for Linux, UNIX, and Windows REDP-4966-00 DB2 Web Query Tutorials Administrative Functions - Getting Started REDP-4968-00 DB2 Web Query Tutorials Building Dashboards and Compound Documents REDP-4969-00 DB2 Web Query Tutorials Going Mobile - Distribution and Mobile Device Support SG24-8018-00 Delivering Continuity and Extreme Capacity with the IBM DB2 pureScale Feature SG24-7218-00 Developing PHP Applications for IBM Data Servers SG24-7363-02 High Availability and Disaster Recovery Options for DB2 for Linux, UNIX, and Windows TIPS0932 Higher Performance and Lower Cost Solutions with IBM InfoSphere Warehouse V10 TIPS0974 IBM Flash Storage in OLAP Database Environments REDP-4740-00 IBM ILOG® ODM Enterprise and Data Integration SG24-6672-00 Microsoft SQL Server to IBM DB2 UDB Conversion Guide SG24-7736-01 Oracle to DB2 Conversion Guide: Compatibility Made Easy SG24-7259-00 Powering SOA with IBM Data Servers SG24-8031-00 Solving Operational Business Intelligence with InfoSphere Warehouse Advanced Edition TIPS0948 Turning Big Data into Actionable Information with IBM InfoSphere Streams SG24-8032-00 Unleashing DB2 10 for Linux, UNIX, and Windows SG24-6899-01 Up and Running with DB2 on Linux
For additional Redbooks , refer to
|
Technical information |
Specified operating environment
Hardware requirements
Minimum hardware requirements:
- 64-bit Windows and Linux : All systems based on Intel or AMD processors that are capable of running the supported Windows or Linux operating systems (x64 systems).
- AIX and Linux for IBM System p® and for IBM System i® systems: Systems with POWER5, or later processors are required.
- Solaris: Systems with UltraSPARC processors or x64 systems are required.
- HP-UX: Itanium-based HP Integrity Series systems are required.
- 32-bit Windows and Linux : All systems based on Intel or AMD processors that are capable of running the supported Windows or Linux operating 1 systems (x86-32 systems). DB2 images are available in DB2 Developer Edition only. These platforms are supported for non-production use only.
The hardware requirements of DB2 products may be occasionally updated. To obtain the current information for supported hardware, visit
Memory requirements: The amount of memory required for the IBM Data Server Runtime client depends on the operating system and the database applications that are running. In most cases, it should be sufficient to use the minimum memory requirements of the operating system as the minimum requirement for running the IBM Data Server Runtime client.
The following table shows the minimum memory in MB that is prerequisite to installation. The actual requirement depends on the applications you intend to run. Additional memory may be required to handle heavy workloads and a large number of concurrent users. The following numbers are for planning purposes only.
DB2 products and components Memory requirement DB2 for Linux, UNIX, and Windows (all editions) 256 MB Net Search Extender 256 MB
Disk space requirements: The following table shows the minimum disk space in MB for a typical installation. The actual space required may vary depending on your file system and the components installed. The following numbers are for planning purposes only.
DB2 products and components Memory requirement DB2 for Linux, UNIX, and Windows (all editions) 450 MB (1) IBM Data Server Runtime client 100 MB IBM Data Server Client 256 MB (2) DB2 Information Center 120 MB (3) Net Search Extender 50 MB
(1) Does not include any DB2 databases. An empty DB2 database requires 200 MB of disk space.
(2) Includes the JDK.
(3) English only. Other languages may require more disk space.
Software requirements
This section indicates the minimal requirements for operating systems at the time of this announcement.
Linux
- Red Hat Enterprise Linux (RHEL) 6
- SUSE Linux Enterprise Server (SLES) 10 and 11
- Linux for System i - SLES 10, SLES 11; 64 bit
- Linux for System i - RHEL 6; 64 bit
- Linux for System p - SLES 10, SLES 11; 64 bit
- Linux for System p - RHEL 6; 64 bit
- Linux for System z - SLES 10, SLES 11; 64 bit
- Linux for System z - RHEL 6; 64 bit
Windows
- 64-bit (x64) Windows Server 2008 R2, Standard Enterprise Server, and Datacenter Editions
- 64 bit (x64) Windows 7 and 8 Professional, Enterprise, Ultimate Editions
- 64 bit (x64) Windows 2012 Standard, Enterprise, Datacenter Editions
AIX
- AIX V6.1
- AIX V7.1
HP-UX
- HP-UX 11i v3 for HP Integrity servers (Itanium-based systems)
Solaris
- Solaris 10 for UltraSPARC or SPARC64 servers
- Solaris 10 for x64 servers
DB2 on Linux on System z is supported only on DB2 Enterprise Server Edition, DB2 Advanced Workgroup Server Edition, and DB2 Advanced Enterprise Server Edition.
The operating system support level for various DB2 products is frequently updated. To obtain the current information for supported software levels, including recommended maintenance levels, refer to
For more information, refer to the installation prerequisites in the documentation accompanying each product.
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
IBM DB2 Advanced Enterprise Server Edition for Linux , UNIX , and Windows 10.5 - Authorized User Single Install, PVU, and Terabyte options
Media:
- IBM DB2 Advanced Enterprise Server Edition - Quick Start and Activation DCD
- IBM DB2 Information Center DVDs
- IBM DB2 PDF documentation DVD
- IBM DB2 Advanced Enterprise Server Edition DVDs
- IBM Data Server Runtime Client DVDs
- IBM Data Server Client DVDs
- IBM Data Server Driver Package DVDs
- IBM DB2 Support Files for SSL Functionality DVD
- IBM DB2 Support Files for Advanced Copy Services Functionality DVD
- IBM DB2 Net Search Extender DVD
- IBM InfoSphere Data Replication - CDC for DB2 DVD
- IBM Data Studio V4.1 DVDs
- IBM InfoSphere Optim Performance Manager Extended Edition V5.3 DVDs
- IBM InfoSphere Optim Query Workload Tuner V4.1 DVDs
- IBM InfoSphere Optim Configuration Manager V3.1 DVDs
- IBM InfoSphere Optim pureQuery Runtime for Linux , UNIX , and Windows V3.3 DVDs
- IBM InfoSphere Data Architect V9.1 DVDs
- IBM Cognos Business Intelligence V10.2 DVDs
- IBM InfoSphere Warehouse Pack for Customer Insight V8.2 DVD
- IBM InfoSphere Warehouse Pack for Market and Campaign Insight V8.2 DVD
- IBM InfoSphere Warehouse Pack for Supply Chain Insight V8.2 DVD
- IBM WebSphere® Application Server V8.5 DVDs
- IBM WebSphere MQSeries® V7.5 DVDs
- IBM Tivoli System Automation for Multiplatform V3.2 - Window CD
- IBM Mobile Database Sync V1.0 DVDs
- IBM solidDB V7.0 DVDs
- IBM DB2 Warehouse Server DVDs
- IBM DB2 Warehouse Client DVDs
- IBM InfoSphere Federation Server V10.5 DVDs
IBM DB2 Enterprise Server Edition for Linux , UNIX , and Windows 10.5 - Authorized User Single Install and PVU options
Media:
- IBM DB2 Enterprise Server Edition - Quick Start and Activation DVD
- IBM DB2 Information Center DVDs
- IBM DB2 PDF documentation DVD
- IBM DB2 Server Edition DVDs
- IBM Data Server Runtime Client DVDs
- IBM Data Server Client DVDs
- IBM Data Server Driver Package DVDs
- IBM DB2 Support Files for SSL Functionality DVD
- IBM DB2 Support Files for Advanced Copy Services Functionality DVD
- IBM DB2 Net Search Extender DVD
- IBM Data Studio V4.1 DVDs
- IBM WebSphere Application Server V8.5 DVDs
- IBM WebSphere MQSeries V7.5 DVDs
- IBM Tivoli System Automation for Multiplatform V3.2 - Window CD
- IBM Mobile Database Sync V1.0 DVDs
- IBM DB2 Warehouse Server DVDs
- IBM DB2 Warehouse Client DVDs
IBM DB2 Advanced Workgroup Server Edition for Linux , UNIX , and Windows 10.5 - Authorized User Single Install, PVU, and Terabyte options
Media:
- IBM DB2 Advanced Workgroup Server Edition - Quick Start and Activation DVD
- IBM DB2 Information Center DVDs
- IBM DB2 PDF documentation DVD
- IBM DB2 Server DVDs
- IBM Data Server Runtime Client DVDs
- IBM Data Server Client DVDs
- IBM Data Server Driver Package DVDs
- IBM DB2 Support Files for SSL Functionality DVD
- IBM DB2 Support Files for Advanced Copy Services Functionality DVD
- IBM DB2 Net Search Extender DVD
- IBM InfoSphere Data Replication - CDC for DB2 DVD
- IBM Data Studio V4.1 DVDs
- IBM InfoSphere Optim Performance Manager Extended Edition V5.3 DVDs
- IBM InfoSphere Optim Query Workload Tuner V4.1 DVDs
- IBM InfoSphere Optim Configuration Manager V3.1 DVDs
- IBM InfoSphere Optim pureQuery Runtime for Linux , UNIX , and Windows V3.3 DVDs
- IBM InfoSphere Data Architect V9.1 DVDs
- IBM Cognos Business Intelligence 10.2 DVDs
- IBM InfoSphere Warehouse Pack for Customer Insight 8.2 DVD
- IBM InfoSphere Warehouse Pack for Market and Campaign Insight 8.2 DVD
- IBM InfoSphere Warehouse Pack for Supply Chain Insight 8.2 DVD
- IBM WebSphere Application Server 8.5 DVDs
- IBM WebSphere MQSeries 7.5 DVDs
- IBM Tivoli System Automation for Multiplatform 3.2 - Window CD
- IBM Mobile Database Sync 1.0 DVDs
- IBM solidDB 7.0 DVDs
- IBM DB2 Warehouse Server DVDs
- IBM DB2 Warehouse Client DVDs
- IBM InfoSphere Federation Server 10.5 DVDs
IBM DB2 Workgroup Server Edition for Linux , UNIX , and Windows 10.5 - Authorized User Single Install, PVU, and Limited Use Socket options
Media:
- IBM DB2 Workgroup Server Edition - Quick Start and Activation DVD
- IBM DB2 Information Center DVDs
- IBM DB2 PDF documentation DVD
- IBM DB2 Server DVDs
- IBM Data Server Runtime Client DVDs
- IBM Data Server Client DVDs
- IBM Data Server Driver Package DVDs
- IBM DB2 Support Files for SSL Functionality DVD
- IBM DB2 Support Files for Advanced Copy Services Functionality DVD
- IBM DB2 Net Search Extender DVD
- IBM Data Studio V4.1 DVDs
- IBM WebSphere MQSeries V7.5 DVDs
- IBM Tivoli System Automation Multiplatforms V3.2 for Windows CD
- IBM Mobile Database Sync V1.0 DVDs
IBM DB2 Express Server Edition for Linux , UNIX , and Windows 10.5 - Authorized User Single Install, PVU, Limited Use Virtual Server, and Fixed Term License options
Media:
- IBM DB2 Express Server Edition - Quick Start and Activation CD
- IBM DB2 Server DVDs
- IBM DB2 Support Files for Advanced Copy Services Functionality DVD
- IBM DB2 Net Search Extender DVD
- IBM Data Studio 4.1 DVDs DVD
- IBM WebSphere MQSeries 7.5 DVDs
- IBM Tivoli System Automation Multiplatforms 3.2 for Windows CD
- IBM Mobile Database Sync 1.0 DVD
IBM DB2 Developer Edition for Linux , UNIX , and Windows 10.5 - Authorized User option
Media:
- IBM DB2 Developer Edition - Quick Start and Activation CD
- IBM DB2 Information Center DVDs
- IBM DB2 PDF documentation DVD
- IBM DB2 Server DVDs
- IBM DB2 Connect Personal Edition DVDs
- IBM Data Server Runtime Client DVDs
- IBM Data Server Client DVDs
- IBM Data Server Driver Package DVDs
- IBM DB2 Support Files for SSL Functionality DVD
- IBM DB2 Support Files for Advanced Copy Services Functionality DVD
- IBM DB2 Net Search Extender DVD
- IBM InfoSphere Data Replication - CDC for DB2 DVD
- IBM Data Studio V4.1 DVDs
- IBM InfoSphere Optim Performance Manager Extended Edition V5.3 DVDs
- IBM InfoSphere Optim Query Workload Tuner V4.1 DVDs
- IBM InfoSphere Optim Configuration Manager V3.1 DVDs
- IBM InfoSphere Optim pureQuery Runtime for Linux , UNIX , and Windows V3.3 DVDs
- IBM InfoSphere Data Architect V9.1 DVDs
- IBM Cognos Business Intelligence V10.2 DVDs
- IBM InfoSphere Warehouse Pack for Customer Insight V8.2 DVD
- IBM InfoSphere Warehouse Pack for Market and Campaign Insight V8.2 DVD
- IBM InfoSphere Warehouse Pack for Supply Chain Insight V8.2 DVD
- IBM WebSphere Application Server V8.5 DVDs
- IBM WebSphere MQSeries V7.5 DVDs
- IBM Tivoli System Automation for Multiplatform V3.2 - Windows CD
- IBM Mobile Database Sync V1.0 DVDs
- IBM solidDB V7.0 DVDs
- IBM DB2 Warehouse Server DVDs
- IBM DB2 Warehouse Client DVDs
- IBM InfoSphere Federation Server V10.5 DVDs
IBM DB2 Advanced Recovery Feature for Linux , UNIX , and Windows 10.5
Media:
- IBM DB2 Merge Backup for Linux , UNIX , and Windows 2.1 DVD
- IBM DB2 Recovery Expert for Linux , UNIX , and Windows 4.1 DVD
- IBM Optim High Performance Unload for DB2 for Linux , UNIX , and Windows 5.1 DVD
InfoSphere Federation Server
Media
- InfoSphere Federation Server DVDs
This program, when downloaded from a website, contains the applicable IBM license agreement and License Information, if appropriate, which will be presented for acceptance at the time of installation of the program. For future reference, the license and License Information will be stored in a directory such as LICENSE.TXT.
Security, auditability, and control
IBM DB2 for Linux , UNIX , and Windows V10.5 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.
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, or integration of this product.
|
Ordering information |
For ordering information, consult your IBM representative or authorized IBM Business Partner, or visit
Passport Advantage®
Part number Program name/Description
Passport Advantage program licenses
5724N76 IBM DB2 Developer Edition
D58N5LL DB2 DEVELOPER EDITION AU LIC + SW S&S 12 MO&S Rnwl E02MRLL DB2 DEVELOPER EDITION AU ANNUAL SW S&S RNWLS 12 Mo D58N6LL DB2 DEVELOPER EDITION AU SW S&S REINSTATE 12 MOe 12 Mo D58N7LL DB2 DEVELOPER EDITION AUTH USR LNX ON Z LIC + SW S&S 12 MO E02MSLL DB2 DEVELOPER EDITION AUTH USER LNX ON Z ANNUAL SW S&S RNWL D58N8LL DB2 DEVELOPER EDITION AUTH USR LNX ON Z SW S&S REINSTATE 12 MO
5725L47 IBM DB2 Advanced Enterprise Server Edition
D0ZVILL IBM DB2 Advanced Enterprise Server Edition AUSI Lic + SW S&S 12 Mo E0HQBLL IBM DB2 Advanced Enterprise Server Edition AUSI Annual SW S&S Rnwl D0ZVJLL IBM DB2 Advanced Enterprise Server Edition AUSI SW S&S Reinstate 12 Mo D0ZVFLL IBM DB2 Advanced Enterprise Svr Edi AUSI Lnx Sys z Lic + SW S&S 12 Mo E0HQALL IBM DB2 Advanced Enterprise Svr Edi AUSI Lnx Sys z Annual SW S&S Rnwl D0ZVGLL IBM DB2 Advanced Enterprise Svr Edi AUSI Lnx Sys z SW S&S Reinstate 12 Mo D0ZUTLL IBM DB2 Advanced Enterprise Server Edition PVU Lic + SW S&S 12 Mo E0HPVLL IBM DB2 Advanced Enterprise Server Edition PVU Annual SW S&S Rnwl D0ZUULL IBM DB2 Advanced Enterprise Server Edition PVU SW S&S Reinstate 12 Mo D0ZUXLL IBM DB2 Advanced Enterprise Svr Ed PVU Lnx Sys z Lic + SW S&S 12 Mo E0HPWLL IBM DB2 Advanced Enterprise Svr Ed PVU Lnx Sys z Annual SW S&S Rnwl D0ZV0LL IBM DB2 Advanced Enterprise Svr Ed PVU Lnx Sys z SW S&S Reinstate 12 Mo D0ZUFLL IBM DB2 Advanced Enterprise Server Edition Terabyt Lic + SW S&S 12 Mo E0HPNLL IBM DB2 Advanced Enterprise Server Edition Terabyt Annual SW S&S Rnwl D0ZUILL IBM DB2 Advanced Enterprise Server Edition Terabyt SW S&S Reinstate 12 Mo D0ZUNLL IBM DB2 Advanced Enterprise Svr Ed Trbt Lnx S z Lic + SW S&S 12 Mo E0HPTLL IBM DB2 Advanced Enterprise Svr Ed Trbt Lnx S z Annual SW S&S Rnwl D0ZUPLL IBM DB2 Advanced Enterprise Svr Ed Trbt Lnx S z SW S&S Reinstate 12 Mo
5725L16 IBM DB2 Advanced Recovery Feature
D0ZSALL IBM DB2 Adv Recovery Feature Auth User Sngl Instl Lic + SW S&S 12 Mo E0HNWLL IBM DB2 Adv Recovery Feature Auth User Sngl Instl Annual SW S&S Rnwl D0ZSBLL IBM DB2 Adv Recovery Feature Auth User Sngl Instl SW S&S Reinstate 12 Mo D0ZSCLL IBM DB2 Advanced Recovery Feature AUSI Lnx Sys z Lic + SW S&S 12 Mo E0HNXLL IBM DB2 Advanced Recovery Feature AUSI Lnx Sys z Annual SW S&S Rnwl D0ZSDLL IBM DB2 Advanced Recovery Feature AUSI Lnx Sys z SW S&S Reinstate 12 Mo D0ZSELL IBM DB2 Advanced Recovery Feature PVU Lic + SW S&S 12 Mo E0HNYLL IBM DB2 Advanced Recovery Feature PVU Annual SW S&S Rnwl D0ZSFLL IBM DB2 Advanced Recovery Feature PVU SW S&S Reinstate 12 Mo D0ZSGLL IBM DB2 Advanced Recovery Feature PVU Lnx Sys z Lic + SW S&S 12 Mo E0HNZLL IBM DB2 Advanced Recovery Feature PVU Lnx Sys z Annual SW S&S Rnwl D0ZSHLL IBM DB2 Advanced Recovery Feature PVU Lnx Sys z SW S&S Reinstate 12 Mo D0ZT3LL IBM DB2 Advanced Recovery Feature Terabyte Lic + SW S&S 12 Mo E0HP8LL IBM DB2 Advanced Recovery Feature Terabyte Annual SW S&S Rnwl D0ZT4LL IBM DB2 Advanced Recovery Feature Terabyte SW S&S Reinstate 12 Mo D0ZT5LL IBM DB2 Advanced Recovery Feature Terabyte Lnx Syz Lic + SW S&S 12 Mo E0HP9LL IBM DB2 Advanced Recovery Feature Terabyte Lnx Syz Annual SW S&S Rnwl D0ZT6LL IBM DB2 Advanced Recovery Feature Terabyte Lnx Syz SW S&S Reinstate 12
5765F41 DB2 Enterprise Server Edition
D56CILL DB2 ENTERPRISE SERVER EDITION AU SI LIC + SW S&S 12 MO E028NLL DB2 ENTERPRISE SERVER EDITION AUTHUSRSI ANNUAL SW S&S RNWL D56CJLL DB2 ENTERPRISE SERVER EDITION AUTHUSR SI SW S&S REINSTATE 12 MO D55IULL DB2 ENTERPRISE SERVER EDITION PVU LIC + SW S&S 12 MO E020CLL DB2 ENTERPRISE SERVER EDITION PVU ANNUAL SW S&S RNWL D55IVLL DB2 ENTERPRISE SERVER EDITION PVU SW S&S REINSTATE 12 MO D55IXLL DB2 ENTERPRISE SERVER EDITION PVU FR WSE PR TU LIC + SW S&S 12 MO D55J0LL DB2 ENTERPRISE SERVER EDITION FOR LINUX ON Z PVU LIC + SW S&S 12 MO E020ELL DB2 ESE FOR LINUX ON Z PVU ANNUAL SW S&S RNWL D55J1LL DB2 ENTERPRSE SERVER ED FOR LINUX ON Z PVU SW S&S REINSTATE 12 MO
5724E49 IBM DB2 Express Server Edition
D52BKLL DB2 EXPRESS SERVER EDITION AUTHUS SI LIC + SW S&S 12 MO E00QULL DB2 EXPRESS SERVER EDITION AUTHUS SI ANNUAL SW S&S RNWL D52BLLL DB2 EXPRESS SERVER EDITION AUTHUSR SI SW S&S REINSTATE 12 MO D0A11LL DB2 EXPRESS SERVER EDITION LIMITED USE VIRTUAL SERVER LIC + SW S&S 12 MO E07BNLL DB2 EXPRESS SERVER EDITION LIMITED USE VIRTUAL SERVER ANNUAL SW S&S RNWL D0A12LL DB2 EXPRESS SERVER EDITION LIMITED USE VIRTUAL SERVER SW S&S REINSTATE 12 MO D55TULL IBM DB2 EXPRESS SERVER EDITION PVU LIC + SW S&S 12 MO E024QLL IBM DB2 EXPRESS SERVER EDITION PVU ANNUAL SW S&S RNWL D55TVLL IBM DB2 EXPRESS SERVER EDITION PVU SW S&S REINSTATE 12 MO D60PLLL IBM DB2 EXPRESS SERVER ED FTL 12 MONTHS LICENSE AND SUBSCRIPTION PER SERVER E03NALL IBM DB2 EXPRESS SERVER ED SVR SUBSQ FT LIC + SW S&S 12 MO
5725L15 IBM DB2 Advanced Workgroup Server Edition
D0ZSILL IBM DB2 Advanced Workgroup Server Edition AUSI Lic + SW S&S 12 Mo E0HP0LL IBM DB2 Advanced Workgroup Server Edition AUSI Annual SW S&S Rnwl D0ZSJLL IBM DB2 Advanced Workgroup Server Edition AUSI SW S&S Reinstate 12 Mo D0ZSLLL IBM DB2 Advanced Workgroup Svr Edition AUSI Lnx Sz Lic + SW S&S 12 Mo E0HP1LL IBM DB2 Advanced Workgroup Svr Edition AUSI Lnx Sz Annual SW S&S Rnwl D0ZSMLL IBM DB2 Advanced Workgroup Svr Edition AUSI Lnx Sz SW S&S Reinstate 12 Mo D0ZSQLL IBM DB2 Advanced Workgroup Server Edition PVU Lic + SW S&S 12 Mo E0HP3LL IBM DB2 Advanced Workgroup Server Edition PVU Annual SW S&S Rnwl D0ZSRLL IBM DB2 Advanced Workgroup Server Edition PVU SW S&S Reinstate 12 Mo D0ZSNLL IBM DB2 Advanced Workgroup Svr Edition PVU Lnx Sz Lic + SW S&S 12 Mo E0HP2LL IBM DB2 Advanced Workgroup Svr Edition PVU Lnx Sz Annual SW S&S Rnwl D0ZSPLL IBM DB2 Advanced Workgroup Svr Edition PVU Lnx Sz SW S&S Reinstate 12 Mo D0ZSWLL IBM DB2 Advanced Workgroup Server Edition Terabyte Lic + SW S&S 12 Mo E0HP5LL IBM DB2 Advanced Workgroup Server Edition Terabyte Annual SW S&S Rnwl D0ZSXLL IBM DB2 Advanced Workgroup Server Edition Terabyte SW S&S Reinstate 12 Mo D0ZSTLL IBM DB2 Advanced Workgroup Svr Edition Trbt Lnx Sz Lic + SW S&S 12 Mo E0HP4LL IBM DB2 Advanced Workgroup Svr Edition Trbt Lnx Sz Annual SW S&S Rnwl D0ZSULL IBM DB2 Advanced Workgroup Svr Edition Trbt Lnx Sz SW S&S Reinstate 12 Mo
5765F35 DB2 Workgroup Server Edition
D0A1LLL DB2 WORKGROUP SERVER EDITION LIMITED USE SOCKET LIC + SW S&S 12 MO E07BQLL DB2 WORKGROUP SERVER EDITION LIMITED USE SOCKET ANNUAL SW S&S RNWL D0A1MLL DB2 WORKGROUP SERVER EDITION LIMITED USE SOCKET SW S&S REINSTATE 12 MO D55TWLL IBM DB2 WORKGROUP SERVER ED PVU LIC + SW S&S 12 MO E024RLL IBM DB2 WORKGROUP SERVER ED PVU ANNUAL SW S&S RNWL D55TXLL IBM DB2 WORKGROUP SERVER ED PVU SW S&S REINSTATE 12 MO D5B77LL DB2 WORKGROUP SERVER EDITION AUTHUSSI LIC + SW S&S 12 MO E1B79LL DB2 WORKGROUP SERVER EDITION AUTHUSSI ANNUAL SW S&S RNWL D5B7ALL DB2 WORKGROUP SERVER EDITION AUTHURSI SW S&S REINSTATE 12 MO
5724N97 InfoSphere Federation Server
E04NXLL IBM InfoSphere Federation Server Linux for System z Processor Value Unit (PVU) Annual SW Subscription & Support Renewal D03SCLL IBM InfoSphere Federation Server Linux for System z Processor Value Unit (PVU) License + SW Subscription & Support 12 Months D03SDLL IBM InfoSphere Federation Server Linux for System z Processor Value Unit (PVU) SW Subscription & Support Reinstatement 12 Months E03Y8LL IBM InfoSphere Federation Server Processor Value Unit (PVU) Annual SW Subscription & Support Renewal D61B6LL IBM InfoSphere Federation Server Processor Value Unit (PVU) License + SW Subscription & Support 12 Months D61B7LL IBM InfoSphere Federation Server Processor Value Unit (PVU) SW Subscription & Support Reinstatement 12 Months E04NULL IBM InfoSphere Federation Server Developer Edition Linux for System z Authorized User Annual SW Subscription & Support Renewal E03Y7LL IBM InfoSphere WebSphere Federation Server Developer Edition Authorized User Annual SW Subscription & Support Renewal D61B4LL IBM InfoSphere WebSphere Federation Server Developer Edition Authorized User License + SW Subscription & Support 12 Months D61B5LL IBM InfoSphere WebSphere Federation Server Developer Edition Authorized User SW Subscription & Support Reinstatement 12 Months D03S6LL IBM InfoSphere WebSphere Federation Server Developer Edition Linux for System z Authorized User License + SW Subscription & Support 12 Months D03S7LL IBM InfoSphere WebSphere Federation Server Developer Edition Linux for System z Authorized User SW Subscription & Support Reinstatement 12 Months
Passport Advantage trade up
You must have previously acquired licenses for the following precursor products to be eligible to acquire equivalent licenses of the trade-up products.
5725L47 IBM DB2 Advanced Enterprise Server Edition DB2 Advanced ESE AU fr DB2 ESE AU Trdup Lic + SW S&S 12 Mo D0ZVSLL DB2 AESE AUSI z fr DB2 ESE AU Trdup Lic + SW S&S 12 Mo D0ZVHLL DB2 AESE PVU fr DB2 ESE PVU Trdup Lic + SW S&S 12 Mo D0ZVTLL DB2 AESE PVU fr DB2 ESE + OPM PVU Trdup Lic + SW S&S 12 Mo D0ZUVLL DB2 AESE PVU fr DB2 for SAP Applications Trdup Lic + D0ZUWLL SW S&S 12 Mo DB2 AESE PVU LnxZ fr DB2 ESE PVU Trdup Lic + SW S&S 12 Mo D0ZVULL
5725L15 IBM DB2 Advanced Workgroup Server Edition DB2 AWSE AUSI fr DB2 WSE AUSI Trdup Lic + SW S&S 12 Mo D0ZSKLL DB2 AWSE PVU fr DB2 WSE PVU Trdup Lic + SW S&S 12 Mo D0ZSSLL
5765F35 DB2 Workgroup Server Edition DB2 WSE AUSI FR DB2 EXPRESS AUSI TRDUP LIC + SW S&S 12 MO D58Z4LL DB2 WSE Limited Use Socket from DB2 WSE 100 PVU Trdup D0A1NLL Lic + SW S&S 12 Mo IBM DB2 WORKGROUP SERVER ED PVU TRDUP LIC + SW S&S 12 MO D55TYLL IBM DB2 WORKGROUP SERVER ED PVU TRDUP LIC + SW S&S 12 MO D55TZLL DB2 WSE AUSI FROM QUAL COMPETITOR AUTH USER TRDUP LIC + D58Z5LL SW S&S 12 MO
5765F41 DB2 Enterprise Server Edition for Linux, UNIX, and Windows DB2 ESE PVU FR DB2 ESE RESTR USE TRDUP LIC + SW S&S 12 MO D570VLL DB2 ENTERPRISE SVR ED AUSIFR QUALIFIED COMPETITOR TRDUP D58YULL LIC + SW S&S 12 MO DB2 ENTERPRISE SERVER ED PVU FR QUAL COMP PR TU LIC + SW D55IWLL S&S 12 MO DB2 ENTERPRISE SERVER EDITION PVU FR WSE PR TU LIC + SW D55IXLL S&S 12 MO DB2 ENTERPRISE SERVER ED AUSI FR WSE AUSI TRDUP D58YTLL LIC + SW S&S 12 MO
5724E49 IBM DB2 Express Server Edition D0A1TLL DB2 EXPRESS SERVER EDITION LUVS FR EXE 200 PVUS TRDUP TRDUP LIC + SW S&S 12 MO
Passport Advantage customer: Media pack entitlement details
Customers with active maintenance or subscription for the products listed are entitled to receive the corresponding media pack.
Media Packs description Part number 5724N76 IBM DB2 Developer Edition IBM Developer Edition V10.5 Win Lnx AIX HP-UX Sol MP ML BB1EBML
5725L47 IBM DB2 Advanced Enterprise Server Edition DB2 ADVANCED ENTERPRISE SERVER EDITION AU OPTION V10.5 BB1EJML MP ML MP DB2 ADVANCED ENTERPRISE SERVER EDITION PVU OPTION V10.5 BB1EKML MP ML MP DB2 ADVANCED ENTERPRISE SERVER EDITION TERABYTE V10.5 BB1FFML MP ML MP
5725L16 IBM DB2 Advanced Recovery Feature DB2 Advanced Recovery Feature 10.5 MP ML BB1FGML
5765F41 DB2 Enterprise Server Edition DB2 Enterprise Server Edition AU Option V10.5 Win AIX HP-UX Linux Sol MP ML BB1ELML DB2 Enterprise Server Edition PVU Option V10.5 MP MLMedPk BB1EMML
5724E49 IBM DB2 Express Server Edition DB2 Express Server Edition AU Option V10.5 MP ML BB1ENML DB2 Express Server Edition PVU Option V10.5 MP ML BB1EPML DB2 Express Server Edition Svr Option V10.5 MP ML BB1EQML DB2 Express Server Edition FTLSvr Option V10.5 MP ML BB1ERML
5725L15 IBM DB2 Advanced Workgroup Server Edition DB2 Advanced Workgroup Server Edition AU Opt10.5 ML MP MP BB1FJML DB2 Advanced Workgroup Server Edition PVU Opt10.5 ML MP MP BB1FKML DB2 Advanced Workgroup Server Edition TB Opt10.5 ML MP MP BB1FLML
5765F35 DB2 Workgroup Server Edition DB2 Workgroup Server Edition Authorized User V10.5 MP ML BB1ESML DB2 Workgroup Server Edition PVU V10.5 MP ML BB1ETML DB2 Workgroup Server Edition Socket V10.5 MP ML BB1EUML
5724N97 InfoSphere Federation Server IBM InfoSphere Federation Server V10.5 MP Multilingual BB1FDML Media Pack IBM InfoSphere Federation Server Dev Ed V10.5 MP BB1FEML Multilingual Media Pack
Charge metric
Program name PID number Charge metric
IBM DB2 Advanced CEO 5725-E89 Per Authorized User IBM DB2 Advanced CEO 5725-E89 Per Authorized User for Linux on System z IBM DB2 Advanced Enterprise Server 5725-L47 Per Authorized Edition User Single Install IBM DB2 Advanced Enterprise Server 5725-L47 Per Authorized Edition for Linux on System Z User Single Install IBM DB2 Advanced Enterprise Server 5725-L47 Processor-Day(s) Edition IBM DB2 Advanced Enterprise Server 5725-L47 Per Processor Edition Value Unit (PVU) IBM DB2 Advanced Enterprise Server 5725-L47 Per Processor Value Unit Edition for Linux on System Z IBM DB2 Advanced Enterprise Server 5725-L47 Per Terabyte Edition IBM DB2 Advanced Enterprise Server 5725-L47 Per Terabyte Edition for Linux on System z
IBM DB2 Advanced Workgroup Server 5725-L15 Per Authorized Edition User Single Install IBM DB2 Advanced Workgroup Server 5725-L15 Per Authorized Edition for Linux on System Z User Single Install IBM DB2 Advanced Workgroup Server 5725-L15 Per Processor(s) Edition Value Unit (PVU) IBM DB2 Advanced Workgroup Server 5725-L15 Per Processor Value Edition for Linux on System Z Unit IBM DB2 Advanced Workgroup Server 5725-L15 Per Terabyte Edition IBM DB2 Advanced Workgroup Server 5725-L15 Per Terabyte Edition for Linux on System z
IBM DB2 CEO 5724-R28 Per Authorized User IBM DB2 Enterprise Server Edition 5765-F41 Per Authorized User Single Install IBM DB2 Enterprise Server Edition 5765-F41 Per Processor Value Unit (PVU) IBM DB2 Enterprise Server Edition 5765-F41 Per Processor Value For Linux on System Z Value Unit (PVU) IBM DB2 Enterprise Server Edition 5765-F41 Processor-Day(s)
IBM DB2 Express Server Edition 5724-E49 Per Authorized User Single Install IBM DB2 Express Server Edition 5724-E49 Fixed term License IBM DB2 Express Server Edition 5724-E49 Per Processor Value Unit (PVU) IBM DB2 Express Server Edition 5724-E49 Per Limited Use Virtual Server IBM DB2 Workgroup Server Edition 5765-F35 Per Authorized User Single Install IBM DB2 Workgroup Server Edition 5765-F35 Per Processor Value Unit (PVU) IBM DB2 Workgroup Server Edition 5765-F35 Per Limited Use Socket
IBM DB2 Developer 5724-N76 Per Authorized Edition for Linux on System Z User for Linux on z IBM DB2 Developer 5724-N76 PA Per Authorized User Edition
IBM DB2 IBM DB2 Advanced Recovery 5725-L16 Per Authorized User Feature Linux on System Z Single Install IBM DB2 IBM DB2 Advanced Recovery 5725-L16 Per Processor Feature Linux on System Z Value Unit (PVU) IBM DB2 IBM DB2 Advanced Recovery 5725-L16 Per Terabyte Feature Linux on System Z IBM DB2 IBM DB2 Advanced Recovery 5725-L16 Per Authorized User Feature Single Install IBM DB2 IBM DB2 Advanced Recovery 5725-L16 Per Processor Feature Value Unit (PVU) IBM DB2 IBM DB2 Advanced Recovery 5725-L16 Per Terabyte Feature
IBM InfoSphere Federation Server 5724-N97 Per Processor Linux for System z Value Unit (PVU) IBM InfoSphere Federation Server 5724-N97 Per Processor Value Unit (PVU) IBM InfoSphere Federation Server 5724-N97 Authorized User Developer Edition IBM InfoSphere Federation Server 5724-N97 Authorized User Developer Edition for System z
Processor Value Unit (PVU)
PVU is a unit of measure by which the program can be licensed. The number of PVU entitlements required is based on the processor technology (defined within the PVU table by processor value, brand, type, and model number at the website below) and the number of processors made available to the program. IBM continues to define a processor, for the purpose of PVU-based licensing, to be each processor core on a chip. A dual-core processor chip, for example, has two processor cores. The PVU table can be found at
Licensee can deploy the program using either full capacity licensing or virtualization capacity (sub-capacity) licensing according to the Passport Advantage Sub-Capacity Licensing Terms (refer to the web page below). If using Full Capacity licensing, Licensee must obtain PVU entitlements sufficient to cover all activated processor cores* in the physical hardware environment made available to or managed by the Program, except for those servers from which the Program has been permanently removed. If using Virtualization Capacity licensing, Licensee must obtain entitlements sufficient to cover all activated processor cores made available to or managed by the Program, as defined according to the Virtualization Capacity License Counting Rules at
* An activated processor core is a processor core that is available for use in a physical or virtual server, regardless of whether the capacity of the processor core can be or is limited through virtualization technologies, operating system commands, BIOS settings, or similar restrictions.
Notes :
- Some programs may require licenses for the program and what is being managed. In that case, the following applies. In addition to the entitlements required for the program directly, licensee must obtain PVU entitlements for this program sufficient to cover the processor cores managed by the program.
- Some programs may be licensed on a managed basis only. In that case, the following applies. Instead of the entitlements required for the program directly, licensee must obtain PVU entitlements for this program sufficient to cover the processor cores managed by the program.
- A few programs on an exception basis may be licensed on a referenced basis. In that case, the following applies. Rather than obtaining entitlements for the activated processor cores available to the program, licensee must obtain PVU entitlements for this program sufficient to cover the environment made available to the referenced program as if the program itself were executing everywhere the referenced program was executing, independent of the basis on which the referenced program is licensed.
Basic license
On/Off Capacity on Demand (CoD)
Part number Description D0ZUJLL DB2 AESE Proc Day OOCoD Temp Use Chrg ASQC8LL DB2 ENTERPRISE SERVER ED CPU OPT PROCESSOR DAY OOCOD TEMP USE CHRG D61TALL IBM InfoSphere Federation Server Processor Day OOCod Temporary Use Charge
Customized Offerings
Product deliverables are shipped only via CBPDO, ServerPac, SystemPac® , FunctionPac, and ProductPac® .
All of 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, refer to the Shopz 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 include:
- 3590
- 3592
Most products can be ordered in ServerPac, SystemPac , FunctionPac, and ProductPac the month following their availability in CBPDO. z/OS® can be ordered via CBPDO, ServerPac, and SystemPac 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, visit the Help section on the Shopz web site at
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 , FunctionPac, and ProductPac shipments will begin four weeks after general availability due to additional customization, and data input verification.
|
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 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. Part number products only, offered outside of Passport Advantage , where applicable, are license only and do not include Software Maintenance.
The following agreement applies for Software Subscription and Support (Software Maintenance) and does not require customer 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 System z Operational Support Services - SoftwareXcel is an option if you desire added services.
License Information form number
Program Form Program name number number DB2 Advanced Enterprise Server Edition 5725-L47 L-VACA-92XQMK DB2 Enterprise Server Edition 5765-F41 L-VACA-93QRGR DB2 Advanced Workgroup Server Edition 5725-L15 L-VACA-93QS97 DB2 Workgroup Server Edition 5765-F35 L-VACA-93QT4S DB2 Express Edition 5724-E49 L-VACA-93QTU6 IBM DB2 Developer Edition 5724-N76 L-VACA-93QV2V IBM DB2 Advanced Recovery Feature 5725-L16 L-VACA-94LMF2 InfoSphere Federation Server 5724-N97 L-JTRE-94T4JK InfoSphere Federation Server 5724-N97 L-JTRE-94T63H Developer Edition
The program's License Information will be available for review on the IBM Software License Agreement website
Limited warranty applies
Yes
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 (1) for programs acquired under the IBM International Passport Advantage offering, this term applies only to your first acquisition of the program and (2) 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)
Yes. Contact your IBM representative.
Passport Advantage applies
Yes, and through the Passport Advantage website at
Software Subscription and Support applies
Yes. Software Subscription and Support (also referred to as Software Maintenance) is included with licenses purchased through Passport Advantage and Passport Advantage Express . Product upgrades and Technical Support are provided by the Software Subscription and Support offering as described in the Agreements. Product upgrades provide the latest versions and releases to entitled software and Technical Support provides voice and electronic access to IBM support organizations, worldwide.
IBM includes one year of Software Subscription and Support with each program license acquired. The initial period of Software Subscription and Support can be extended by the purchase of a renewal option, if available.
While your Software Subscription and Support is in effect, IBM provides you assistance for your routine, short-duration installation and usage (how-to) questions, and code-related questions. IBM provides assistance via telephone and, if available, electronic access, only to your information systems (IS) technical support personnel during the normal business hours (published prime shift hours) of your IBM support center. (This assistance is not available to your end users.) IBM provides Severity 1 assistance 24 hours a day, 7 days a week. For additional details, consult your IBM Software Support Handbook at
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, or failures caused by products for which IBM is not responsible under the applicable agreements.
For additional information about the International Passport Advantage Agreement and the IBM International Passport Advantage Express Agreement, visit the Passport Advantage website at
System i Software Maintenance applies
Yes
Variable charges apply
No
Educational allowance available
Education allowance does not apply.
Education software allowance does not apply.
Special education prices are available for qualified customers through Passport Advantage .
Sub-capacity utilization determination
Sub-capacity utilization is determined based on the utilization of an eligible operating system and machine (for example, z/OS running in z/Architecture® (64 bit) mode on a System z (or equivalent) server).
On/Off Capacity on Demand (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 System z 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 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 comprehensive security approach, which will necessarily involve additional operational procedures, and may require other systems, products, or services to be most effective. IBM does not warrant that systems and products are immune from the malicious or illegal conduct of any party.
|
IBM Electronic Services |
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 5.3, AIX 6.1, and AIX 7.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
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 customers a single point of exit from their site. Communication is one way. Activating Electronic Service Agent does not enable IBM to call into a customer's system. System inventory information is stored in a secure database, which is protected behind IBM firewalls. It is viewable only by the customer and IBM . The customer's business applications or business data is never transmitted to IBM .
More accurate reporting: Since system information and error logs are automatically uploaded to the IBM Support center in conjunction with the service request, customers 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, customers can view system and support information in the "My Systems" and "Premium Search" sections of the Electronic Support website at
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 the customer's 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, customers are able to see search results that apply specifically to their systems.
For more information on how to utilize the power of IBM Electronic Services, contact your IBM Systems Services Representative, or visit
|
Prices |
Passport Advantage
For Passport Advantage information and charges, contact your IBM representative or authorized IBM Business Partner for Software Value Plus. Additional information is also available at
For all local charges, contact your IBM representative.
Business Partner information
If you are an IBM Business Partner -- Distributor for Workstation Software acquiring products from IBM , you may link to Passport Advantage Online for resellers where you can obtain Business Partner pricing information. An IBM ID and password are required.
|
Announcement countries |
All European, Middle Eastern, and African countries.
Trademarks
Optim, DB2 Connect and Electronic Service Agent are trademarks of IBM Corporation in the United States, other countries, or both.
IBM, DB2, pureScale, InfoSphere, Express, pureQuery, Informix, solidDB, Cognos, pureXML, Tivoli, Redbooks, AIX, POWER, System z, z/VM, ILOG, System p, System i, WebSphere, MQSeries, Global Technology Services, Passport Advantage, SystemPac, ProductPac, z/OS 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.
UNIX is a registered trademark of The Open Group in the United States and other countries.
Windows and Microsoft are trademarks of Microsoft Corporation in the United States, other countries, or both.
Intel is a trademark of Intel Corporation or its subsidiaries 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. 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
For the most current information regarding IBM products, consult your IBM representative or reseller, or visit the IBM worldwide contacts page