IBM DB2 10.1 for Linux , UNIX , and Windows makes
it easier for you to develop database applications, and helps you
speed your database application deployment
IBM United States
Software Announcement 212-074
April 3, 2012
IBM® DB2® 10.1
for Linux™, UNIX™, and Windows™ (LUW)
reduces your overall database licensing, administration, and storage
costs. DB2 10.1
for LUW offers:
- PL/SQL compatibility, integrated time-based analytics, and SPARQL
support for new "no SQL" applications, helping to speed up application
development
- Simplified administration and optimal use of your data storage
resources with multi-temperature storage
- Extreme scalability and availability with DB2 pureScale®
- Adaptive compression, helping to lower storage
- Flexible definitions of role and data access control, helping
you improve security
- A suite of complementary products to manage database performance,
deployment, administration, monitoring, and availability that is included
in the DB2 Advanced
Enterprise Server Edition
For ordering, contact your IBM representative or an IBM Business
Partner. For more information contact the Americas Call Centers at
800-IBM-CALL (426-2255).
Reference: YE001
Back to top
IBM DB2 10.1
for Linux, UNIX, and Windows (LUW)
delivers new capabilities that can help you save time and money. DB2 10.1
can help you reduce the complexity of management, improve the productivity
of your developers and database administrators, ease the effort and
expense of deploying new applications, and take advantage of query
performance and compression improvements to help lower your overall
data management cost.
DB2 10.1
LUW offers greater management efficiency. Multi-temperature storage
helps you to leverage different types of storage to maximize performance
at the lowest possible cost with integrated management of storage
groups to migrate hot, warm, and cold data to the appropriate class
of storage. New Row and Column Access Control provides you with easy
and flexible rule and role definitions to manage and control data
accesses for enhanced security and the building of multi-tenant applications.
Continuous Data Ingest is designed to enable you to transparently
load data from external sources into DB2 databases without downtime for
integrated real-time analysis and decision making.
DB2 10.1
LUW includes the PL/SQL compatibility feature, which can help speed
application development, and help reduce your time to market as well
as costs. Time Travel Query is integrated into DB2 for
easier and faster time-based analytics applications development. SPARQL
support enables new types of "no SQL" applications development with
Resource Definition Framework (RDF) data stores.
DB2 10.1
LUW is designed to deliver fast performance and high reliability for
your enterprise. IBM DB2 pureScale leverages proven mainframe Sysplex
technology to deliver extreme redundancy and scalability. Adaptive
compression, the latest addition to DB2's industry-leading database
compression technology, can help to further reduce your storage costs
while at the same time improve performance. Enhanced query joins and
optimizer enhancements increase query performance that can enable
you to respond to complex business questions within seconds or less.
DB2 Advanced
Enterprise Server Edition includes a full suite of products and features
to help you manage your enterprise and help reduce your overall database
software costs. DB2 10.1 Advanced Enterprise Server Edition also
includes a comprehensive set of tools to help you develop, manage,
and deploy databases with greater efficiency, performance, and availability.
High Availability Disaster Recovery (HADR) feature is included
in all the for-purchase DB2 10.1 editions (Express®, Workgroup Server, Enterprise
Server, and Advanced Enterprise Server, Database Enterprise Developer).
The security features Label Based Access Control and the new Row
and Column Access Control are also included in all the for-purchase DB2 10.1
editions (Express,
Workgroup Server, Enterprise Server, and Advanced Enterprise Server,
Database Enterprise Developer). These security features provide you
with a robust and flexible set of rules and access controls to manage
and help secure data accesses to help you control your security risks.
Back to top
Refer to the Hardware requirements and Software requirements sections of this document.
Back to top
April 30, 2012: Electronic availability
June 11, 2012: Media availability
Back to top
IBM DB2 10.1 Linux, UNIX, and Windows (LUW)
offers you a robust set of new functionality to help you reduce your
costs and improve your operational efficiency through increased performance,
enhanced security management features, extreme scalability, and faster
applications development.
New functions
Optimized storage utilization
Multi-Temperature Data Management allows for grouping of hot, warm,
and cold data on varying storage systems. You can now use different
storage technologies to help optimize performance while helping to
minimize cost. Storage can be allocated depending on data temperature,
such as placing hot data on the fastest and most expensive Solid® State
Disks (SSDs), while other data can reside on less expensive storage
systems.
Multi-Temperature Data Management integration with DB2 Workload
Manager is available with DB2 Advanced Enterprise Server Edition to more
easily prioritize queries, not only on "who" submitted the work or
"what" type of work it is, but also on "where" the data resides.
For faster performance, queries touching only hot data can be assigned
higher prioritization than queries touching cold data.
Multi-Temperature Data Management is included in the DB2 Enterprise
Server Edition, DB2 Advanced Enterprise Server Edition, and IBM Database
Enterprise Developer Edition.
Further storage savings with improved compression
You get significant enhancements with DB2's industry-leading compression
technologies that now include the new Adaptive Compression, which
can further help reduce your storage needs. The enhancements deliver
efficient compression of high amounts of new and changing data. The
improved compression ratio further helps reduce storage needs and
allows for more data in memory, therefore, helping to increase performance.
The new approach used in Adaptive Compression also reduces the need
for table reorganization. As a consequence, overall maintenance of
compressed data is reduced, helping you achieve additional cost savings.
Adaptive Compression is included in DB2 Advanced Enterprise Server Edition
and DB2 Database
Enterprise Developer Edition.
Easier business trend analysis and application development
Time Travel Query, based on the SQL 2011 standard, is integrated
into the database engine to provide significant performance and manageability
advantages. Time Travel Query provides the infrastructure for time-aware
analytics to reduce the operational complexity of collecting and analyzing
time-based data.
Time Travel Query accelerates dynamic analysis of business trends
and changes over time, for both new and existing applications. Time
Travel Query provides the flexibility to audit for change with system-controlled
temporal data, and to analyze all kinds of temporal data including
forward-looking data when using user-controlled temporal data.
Time Travel Query is available in all editions of DB2.
DB2 10.1
LUW can now be used as the Resource Definition Framework (RDF) data
store with built-in query processor and SPARQL support. With this
support, you will be able to build highly scalable and reliable semantic
data applications on the DB2 platform. Application developers will have
a flexible and expressive API to develop or rapidly prototype applications
where the schema is changing or where there is a wide spectrum of
disparate entity types to be stored with an evolving relationships
between them. SPARQL query features, with open source Jena API, are
supported. Utilities to create, load, and reorganize RDF data are
provided.
SPARQL and RDF datastore are available to all DB2 editions.
Security enhancements
Row and Column Access Control provides easy and flexible control
over data access. With Row and Column Access Control, you can define
the security policies that are optimal for your environment by creating
permissions for rows and masks for columns based on rules defined
for users, groups, and roles. This very fine granularity is designed
to allow you to easily control access by roles such as departmental,
supervisory, database administrators (DBAs), system administrators,
and others, and allow for full separation of duty between security
officers and DBAs.
Row and Column Access Control is available in all the for-purchase DB2 10.1
editions (Express,
Workgroup Server, Enterprise Server, and Advanced Enterprise Server,
Database Enterprise Developer).
Performance enhancements
DB2 10.1
LUW adds many enhancements designed to further increase the performance
of queries.
Zigzag join is now available and is capable of delivering sub-second
response time on complex multi-dimensional queries. Other join methods
are also enhanced for memory usage efficiency, early predicate evaluation,
support of expressions in predicates, as well as optimizer costing
and query plan optimization. Additionally, you may now set the INTRA_PARALLELISM
variable dynamically to optimize performance on multicore systems
for specific applications or workloads.
These performance enhancements are available in all editions of DB2.
Continous Data Ingest utility
The ingest utility allows the seamless roll-in of external data
feeds with minimal impact on operations, including long-running queries.
It enables real-time business analytics with massive volumes of streaming
external data. It is designed to avoid trade-off between data concurrency
and data availability.
The Continuous Data Utility is available in DB2 Advanced
Enterprise Server Edition and DB2 Database Enterprise Developer Edition.
DB2 pureScale
The DB2 pureScale Feature
brings clustering technology to DB2 on distributed IBM Power® System
and System
x® platforms. It helps you to meet your business needs around
availability and scalability, and at the same time, it is easy to
configure and administer. By combining the extensive features of DB2 with
the availability and scalability of the DB2 pureScale Feature along with IBM system
dependability and flexibility, the result is a comprehensive data
management solution that helps you meet the most demanding business
needs.
The DB2 pureScale Feature
is designed to keep your critical data available during both planned
and unplanned outages. For planned outages, where you are performing
maintenance on your cluster, you can do rolling maintenance on individual
members without affecting the availability of the cluster. For unplanned
outages, where a member of the cluster fails due to hardware or software
reasons, the DB2 pureScale Feature
is designed to allow the cluster, with its remaining members, to continue
to function with minimal interruption to your application or business.
The DB2 pureScale Feature
allows you to add members to the cluster and remove them from the
cluster on demand. You can scale up or scale down the cluster to meet
your dynamic business needs. DB2 pureScale, developed with ease of use in
mind, has a single installation process for all the software components.
The DB2 pureScale Feature
is included in DB2 Workgroup
Server Edition and is restricted to up to 16 cores and 64 GB memory
total across the cluster, not including the DB2 Cluster Facility and quorum
host. DB2 pureScale Feature
is included in DB2 Database
Enterprise Developer Edition for development use. DB2 pureScale,
with no core or memory restrictions, is available for purchase with DB2 Advanced
Enterprise Server Edition and DB2 Enterprise Server Edition.
Advanced tools for DB2 LUW
InfoSphere® Optim™ Tools
are updated to accelerate adoption and enhance the value of key DB2 features
including Time Travel Query, Row and Column Access Control, Multi-Temperature
Data Management, and IBM DB2 pureScale.
Optim Tools
are available for purchase to use with DB2 editions. Refer to the Product positioning section for details about
which Optim Tools
are included in each DB2 edition.
New releases supporting DB2 10.1 LUW are:
- Data Studio V3.1.1
- InfoSphere Data
Architect V8.1
- InfoSphere Optim Query
Workload Tuner V3.1.1
- InfoSphere Optim pureQuery
Runtime V3.1.1
- InfoSphere Optim Performance
Manager V5.1.1
- InfoSphere Optim Configuration
Manager V2.1.1
- InfoSphere Optim High
Performance Unload V4.2.1
- DB2 Merge
Backup V1.1.1
- DB2 Recovery
Expert V3.1.1
Performance enhancements
Using InfoSphere Optim Tools, developers, DBAs,
or security administrators can:
- Design, develop, and deploy temporal tables, develop and validate
SQL access, and view row history.
- Use Data Studio and InfoSphere Data Architect for collaboration
to help safeguard data and enable security administrators to define,
view, and deploy fine grained access control, and DBAs to analyze
impact of new security controls and update routines accordingly.
- Use IBM Data
Studio to monitor multiple standby availability and alert availability
risks.
- Use Data Studio and Optim Configuration Manager to get recommendations
for adaptive compression use, deploy compression, and validate compression
savings.
- Use Optim Configuration
Manager and Optim Performance
Manager to enhance value of multi-temperature technology delivery
by analyzing storage group growth and contents, enabling Workload
Manager configurations to prioritize queries against high performing
storage, and automating period roll-off for range partitioned tables
to help lower storage cost.
- Analyze access plan improvements and regressions based on new
optimization strategies and get actionable recommendations for improvements. Optim Query
Workload Tuner is now the one-stop-shop for query improvement recommendations
subsuming all DB2 Design
Advisor functions under its broader value-add capability.
- Use Optim High
Performance Unload to unload, extract, and repartition data in DB2 10
databases. It helps to work with large quantities of data with less
effort and faster results.
- Use DB2 Merge
Backup to create fast DB2 backups for your production system designed
to enable you to have full current backups available for shorter restore
times. DB2 Merge
Backup combines incremental and delta backups with the latest full
backup to create a new and current full DB2 backup.
- Use DB2 Recovery
Expert to recover faster and with greater granularity than what is
offered with traditional database recovery. The log analysis features
enable organizations to monitor changes to a database and gives the
DBA the capability to quickly restore or correct erroneous data using
fewer resources and helping to reduce data outages.
Additionally, Data Studio and Optim Query Workload Tuner are
now tightly integrated to provide an improved startup experience.
Users can now enable Optim Query Workload Tuner functionality with
a simple license activation. Data Studio, which includes a rich set
of developer and database administrator productivity tools, is the
replacement of the legacy DB2 Control Center tools. Data Studio is available
for all editions of DB2 at no extra charge.
Furthermore, InfoSphere Optim Tools continue to support
production deployment for DB2 pureScale environments with added configuration,
administration, and monitoring capabilities. Developers will also
benefit from new tool support that facilitates migration to DB2, with
added support for PL/SQL procedure profiling and database federation
definition. Finally, Eclipse based offerings are updated to Eclipse
3.6 platform providing integration with Rational® Software Development
Platform V8 software.
Summary of DB2 10.1 edition changes
Resource limits for each edition, where applicable, are also listed
below.
DB2 Express-C:
- Time Travel Query.
- IBM Data
Studio.
- Memory limit has been increased to 4 GB. Processor core limit
remains at two. Both limits are per physical server, or where partitioned,
virtual server.
DB2 Express Edition:
- Row and Column Access Control.
- Label Based Access Control
- Time Travel Query.
- High Availability Disaster Recover (HADR).
- IBM Data
Studio.
- Memory limit has been increased to 8 GB. Processor core limit
remains at four. Both limits are per physical server, or where partitioned,
virtual server.
DB2 Workgroup
Server Edition:
- Row and Column Access Control.
- Label Based Access Control.
- Time Travel Query.
- IBM Data
Studio.
- Memory limit remains at 64 GB. Processor core limit remains at
16. Both limits are per physical server, or where partitioned, virtual
server.
DB2 Enterprise
Server Edition:
- Row and Column Access Control
- Label Based Access Control
- Time Travel Query
- Multi-Temperature Data Management
- IBM Data
Studio
DB2 Advanced
Enterprise Server Edition:
- Row and Column Access Control
- Label Based Access Control
- Time Travel Query
- Multi-Temperature Data Management
- Storage Optimization Feature, including Adaptive Compression
- Continuous Data Ingest
- IBM Data
Studio
- InfoSphere Data
Architect (10 users)
- InfoSphere Optim Configuration
Manager
- InfoSphere Optim Performance
Manager Extended Edition
- InfoSphere Optim Query
Workload Tuner
- InfoSphere Optim pureQuery
Runtime for LUW
IBM Database
Enterprise Developer Edition:
- Row and Column Access Control
- Label Based Access Control
- Time Travel Query
- Multi-Temperature Data Management
- Storage Optimization Feature, including Adaptive Compression
- Continuous Data Ingest
- IBM Data
Studio
- InfoSphere Data
Architect
- InfoSphere Optim Configuration
Manager
- InfoSphere Optim Performance
Manager Extended Edition
- InfoSphere Optim Query
Workload Tuner
- InfoSphere Optim pureQuery
Runtime for LUW
Accessibility by people with disabilities
A US Section 508 Voluntary Product Accessibility Template (VPAT)
can be requested via the IBM website
- http://www.ibm.com/able/product_accessibility/index.html
Section 508 of the US Rehabilitation Act
DB2 Express Edition
is capable as of June 11, 2012, when used in accordance with IBM's
associated documentation, of satisfying the applicable requirements
of Section 508 of the Rehabilitation Act, provided that any assistive
technology used with the product properly interoperates with it. A
US Section 508 Voluntary Product Accessibility Template (VPAT), containing
details on the products accessibility compliance, can be requested
on the following website
- http://www.ibm.com/able/product_accessibility/index.html
Back to top
IBM DB2 Editions
for production deployment
IBM DB2 10.1
Advanced Enterprise Server Edition for Linux, UNIX and Windows
DB2 Advanced
Enterprise Server Edition is designed to meet the data server needs
of the most demanding businesses. DB2 Advanced Enterprise Server Edition
is bundled with the functionality and tools needed for large complex
enterprise environments. DB2 Advanced Enterprise Server Edition includes
all the functionality from the DB2 Enterprise Server Edition, and it also integrates
the capabilities of DB2 Enterprise Server Edition with replication
and federation required for today's complex data environments. The
use of Queue-based Replication (Q Replication) in InfoSphere Data
Replication, which is restricted to replication between three DB2 LUW
systems, and InfoSphere Federation Server between Oracle
and DB2 LUW
databases, helps you rapidly integrate DB2 into mixed database platform
environments. Additionally, DB2 Advanced Enterprise Server Edition helps
reduce storage costs by inclusion of the DB2 Storage Optimization Feature.
To simplify administration, tuning, and development, DB2 10.1
Advanced Enterprise Server Edition includes a rich set of tools:
- IBM Data
Studio
- DB2 Workload
Management
- InfoSphereOptim Performance Manager Extended Edition
- InfoSphereOptim Query Workload Tuner
- InfoSphereOptim Configuration Manager
- InfoSphere Data
Architect (10 authorized users)
- InfoSphere Optim pureQuery
Runtime for LUW
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.
You can upgrade from DB2 Enterprise Server Edition to DB2 Advanced
Enterprise Server Edition using a Processor Value Unit (PVU) based
upgrade part number. You can also upgrade to DB2 Advanced
Enterprise Server Edition from DB2 Enterprise Server Edition with DB2 Storage
Optimization Feature and have the entitlement of both products converted
to entitlement for DB2 Advanced Enterprise Server Edition. You can
upgrade to DB2 Advanced
Enterprise Server Edition from DB2 Enterprise with DB2 Performance Optimization Feature
and have the entitlement of both products converted to entitlement
for DB2 Advanced
Enterprise Server Edition.
Program charges: DB2 10.1 Advanced Enterprise Server Edition includes
all the functionality from the DB2 Enterprise Server Edition, DB2 Storage
Optimization feature, DB2 Workload Management, InfoSphere Optim Performance
Manager Extended Edition, IBM Data Studio, InfoSphere Optim Query
Workload Tuner, InfoSphere Optim Configuration Manager, InfoSphere Data
Architect, InfoSphere Optim pureQuery Runtime for LUW, InfoSphere Federation
Server between DB2 LUW
and Oracle databases, and queue-based replication from InfoSphere Data
Replication between three DB2 LUW servers.
DB2 Advanced
Enterprise Server Edition is available on either a PVU or a per Authorized
User Single Install charge metric. Under the Authorized User Single
Install charge metric, you must acquire a minimum of 25 Authorized
User Single Install licenses per 100 PVUs.
IBM DB2 10.1
Enterprise Server Edition for Linux, UNIX and Windows
DB2 Enterprise
Server Edition is designed to meet the data server needs of midsize
to large-size businesses. 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. DB2 Enterprise Server Edition is
an ideal foundation for building on-demand enterprise-wide solutions
such as high-performing 24 x 7 available high-volume transaction processing
business solutions or web-based solutions. DB2 Enterprise Server Edition is
the data server backend of choice for industry-leading ISVs building
enterprise solutions such as content management, e-commerce, business
intelligence, enterprise resource planning, customer relationship
management, or supply chain management. Additionally, DB2 Enterprise
Server Edition offers connectivity, compatibility, and integration
with other enterprise DB2 and Informix® Dynamic Server (IDS) data sources.
Program charges: DB2 10.1 Enterprise Server 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 (HADR), Online Reorganization,
Materialized Query Tables (MQTs), Multidimensional Clustering (MDC),
Query Parallelism, Scan Sharing, Connection Concentrator, pureXML®,
backup compression, and Tivoli® System Automation for Multiplatforms.
The product also includes DB2 Homogeneous Federation and Homogeneous SQL
Replication allowing federated data access and replication between DB2 LUW
servers as well as web services federation.
DB2 Enterprise
Server Edition is available on either a PVU or a per Authorized User
Single Install charge metric. Under the Authorized User Single Install
charge metric, you must acquire a minimum of 25 Authorized User Single
Install licenses per 100 PVUs.
IBM DB2 10.1
Workgroup Server Edition for Linux, UNIX and Windows
DB2 Workgroup
Server Edition is the data server of choice for deployment in a departmental,
workgroup, or medium-sized business environment. It is offered in
multiple charge metrics to provide an attractive price point for medium-size
environments while providing a full-function data server. DB2 10.1
Workgroup Server Edition, running on either IBM System x or IBM Power servers,
includes the usage of DB2 pureScale with a maximum cluster size of
16 cores total across all servers, excluding the DB2 Cluster
Facility and quorum host. Defined Red Hat and SUSE Linux distributions
are supported for DB2 pureScale on System x, and AIX® is
supported for DB2 pureScale on Power servers.
Program charges: DB2 Workgroup Server Edition includes IBM Data
Studio, Label Based Access Control, Row and Column Access Control,
Time Travel Query, HADR, Online Reorganization, pureXML,
web services federation support, DB2 LUW Homogeneous Federation,
Homogeneous SQL Replication, backup compression, and Tivoli System
Automation for Multiplatforms. DB2 Workgroup Server Edition can be deployed
in Linux, UNIX, and Windows server
environments and will use up to 16 cores and 64 GB of memory per physical
or, where partitioned, virtual server. There is no limit on the cores
or memory available to the physical server, which makes DB2 Workgroup
Server Edition ideal for consolidating multiple workloads onto a large
physical server running DB2 Workgroup Server Edition in multiple virtual
servers.
DB2 Workgroup
Server Edition is available on a per Limited Use Socket, PVU, or Authorized
User Single Install charge metric. You must acquire a minimum of five
Authorized User Single Install licenses per Install.
IBM DB2 10.1 Express Edition
for Linux, UNIX and Windows
DB2 Express Edition
is a full-function DB2 data server, which provides very attractive
entry-level pricing for the small and medium business (SMB) market.
It is offered in multiple pricing models to provide choices to match
SMB customer needs. It comes with simplified packaging and is easy
to transparently install within an application. With DB2 Express Edition,
it is easy to subsequently upgrade to the other editions of DB2 10.1
since DB2 Express Edition
includes most of the same features, including security and HADR, as
the more scalable editions. You never have to change your application
code to upgrade; simply install the license certificate to upgrade.
Program charges: DB2 Express can be deployed on pervasive SMB,
x86-based operating systems, such as Linux, Windows,
or Solaris, and includes IBM Data Studio, Label Based Access Control,
Row and Column Access Control, Time Travel Query, pureXML,
web services federation, DB2 LUW Homogeneous Federation, Homogeneous SQL
Replication, backup compression, and HADR. DB2 Express Edition can be deployed
in x86 server environments and will use up to 4 cores and 8 GB of
memory per physical or, where partitioned, virtual server. On the
Limited Use Virtual Server charge metric, there is no limit on the
size of the physical server, which makes DB2 Express ideal for consolidating
multiple workloads onto a large physical server running DB2 Express in
multiple virtual servers.
DB2 Express Edition
is available on a per Authorized User Single Install, PVU, Limited
Use Virtual Server, or 12 month Fix Term licensing model. You must
acquire a minimum of five Authorized User Single Install licenses
per Install. DB2 Express Edition
can also be licensed on a yearly Fixed Term License pricing model.
DB2 10.1,
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, easy-to-use and embed, includes self-management
features, and embodies all of the core capabilities of DB2 for Linux, UNIX and Windows such
as Time Travel Query. Solutions developed using DB2 Express-C
can be seamlessly deployed using more scalable DB2 editions
without modifications to the application code.
Program charges: DB2 Express-C can be used for development and
deployment at no charge. It can be installed on x86-based physical
or virtual systems and may use up to a maximum of 2 processor cores
and 4 GB of memory. 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 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 10.1
Database Enterprise Developer Edition
IBM DB2 10.1
Database Enterprise Developer Edition offers a package for a single
application developer to design, build, and prototype applications
for deployment on any of the IBM Information Management client or server platforms.
This comprehensive developer offering includes DB2 Workgroup
Server Edition DB2 Enterprise
Server Edition, DB2 Advanced Enterprise Server Edition, IDS Enterprise
Edition, DB2 Connect™ Unlimited Edition for System
z®, and all of the DB2 10.1 features, 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 authorized user of this product.
IBM DB2 10.1
LUW, Enterprise Edition and Advanced Enterprise Edition for purchase
features
IBM DB2 Storage
Optimization Feature for Linux, UNIX and Windows
This feature includes data row, index, temporary table, and adaptive
compression and other compression types to help maximize the use of
existing storage:
- Data Row Compression uses a static dictionary-based compression
algorithm to compress data by row. Compressing data at the row level
is advantageous because it allows repeating patterns that span multiple
column values within a row to be replaced with shorter symbol strings,
helping to improved performance. In I/O-bound systems it will not
only help reduce storage requirements but it might help improve overall
performance.
- Index Compression utilizes multiple algorithms to help reduce
the storage requirements for indexes as well as the total storage
footprint of your DB2 database.
- Temp Compression will automatically compress the amount of space
used for temp tables. This automated compression will help to both
improve performance of business intelligence workloads using large
temp tables as well as reduce the total storage needed by DB2.
- Adaptive Compression lets you use the above mentioned compression
methods in parallel with table and page level dictionaries.
Program charges: This feature is included in the DB2 Advanced
Enterprise Server Edition and IBM Database Enterprise Developer Edition.
This feature is available as an option for DB2 Enterprise
Server Edition, and can only be acquired if the underlying data server
is licensed with the PVU charge metric.
DB2 pureScale Feature
This feature introduces clustering technology to DB2 on
distributed platforms, so you can deploy continuously available and
scalable database clusters. By allowing the database to continue processing
through most planned and unplanned outages, it helps improve the availability
of DB2.
It supports higher transaction rates by letting you grow your business
to meet the most demanding business needs. This feature additionally
delivers the necessary tools to easily and flexibly administer databases.
Defined Red Hat and SUSE Linux distributions are supported for DB2 pureScale on System
x, and AIX is
supported for DB2 pureScale on Power servers.
Program charges: This feature is included in the DB2 Workgroup
Server Edition with a limit of up to 16 cores and 64 GB memory total
in a cluster, not including the DB2 Cluster Facility and quorum
host, and is included in the Database Enterprise Developer Edition.
This feature is available as an option for the DB2 Advanced
Enterprise Server Edition and the DB2 Enterprise Server Edition. You
must acquire this feature under the same charge metric as the underlying DB2 data
server.
Back to top
Refer to:
- Software Announcement 212-073, dated April 03, 2012
- Software Announcement 212-077, dated April 03, 2012
- Software Announcement 211-520, dated December 06, 2011
- Software Announcement 211-445, dated December 06, 2011
- Software Announcement 211-287, dated August 16, 2011
- Software Announcement 211-212, dated May 03, 2011
- Software Announcement 211-450, dated October 18, 2011
- Software Announcement 211-441, dated October 18, 2011
- Software Announcement 211-448, dated October 18, 2011
- Software Announcement 210-354, dated October 05, 2010
Back to top
Product description Language GA date
DB2 AESE AU SI Option V10.1.0 All Lang per June 11, 2012
ESD/PA Media
Pks
DB2 AESE PVU Option V10.1.0 All Lang per June 11, 2012
ESD/PA Media
Pks
DB2 ESE AU SI Option V10.1.0 All Lang per June 11, 2012
ESD/PA Media
Pks
DB2 ESE PVU Option V10.1.0 All Lang per June 11, 2012
ESD/PA Media
Pks
DB2 EXE AU SI Option V10.1.0 All Lang per June 11, 2012
ESD/PA Media
Pks
DB2 EXE FTL Server Option All Lang per June 11, 2012
V10.1.0 ESD/PA Media
Pks
DB2 EXE Server Option V10.1.0 All Lang per June 11, 2012
ESD/PA Media
Pks
DB2 Express Ed PVU Option All Lang per June 11, 2012
V10.1.0 ESD/PA Media
Pks
DB2 SOF V10.1.0 All Lang per June 11, 2012
ESD/PA Media
Pks
DB2 WSE AU SI Option V10.1.0 All Lang per June 11, 2012
ESD/PA Media
Pks
DB2 WSE PVU Option V10.1.0 All Lang per June 11, 2012
ESD/PA Media
Pks
DB2 WSE Socket Option V10.1.0 All Lang per June 11, 2012
ESD/PA Media
Pks
DB2 pureScale Feature V10.1.0 All Lang per June 11, 2012
ESD/PA Media
Pks
DEDE V10.1.0 All Lang per June 11, 2012
ESD/PA Media
Pks
IBM HR Feature for DB2 ESE All Lang per June 11, 2012
V10.1.0 ESD/PA Media
Pks
Back to top
Program VRM Program name
number
5725-E89 1.0.0 DB2 Advanced CEO Offering
5725-B76 10.1.0 DB2 Advanced Enterprise
Server Edition
5724-R28 9.1.0 IBM DB2 CEO Offering
5765-F41 10.1.0 IBM DB2 Enterprise Server
Edition
5724-E49 10.1.0 IBM DB2 Express Edition
5724-S40 10.1.0 IBM DB2 Express Edition
Fixed Term License
5724-N78 10.1.0 IBM DB2 Storage
Optimization Feature
5765-F35 10.1.0 IBM DB2 Workgroup Server
Edition
5724-Y69 10.1.0 IBM DB2 pureScale Feature
5724-N76 10.1.0 IBM Database Enterprise
Developer Edition
5724-T19 10.1.0 IBM Homogeneous
Replication Feature for
DB2 Enterprise Server
Edition
Back to top
The following educational offerings are available as listed below:
Course code Course title Course type
CL24 DB2 for LUW Multi Classroom
Partition Database
Administration
Workshop
CL25 DB2 for LUW Multi Classroom
Partition Environment
for Single Partition
DBAs
CL44 DB2 for LUW Multi Classroom
Partition Performance
Workshop
IBM training
provides education to support many IBM offerings. Descriptions of courses
for IT professionals and managers are on the IBM training
website
- http://www.ibm.com/services/learning/
Call IBM training at 800-IBM-TEACH (426-8322) for
catalogs, schedules, and enrollments.
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 (ILO) to meet your demanding schedule. 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 -- 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
CL284 Fast Path to DB2 10.1 Classroom
for
Experienced
Relational DBAs
3L284 Fast Path to DB2 10.1 Instructor-Led
for Online
Experienced
Relational DBAs
CL484 DB2 10.1 for LUW Classroom
Quickstart for
Experienced
Relational DBAs
3L484 DB2 10.1 for LUW Instructor-Led
Quickstart for Online
Experienced
Relational DBAs
CL313 DB2 10 for Linux, Classroom
UNIX, and
Windows New Features
3L313 DB2 10 for Linux, Instructor-Led
UNIX, and Online
Windows New Features
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
- http://www-03.ibm.com/certify/tests/test_index_bd.shtml
Back to top
Product information is available via the Offering Information website
- http://www.ibm.com/common/ssi
Also, visit the Passport Advantage® website
- http://www.ibm.com/software/passportadvantage
Back to top
No publications are shipped with these products.
The IBM Publications
Center
- http://www.ibm.com/shop/publications/order
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 U.S.) 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.
- https://www.ibm.com/support/mysupport/us/en/?OpenDocument
The following books are available for the DB2 10.1
for Linux, UNIX, and Windows products:
Description Language Form number
Administrative API English SC27-3864-00
Reference
Japanese SA88-4671-00
Spanish SC11-8069-00
Administrative English SC27-3865-00
Routines and Views
Japanese SA88-4672-00
Spanish SC11-8067-00
CLI Guide and English SC27-3866-00
Reference, Volume 1
Japanese SA88-4676-00
CLI Guide and English SC27-3867-00
Reference, Volume 2
Japanese SA88-4677-00
Command Reference English SC27-3868-00
Japanese SA88-4673-00
Spanish SC11-8071-00
Data Movement English SC27-3869-00
Utilities Guide and
Reference
German SC12-4691-00
Japanese SA88-4693-00
Simplified Chinese S151-1756-00
Data Recovery and English SC27-3870-00
High Availability
Guideand Reference
German SC12-4692-00
Japanese SA88-4694-00
Simplified Chinese S151-1755-00
Database English SC27-3871-00
Administration
Concepts and
Configuration
Reference
German SC12-4673-00
Japanese SA88-4662-00
Simplified Chinese S151-1758-00
Database Monitoring English SC27-3887-00
Guide and Reference
German SC12-4674-00
Japanese SA88-4663-00
Simplified Chinese S151-1759-00
Database Security English SC27-3872-00
Guide
German SC12-4693-00
Japanese SA88-4695-00
Simplified Chinese S151-1753-01
DB2 Connect User's English SC27-3863-00
Guide
Brazilian Portuguese S517-0060-00
Bulgarian SC19-1559-00
Croatian SC19-1554-00
Czech SC19-3531-00
Dutch SC14-2085-00
French SC11-7092-00
German SC12-4681-00
Hungarian SC22-1153-00
Japanese SA88-4683-00
Polish SC85-0485-00
Romanian SC19-1706-00
Russian SC89-1243-00
Simplified Chinese S151-1771-00
Slovakian SC19-1435-00
Slovenian SC19-1564-00
Spanish SC11-8075-00
Traditional Chinese SC27-3096-00
DB2 Text Search Guide English SC27-3888-00
German SC12-4690-00
Japanese SA88-4692-00
Spanish SC11-8083-00
Developing ADO.NET English SC27-3873-00
and OLE DB
Applications
Japanese SA88-4665-00
Simplified Chinese S151-1765-00
Developing Embedded English SC27-3874-00
SQL Applications
Japanese SA88-4666-00
Simplified Chinese S151-1763-00
Developing Java™ English SC27-3875-00
Applications
Japanese SA88-4669-00
Spanish SC11-8066-00
eveloping Perl, PHP, English SC27-3876-00
Python, and Ruby on
Rails Applications
Japanese SA88-4670-00
Spanish SC11-8065-00
Developing English SC27-3877-00
User-defined Routines
(SQL and External)
Japanese SA88-4667-00
Simplified Chinese S151-1761-00
Getting Started With English GI13-2046-00
Database Application
Development
Japanese GI88-4279-00
Simplified Chinese G151-1764-00
Getting Started with English GI13-2047-00
DB2 Installation and
Administration on
Linux and Windows
Brazilian Portuguese G517-0196-00
Czech GI13-2404-00
French GI11-7431-00
German GI11-3285-00
Japanese GI88-4280-00
Polish GI10-6771-00
Russian GI43-0114-00
Simplified Chinese G151-1769-00
Spanish GI13-1946-00
Traditional Chinese GI13-1152-00
Globalization Guide English SC27-3878-00
German SC12-4694-00
Japanese SA88-4696-00
Simplified Chinese S151-1757-00
Installing and English SC27-3861-00
Configuring DB2
Connect Personal
Edition
Brazilian Portuguese S517-0062-00
Bulgarian SC19-1557-00
Croatian SC19-1552-00
Czech SC19-3529-00
Dutch SC14-2084-00
French SC11-7090-00
German SC12-4679-00
Hungarian SC22-1155-00
Japanese SA88-4681-00
Polish SC85-0483-00
Romanian SC19-1704-00
Russian SC89-1245-00
Simplified Chinese S151-1773-00
Slovakian SC19-1433-00
Slovenian SC19-1562-00
Spanish SC11-8077-00
Traditional Chinese SC27-3098-00
Installing and English SC27-3862-00
Configuring DB2
Connect Servers
Brazilian Portuguese S517-0061-00
Bulgarian SC19-1558-00
Croatian SC19-1553-00
Czech SC19-3530-00
French SC11-7091-00
German SC12-4680-00
Hungarian SC22-1154-00
Japanese SA88-4682-00
Polish SC85-0484-00
Romanian SC19-1705-00
Russian SC89-1244-00
Simplified Chinese S151-1772-00
Slovakian SC19-1434-00
Slovenian SC19-1563-00
Spanish SC11-8076-00
Traditional Chinese SC27-3097-00
Installing DB2 English GC27-3884-00
Servers
Brazilian Portuguese G517-0195-00
Czech GC19-3526-00
French GC11-7088-00
German SC12-4677-00
Japanese GA88-4679-00
Polish GC85-0481-00
Russian GC89-1240-00
Simplified Chinese G151-1768-00
Spanish GC11-8073-00
Traditional Chinese GC27-3094-00
Installing IBM Data English GC27-3883-00
Server Clients
Brazilian Portuguese G517-0197-00
Bulgarian GC19-1556-00
Croatian GC19-1551-00
Czech GC19-3528-00
Dutch GC14-2083-00
French GC11-7089-00
German SC12-4678-00
Hungarian GC22-1152-00
Japanese GA88-4680-00
Polish GC85-0482-00
Romanian GC19-1703-00
Russian GC89-1242-00
Slovakian GC19-1432-00
Slovenian GC19-1561-00
Spanish GC11-8074-00
Traditional Chinese GC27-3092-00
Turkish GC14-7095-00
Message Reference English SC27-3879-00
Volume 1
Czech SC19-3532-00
Dutch SC14-2087-00
French SC11-7094-00
German SC12-4686-00
Japanese SA88-4688-00
Simplified Chinese S151-1767-00
Spanish SC11-8080-00
Message Reference English SC27-3880-00
Volume 2
Czech SC19-3533-00
Dutch SC14-2088-00
French SC11-7095-00
Japanese SA88-4689-00
Simplified Chinese S151-1766-00
Spanish SC11-8079-00
Traditional Chinese SC27-3099-00
Net Search Extender English SC27-3895-00
Administration and
User's Guide
French SC11-7096-00
German SC12-4689-00
Japanese SA88-4691-00
Simplified Chinese S151-1078-00
Spanish SC11-8082-00
Partitioning and English SC27-3895-00
Clustering Guide
German SC12-4695-00
Japanese SA88-4697-00
Simplified Chinese S151-1754-00
pureXML Guide English SC27-3892-00
German SC12-4684-00
Japanese SA88-4686-00
Simplified Chinese S151-1775-00
Spatial Extender and English SC27-3894-00
Geodetic Data
Management Feature
User's Guide and
Reference
Brazilian Portuguese S517-0064-00
German SC12-4688-00
Japanese SA88-4690-00
Spanish SC11-8081-00
SQL Procedural English SC27-3896-00
Languages:
Application
Enablement and
Support
Japanese SA88-4668-00
Simplified Chinese S151-1762-00
SQL Reference, Volume English SC27-3885-00
1
Japanese SA88-4674-00
Spanish SC11-8070-00
SQL Reference, Volume English SC27-3886-00
2
Japanese SA88-4675-00
Spanish SC11-8068-00
Trouble shooting and English SC27-3889-00
Tuning Database
Performance
German SC12-4675-00
Japanese SA88-4664-00
Simplified Chinese S151-1760-00
Upgrading to DB2 English SC27-3881-00
Version 10.1
Brazilian Portuguese S517-0017-00
Czech SC19-3527-00
French SC11-7087-00
German SC12-4676-00
Japanese SA88-4678-00
Polish SC85-0480-00
Russian SC89-1241-00
Simplified Chinese S151-1770-00
Spanish SC11-8072-00
TraditionalChinese SC27-3095-00
What's New for DB2 English SC27-3890-00
Version 10.1
Brazilian Portuguese S517-0063-00
Bulgarian SC19-1560-00
Croatian SC19-1555-00
Dutch SC14-2086-00
French SC11-7093-00
German SC12-4682-00
Hungarian SC22-1156-00
Japanese SA88-4684-00
Romanian SC19-1706-00
Russian SC89-1246-00
Simplified Chinese S151-1752-00
Slovakian SC19-1436-00
Slovenian SC19-1565-00
Spanish SC11-8078-00
Traditional Chinese SC27-3093-00
Workload Management English SC27-3891-00
Guide and Reference
German SC12-4683-00
Japanese SA88-4685-00
Spanish SC11-8079-00
XQuery Reference English SC27-3893-00
German SC12-4685-00
Japanese SA88-4687-00
Simplified Chinese S151-1774-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.
IBM form number Title
SG24-7736-00 Oracle to DB2 Conversion Guide
for Linux, UNIX, and Windows
(update)
SG24-7048-01 Oracle to DB2 Conversion Guide
for Linux, UNIX, and Windows
SG24-7301-00 DB2 Express-C: The Developer
Handbook for XML, PHP, C/C++,
Java, and .NET
SG24-6672-00 Microsoft™ SQL Server to IBM DB2
UDB Conversion Guide
SG24-7363-01 High Availability and Disaster
Recovery Options for DB2 on
Linux, UNIX, and Windows
SG24-7218-00 Developing PHP Applications for
IBM Data Servers
SG24-7259-00 Powering SOA with IBM Data
Servers
SG24-7467-00 Database Partitioning, Table
Partitioning, and MDC for DB2 9
SG24-7653-00 DB2 Deployment Guide
SG24-7555-00 DB2 Security and Compliance
Solutions for Linux, UNIX, and
Windows
SG24-6899-01 Up and Running with DB2 on
Linux
For additional Redbooks, refer to
- http://www.redbooks.ibm.com/
Back to top
Specified operating environment
Hardware requirements
Minimum hardware requirements:
- 32-bit and 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 (x86 and x64 systems).
- AIX and Linux for IBM System
p® and for IBM System
i® systems: Systems with POWER4, 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.
The hardware requirements of DB2 products may be occasionally
updated. To obtain the current information for supported hardware,
visit
- http://www.ibm.com/software/data/db2/udb/sysreqs.html
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.
Graphical administration and application development tools, that are
part of the IBM Data
Server Client, require an additional 256 MB.
The following table shows the minimum memory in MBs that are 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 256 MB
(all editions)
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 Disk space requirement
DB2 for Linux, UNIX, and Windows 450 MB (1)
(all editions)
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 and graphical tools.
(3) English only. Other languages may require more disk space.
563 MB of the 600 MB is for United States geocoder reference data.
Software requirements
This section indicates the minimal requirements for operating systems
at the time of this announcement.
Linux
- Red Hat Enterprise Linux (RHEL) 5 and 6
- SUSE Linux Enterprise
Server (SLES) 10 and 11
- Linux for
System i- SLES 10, SLES 11; 32 bit and 64 bit
- Linux for System
i - RHEL 5 and 6; 32 bit and 64 bit
- Linux for System
p - SLES 10, SLES 11; 64 bit
- Linux for System
p - RHEL 5 and 6; 64 bit
- Linux for System
z - SLES 10, SLES 11; 64 bit
- Linux for System
z - RHEL 5 and 6; 64 bit
Windows
- 32-bit and 64-bit (x64) Windows Server 2003, Standard
Server, Enterprise Server, and Datacenter Editions
- 32-bit and 64-bit (x64) Windows Server 2008, Standard
Server, Enterprise Server, and Datacenter Editions
- 32-bit and 64-bit (x64) Windows XP Professional Edition
- 32-bit and 64-bit (x64) Windows Vista Business, Enterprise,
and Ultimate editions
- 32-bit and 64-bit (x64) Windows 7
AIX
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 only supported on DB2 Enterprise Server Edition and on 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
- http://www.ibm.com/software/data/db2/udb/sysreqs.html
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
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 (also referred to as Software Maintenance)
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 (also referred to as
Software Maintenance) with each program license acquired. The initial
period of Software Subscription and Support (also referred to as Software
Maintenance) can be extended by the purchase of a renewal option,
if available.
Packaging
IBM DB2 10.1,
Advanced Enterprise Server Edition - Authorized User Single Install
and PVU Options
Media:
- IBM DB2 10.1
Advanced Enterprise Server Edition - Quick Start and Activation CD
- IBM DB2 10.1
Information Center DVDs
- IBM DB2 10.1
PDF documentation DVD
- IBM DB2 10.1
Advanced Enterprise Server Edition DVDs
- IBM Data
Server Runtime Client 10.1 DVDs
- IBM Data
Server Client 10.1 DVDs
- IBM Data
Server Driver Package 10.1 DVDs
- IBM DB2 Support
Files for SSL Functionality 10.1 CD
- IBM DB2 Support
Files for Advanced Copy Services Functionality 10.1 CD
- IBM DB2 Net
Search Extender 10.1 DVD
- IBM Tivoli System
Automation for Multiplatform V3.2.2 - Window CD
- IBM WebSphere® MQSeries® V7.1
DVDs
- IBM InfoSphere Optim Performance
Manager Extended Edition V5.1.1 DVDs
- IBM InfoSphere Optim Query
Workload Tuner V3.1.1 DVDs
- IBM InfoSphere Optim Configuration
Manager V2.1.1 DVDs
- IBM InfoSphere Optim pureQuery
Runtime for LUW V3.1.1 DVD
- IBM InfoSphere Data
Architect V8.1 DVDs
- IBM Data
Studio V3.1.1 DVDs
IBM DB2 10.1,
Enterprise Server Edition - Authorized User Single Install and PVU
Options
Media:
- IBM DB2 10.1
Enterprise Server Edition - Quick Start and Activation CD
- IBM DB2 10.1
Information Center DVDs
- IBM DB2 10.1
PDF documentation DVD
- IBM DB2 10.1
Enterprise Server Edition DVDs
- IBM Data
Server Runtime Client 10.1 DVDs
- IBM Data
Server Client 10.1 DVDs
- IBM Data
Server Driver Package 10.1 DVDs
- IBM DB2 Support
Files for SSL Functionality 10.1 CD
- IBM DB2 Support
Files for Advanced Copy Services Functionality 10.1 CD
- IBM DB2 Net
Search Extender 10.1 DVD
- IBM Tivoli System
Automation for Multiplatform V3.2.2 - Window CD
- IBM WebSphere MQSeries V7.1
DVDs
- IBM Data
Studio V3.1.1 DVDs
IBM DB2 10.1,
Workgroup Server Edition - Authorized User Single Install, PVU and
Limited Use Socket Options
Media:
- IBM DB2 10.1
Workgroup Server Edition - Quick Start and Activation CD
- IBM DB2 10.1
Information Center DVDs
- IBM DB2 10.1
PDF documentation DVD
- IBM DB2 10.1
Workgroup Server Edition DVDs
- IBM Data
Server Runtime Client 10.1 DVDs
- IBM Data
Server Client 10.1 DVDs
- IBM Data
Server Driver Package 10.1 DVDs
- IBM DB2 Support
Files for SSL Functionality 10.1 CD
- IBM DB2 Support
Files for Advanced Copy Services Functionality 10.1 CD
- IBM DB2 Net
Search Extender 10.1 DVD
- IBM Tivoli System
Automation Multiplatforms V3.2.2 for Windows CD
- IBM WebSphere MQSeries V7.1
DVDS
- IBM Data
Studio V3.1.1 DVDs
IBM DB2 10.1, Express Edition
- Authorized User Single Install, PVU, Limited Use Virtual Server,
and Fixed Term License Options
Media:
- IBM DB2 10.1 Express Edition
- Quick Start and Activation CD
- IBM DB2 10.1 Express Edition
DVDs
- IBM DB2 Support
Files for Advanced Copy Services Functionality 10.1 CD
- IBM DB2 Net
Search Extender 10.1 DVD
- IBM Tivoli System
Automation Multiplatforms V3.2.2 for Windows CD
- IBM WebSphere MQSeries V7.1
DVDs
- IBM Data
Studio V3.1.1 DVDs
IBM Database
Enterprise Developer Edition 10.1
Media:
- IBM Database
Enterprise Developer Edition 10.1 - Quick Start and Activation CD
- IBM DB2 10.1
Information Center DVDs
- IBM DB2 10.1
PDF documentation DVD
- IBM DB2 10.1
Advanced Enterprise Server DVDs
- IBM DB2 10.1
Enterprise Server Edition DVDs
- IBM DB2 10.1
Workgroup Server Edition DVDs
- IBM DB2
Connect 10.1 Server DVDs
- IBM Data
Server Runtime Client 10.1 DVDs
- IBM Data
Server Client 10.1 DVDs
- IBM Data
Server Driver Package 10.1 DVDs
- IBM DB2 Support
Files for SSL Functionality 10.1 CD
- IBM DB2 Support
Files for Advanced Copy Services Functionality 10.1 CD
- IBM DB2 Net
Search Extender 10.1 DVD
- IBM Tivoli System
Automation for Multiplatform V3.2.2 - Windows CD
- IBM WebSphere MQSeries V7.1
DVDs
- IBM Informix Ultimate
Edition V11.70 DVDs
- IBM InfoSphere Optim Performance
Manager Extended Edition V5.1.1 DVDs
- IBM InfoSphere Optim Query
Workload Tuner V3.1.1 DVDs
- IBM InfoSphere Optim Configuration
Manager V2.1.1 DVDs
- IBM InfoSphere Optim pureQuery
Runtime for LUW V3.1.1 DVD
- IBM InfoSphere Data
Architect V8.1 DVDs
- IBM Data
Studio V3.1.1 DVDs
- IBM solidDB® 7.0
DVDs
IBM DB2 Storage
Optimization Feature
Media:
- IBM DB2 10.1
Storage Optimization Feature - Quick Start and Activation CD
IBM DB2 pureScale Feature
Media:
- IBM DB2 10.1 pureScale Feature
- Quick Start and Activation CD
- IBM InfoSphere Optim Performance
Manager Extended Edition V5.1.1 DVDs
Security, auditability, and control
To protect data and resources associated with a database server, DB2 uses
a combination of external security services and internal access control
information. To access a database server, the user must pass some
security checks before being given access to database data or resources.
DB2 products
interface with external security mechanisms available with operating
systems on which DB2 products are supported as well as support
for the Kerberos security mechanism. DB2 has an integrated audit facility
that can be used to track data access by users. The subsequent analysis
of an audit log can lead to improvements in the control of data access
and the ultimate prevention of malicious or careless unauthorized
access to the data.
The customer is responsible for evaluation, selection, and implementation
of security features, administrative procedures, and appropriate controls
in application systems and communication facilities.
Back to top
This product is only available via Passport Advantage.
It is not available as shrinkwrap.
These products may only be sold directly by IBM or
by authorized IBM Business
Partners for Software Value Plus.
For more information about IBM Software Value Plus, visit
- http://www-01.ibm.com/software/info/itsolutions/softwarevalueplus/
To locate IBM Business
Partners for Software Value Plus in your geography for a specific
Software Value Plus portfolio, contact your IBM representative.
Product information
Licensed function title Product group Product
category
IBM DB2 Advanced CEO IBM Database 2 DB2
IBM DB2 Advanced CEO Offering IBM Database 2 DB2
IBM DB2 Advanced Enterprise Server IBM Database 2 DB2
Edition Authorized User SI Option
IBM DB2 Advanced Enterprise Server IBM Database 2 DB2
Edition PVU Option
IBM DB2 CEO Bundle Other CEO Bundle
IBM DB2 CEO Offering Bundle Other CEO Bundle
IBM DB2 Enterprise Server Edition IBM Database 2 DB2 Enterprise
Authorized User Single Install Server Edition
IBM DB2 Enterprise Server Edition IBM Database 2 DB2 Enterprise
PVU Option Server Edition
IBM DB2 Express Edition AU Single IBM Database 2 IBM DB2
Install Option Universal
Database
IBM DB2 Express Edition FTL IBM Database 2 DB2
IBM DB2 Express Edition PVU Option IBM Database 2 IBM DB2
Universal
Database
IBM DB2 Express Edition Server IBM Database 2 DB2
Option
IBM DB2 Storage Optimization IBM Database 2 IBM DB2
Feature Universal
Database
IBM DB2 Workgroup Server Edition IBM Database 2 IBM DB2
Authorized User Single Install Universal
Database
IBM DB2 Workgroup Server Edition IBM Database 2 IBM DB2
PVU Option Universal
Database
IBM DB2 Workgroup Server Edition IBM Database 2 DB2
Socket Option
IBM DB2 pureScale Feature IBM Database 2 DB2
IBM Database Enterprise Developer IBM Database 2 IBM DB2
Edition Universal
Database
IBM Homogeneous Replication IBM Database 2 IBM DB2
Feature for DB2 Enterprise Server Universal
Edition Database
Program name PID Charge unit
number description
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 CEO Offering 5725-E89 Per Authorized
User
IBM DB2 Advanced Enterprise Server 5725-B76 Per Authorized
Edition Authorized User SI Option User Single
Install
IBM DB2 Advanced Enterprise Server 5725-B76 PROCESSOR-Day(s)
Edition PVU Option
IBM DB2 Advanced Enterprise Server 5725-B76 Per Processor
Edition PVU Option Value Unit (PVU)
IBM DB2 Advanced Enterprise Server 5725-B76 Per Processor
Edition PVU Option Value Unit for
Linux on System
z
IBM DB2 CEO 5724-R28 Per Authorized
User
IBM DB2 CEO Offering 5724-R28 PA Per
Authorized User
IBM DB2 Enterprise Server Edition 5765-F41 Per Authorized
Authorized User Single Install User Single
Install
IBM DB2 Enterprise Server Edition 5765-F41 Per Processor
PVU Option Value Unit (PVU)
IBM DB2 Enterprise Server Edition 5765-F41 Per Processor
PVU Option Value Unit for
Linux on System
z
IBM DB2 Enterprise Server Edition 5765-F41 PROCESSOR-Day(s)
PVU Option
IBM DB2 Express Edition AU Single 5724-E49 Per Authorized
Install Option User Single
Install
IBM DB2 Express Edition FTL 5724-S40 FTL per Limited
Use Virtual
Server
IBM DB2 Express Edition PVU Option 5724-E49 PROCESSOR-Day(s)
IBM DB2 Express Edition PVU Option 5724-E49 Per Processor
Value Unit (PVU)
IBM DB2 Express Edition Server 5724-E49 Per Limited Use
Option Virtual Server
IBM DB2 Storage Optimization Feature 5724-N78 PROCESSOR-Day(s)
IBM DB2 Storage Optimization Feature 5724-N78 Per Processor
Value Unit (PVU)
IBM DB2 Workgroup Server Edition 5765-F35 Per Authorized
Authorized User Single Install User Single
Install
IBM DB2 Workgroup Server Edition PVU 5765-F35 Per Processor
Option Value Unit (PVU)
IBM DB2 Workgroup Server Edition 5765-F35 Per Limited Use
Socket Option Socket
IBM DB2 pureScale Feature 5724-Y69 Per Processor
Value Unit (PVU)
IBM DB2 pureScale Feature 5724-Y69 PROCESSOR-Day(s)
IBM DB2 pureScale Feature 5724-Y69 Per Authorized
User Single
Install
IBM Database Enterprise Developer 5724-N76 Per Authorized
Edition User for Linux
on z
IBM Database Enterprise Developer 5724-N76 PA Per
Edition Authorized User
IBM Homogeneous Replication Feature 5724-T19 Per Value Unit
for DB2 Enterprise Server Edition
IBM Homogeneous Replication Feature 5724-T19 PROCESSOR-Day(s)
for DB2 Enterprise Server Edition
Charge metrics definitions
Authorized User Single Install
Authorized User Single Install is a unit of measure by which the
program can be licensed. An Authorized User is a unique person who
is given access to the program. An Install is an installed copy of
the program on a physical or virtual disk made available to be executed
on a computer. The program may be installed on any number of computers
or servers, but if the Authorized User has accessed or has access
to more than one Install of the program, the Authorized User requires
a separate entitlement for each such Install. Licensee must obtain
separate, dedicated entitlements for each Authorized User given access
to the program on each Install in any manner directly or indirectly
(for example: via a multiplexing program, device, or application server)
through any means. An entitlement for an Authorized User is unique
to that Authorized User and may not be shared, nor may it be reassigned
other than for the permanent transfer of the Authorized User entitlement
to another person.
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
- http://www.ibm.com/software/lotus/passportadvantage/pvu_licensing_for_customers.html
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.
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 webpage
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
- http://www.ibm.com/software/lotus/passportadvantage/Counting_Software_licenses_using_specific_virtualization_technologies.html
* 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.
Passport Advantage program licenses
DB2 AESE
Part description Part
number
IBM DB2 Advanced Enterprise Server Edition Authorized
User SI Option
DB2 AESE Per Author User Single Install Annual SW S&S E0AJ6LL
Rnwl
DB2 AESE Per Author User Single Install Lic + SW S&S 12 D0GB8LL
Mo
DB2 AESE Per Author User Single Install SW S&S D0GB9LL
Reinstate 12 Mo
DB2 AESE
Part description Part
number
IBM DB2 Advanced Enterprise Server Edition PVU Option
IBM DB2 Advanced Enterprise Server Edition Per PVU E0AJ4LL
Annual SW S&S Rnwl
IBM DB2 Advanced Enterprise Server Edition Per PVU Lic D0GB4LL
+ SW S&S 12 Mo
IBM DB2 Advanced Enterprise Server Edition Per PVU SW D0GB5LL
S&S Reinstate 12 Mo
DB2 Advanced
CEO Offering
Part description Part
number
IBM DB2 Advanced CEO Offering
DB2 Advanced CEO Bundle Per Authorized User Annual SW E0CUNLL
S&S Rnwl
DB2 Advanced CEO Bundle Per Authorized User Lic + SW D0LEFLL
S&S 12 Mo
DB2 Advanced CEO Bundle Per Authorized User SW S&S D0LEGLL
Reinstate 12 Mo
DB2 Advanced
CEO Offering
Part description Part
number
IBM DB2 Advanced CEO
DB2 Advanced CEO Per Authorized User Annual SW S&S Rnwl E0DJWLL
DB2 Advanced CEO Per Authorized User Lic + SW S&S 12 Mo D0NZILL
DB2 Advanced CEO Per Authorized User SW S&S Reinstate D0NZJLL
12 Mo
DB2 CEO
Offering
Part description Part
number
IBM DB2 CEO
DB2 CEO Offering Per Authorized User Annual SW S&S Rnwl E0DJXLL
DB2 CEO Offering Per Authorized User Lic + SW S&S 12 Mo D0NZKLL
DB2 CEO Offering Per Authorized User SW S&S Reinstate D0NZLLL
12 Mo
DB2 CEO
Offering
Part description Part
number
IBM DB2 CEO Offering
DB2 CEO Offering PA Per Authorized User Annual SW S&S E033WLL
Rnwl
DB2 CEO Offering PA Per Authorized User Lic + SW S&S 12 D59RCLL
Mo
DB2 CEO Offering PA Per Authorized User SW S&S D59RDLL
Reinstate 12 Mo
DB2 Enterprise
Server Edition
Part description Part
number
IBM DB2 Enterprise Server Edition PVU Option
DB2 Enterprise Svr Ed Per Processor Value Unit (PVU) E020CLL
Annual SW S&S Rnwl
DB2 Enterprise Svr Ed Per Processor Value Unit (PVU) D55IULL
Lic + SW S&S 12 Mo
DB2 Enterprise Svr Ed Per Processor Value Unit (PVU) SW D55IVLL
S&S Reinstate 12 Mo
DB2 Enterprise
Server Edition
Part description Part
number
IBM DB2 Enterprise Server Edition Authorized User
Single Install
DB2 Enterprise Svr Ed Per Author User Single Install E028NLL
Annual SW S&S R
DB2 Enterprise Svr Ed Per Author User Single Install D56CILL
Lic + SW S&S 12
DB2 Enterprise Svr Ed Per Author User Single Install SW D56CJLL
S&S Reinstat
DB2 Express Edition
Part description Part
number
IBM DB2 Express Edition Server Option
DB2 Express Edition Limited Use Virtual Server Annual E07BNLL
SW S&S Rnwl
DB2 Express Edition Limited Use Virtual Server Lic + SW D0A11LL
S&S 12 Mo
DB2 Express Edition Limited Use Virtual Server SW S&S D0A12LL
Reinstate
DB2 Express Edition
Part description Part
number
IBM DB2 Express Edition PVU Option
DB2 Express Edition PVU Option Processor Value Unit E024QLL
Annual SW S&S Rnwl
DB2 Express Edition PVU Option Processor Value Unit Lic D55TULL
+ SW S&S 12 Mo
DB2 Express Edition PVU Option Processor Value Unit SW D55TVLL
S&S Reinstate 12 Mo
DB2 Express Edition
Part description Part
number
IBM DB2 Express Edition AU Single Install Option
DB2 Express Ed Per Author User Single Install Annual SW E00QULL
S&S R
DB2 Express Ed Per Author User Single Install Lic + SW D52BKLL
S&S 12
DB2 Express Ed Per Author User Single Install SW S&S D52BLLL
Reinstat
DB2 Storage
Optimization Feature
Part description Part
number
IBM DB2 Storage Optimization Feature
DB2 Storage Optimization Feature Processor VU SW S&S D59GGLL
Reinstate 12 Mo
DB2 Storage Optimization Feature Processor Value Unit E02ZDLL
Annual SW S&S Rnwl
DB2 Storage Optimization Feature Processor Value Unit D59GFLL
Lic + SW S&S 12 Mo
DB2 Workgroup
Server Edition
Part description Part
number
IBM DB2 Workgroup Server Edition Socket Option
DB2 Workgroup Server Edition Limited Use Socket Annual E07BQLL
SW S&S Rnwl
DB2 Workgroup Server Edition Limited Use Socket Lic + D0A1LLL
SW S&S 12 Mo
DB2 Workgroup Server Edition Limited Use Socket SW S&S D0A1MLL
Reinstate 12 Mo
DB2 Workgroup
Server Edition
Part description Part
number
IBM DB2 Workgroup Server Edition PVU Option
DB2 Workgroup Svr Ed Per Processor Value Unit (PVU) E024RLL
Annual SW S&S Rnwl
DB2 Workgroup Svr Ed Per Processor Value Unit (PVU) Lic D55TWLL
+ SW S&S 12 Mo
DB2 Workgroup Svr Ed Per Processor Value Unit (PVU) SW D55TXLL
S&S Reinstate 12 Mo
DB2 Workgroup
Server Edition
Part description Part
number
IBM DB2 Workgroup Server Edition Authorized User Single
Install
DB2 Workgroup Svr Ed Per AU Single Install Lic + SW S&S D5B77LL
12 Mo
DB2 Workgroup Svr Ed Per AU Single Install Annual SW E1B79LL
S&S Rnwl
DB2 Workgroup Svr Ed Per AU Single Install SW S&S D5B7ALL
Reinstate 12 Mo
DB2 pureScale Feature
Part description Part
number
IBM DB2 pureScale Feature
DB2 pureScale Feature Per Author User Single Install E0866LL
Annual SW S&S Rnwl
DB2 pureScale Feature Per Author User Single Install D0BPYLL
Lic + SW S&S 12 Mo
DB2 pureScale Feature Per Author User Single Install SW D0BPZLL
S&S Reinstate 12 Mo
DB2 pureScale Feature Per PVU Annual SW S&S Rnwl E0867LL
DB2 pureScale Feature Per PVU Lic + SW S&S 12 Mo D0BQ0LL
DB2 pureScale Feature Per PVU SW S&S Reinstate 12 Mo D0BQ1LL
Database Enterprise Developer Edition
Part description Part
number
IBM Database Enterprise Developer Edition
Database Enterprise Developer Edition per AU Annual SW E02MRLL
S&S Rnwl
Database Enterprise Developer Edition per AU SW S&S D58N6LL
Reinstate 12 Mo
Database Enterprise Developer Edition per Authorized D58N5LL
Usr Lic + SW S&S 12 Mo
IBM DB2 Express Edition
FTL
Part description Part
number
IBM DB2 Express Edition FTL
DB2 Express Edition Limited Use Virtual Server Initl FT D60PLLL
Lic+S&S 12 Mo
DB2 Express Edition Limited Use Virtual Server Subsq FT E03NALL
Lic+S&S 12 Mo
IBM HR
Feature for DB2 ESE
Part description Part
number
IBM Homogeneous Replication Feature for DB2 Enterprise
Server Edition
IBM Homogeneous Replication Feature for DB2 ESE E044TLL
VUAnnual SW S&S Rnwl
IBM Homogeneous Replication Feature for DB2 ESE VULic + D61P3LL
SW S&S 12 Mo
IBM Homogeneous Replication Feature for DB2 ESE VUSW D61P2LL
S&S Reinstate 12 Mo
Passport Advantage trade-up licenses
DB2 AESE
Precursor product Trade-up product Trade-up
part
number
IBM DB2 Advanced
Enterprise Server Edition
PVU Option
IBM DB2 Enterprise Server IBM DB2 Adv ESE Per PVU fr D0GBTLL
Edition PVU + POF DB2 ESE + DB2 POF PVU
TradeUp Lic + SW S&S 12 Mo
IBM DB2 Enterprise Server IBM DB2 Adv ESE Per PVU fr D0GBSLL
Edition PVU + SOF DB2 ESE + DB2 SOF PVU
TradeUp Lic + SW S&S 12 Mo
IBM DB2 Enterprise Server IBM DB2 Adv ESE Per PVU D0GBRLL
Edition CPU Option from DB2 ESE per PVU
TradeUp Lic + SW S&S 12 Mo
IBM DB2 Enterprise Server IBM DB2 Advanced ESE Per D0GKKLL
Edition PVU, POF, SOF PVU fr ESE +POF+SOF PVU
TradeUp Lic + SW S&S 12 Mo
IBM DB2 Enterprise Server IBM InfoSph Whse PVU fr D0G6GLL
Edition CPU Option DB2 Adv ESE PVU TradeUp
Lic + SW S&S 12 Mo
IBM DB2 Enterprise Server IBM InfoSph Whse PVU fr D0GIJLL
Edition +IBM Enterprise DB2 ESE + Base WHse Ftr
Warehouse Feature for DB2 TradeUp Lic + SW S&S 12 Mo
IBM DB2 Enterprise Server IBM InfoSphe Whse PVU fr D0GIKLL
Edition +IBM Base DB2 ESE + Ent Whse PVU
Warehouse Feature for DB2 TradeUp Lic + SW S&S 12 Mo
DB2 AESE
Precursor product Trade-up product Trade-up
part
number
IBM DB2 Advanced
Enterprise Server Edition
Authorized User SI Option
IBM DB2 Enterprise Server DB2 AESE Per AU Single D0GILLL
Edition Authorized User Install fr DB2 ESE AU SI
TrdUp Lic + SW S&S 12 Mo
DB2 Advanced
CEO Offering
Precursor product Trade-up product Trade-up
part
number
IBM DB2 Advanced CEO
IBM DB2 CEO DB2 Advanced CEO AU Sys z D0NWQLL
fr DB2 CEO AU Trade Up Lic
+ SW S&S 12 Mo
IBM DB2 CEO DB2 Advanced CEO AU fr DB2 D0P0MLL
CEO AU Trade Up Lic + SW
S&S 12 Mo
DB2 Advanced
CEO Offering
Precursor product Trade-up product Trade-up
part
number
IBM DB2 Advanced CEO
Offering
IBM DB2 CEO Offering DB2 Advanced CEO Per AU fr D0LEHLL
DB2 CEO Per AU Trade Up
Lic + SW S&S 12 Mo
DB2 CEO
Offering
Precursor product Trade-up product Trade-up
part
number
IBM DB2 CEO
Competitive DB2 CEO Per Authorized D0P0PLL
User fr Competitive Trade
Up Lic + SW S&S 12 Mo
OEM DB2 CEO Per Authorized D0P0NLL
User from OEM Trade Up Lic
+ SW S&S 12 Mo
DB2 Enterprise
Server Edition
Precursor product Trade-up product Trade-up
part
number
IBM DB2 Enterprise Server
Edition Authorized User
Single Install
Qualified Competitor DB2 Enterprise Svr Ed AU D58YULL
SI fr Qualified Competitor
Trade Up Lic +
IBM DB2 Workgroup Server DB2 Enterprise Svr Ed AU D58YTLL
Edition Authorized User Single Install fr WSE AU
Single Install SI Trade Up Lic +
DB2 Enterprise
Server Edition
Precursor product Trade-up product Trade-up
part
number
IBM DB2 Enterprise Server
Edition PVU Option
DB2 Enterprise Server DB2 ESE PVU fr DB2 ESE D570VLL
Edition Restricted Use Restr Use Trdup Lic + SW
S&S 12 Mo
Qualified Competitor PR DB2 Enterprise Server Ed D55IWLL
PVU fr Qual Comp PVU Lic +
SW S&S 12 Mo
IBM DB2 Workgroup Server DB2 Enterprise Server D55IXLL
Edition CPU Option Edition PVU fr DB2 WSE PVU
Lic + SW S&S 12 Mo
DB2 Express Edition
Precursor product Trade-up product Trade-up
part
number
IBM DB2 Express Edition
PVU Option
IBM DB2 Personal Edition DB2 EXPRESS ED PVU OPT FR D59E9LL
Client Device PERS ED Client DEV TRDUP
Lic + SW S&S 12 Mo
DB2 Express Edition
Precursor product Trade-up product Trade-up
part
number
IBM DB2 Express Edition
Server Option
IBM DB2 Express Edition DB2 Express Ed Limited Use D0A1TLL
200 Processor Value Unit Virtual Server Trade Up Fr
EXE 200 PVU Lic + SW
DB2 Workgroup
Server Edition
Precursor product Trade-up product Trade-up
part
number
IBM DB2 Workgroup Server
Edition Authorized User
Single Install
IBM DB2 Express Edition AU DB2 WSE AU Single Install D58Z4LL
Single Install Option fr DB2 Express Ed AU SI
TrdUp Lic + SW S&S 12 Mo
Qualified Competitor DB2 WSE PerAU Single Instl D58Z5LL
fr Qualified Competitor
TrdUp Lic + SW S&S 12 Mo
DB2 Workgroup
Server Edition
Precursor product Trade-up product Trade-up
part
number
IBM DB2 Workgroup Server
Edition PVU Option
Qualified Competitor DB2 Workgroup Svr Ed PVU D55TYLL
fr Qualified Competitor
PVU TrdUp Lic + SW S&S 12
IBM DB2 Express Edition DB2 Workgroup Svr Ed Per D55TZLL
PVU Option PVU fr Express Ed PVU
Trade Up Lic + SW S&S 12
DB2 Workgroup
Server Edition
Precursor product Trade-up product Trade-up
part
number
IBM DB2 Workgroup Server
Edition Socket Option
IBM DB2 Workgroup Server DB2 WSE Limited Use Socket D0A1NLL
Edition 100 Processor TradeUp Fr DB2 WSE 100 PVU
Value Unit Lic + SW S&S 12 Mo
Passport Advantage supply
Program name/description Part
number
DB2 AESE AU SI Option V10.1.0
DB2 10.1 Advanced ESE AU Single Install Option MP BB1ANML
Multilingual Media Pack
DB2 AESE PVU Option V10.1.0
DB2 10.1 Advanced ESE PVU Option Multiplatform BB1APML
Multilingual Media Pack
DB2 ESE AU SI Option V10.1.0
DB2 10.1 Enterprise Svr Ed AU Single Install Option MP BB1AQML
ML Media Pack
DB2 ESE PVU Option V10.1.0
DB2 10.1 Enterprise Svr Ed PVU Option Multiplatform ML BB1ARML
Media Pack
DB2 EXE AU SI Option V10.1.0
DB2 10.1 Express Ed AU Single Install Option MP BB1AZML
Multilingual Media Pack
DB2 EXE FTL Server Option V10.1.0
DB2 10.1 Express Ed FTL Server Option Multiplatform ML BB1B2ML
Media Pack
DB2 EXE Server Option V10.1.0
DB2 10.1 Express Ed Server Option Multiplatform BB1B1ML
Multilingual Media Pack
DB2 Express Ed PVU Option V10.1.0
DB2 10.1 Express Ed PVU Option Multiplatform BB1B0ML
Multilingual Media Pack
DB2 SOF V10.1.0
DB2 10.1 Storage Optimization Feature Multiplatform ML BB1AWML
Media Pack
DB2 WSE AU SI Option V10.1.0
DB2 10.1 Workgroup Svr Ed AU Single Install Option MP BB1ASML
ML Media Pack
DB2 WSE PVU Option V10.1.0
DB2 10.1 Workgroup Svr Ed PVU Option Multiplatform ML BB1ATML
Media Pack
DB2 WSE Socket Option V10.1.0
DB2 10.1 Workgroup Svr Ed Socket Option Multiplatform BB1AUML
ML Media Pack
DB2 pureScale Feature V10.1.0
DB2 10.1 pureScale Feature AIX 6 Multilingual Media BB1B4ML
Pack
DEDE V10.1.0
Database Enterprise Developer Edition 10.1 BB1AGML
Multiplatform ML Media Pack
IBM HR Feature for DB2 ESE V10.1.0
IBM Homogeneous Repliction Ftr for DB2 10.1 ESE BB1AXML
Multiplatfrm ML Media Pack
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.
DB2 SOF V10.1.0
Entitled maintenance Media packs description Part
offerings description number
IBMDB2StorageOptimizationFe DB2 10.1 Storage BB1AWML
atureperValueUnit Optimization Feature
Multiplatform ML Media
Pack
DB2 WSE AU SI Option V10.1.0
Entitled maintenance Media packs description Part
offerings description number
DB2 Workgroup Server DB2 10.1 Workgroup Svr Ed BB1ASML
Edition Authorized User AU Single Install Option
Single Install MP ML Media Pack
DB2 EXE Server Option V10.1.0
Entitled maintenance Media packs description Part
offerings description number
DB2 Express Edition DB2 10.1 Express Ed Server BB1B1ML
Limited Use Virtual Server Option Multiplatform
Option Multilingual Media Pack
DB2 Express Ed PVU Option V10.1.0
Entitled maintenance Media packs description Part
offerings description number
DB2 Express PVU Option DB2 10.1 Express Ed PVU BB1B0ML
Value Unit Option Multiplatform
Multilingual Media Pack
DB2 WSE PVU Option V10.1.0
Entitled maintenance Media packs description Part
offerings description number
IBM DB2 Workgroup Server DB2 10.1 Workgroup Svr Ed BB1ATML
Edition per Processor PVU Option Multiplatform
Value Unit ML Media Pack
DEDE V10.1.0
Entitled maintenance Media packs description Part
offerings description number
IBMDatabaseEnterpriseDevelo Database Enterprise BB1AGML
perEditionperAuthorizedUser Developer Edition 10.1
Multiplatform ML Media
Pack
IBMDatabaseEnterpriseDevelo Database Enterprise BB1AGML
perEditionperAuthorizedUser Developer Edition 10.1
forLinuxonZ Multiplatform ML Media
Pack
IBM HR Feature for DB2 ESE V10.1.0
Entitled maintenance Media packs description Part
offerings description number
IBM Homogeneous IBM Homogeneous Repliction BB1AXML
Replication Feature for Ftr for DB2 10.1 ESE
DB2 Enterprise Server Multiplatfrm ML Media Pack
Edition per Value Unit
DB2 WSE Socket Option V10.1.0
Entitled maintenance Media packs description Part
offerings description number
DB2 Workgroup Server DB2 10.1 Workgroup Svr Ed BB1AUML
Edition Limited Use Socket Socket Option
Multiplatform ML Media
Pack
DB2 pureScale Feature V10.1.0
Entitled maintenance Media packs description Part
offerings description number
DB2 pureScale Feature DB2 10.1 pureScale Feature BB1B4ML
Authorized User Single AIX 6 Multilingual Media
Install Pack
DB2 pureScale Feature DB2 10.1 pureScale Feature BB1B4ML
Processor Value Unit AIX 6 Multilingual Media
Pack
DB2 EXE FTL Server Option V10.1.0
Entitled maintenance Media packs description Part
offerings description number
IBM DB2 Express Edition DB2 10.1 Express Ed FTL BB1B2ML
FTL Server Server Option
Multiplatform ML Media
Pack
DB2 AESE AU SI Option V10.1.0
Entitled maintenance Media packs description Part
offerings description number
DB2 Advanced Enterprise DB2 10.1 Advanced ESE AU BB1ANML
Server Edition Authorized Single Install Option MP
User Single Install Multilingual Media Pack
DB2 AESE PVU Option V10.1.0
Entitled maintenance Media packs description Part
offerings description number
DB2AdvancedEnterpriseServer DB2 10.1 Advanced ESE PVU BB1APML
EditionPVUforLinuxonSystemz Option Multiplatform
Multilingual Media Pack
DB2AdvancedEnterpriseServer DB2 10.1 Advanced ESE PVU BB1APML
EditionProcessorValueUnit Option Multiplatform
Multilingual Media Pack
DB2 ESE PVU Option V10.1.0
Entitled maintenance Media packs description Part
offerings description number
DB2 Enterprise Server DB2 10.1 Enterprise Svr Ed BB1ARML
Edition Linux on z Value PVU Option Multiplatform
Unit ML Media Pack
DB2 Enterprise Server DB2 10.1 Enterprise Svr Ed BB1ARML
Edition Proc Value Unit PVU Option Multiplatform
ML Media Pack
DB2 EXE AU SI Option V10.1.0
Entitled maintenance Media packs description Part
offerings description number
DB2 Express Edition DB2 10.1 Express Ed AU BB1AZML
Authorized User Single Single Install Option MP
Install Option Multilingual Media Pack
DB2 ESE AU SI Option V10.1.0
Entitled maintenance Media packs description Part
offerings description number
DB2 Enterprise Server DB2 10.1 Enterprise Svr Ed BB1AQML
Edition Authorized User SI AU Single Install Option
MP ML Media Pack
Cross-platform products
Cross-platform products for use on System
z
Order the part numbers that follow when the product is used for
either the development of code that will be deployed on System
z servers or when the product will be communicating or transferring
data between a distributed server and a System z server. Otherwise
order from the other set of part numbers in this announcement. This
set of part numbers provides the identical supply and authorization
as the other set in this announcement.
Cross-platform product for use on System
z IFL engines
Order the part numbers that follow when the product is intended
to run on the Linux operating
system on System
z IFL engines. If the product is not intended to run on the Linux operating
system on System
z IFL engines, order from the other set of part numbers in this
announcement. This set of part numbers provides the identical supply
and authorization as the other set in this announcement.
DB2 AESE
Part description Part
number
IBM DB2 Advanced Enterprise Server Edition PVU Option
IBM DB2 Advanced Ent Svr Ed Per PVU for Linux Sys z E0AJ5LL
Annual SW S&S Rnwl
IBM DB2 Advanced Ent Svr Ed Per PVU for Linux Sys z Lic D0GB6LL
+ SW S&S 12 Mo
IBM DB2 Advanced Ent Svr Ed Per PVU for Linux Sys z SW D0GB7LL
S&S Reinstate 12 Mo
DB2 Advanced
CEO Offering
Part description Part
number
IBM DB2 Advanced CEO
DB2 Advanced CEO Per Aut.U.for Linux on Sys.z Annual SW E0DIPLL
S&S Rnwl
DB2 Advanced CEO Per Aut.U.for Linux on Sys.z Lic + SW D0NWMLL
S&S 12 Mo
DB2 Advanced CEO Per Aut.U.for Linux on Sys.z SW S&S D0NWNLL
Reinstate 12 Mo
DB2 Enterprise
Server Edition
Part description Part
number
IBM DB2 Enterprise Server Edition PVU Option
DB2 Enterprise Svr Ed for Linux on System z PVU Annual E020ELL
SW S&S Rnwl
DB2 Enterprise Svr Ed for Linux on System z PVU Lic + D55J0LL
SW S&S 12 Mo
DB2 Enterprise Svr Ed for Linux on System z PVU SW S&S D55J1LL
Reinstate 12 Mo
Database Enterprise Developer Edition
Part description Part
number
IBM Database Enterprise Developer Edition
Database Enterprise Developer Ed per AU Linux Sys z SW D58N8LL
S&S Reinstate 12 Mo
Database Enterprise Developer Ed per AU Linux on Sys z D58N7LL
Lic + SW S&S 12 Mo
Database Enterprise Developer Edition per AU Linux Sys E02MSLL
z Annual SW S&S Rnwl
Trade-up licenses for cross-platform products
DB2 AESE
Precursor product Trade-up product Part
number
IBM DB2 Advanced
Enterprise Server Edition
PVU Option
IBM DB2 Enterprise Server DB2 AESE P/PVU LIN Sys z D0LGPLL
Edition CPU Option fr DB2 ESE PVU LINSys z
TrdUp Lic + SW S&S 12 Mo
On/Off CoD
IBM DB2 Advanced
Enterprise Server Edition PVU Option
Part description Part
number
IBM DB2 Advanced Enterprise Server Ed PROCESSOR-Day(s) D0GBLLL
Per Use-Day OOCoD
IBM DB2 Enterprise
Server Edition PVU Option
Part description Part
number
DB2 Enterprise Svr Ed PROCESSOR-Day(s) Per Use-Day ASQC8LL
OOCoD
IBM DB2 Express Edition
PVU Option
Part description Part
number
DB2 Express Edition PVU Option Processor Day Per D53H1LL
Use-Day OOCoD
IBM DB2 Storage
Optimization Feature
Part description Part
number
DB2 Storage Optimization Feature Processor Day Per D58UFLL
Use-Day OOCoD
IBM DB2 pureScale Feature
Part description Part
number
DB2 pureScale Feature PROCESSOR-Day(s) Per Use-Day D0BQFLL
OOCoD
IBM Homogeneous
Replication Feature for DB2 Enterprise Server Edition
Part description Part
number
IBM Homogeneous Replication Ftr for DB2 ESE Processor D61P4LL
Day Per Use-Day OOCoD
Back to top
The information provided in this announcement letter is for reference
and convenience purposes only. The terms and conditions that govern
any transaction with IBM are contained in the applicable contract
documents such as the IBM International Program License Agreement, IBM International Passport
Advantage Agreement, and the IBM Agreement for Acquisition of
Software Maintenance.
Licensing
IBM International
Program License Agreement including the License Information document
and Proof of Entitlement (PoE) govern your use of the program. PoEs
are required for all authorized use.
Part number products only, offered outside of Passport
Advantage, where applicable, are license only and do not include
Software Maintenance.
This software license includes Software Subscription and Support
(also referred to as Software Maintenance).
License Information form numbers
Program name Program Form number
number
DB2 AESE 5725-B76 L-VACA-8N2QVW
DB2 Advanced CEO Offering 5725-E89 NA
DB2 CEO Offering 5724-R28 NA
DB2 Enterprise Server Edition 5765-F41 L-VACA-8N6KP9
DB2 Express Edition 5724-E49 L-VACA-8N7Q7H
DB2 Storage Optimization Feature 5724-N78 L-VACA-8NHTFR
DB2 Workgroup Server Edition 5765-F35 L-VACA-8N6RZZ
DB2 pureScale Feature 5724-Y69 L-VACA-8NHS9S
Database Enterprise Developer Edition 5724-N76 L-VACA-8N7THG
IBM DB2 Express Edition FTL 5724-S40 L-VACA-8N7Q7H
IBM HR Feature for DB2 ESE 5724-T19 L-VACA-8NHRBD
The program's License Information will be available for review
on the IBM Software
License Agreement website
- http://www.ibm.com/software/sla/sladb.nsf
Limited warranty applies
Yes
Limited warranty
IBM warrants
that when the program is used in the specified operating environment,
it will conform to its specifications. The warranty applies only to
the unmodified portion of the program. IBM does not warrant uninterrupted
or error-free operation of the program or that IBM will
correct all program defects. You are responsible for the results obtained
from the use of the program.
IBM provides
you with access to IBM databases containing information on known
program defects, defect corrections, restrictions, and bypasses at
no additional charge. For further information, consult the IBM Software
Support Handbook found at
- http://www.ibm.com/support/handbook
IBM will
maintain this information for at least one year after the original
licensee acquires the program (warranty period).
Program technical support
Technical support of a program product version or release will
be available for a minimum of five years from the general availability
date, as long as your Software Maintenance is in effect. This technical
support allows you to obtain assistance (via telephone or electronic
means) from IBM for
product-specific, task-oriented questions regarding the installation
and operation of the program product. Software Maintenance also provides
you with access to updates (modifications or fixes), releases, and
versions of the program. You will be notified, via announcement letter,
of discontinuance of support with 12 months' notice. If you require
additional technical support from IBM, including an extension of support
beyond the discontinuance date, contact your IBM representative
or IBM Business
Partner. This extension may be available for a fee.
Money-back guarantee
For clarification, note that if for any reason you are dissatisfied
with the program and you are the original licensee, you may obtain
a refund of the amount you paid for it, if within 30 days of your
invoice date you return the program and its PoE to the party from
whom you obtained it. If you downloaded the program, you may contact
the party from whom you acquired it for instructions on how to obtain
the refund.
For clarification, note that for programs acquired under the IBM International Passport
Advantage Agreement, this term applies only to your first acquisition
of the program.
For clarification, note that for programs acquired under any of
IBM's On/Off CoD software offerings, this term does not apply since
these offerings apply to programs already acquired and in use by you.
Volume orders (IVO)
No
Passport Advantage applies
Yes, and through the Passport Advantage website at
- http://www.ibm.com/software/passportadvantage
This product is only available via Passport Advantage.
It is not available as shrinkwrap.
Usage restriction
Yes.
For additional information refer to the License Information Document
that is available on the IBM Software License Agreement website
- http://www.ibm.com/software/sla/sladb.nsf
International Passport Agreement
Software Subscription and Support applies
Yes. Software Subscription and Support 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, 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
- http://www.ibm.com/support/handbook
Software Subscription and Support does not include assistance for
the design and development of applications, your use of programs in
other than their specified operating environment, 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
- http://www.ibm.com/software/passportadvantage
Other terms
System i Software Maintenance applies
No
Educational allowance available
Not applicable.
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.
On/Off Capacity on Demand (CoD)
To be eligible for On/Off CoD pricing, customers must be enabled
for temporary capacity on the corresponding hardware, and the required
contract - Z125-6907, Amendment for iSeries® and pSeries® Temporary
Capacity On Demand - Software - must be signed prior to use.
Back to top
IBM has
transformed its delivery of hardware and software support services
to help you achieve higher system availability. Electronic Services
is a web-enabled solution that offers an exclusive, no-additional-charge
enhancement to the service and support available for IBM servers.
These services are designed to provide the opportunity for greater
system availability with faster problem resolution and preemptive
monitoring. Electronic Services comprises two separate, but complementary,
elements: Electronic Services news page and Electronic Services Agent.
The Electronic Services news page is a single Internet entry point
that replaces the multiple entry points traditionally used to access IBM Internet
services and support. The news page enables you to gain easier access
to IBM resources
for assistance in resolving technical problems.
The Electronic Service Agent™ is
no-additional-charge software that resides on your server. It monitors
events and transmits system inventory information to IBM on
a periodic, client-defined timetable. The Electronic Service
Agent automatically reports hardware problems to IBM. Early
knowledge about potential problems enables IBM to deliver proactive service
that may result in higher system availability and performance. In
addition, information collected through the Service Agent is made
available to IBM service
support representatives when they help answer your questions or diagnose
problems. Installation and use of IBM Electronic Service
Agent for problem reporting enables IBM to provide better support and
service for your IBM server.
Back to top
Passport Advantage
For Passport Advantage information
and charges, contact your IBM representative or authorized IBM Business
Partner, or authorized IBM Business Partner for Software ValueNet®,
if applicable. Additional information is also available at
- http://www.ibm.com/software/passportadvantage
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.
- https://www.ibm.com/software/howtobuy/passportadvantage/paoreseller
Back to top
To order, contact your local IBM representative or your IBM Business
Partner.
To identify your local IBM Business Partner or IBM representative,
call 1 800-IBM-4YOU (426-4968). For more information, contact the
Americas Call Centers.
- Phone: 800-IBM-CALL (426-2255)
- Fax: 800-2IBM-FAX (242-6329)
For IBM representative: callserv@ca.ibm.com
For IBM Business
Partner: pwswna@us.ibm.com
Mail: IBM Teleweb Customer Support
ibm.com® Sales Execution Center, Americas North
3500 Steeles Ave. East, Tower 3/4
Markham, Ontario
Canada
L3R 2Z1
Reference: VE001
The Americas Call Centers, our national direct marketing organization,
can add your name to the mailing list for catalogs of IBM products.
Note: Shipments will begin after the planned availability
date.
IBM Software
Value Plus
These products are available under IBM Software Value Plus, either
directly from IBM or
through authorized Business Partners who invest in skills and high
value solutions. IBM customers may benefit from the industry-specific
or horizontal solutions, skills and expertise provided by these Business
Partners.
Additions to Software Value Plus will be communicated through standard
product announcements. For a current list of IBM software
available under Software Value Plus, visit
- http://www-01.ibm.com/software/info/itsolutions/softwarevalueplus/
Questions regarding IBM Software Value Plus may be sent to AskSoftwareValueNet@us.ibm.com
Trademarks
Optim, DB2 Connect and Electronic Service Agent are trademarks of IBM Corporation in the United States, other countries, or both.
IBM, DB2, pureScale, Express, Solid, Power, System x, InfoSphere, Rational, Informix, pureXML, Tivoli, AIX, System z, Passport Advantage, Redbooks, System p, System i, WebSphere, MQSeries, solidDB, iSeries, pSeries, ValueNet and ibm.com are registered trademarks of IBM Corporation in the United States, other countries, or both.
Linux is a registered trademark of Linus Torvalds in the United States, other countries, or both.
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. Additional
terms of use are located at
- http://www.ibm.com/legal/us/en/
For the most current information regarding IBM products,
consult your IBM representative
or reseller, or visit the IBM worldwide contacts page
- http://www.ibm.com/planetwide/us/
ENUS212-074.PDF
