Lower costs made easy with IBM DB2 9.7 for Linux , UNIX , and Windows
IBM United States
Software Announcement 209-134
May 19, 2009
 ENUS209-134.PDF (199KB)
|
(Corrected on June 3, 2009)
The Product positioning
section is revised.
DB2® 9.7
for Linux®, UNIX®,
and Windows® helps
you easily lower application development and database administration costs.
The new release includes:
- Enhancements to DB2's stored procedures, triggers, and functions as well
as SQL syntax that helps developers rapidly build applications.
- New functions, packages, and development languages that help you leverage
the people and the skills already in your organization.
- Greater storage savings with more comprehensive extensive compression.
- Easier to use and more powerful workload management that automatically
re-classifies work in progress based on your business priorities.
- More effective system monitoring, easier administration, and tighter security
all designed to help lower your costs.
- The ability to incorporate XML data as part of your business analytics
and Information Agenda using pureXML™.
To order, contact your IBM® representative, an IBM Business Partner, or the Americas Call
Centers at: 800-IBM-CALL
Reference:
DB2 Advanced Access Control Feature: YE001
DB2 Enterprise Server Edition: YE001
DB2 Express Edition: VE001
DB2 Geodetic Data Management Feature: YE001
DB2 High Availability Feature for EXE: YE001
DB2 Performance Optimization Feature for ESE: YE001
DB2 Personal Edition: YE001
DB2 Storage Optimization Feature: YE001
DB2 Workgroup Server Edition: YE001
Database Enterprise Developer Edition: YE001
IBM DB2 Express Edition FTL: YE001
Back to top
DB2 9.7
for Linux, UNIX,
and Windows (LUW)
delivers new capabilities that can help you manage costs and simplify application
development. By moving to DB2 9.7, you can improve the productivity of your programmers
and database administrators, and take advantage of performance and compression
improvements to help lower your hardware cost.
Finally, enhancements to DB2 pureXML - standard with all DB2 9.7 LUW editions - opens new opportunities
to exploit your XML data as part of your warehouse. You can now include XML
in your business analytics and as part of your overall Information Agenda.
Back to top
Refer to the Hardware requirements and Software requirements sections of this document.
Back to top
June 19, 2009: Electronic software delivery
August 28, 2009: Media and documentation
Back to top
Further storage savings with extensive compression
DB2 9.7
expands the scope of its advanced data row compression to more types of data.
This can further reduce your storage requirements while improving the efficiency
and performance of your disk and IO. Compression is enabled with the Storage
Optimization Feature license.
- XML data in the XML storage object of a table can now be compressed using
data row compression.
- Temporary tables are now automatically compressed by the DB2 optimizer
to help maximize storage savings and performance.
- Indexes can be compressed. If data row compression is enabled on a table,
indexes on the compressed tables will be compressed by default.
- Data replication source tables can be compressed.
- In addition, because some inline LOB files can now be stored in base table
rows, you can use data row compression to compress them as well. When a large
object (LOB) is smaller than a specified size, the LOB is now stored in the
row of the base table instead of in the separate LOB storage object, helping
to increase performance.
Performance enhancements
DB2 9.7
contains numerous performance enhancements benefiting a wide range of database
applications.
Access plan reuse helps ensure consistent performance for applications
not originally written for ideal database performance. By enabling static
SQL access plan reuse, you can ensure that queries execute with predictable
performance across version or fix pack upgrades, updates to statistics, and
some configuration parameter changes. Access plan reuse keeps the access plan
that was chosen for a static SQL statement the same as, or very similar to,
the existing query execution plan across binds or rebinds.
Statement concentration, new for DB2 9.7, reduces the need for compilation.
The statement concentrator enables SQL statements that are identical except
for the values of literals to share the same access plan.
Sampling RUNSTATS on statistical views run faster in DB2 9.7. The SYSTEM
sampling style is now supported and overall sampling performance is better.
Optimization guidelines for packages are also easier to apply.
Currently committed locking semantics help the cursor stability (CS) isolation
level provide better concurrency and faster access to data. The new locking
behavior offers significantly reduced lock wait and deadlock scenarios. The
new behavior is beneficial in high-throughput transaction-processing database
environments. This new behavior is particularly beneficial if your applications
run against databases from multiple vendors. You can use CS instead of writing
and maintaining code pertaining to locking semantics specifically for DB2 databases.
This new CS behavior is the default for new databases, and can be enabled
for existing databases that have upgraded from a previous release.
Scan sharing improves concurrency and performance. DB2 9.7 allows multiple scanners to coordinate
the shared use of buffer pool pages and potentially reduce I/O through buffer
pool page retention. Scan sharing increases workload concurrency and performance.
Partitioned indexes on partitioned tables improve performance. With DB2 9.7,
you can use partitioned indexes to improve performance when you roll data
into and out of a table. In addition, partition elimination for queries against
a partitioned table that uses partitioned indexes can be more efficient.
XML insight with pureXML
Enhancements to DB2 pureXML opens new opportunities to exploit your XML
data by deploying it in data warehouses. XML data is now supported in the
following additional types of tables, objects, and environments: range-partitioned
tables, MDC tables, declared temporary tables, user-defined functions, and
partitioned database environments.
DB2 pureXML performance
has also been enhanced. Multiple XML documents in a column can now be decomposed
at the same time. In addition, write access is supported during creation or
reorganization of indexes over XML data. Finally, all XML data can now be
compressed (refer to the compression enhancements section).
Application development flexibility
Significant application development enhancements have been added to DB2 9.7.
These enhancements will help both existing DB2 applications to be built and modified
quicker, and also allow developers with multiple SQL language skills to work
easily with DB2.
A key focus of DB2 9.7 has been to make it easier to create stored procedures
and triggers in a shorter amount of time. The enhancements include expanded
support for implicit casting, the creation of modules, new functions, and
a range of new data types.
Module and package creation allows developers to bundle and deploy groups
of procedures, functions, and variables. A large number of new, pre-written,
system defined functions and modules included in DB2 9.7 replace scripts or functions that
database administrators (DBAs) may have previously written themselves. Examples
of some of the many new modules are listed below.
- Mail modules
- The mail package allows DBAs and developers to easily send e-mails and
interact with an SMTP server or sockets in their scripts.
- Alert and output modules
- The output package gives DBAs the ability to manipulate files as well
as write to external files. This is very useful for administrative scripting
as well for debugging and deploying applications. The alert package can be
combined with the output module to build custom monitoring and batch scripts.
- Job Scheduling and Utility Module
- The new package helps DBAs automate job scheduling and tracking from
within their existing scripts. A wide range of utilities, SQL and DDL commands
are now available for greater hands-free administration with DB2.
- File modules
- Working with LOBs and files is now easier with the functions included
in the file manipulation package.
DB2 9.7
introduces new data type support for NUMBER, VARCHAR2, and DATE with time
component. To make data management more compatible with other database management
systems, you can now use the NUMBER and VARCHAR2 data types. You can also
have the database manager interpret the DATE data type (normally comprised
of year, month, day) as a TIMESTAMP(0) data type (comprised of year, month,
day, hour, minute, second). Improvements in string manipulation functions,
such as TO_NUMBER, DATETIME, and TO_VARCHAR, make it easy to use the new data
type.
Alternative SQL language syntax is supported including alternative SQL
language syntax for DELETE statements, the RID_BIT scalar function, the FOR
UPDATE clause for SELECT INTO statements, and alternative SQL programming
language syntax for triggers and procedures. Alternative SQL syntax such as
varying outer join methods is now supported.
DB2 9.7
has new application and administrative interfaces to simplify development.
- A new scripting and command line development tool, CLPPlus, provides
support for dynamically creating, editing, and running SQL statements and
scripts.
- Data dictionary views are now available that enhance the existing DB2 catalog
and snapshot information. The data dictionary views are self-describing, so
you can determine what information is available and how to access it.
Full-text searches with Net Search Extender are available in DB2 9.7 for range-partitioned
tables and additional partitioned database environments.
Accessing IBM database
management systems (DB2 and Informix®) is easier than ever. The common IBM data server
clients and drivers have been enhanced and simplified, as have the IBM Database Add-Ins
for Visual Studio and new Python extensions.
Autonomous transaction support and the ability to create global temporary
tables expands the DB2 capabilities. In addition to federating data from DB2 and
IDS databases, DB2 9.7
now supports Web services through federation.
Business-critical reliability and availability
You can now invoke a new stored procedure to move the data in a table to
a new table object of the same name (but with possibly different storage characteristics)
while the data remains online and available for access. You can also generate
a new optimal compression dictionary when a table is moved. For system leveraging
data partitioning, a new node can be added online to minimize the impact on
warehouse environments as the system grows.
DB2 is
now more resilient to critical errors or traps. The first job of your data
server is to keep running. Even when faced with a critical error or trap, DB2 9.7
tries to continue to safely operate. If the data server determines that it
can safely keep working, it will try to isolate the problem and provide diagnostic
messages to help resolve the issue. If you need to restart the data server
to fix the problem, you can now wait until after peak business hours.
Simplified administration
DB2 9.7
provides enhancements that make it easier to manage DB2 environments, can help you reduce the
total cost of ownership (TCO), reduce the impact of performing system management
tasks, and extend the capabilities of the autonomic features. Automatic storage
capabilities have been expanded, and unused storage extents are easier to
reclaim. Adding database partitions has been simplified. Finally, enhancements
to installation, upgrade, and fix pack procedures make DB2 faster to deploy and easier to maintain.
DB2 9.7
accelerates problem solving through new point in time and event monitoring.
You can now better understand what is happening inside your DB2 data server
by using the new comprehensive monitoring information designed to address
common diagnostic problems. Since the new monitoring is also more efficient,
this new level of understanding doesn't come at a price. These enhancements
include:
- New monitor elements, available through SQL, that show where and how the DB2 database
manager is spending its time.
- Improved lock event reporting with a unified approach to monitoring all
lock event types.
- A clearer view into the package cache, including static and dynamic statements.
- A new event monitor that collects section details when capturing an SQL
activity event.
Adaptive workload management
DB2 9.7
both enhances and simplifies workload management. Application-level control
and aggregate activity data collection, and the definition of workloads have
been simplified. For Linux environments, the workload manager has been integrated
with Linux workload
management (WLM). DB2 9.7 supports priority aging of in-progress activities,
I/O buffer pool priority control for service classes, new thresholds, and
improved time granularity for time-based thresholds. These new controls allow DB2 to
react to changing workloads more precisely and effectively right out of the
box. The DB2 data
server can increase or decrease the priority of the workload ensuring that
both runaway queries don't overwhelm a system and that key workloads under
tight service level agreements get priority. Workload Management is included
as part of the Performance Optimization Feature.
Security enhancements
With the number of both internal and external security threats growing,
it is important that data security can be separated from a DBA's management
of critical systems. Advances in separation of duties are designed to let
DBAs maintain full control over database operation, while preventing access
to the data. You can also easily isolate all security and auditing control
into the hands of a separate security administrator. Security has further
been simplified with new groups making application development privileges
as well as workload management simpler. Additionally, security functionality
has been extended with AES encryption, Transport Layer Security (TLS), and
additional Secure Sockets Layer (SSL) client support.
DB2 features
and editions
DB2 features Express Edition Workgroup Enterprise
Edition Edition
Performance Not available Not available Available for
Optimization extra charge
Feature for
Enterprise
Server Edition
(Performance
Expert, Query
Patroller,
Workload
Management)
Storage Not available Not available Available for
Optimization extra charge
Feature
(Compression:
row-level, XML
data, indexes,
data
replication
source tables,
temporary
tables)
Advanced Access Not available Not Available Available for
Control Feature extra charge
(LBAC)
Geodetic Data Not available Not available Available for
Management extra charge
Feature
(Geodetic
Extender)
High Available for Included in Included in
Availability extra charge base base
Feature for
Express Edition
(HADR, Online
Reorg, Tivoli
System
Automation)
Note:DB2 Express
Edition Fixed Term 12 Month License and Subscription (DB2 Express FTL) includes High Availability
Feature for Express edition provided both servers in the high availability
cluster are licensed under the DB2 Express FTL license.
Accessibility by people with disabilities
A US Section 508 Voluntary Product Accessibility Template (VPAT) can be
requested via the IBM Web site
- http://www.ibm.com/able/product_accessibility/index.html
Section 508 of the U.S. Rehabilitation Act
The products in this announcement are capable as of August 28, 2009 , 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 U.S. Section 508 Voluntary Product Accessibility Template (VPAT),
containing details on the products accessibility compliance, can be requested
on the following Web site
- http://www.ibm.com/able/product_accessibility/index.html
Back to top
IBM DB2 Editions
for production deployment
IBM DB2 9.7
for Linux, UNIX,
and Windows,
Enterprise Server Edition:DB2 Enterprise is designed to meet the data
server needs of mid-size 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 from physical
to virtual servers. DB2 Enterprise 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.
It is the data server backend of choice for industry-leading ISVs building
enterprise solutions such as business intelligence, content management, e-commerce,
Enterprise Resource Planning, Customer Relationship Management, or Supply
Chain Management. Additionally, DB2 Enterprise offers connectivity, compatibility,
and integration with other enterprise DB2 and IDS data sources.
Program charges: DB2 Enterprise includes Table Partitioning, High-Availability
Disaster Recovery (HADR), Online Reorganization, Materialized Query Tables
(MQTs), Multidimensional Clustering (MDC), Query Parallelism, Connection Concentrator,
the Governor, pureXML,
backup compression, and Tivoli® System Automation for Multiplatforms (SA MP).
The product also includes DB2 Homogeneous Federation and Homogeneous SQL Replication
allowing federated data access and replication between DB2 servers as well as Web services federation. DB2 Enterprise
is available on either a Processor Value Unit or per Authorized User pricing
model. You must acquire a separate user license for each Authorized User of
this product with a minimum purchase of 25 users per 100 Processor Value Units.
IBM DB2 9.7
for Linux, UNIX,
and Windows,
Workgroup Server Edition:DB2 Workgroup is the data server of choice for deployment
in a departmental, workgroup, or medium-sized business environment. It is
offered in per Authorized User, Value Unit, or limited use socket pricing
models to provide an attractive price point for medium-size installations
while providing a full-function data server.
Program charges: DB2 Workgroup includes High-Availability Disaster Recovery
(HADR), Online Reorganization, pureXML, Web services federation support, DB2 Homogeneous
Federation, Homogeneous SQL Replication, backup compression, and Tivoli System
Automation for Multiplatforms (SA MP). DB2 Workgroup can be deployed in Linux, UNIX, and Windows server
environments and will use up to 16 cores and 16 GB of memory. DB2 Workgroup
is restricted to a stand-alone physical server with a specified maximum number
of Processor Value Units based on the total number and type of processor cores,
as determined in accordance with the IBM Express Middleware™ Licensing
Guide available at
- ftp://ftp.software.ibm.com/software/smb/pdfs/LicensingGuide.pdf
If licensed using per Limited Use Socket licensing you can deploy on servers
up to 4 sockets. You must acquire a separate user license for each authorized
user of this product, with a minimum purchase of five users per server.
IBM DB2 9.7
for Linux, UNIX,
and Windows,
Express Edition:DB2 Express 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 per Authorized User, Value Unit, or Limited Use Virtual Server
based pricing models to provide choices to match SMB customer needs. It comes
with simplified packaging and is easy to transparently install within an application. DB2 Express
can also be licensed on a yearly fixed term Limited Use Virtual Server license.
While it is easy to upgrade to the other editions of DB2 9.7, DB2 Express includes the same autonomic
manageability features of 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 operating
systems, such as Linux, Windows or Solaris and includes pureXML, web services
federation, DB2 Homogeneous Federation, Homogeneous SQL Replication, and backup
compression. If licensed as a yearly subscription (DB2 Express FTL) it also
includes High Availability feature as long as both primary and secondary servers
in the high availability cluster are licensed. If licensed using processor
value units, the limit is 200 PVUs. If licensed under the Limited Use Virtual
Server metric, DB2 Express will use up to four cores on the server. The DB2
data server cannot use more than 4 GB of memory per server. You must acquire
a separate user license for each authorized user of this product with a minimum
purchase of five users per server.
DB2 9.7,
Express-C is a free, entry-level edition of the DB2 data server for the developer and partner
community. It is designed to be up and running in minutes, is 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 pureXML.
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, and can also be distributed with third-party solutions without
any royalties to IBM. It can be installed on physical or virtual systems
with any amount of CPU and RAM, and is optimized to utilize up to a maximum
of two processor cores and 2 GB of memory. DB2 Express-C is refreshed at major release
milestones and comes with online community-based assistance. Users requiring
more formal support, access to fixpacks, or additional capabilities such as
high availability clustering and replication features, can purchase optional
yearly subscription for DB2 Express (FTL) or upgrade to other DB2 editions.
IBM DB2 9.7
for Linux, UNIX,
and Windows,
Personal Edition:DB2 Personal is a single-user, full-function relational
database, with built-in replication, ideal for desktop or laptop-based deployments. DB2 Personal
can be remotely managed, making it the perfect choice for deployment in occasionally
connected or remote office implementations that don't require multiuser capability.
Program charges: DB2 Personal Edition can be deployed on Linux or Windows.
You must acquire a separate user license for each Authorized User of this
product.
IBM DB2 Edition
for application development deployment
IBM Database
Enterprise Developer Edition 9.7: This 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, DB2 Enterprise, IDS Enterprise Edition, DB2
Connect™ Unlimited Edition for System z®, and all the DB2 9.7 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 user license for each Authorized User
of this product.
IBM DB2 9.7,
Enterprise Edition priced features
IBM DB2 Storage
Optimization Feature for Linux, UNIX, and Windows: This feature includes data
row 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, allowing for improved performance.
In I/O-bound systems, it will not only reduce storage requirements but may
improve overall performance.
- Index compression utilizes multiple algorithms to reduce the storage
requirements for indexes and reduces 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 reducing the total storage needed by DB2.
Program charges: This feature is available as an option for DB2 Enterprise
only and can only be acquired if the underlying DB2 data server is licensed with the Processor
Value Unit charge metric.
IBM DB2 Advanced
Access Control Feature for Linux, UNIX, and Windows: This feature increases
the control you have over who can access your data. This feature delivers
Label Based Access Control (LBAC) and lets you decide exactly who has write
access and who has read access to individual rows and individual columns.
Program charges: This feature is available as an option for DB2 Enterprise
only. You must acquire this feature under the same charge metric as the underlying DB2 data
server.
IBM DB2 Performance
Optimization Feature for Enterprise Server Edition for Linux, UNIX, and Windows:DB2 Performance
Optimization leverages DB2 Workload Management, DB2 Performance Expert, and DB2 Query Patroller
components to bring you the best in performance tuning and monitoring. The
Performance Optimization Feature contains the following components:
- DB2 Workload
Management (WLM) lets you divide your work into classes and tailor your
data server to support a variety of users and applications on the same system
by prioritizing those classes.
- DB2 Performance
Expert (PE) is a performance analysis and tuning tool for managing a heterogeneous
mix of DB2 systems
with a single end-user interface. DB2 PE simplifies DB2 performance management by providing
you with the capability to monitor applications, system statistics, and system
parameters using a single tool.
- DB2 Query
Patroller (QP) is a powerful query workload management offering that proactively
and dynamically controls submission and execution of queries to better manage DB2 data
server workloads to meet business needs.
Program charges: This feature is available as an option for DB2 Enterprise
only. You must acquire this feature under the same charge metric as the underlying DB2 data
server.
IBM DB2 Geodetic
Data Management Feature for Linux, UNIX, and Windows: This feature provides the
ability to store, access, manage, or analyze location-based round earth information
for weather, defense, intelligence, or natural resource applications for commercial
or government use. It provides the ability to manage and analyze spatial information
with accuracies in distance and area by treating the earth as a continuous
spherical coordinate system.
Program charges: This feature is available as an option for DB2 Enterprise
only. You must acquire this feature under the same charge metric as the underlying DB2 data
server.
IBM Homogeneous
Replication Feature for DB2 Enterprise Server Edition: This feature is available
as an option for DB2 Enterprise. The homogeneous replication feature allows
you to use Q replication to copy data at high speed and low latency to multiple DB2 or
IDS remote databases. The homogeneous replication feature is part of a larger IBM solution
for replicating data in small and large enterprises.
Program charges: This feature is available as an option for DB2 Enterprise
Server Edition. It can only be acquired if the underlying DB2 data server
is licensed with the Processor Value Unit charge metric.
Note: Refer to Software Announcement 209-140, dated May 19, 2009.
Note:IBM Homogeneous
Replication Feature provides Q replication functionality. SQL-based replication
is available in all editions of DB2 except DB2 Express-C at no charge.
IBM DB2 9.7,
Express Edition priced features
IBM DB2 High
Availability Feature for Express Edition for Linux, UNIX, and Windows: The DB2 High Availability Feature provides 24
x 7 continuous availability for your DB2 data server. The High Availability Feature
contains the following components:
- HADR allows failover to a standby system in the event of a software
or hardware failure on the primary system. HADR is included in DB2 Enterprise
and DB2 Workgroup
- Online reorganization reconstructs the rows in a table to eliminate
fragmented data and compact information for better performance while permitting
uninterrupted access to the table data. Online reorganization is included
in DB2 Enterprise
and DB2 Workgroup.
- IBM Tivoli System
Automation for Multiplatforms (SA MP) provides high availability by automating
the control of IT resources such as processes, filesystems, IP addresses,
and other resources. It can coordinate the automatic failover to a standby DB2 data
server using HADR. SA MP is included in DB2 Enterprise and DB2 Workgroup.
Program charges: This feature is available as an option for DB2 Express. You
must acquire this feature under the same charge metric as the underlying DB2 data
server. DB2 Express
FTL includes this feature at no charge provided both servers in the high availability
cluster are licensed under the DB2 Express Fixed Term License.
Availability of national languages
Product description Language GA date
DB2 Adv Access Ctrl Feature Multilingual August 28, 2009
V9.7.0 (French,
Korean,
Chinese -
Simplified,
Spanish,
Portuguese-Brazilian,
German,
Japanese,
Chinese -
Traditional,
English,
Turkish,
Czech,
Italian,
Polish)
DB2 ESE AU Option V9.7.0 Multilingual August 28, 2009
(French,
Danish,
Russian,
Korean,
Chinese -
Simplified,
Spanish,
Norwegian
Bokmal,
Portuguese-Brazilian,
German,
Swedish,
Japanese,
Chinese -
Traditional,
English,
Czech,
Italian,
Finnish,
Polish)
DB2 EXE AU Option V9.7.0 Multilingual August 28, 2009
(French,
Danish,
Russian,
Korean,
Chinese -
Simplified,
Spanish,
Norwegian
Bokmal,
Portuguese-Brazilian,
German,
Swedish,
Japanese,
Chinese -
Traditional,
English,
Czech,
Italian,
Finnish,
Polish)
DB2 EXE FTL Server Option Multilingual August 28, 2009
V9.7.0 (French,
Danish,
Russian,
Korean,
Chinese -
Simplified,
Spanish,
Norwegian
Bokmal,
Portuguese-Brazilian,
German,
Swedish,
Japanese,
Chinese -
Traditional,
English,
Czech,
Italian,
Finnish,
Polish)
DB2 EXE Server Option V9.7.0 Multilingual August 28, 2009
(French,
Danish,
Russian,
Korean,
Chinese -
Simplified,
Spanish,
Norwegian
Bokmal,
Portuguese-Brazilian,
German,
Swedish,
Japanese,
Chinese -
Traditional,
English,
Czech,
Italian,
Finnish,
Polish)
DB2 Express Ed CPU Option Multilingual August 28, 2009
V9.7.0 (French,
Danish,
Russian,
Korean,
Chinese -
Simplified,
Spanish,
Norwegian
Bokmal,
Portuguese-Brazilian,
German,
Swedish,
Japanese,
Chinese -
Traditional,
English,
Czech,
Italian,
Finnish,
Polish)
DB2 Geodetic DM Feature Multilingual August 28, 2009
V9.7.0 (French,
Korean,
Chinese -
Simplified,
Spanish,
Portuguese-Brazilian,
German,
Japanese,
Chinese -
Traditional,
English US,
Turkish,
Czech,
Italian,
Polish)
DB2 HAF for Express Edition Multilingual August 28, 2009
V9.7.0 (French,
Korean,
Chinese -
Simplified,
Spanish,
Portuguese-Brazilian,
German,
Japanese,
Chinese -
Traditional,
English,
Turkish,
Czech,
Italian,
Polish)
DB2 POF for ESE V9.7.0 Multilingual August 28, 2009
(French,
Korean,
Chinese -
Simplified,
Spanish,
Portuguese-Brazilian,
German,
Japanese,
Chinese -
Traditional,
English,
Turkish,
Czech,
Italian,
Polish)
DB2 Personal Edition V9.7.0 Multilingual August 28, 2009
(French,
Danish,
Korean,
Chinese -
Simplified,
Spanish,
Norwegian
Bokmal,
Portuguese-Brazilian,
German,
Swedish,
Japanese,
Chinese -
Traditional,
English,
Czech,
Italian,
Finnish,
Polish)
DB2 SOF V9.7.0 Multilingual August 28, 2009
(French,
Korean,
Chinese -
Simplified,
Spanish,
Portuguese-Brazilian,
German,
Japanese,
Chinese -
Traditional,
English,
Turkish,
Czech,
Italian,
Polish)
DB2 UDB ESE V9.7.0 Multilingual August 28, 2009
(French,
Danish,
Russian,
Korean,
Chinese -
Simplified,
Spanish,
Norwegian
Bokmal,
Portuguese-Brazilian,
German,
Swedish,
Japanese,
Chinese -
Traditional,
English,
Czech,
Italian,
Finnish,
Polish)
DB2 WSE AU Option V9.7.0 Multilingual August 28, 2009
(French,
Danish,
Russian,
Korean,
Chinese -
Simplified,
Spanish,
Norwegian
Bokmal,
Portuguese-Brazilian,
German,
Swedish,
Japanese,
Chinese -
Traditional,
English,
Czech,
Italian,
Finnish,
Polish)
DB2 WSE CPU Option V9.7.0 Multilingual August 28, 2009
(French,
Danish,
Russian,
Korean,
Chinese -
Simplified,
Spanish,
Norwegian
Bokmal,
Portuguese-Brazilian,
German,
Swedish,
Japanese,
Chinese -
Traditional,
English,
Czech,
Italian,
Finnish,
Polish)
DB2 WSE Socket Option V9.7.0 Multilingual August 28, 2009
(French,
Danish,
Russian,
Korean,
Chinese -
Simplified,
Spanish,
Norwegian
Bokmal,
Portuguese-Brazilian,
German,
Swedish,
Japanese,
Chinese -
Traditional,
English,
Czech,
Italian,
Finnish,
Polish)
DEDE V9.7.0 Multilingual August 28, 2009
(French,
Korean,
Chinese -
Simplified,
Spanish,
Portuguese-Brazilian,
German,
Japanese,
Chinese -
Traditional,
English,
Italian)
Back to top
Program VRM Program name
number
5724-N80 9.7.0 IBM DB2 Advanced Access
Control Feature
5765-F41 9.7.0 IBM DB2 Enterprise Server
Edition
5724-E49 9.7.0 IBM DB2 Express Edition
5724-S40 9.7.0 IBM DB2 Express Edition
Fixed Term License
5724-N75 9.7.0 IBM DB2 Geodetic Data
Management Feature
5724-N85 9.7.0 IBM DB2 High Availability
Feature for Express
Edition
5724-N77 9.7.0 IBM DB2 Performance
Optimization Feature for
Enterprise Server Edition
5724-B55 9.7.0 IBM DB2 Personal Edition
5724-N78 9.7.0 IBM DB2 Storage
Optimization Feature
5765-F35 9.7.0 IBM DB2 Workgroup Server
Edition
5724-N76 9.7.0 IBM Database Enterprise
Developer Edition
Back to top
IBM training
provides education to support many IBM offerings. Descriptions of courses for
IT professionals and managers are on the IBM training Web site
- 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
to meet your demanding schedule. Instructor-Led Online (ILO) is an innovative
learning format where students get the benefit of being in a classroom with
the convenience and cost savings of online training. Take advantage of our
ILO formats: ILO Classic - high-quality classroom content taught live and
online by our expert instructors; ILO Flex Time - shorter sessions over multiple
weeks; and ILO Select - two to three hour lectures on key technical topics.
Go green with IBM Onsite training for groups as small as three or as
large as fourteen. Choose from the same quality training delivered in classrooms,
or customize a course or a selection of courses to best suit your business
needs. Enjoy further savings when you purchase training at a discount with
an IBM Education
Pack - online account -- 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 Web site or with your training representative
for the most recent training schedule.
Course Course title Course type
code
CL28 Fast Path to DB2 9 Classroom
for
Experienced
Relational DBAs
3L28 Fast Path to DB2 9 Instructor-Led
for Online
Experienced
Relational DBAs
CL48 DB2 9 for LUW Classroom
Quickstart for
Experienced
Relational DBAs
3L48 DB2 9 for LUW Instructor-Led
Quickstart for Online
Experienced
Relational DBAs
CL2X DB2 9 Database Classroom
Administration
Workshop for Linux,
UNIX, and Windows
3L2X DB2 9 Database Instructor-Led
Administration Online
Workshop for Linux,
UNIX, and Windows
CL31 DB2 9.7 for Linux, Classroom
UNIX, and
Windows New Features
CL12 Query XML Data with Classroom
DB2 9
3L12 Query XML Data with Instructor-Led
DB2 9 Online
CL14 Manage XML Data with Classroom
DB2 9
3L14 Manage XML Data with Instructor-Led
DB2 9 Online
CL13 Query and Manage XML Classroom
Data with DB2 9
3L13 Query and Manage XML Instructor-Led
Data with DB2 9 Online
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-0 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/
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.
Exam Exam name Certification title
number
730 DB2 9 Family IBM Certified
Fundamentals Database Associate -
DB2 9 Fundamentals
541 DB2 9.7 DBA for IBM Certified
Linux, UNIX, and Database
Windows Administrator - DB2
9.7 DBA for Linux,
UNIX, and Windows
543 DB2 9.7 Application IBM Certified
Developer Application
Developer - DB2 9.7
For additional 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 Web site
- http://www.ibm.com/common/ssi
Also, visit the Passport Advantage® Web site
- http://www.ibm.com/software/passportadvantage
Back to top
No hardcopy 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-1.ibm.com/support/mysupport/us/en/?OpenDocument
The following books are available for the DB2 9.7 for Linux, UNIX, and Windows products:
Description Language Form number
Administrative API English SC27-2435-00
Reference
Japanese SC88-5883-00
Korean SA30-3958-00
Spanish SC11-3912-00
Administrative English SC27-2436-00
Routines and Views
Japanese SC88-5880-00
Korean SA30-3955-00
Spanish SC11-3909-00
CLI Guide and English SC27-2437-00
Reference, Volume 1
Japanese SC88-5885-00
CLI Guide and English SC27-2438-00
Reference, Volume 2
Japanese SC88-5886-00
Command Reference English SC27-2439-00
Japanese SC88-5884-00
Korean SA30-3959-00
Spanish SC11-3914-00
Data Movement English SC27-2440-00
Utilities Guide and
Reference
German SC12-4281-00
Japanese SC88-5903-00
Korean SA30-3969-00
Simplified Chinese S151-1186-00
Data Recovery and English SC27-2441-00
High Availability
Guide and Reference
German SC12-4282-00
Japanese SC88-5904-00
Korean SA30-3970-00
Simplified Chinese S151-1187-00
Database English SC27-2442-00
Administration
Concepts and
Configuration
Reference
German SC12-4283-00
Japanese SC88-5870-00
Korean SA30-3951-00
Simplified Chinese S151-1163-00
Database Monitoring English SC27-2458-00
Guide and Reference
German SC12-4287-00
Japanese SC88-5872-00
Korean SA30-3953-00
Simplified Chinese S151-1165-00
Database Security English SC27-2443-00
Guide
German SC12-4285-00
Japanese SC88-5905-00
Korean SA30-3971-00
Simplified Chinese S151-1188-00
DB2 Connect User's English SC27-2434-00
Guide
Brazilian Portuguese S517-9475-00
Bulgarian SA12-6678-00
Croatian SA12-6611-00
Czech SC09-3857-00
Dutch SC14-2066-00
French SC11-6572-00
German SC12-4280-00
Hungarian SC22-1093-00
Japanese SC88-5890-00
Korean SA30-3964-00
Polish SC85-0375-00
Romanian SA22-1403-00
Russian SC89-1144-00
Simplified Chinese S151-1176-00
Slovakian SA22-1125-00
Slovenian SA12-6650-00
Spanish SC11-3918-00
Traditional Chinese SC40-2457-00
DB2 Text Search Guide English SC27-2459-00
German SC12-4288-00
Japanese SC88-5902-00
Spanish SC11-3927-00
Developing ADO.NET English SC27-2444-00
and OLE DB
Applications
Japanese SC88-5874-00
Simplified Chinese S151-1167-00
Developing Embedded English SC27-2445-00
SQL Applications
Japanese SC88-5875-00
Simplified Chinese S151-1168-00
Developing Java English SC27-2446-00
Applications
Japanese SC88-5878-00
Spanish SC11-3907-00
Developing Perl, PHP, English SC27-2447-00
Python, and Ruby on
Rails Applications
Japanese SC88-5879-00
Spanish SC11-3908-00
Developing English SC27-2448-00
User-defined Routines
(SQL and External)
Japanese SC88-5876-00
Simplified Chinese S151-1169-00
Getting Started With English GI11-9410-00
Database Application
Development
Japanese GI88-4201-00
Simplified Chinese G151-1170-00
Getting Started with English GI11-9411-00
DB2 Installation and
Administration on
Linux and Windows
Brazilian Portuguese G517-9471-00
Czech GI11-8471-00
French GI11-7343-00
German GI11-3220-00
Japanese GI88-4202-00
Korean GA30-3960-00
Polish GI11-8391-00
Russian GI43-0094-00
Simplified Chinese G151-1172-00
Spanish GI11-8640-00
Traditional Chinese GI13-0694-00
Globalization Guide English SC27-2449-00
German SC12-4279-00
Japanese SC88-5906-00
Korean SA30-3972-00
Simplified Chinese S151-1189-00
Installing and English SC27-2432-00
Configuring DB2
Connect Personal
Edition
Brazilian Portuguese S517-9476-00
Bulgarian SA12-6679-00
Croatian SA12-6612-00
Czech SC09-3858-00
Dutch SC14-2067-00
French SC11-6573-00
German SC12-4277-00
Hungarian SC22-1094-00
Japanese SC88-5891-00
Korean SA30-3965-00
Polish SC85-0376-00
Romanian SA22-1404-00
Russian SC89-1145-00
Simplified Chinese S151-1177-00
Slovakian SA22-1126-00
Slovenian SA22-1251-00
Spanish SC11-3919-00
Traditional Chinese SC40-2456-00
Installing and English SC27-2433-00
Configuring DB2
Connect Servers
Brazilian Portuguese S517-9477-00
Bulgarian SA12-6680-00
Croatian SA12-6613-00
Czech SC09-3859-00
French SC11-6574-00
German SC12-4278-00
Hungarian SC22-1095-00
Japanese SC88-5892-00
Korean SA30-3966-00
Polish SC85-0377-00
Romanian SA22-1405-00
Russian SC89-1146-00
Simplified Chinese S151-1178-00
Slovakian SA22-1127-00
Slovenian SA22-1252-00
Spanish SC11-3920-00
Traditional Chinese SC40-2458-00
Slovakian SA22-1127-00
Slovenian SA22-1252-00
Installing DB2 English GC27-2455-00
Servers
Brazilian Portuguese G517-9473-00
Czech GC09-3855-00
French GC11-6570-00
German GC12-4276-00
Japanese GC88-5888-00
Korean GA30-3962-00
Polish GC85-0373-00
Russian GC89-1142-00
Simplified Chinese G151-1174-00
Spanish SC11-3916-00
Traditional Chinese GC40-2454-00
Installing IBM Data English GC27-2454-00
Server Clients
Brazilian Portuguese G517-9474-00
Bulgarian GA12-6677-00
Croatian GA12-6610-00
Czech GC09-3856-00
Dutch GC14-2065-00
French GC11-6571-00
German GC12-4275-00
Hungarian GC22-1092-00
Japanese GC88-5889-00
Korean GA30-3963-00
Polish GC85-0374-00
Romanian GA22-1402-00
Simplified Chinese G151-1175-00
Slovakian GA22-1124-00
Slovenian GA12-6649-00
Spanish SC11-3917-00
Traditional Chinese GC40-2455-00
Turkish SC14-7063-00
Message Reference English SC27-2450-00
Volume 1
Brazilian Portuguese S517-9479-00
Czech SC09-3860-00
Dutch SC14-2069-00
French SC11-6576-00
German SC12-4295-00
Italian SC13-4143-00
Japanese SC88-5897-00
Simplified Chinese S151-1182-00
Spanish SC11-3922-00
Traditional Chinese SC40-2460-00
Message Reference English SC27-2451-00
Volume 2
Brazilian Portuguese S517-9480-00
Czech SC09-3861-00
Dutch SC14-2070-00
French SC11-6577-00
German SC12-4296-00
Italian SC13-4144-00
Japanese SC88-5898-00
Simplified Chinese S151-1183-00
Spanish SC11-3923-00
Traditional Chinese SC40-2461-00
Net Search Extender English SC27-2469-00
Administration and
User's Guide
French SC11-6579-00
German SC12-4298-00
Japanese SC88-5901-00
Simplified Chinese S151-1185-00
Spanish SC11-3926-00
Partitioning and English SC27-2453-00
Clustering Guide
German SC12-4286-00
Japanese SC88-5907-00
Korean SA30-3973-00
Simplified Chinese S151-1190-00
pureXML Guide English SC27-2465-00
German SC12-4293-00
Japanese SC88-5895-00
Simplified Chinese S151-1180-00
Query Patroller English SC27-2467-00
Administration and
User's Guide
French SC11-6580-00
German SC12-4304-00
Japanese SC88-5908-00
Korean SA30-3974-00
Spatial Extender and Englsih SC27-2468-00
Geodetic Data
Management Feature
User's Guide and
Reference
Brazilian Portuguese S517-9481-00
German SC12-4299-00
Japanese SC88-5900-00
Spanish SC11-3925-00
SQL Procedural English SC27-2470-00
Languages:
Application
Enablement and
Support
Japanese SC88-5877-00
Simplified Chinese S151-1171-00
SQL Reference, Volume English SC27-2456-00
1
Japanese SC88-5881-00
Korean SA30-3956-00
Spanish SC11-3910-00
SQL Reference, Volume English SC27-2457-00
2
Japanese SC88-5882-00
Korean SA30-3957-00
Spanish SC11-3911-00
Troubleshooting and English SC27-2461-00
Tuning Database
Performance
German SC12-4289-00
Japanese SC88-5871-00
Korean SA30-3952-00
Simplified Chinese S151-1164-00
Upgrading to DB2 English SC27-2452-00
Version 9.7
Brazilian Portuguese S517-9472-00
Czech SC09-3854-00
French SC11-6569-00
German SC12-4274-00
Japanese SC88-5887-00
Korean SA30-3961-00
Polish SC85-0372-00
Russian SC89-1141-00
Simplified Chinese S151-1173-00
Spanish SC11-3915-00
Traditional Chinese SC40-2453-00
Visual Explain English SC27-2462-00
Tutorial
Brazilian Portuguese S517-9481-00
Czech SC09-3862-00
French SC11-6578-00
German SC12-4290-00
Japanese SC88-5899-00
Korean SA30-3968-00
Polish SC85-0378-00
Russian SC89-1147-00
Romanian SA22-1406-00
Simplified Chinese S151-1184-00
Slovakian SA22-1128-00
Slovenian SA22-1253-00
Spanish SC11-3924-00
Traditional Chinese SC40-2462-00
What's New for DB2 English SC27-2463-00
Version 9.7
Brazilian Portuguese S517-9478-00
Bulgarian SA12-6681-00
Croatian SA12-6614-00
Dutch SC14-2068-00
French SC11-6575-00
German SC12-4291-00
Japanese SC88-5893-00
Korean SA30-3967-00
Romanian SA22-1406-00
Simplified Chinese S151-1179-00
Slovakian SA22-1128-00
Slovenian SA22-1253-00
Spanish SC11-3921-00
Traditional Chinese SC40-2459-00
Workload Manager English SC27-2464-00
Guide and Reference
German SC12-4292-00
Japanese SC88-5894-00
XQuery Reference English SC27-2466-00
German SC12-4294-00
Japanese SC88-5896-00
Simplified Chinese S151-1181-00
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
Spatial Extender 16 MB
Query Patroller 256 MB
Performance Expert server 512 MB
Performance Expert client 512 MB
Performance Expert agent 512 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)
Spatial Extender 600 MB (4)
Net Search Extender 50 MB
Query Patroller 14 MB
Performance Operating Disk space in Disk space in
Expert component system the temporary the
directory installation
during directory for
installation program files
and log files
Performance Linux on System 260 MB 110 MB
Expert Server x 32-bit
(5)
Linux on System 500 MB 200 MB
x 64-bit
Linux on System 300 MB 150 MB
p
Linux on System 300 MB 150 MB
z
AIX 150 MB 150 MB
HP-UX 600 MB 300 MB
Solaris 500 MB 200 MB
Windows 32-bit 50 MB 110 MB
Windows 64-bit 50 MB 170 MB
Performance Linux on System 260 MB 200 MB
Expert Client x 32-bit
Linux on System 500 MB 200 MB
x 64-bit
Windows 32-bit 150 MB 210 MB
Windows 64-bit 150 MB 260 MB
Performance Linux on System 260 MB 80 MB
Expert Agent x 32-bit
(6)
Linux on System 500 MB 200 MB
x 64-bit
Linux on System 300 MB 150 MB
p
Linux on System 300 MB 150 MB
z
AIX 150 MB 150 MB
HP-UX 600 MB 300 MB
Solaris 500 MB 200 MB
Windows 32-bit 50 MB 110 MB
Windows 64-bit 50 MB 160 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.
(4) 563 MB of the 600 MB is for United States geocoder reference data.
(5) Additional disk space for each monitored DB2 instance depending on the type of information
that is collected for history data and Performance Warehouse.
(6) 5 MB disk space in the working directory for log files and ini files
of Performance Expert Agent.
Software requirements
This section indicates the minimal requirements for operating systems at
the time of this announcement.
Linux
- Red Hat Enterprise Linux (RHEL) 5
- 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; 32 bit and 64 bit
- Linux for System
p - SLES 10, SLES 11; 64 bit
- Linux for System
p - RHEL 5; 64 bit
- Linux for System
z - SLES 10, SLES 11; 64 bit
- Linux for System
z - RHEL 5; 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
AIX
HP-UX
- HP-UX 11i v2 for HP Integrity servers (Itanium-based systems)
- HP-UX 11i v3 for HP Integrity servers (Itanium-based systems)
Solaris
- Solaris 9 for UltraSPARC or SPARC64 servers
- 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.
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
DB2 Performance
Expert
- AIX
5L V5.3, V6.1; 64 bit
- Solaris 9 and 10 operating environment on SPARC; 64 bit
- HP-UX 11iv2 or 11iv3 on Itanium®; 64 bit
- Windows XP,
Vista , Server 2003, Server 2008; 32 bit and 64 bit
- Linux for
System i- SLES 10, SLES 11; 32 bit and 64 bit
- Linux for System
i - RHEL 5; 32 bit and 64 bit
- Linux for System
p - SLES 10, SLES 11; 64 bit
- Linux for System
p - RHEL 5; 64 bit
- Linux for System
z - SLES 10, SLES 11; 64 bit
- Linux for System
z - RHEL 5; 64 bit
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 9.7,
Personal Edition
Media:
- IBM DB2 Personal
Edition - Quick Start and Activation CD
- IBM DB2 Information
Center for Linux DVD
- IBM DB2 Information
Center for Windows DVD
- IBM DB2 PDF
documentation DVD
- IBM DB2 Personal
Edition for Linux on
32-bit AMD and Intel systems (x86) DVD
- IBM DB2 Personal
Edition for Linux on
AMD64 and Intel EM64T
systems (x86-64) DVD
- IBM DB2 Personal
Edition for Windows on 32-bit AMD and Intel systems (x86) DVD
- IBM DB2 Personal
Edition for Windows on AMD64 and Intel EM64T systems (x64) DVD
- IBM DB2 Net
Search Extender for AIX, Linux, HP-UX, Solaris, and Windows DVD
- IBM DB2 Spatial
Extender for Linux on
32-bit AMD and Intel systems (x86) CD
- IBM DB2 Spatial
Extender for Linux on
AMD64 and Intel EM64T
systems (x86-64) CD
- IBM DB2 Spatial
Extender for Windows on 32-bit AMD and Intel systems (x86) CD
- IBM DB2 Spatial
Extender for Windows on AMD64 and Intel EM64T systems (x64) CD
IBM DB2 9.7,
Express Edition - Authorized User, CPU, Fixed Term License and Server Options
Media:
- IBM DB2 Express
Edition - Quick Start and Activation CD
- IBM DB2 Express
Edition for Linux on
32-bit AMD and Intel systems (x86) DVD
- IBM DB2 Express
Edition for Linux on
AMD64 and Intel EM64T
systems (x86-64) DVD
- IBM DB2 Express
Edition for Linux on POWER™ (System
i and System
p) systems DVD
- IBM DB2 Express
Edition for Solaris on x64 systems DVD
- IBM DB2 Express
Edition for Windows on 32-bit AMD and Intel systems (x86) DVD
- IBM DB2 Express
Edition for Windows on AMD64 and Intel EM64T systems (x64) DVD
- IBM DB2 Net
Search Extender for AIX, Linux, HP-UX, Solaris, and Windows DVD
Downloadable:
- IBM DB2 Information
Center for Linux
- IBM DB2 Information
Center for Windows
- IBM DB2 Spatial
Extender for Linux on
32-bit AMD and Intel systems (x86)
- IBM DB2 Spatial
Extender for Linux on
AMD64 and Intel EM64T
systems (x86-64)
- IBM DB2 Spatial
Extender for Solaris on x64 systems
- IBM DB2 Spatial
Extender for Windows on 32-bit AMD and Intel systems (x86)
- IBM DB2 Spatial
Extender for Windows on AMD64 and Intel EM64T systems (x64)
IBM DB2 9.7,
Workgroup Server Edition - Authorized User, CPU and Socket Options
Media:
- IBM DB2 Workgroup
Server Edition - Quick Start and Activation CD
- IBM DB2 Information
Center for Linux DVD
- IBM DB2 Information
Center for Windows DVD
- IBM DB2 PDF
documentation DVD
- IBM DB2 Workgroup
Server Edition for Linux on 32-bit AMD and Intel systems (x86) DVD
- IBM DB2 Workgroup
Server Edition for Linux on AMD64 and Intel EM64T systems (x86-64) DVD
- IBM DB2 Workgroup
Server Edition for Linux on POWER (System i and System p) systems DVD
- IBM DB2 Workgroup
Server Edition for AIX DVD
- IBM DB2 Workgroup
Server Edition for HP-UX on HP Integrity Itanium-based systems DVD
- IBM DB2 Workgroup
Server Edition for Solaris on UltraSPARC systems DVD
- IBM DB2 Workgroup
Server Edition for Solaris on x64 systems DVD
- IBM DB2 Workgroup
Server Edition for Windows on 32-bit AMD and Intel systems (x86) DVD
- IBM DB2 Workgroup
Server Edition for Windows on AMD64 and Intel EM64T systems (x64) DVD
- IBM Data
Server Runtime Client for Linux on 32-bit AMD and Intel systems (x86) DVD
- IBM Data
Server Runtime Client for Linux on AMD64 and Intel EM64T systems (x86-64) DVD
- IBM Data
Server Runtime Client for Linux on POWER (System i and System p) systems DVD
- IBM Data
Server Runtime Client for Linux on System z DVD
- IBM Data
Server Runtime Client for AIX DVD
- IBM Data
Server Runtime Client for HP-UX on HP Integrity Itanium-based systems DVD
- IBM Data
Server Runtime Client for Solaris on UltraSPARC systems DVD
- IBM Data
Server Runtime Client for Solaris on x64 systems DVD
- IBM Data
Server Runtime Client for Windows on 32-bit AMD and Intel systems
(x86) DVD
- IBM Data
Server Runtime Client for Windows on AMD64 and Intel EM64T
systems (x64) DVD
- IBM Data
Server Client for Linux on 32-bit AMD and Intel systems (x86) DVD
- IBM Data
Server Client for Linux on AMD64 and Intel EM64T systems (x86-64) DVD
- IBM Data
Server Client for Linux on POWER (System i and System p) systems DVD
- IBM Data
Server Client for Linux on System z DVD
- IBM Data
Server Client for AIX DVD
- IBM Data
Server Client for HP-UX on HP Integrity Itanium-based systems DVD
- IBM Data
Server Client for Solaris on UltraSPARC systems DVD
- IBM Data
Server Client for Solaris on x64 systems DVD
- IBM Data
Server Client for Windows on 32-bit AMD and Intel systems (x86) DVD
- IBM Data
Server Client for Windows on AMD64 and Intel EM64T systems (x64) DVD
- IBM Data
Server Driver Package for AIX, Linux, Solaris, and HP-UX DVD
- IBM Data
Server Driver Package for Windows on 32-bit AMD and Intel systems
(x86) DVD
- IBM Data
Server Driver Package for Windows on AMD64 and Intel EM64T
systems (x64) DVD
- IBM DB2 Support
Files for SSL Functionality for AIX, Linux, HP-UX, Solaris and Windows DVD
- IBM DB2 Net
Search Extender for AIX, Linux, HP-UX, Solaris, and Windows DVD
- IBM DB2 Spatial
Extender for Linux on
32-bit AMD and Intel systems (x86) CD
- IBM DB2 Spatial
Extender for Linux on
AMD64 and Intel EM64T
systems (x86-64) CD
- IBM DB2 Spatial
Extender for Linux on System
z CD
- IBM DB2 Spatial
Extender for AIX CD
- IBM DB2 Spatial
Extender for HP-UX on HP Integrity Itanium-based systems CD
- IBM DB2 Spatial
Extender for Solaris on UltraSPARC systems CD
- IBM DB2 Spatial
Extender for Solaris on x64 systems CD
- IBM DB2 Spatial
Extender for Windows on 32-bit AMD and Intel systems (x86) CD
- IBM DB2 Spatial
Extender for Windows on AMD64 and Intel EM64T systems (x64) CD
Complimentary products/additional media:
- IBM Tivoli System
Automation for Multiplatform - Windows CD
- IBM WebSphere® MQSeries® CDs
IBM DB2 9.7,
Enterprise Server Edition - Authorized User and CPU Options
Media:
- IBM DB2 Enterprise
Server Edition - Quick Start and Activation CD
- IBM DB2 Information
Center for Linux DVD
- IBM DB2 Information
Center for Windows DVD
- IBM DB2 PDF
documentation DVD
- IBM DB2 Enterprise
Server Edition for Linux on AMD64 and Intel EM64T systems (x86-64) DVD
- IBM DB2 Enterprise
Server Edition for Linux on POWER (System i and System p) systems DVD
- IBM DB2 Enterprise
Server Edition for Linux on System z DVD
- IBM DB2 Enterprise
Server Edition for AIX DVD
- IBM DB2 Enterprise
Server Edition for HP-UX on HP Integrity Itanium-based systems DVD
- IBM DB2 Enterprise
Server Edition for Solaris on UltraSPARC systems DVD
- IBM DB2 Enterprise
Server Edition for Solaris on x64 systems DVD
- IBM DB2 Enterprise
Server Edition for Windows on 32-bit AMD and Intel systems (x86) DVD
- IBM DB2 Enterprise
Server Edition for Windows on AMD64 and Intel EM64T systems (x64) DVD
- IBM Data
Server Runtime Client for Linux on 32-bit AMD and Intel systems (x86) DVD
- IBM Data
Server Runtime Client for Linux on AMD64 and Intel EM64T systems (x86-64) DVD
- IBM Data
Server Runtime Client for Linux on POWER (System i and System p) systems DVD
- IBM Data
Server Runtime Client for Linux on System z DVD
- IBM Data
Server Runtime Client for AIX DVD
- IBM Data
Server Runtime Client for HP-UX on HP Integrity Itanium-based systems DVD
- IBM Data
Server Runtime Client for Solaris on UltraSPARC systems DVD
- IBM Data
Server Runtime Client for Solaris on x64 systems DVD
- IBM Data
Server Runtime Client for Windows on 32-bit AMD and Intel systems
(x86) DVD
- IBM Data
Server Runtime Client for Windows on AMD64 and Intel EM64T
systems (x64) DVD
- IBM Data
Server Client for Linux on 32-bit AMD and Intel systems (x86) DVD
- IBM Data
Server Client for Linux on AMD64 and Intel EM64T systems (x86-64) DVD
- IBM Data
Server Client for Linux on POWER (System i and System p) systems DVD
- IBM Data
Server Client for Linux on System z DVD
- IBM Data
Server Client for AIX DVD
- IBM Data
Server Client for HP-UX on HP Integrity Itanium-based systems DVD
- IBM Data
Server Client for Solaris on UltraSPARC systems DVD
- IBM Data
Server Client for Solaris on x64 systems DVD
- IBM Data
Server Runtime Client for Solaris on x64 systems DVD
- IBM Data
Server Client for Windows on 32-bit AMD and Intel systems (x86) DVD
- IBM Data
Server Client for Windows on AMD64 and Intel EM64T systems (x64) DVD
- IBM Data
Server Driver Package for AIX, Linux, Solaris and HP-UX DVD
- IBM Data
Server Driver Package for Windows on 32-bit AMD and Intel systems
(x86) DVD
- IBM Data
Server Driver Package for Windows on AMD64 and Intel EM64T
systems (x64) DVD
- IBM DB2 Support
Files for SSL Functionality for AIX, Linux, HP-UX, Solaris and Windows DVD
- IBM DB2 Net
Search Extender for AIX, Linux, HP-UX, Solaris, and Windows DVD
- IBM DB2 Spatial
Extender for Linux on
32-bit AMD and Intel systems (x86) CD
- IBM DB2 Spatial
Extender for Linux on
AMD64 and Intel EM64T
systems (x86-64) CD
- IBM DB2 Spatial
Extender for Linux on System
z CD
- IBM DB2 Spatial
Extender for AIX CD
- IBM DB2 Spatial
Extender for HP-UX on HP Integrity Itanium-based systems CD
- IBM DB2 Spatial
Extender for Solaris on UltraSPARC systems CD
- IBM DB2 Spatial
Extender for Solaris on x64 systems CD
- IBM DB2 Spatial
Extender for Windows on 32-bit AMD and Intel systems (x86) CD
- IBM DB2 Spatial
Extender for Windows on AMD64 and Intel EM64T systems (x64) CD
- IBM DB2 Mobility
on Demand DVD
Complimentary products/additional media:
- IBM Tivoli System
Automation for Multiplatform - Windows CD
- IBM WebSphere MQSeries CDs
IBM Database
Enterprise Developer Edition 9.7
Media:
- IBM Database
Enterprise Developer Edition - Quick Start and Activation CD
- IBM DB2 Information
Center for Linux DVD
- IBM DB2 Information
Center for Windows DVD
- IBM DB2 PDF
documentation DVD
- IBM DB2 Workgroup
Server Edition for Linux on 32-bit AMD and Intel systems (x86) DVD
- IBM DB2 Workgroup
Server Edition for Linux on AMD64 and Intel EM64T systems (x86-64) DVD
- IBM DB2 Workgroup
Server Edition for Linux on POWER (System i and System p) systems DVD
- IBM DB2 Workgroup
Server Edition for AIX DVD
- IBM DB2 Workgroup
Server Edition for HP-UX on HP Integrity Itanium-based systems DVD
- IBM DB2 Workgroup
Server Edition for Solaris on UltraSPARC systems DVD
- IBM DB2 Workgroup
Server Edition for Solaris on x64 systems DVD
- IBM DB2 Workgroup
Server Edition for Windows on 32-bit AMD and Intel systems (x86) DVD
- IBM DB2 Workgroup
Server Edition for Windows on AMD64 and Intel EM64T systems (x64) DVD
- IBM DB2 Enterprise
Server Edition for Linux on AMD64 and Intel EM64T systems (x86-64) DVD
- IBM DB2 Enterprise
Server Edition for Linux on POWER (System i and System p) systems DVD
- IBM DB2 Enterprise
Server Edition for Linux on System z DVD
- IBM DB2 Enterprise
Server Edition for AIX DVD
- IBM DB2 Enterprise
Server Edition for HP-UX on HP Integrity Itanium-based systems DVD
- IBM DB2 Enterprise
Server Edition for Solaris on UltraSPARC systems DVD
- IBM DB2 Enterprise
Server Edition for Solaris on x64 systems DVD
- IBM DB2 Enterprise
Server Edition for Windows on 32-bit AMD and Intel systems (x86) DVD
- IBM DB2 Enterprise
Server Edition for Windows on AMD64 and Intel EM64T systems (x64) DVD
- IBM DB2
Connect Server for Linux on 32-bit AMD and Intel systems (x86) DVD
- IBM DB2
Connect Server for Linux on AMD64 and Intel EM64T systems (x86-64) DVD
- IBM DB2
Connect Server for Linux on POWER (System i and System p) systems DVD
- IBM DB2
Connect Server for Linux on System z DVD
- IBM DB2
Connect Server for AIX DVD
- IBM DB2
Connect Server for HP-UX on HP Integrity Itanium-based systems DVD
- IBM DB2
Connect Server for Solaris on UltraSPARC systems DVD
- IBM DB2
Connect Server for Solaris on x64 systems DVD
- IBM DB2
Connect Server for Windows on 32-bit AMD and Intel systems
(x86) DVD
- IBM DB2
Connect Server for Windows on AMD64 and Intel EM64T
systems (x64) DVD
- IBM Data
Server Runtime Client for Linux on 32-bit AMD and Intel systems (x86) DVD
- IBM Data
Server Runtime Client for Linux on AMD64 and Intel EM64T systems (x86-64) DVD
- IBM Data
Server Runtime Client for Linux on POWER (System i and System p) systems DVD
- IBM Data
Server Runtime Client for Linux on System z DVD
- IBM Data
Server Runtime Client for AIX DVD
- IBM Data
Server Runtime Client for HP-UX on HP Integrity Itanium-based systems DVD
- IBM Data
Server Runtime Client for Solaris on UltraSPARC systems DVD
- IBM Data
Server Runtime Client for Solaris on x64 systems DVD
- IBM Data
Server Runtime Client for Windows on 32-bit AMD and Intel systems
(x86) DVD
- IBM Data
Server Runtime Client for Windows on AMD64 and Intel EM64T
systems (x64) DVD
- IBM Data
Server Client for Linux on 32-bit AMD and Intel systems (x86) DVD
- IBM Data
Server Client for Linux on AMD64 and Intel EM64T systems (x86-64) DVD
- IBM Data
Server Client for Linux on POWER (System i and System p) systems DVD
- IBM Data
Server Client for Linux on System z DVD
- IBM Data
Server Client for AIX DVD
- IBM Data
Server Client for HP-UX on HP Integrity Itanium-based systems DVD
- IBM Data
Server Client for Solaris on UltraSPARC systems DVD
- IBM Data
Server Client for Solaris on x64 systems DVD
- IBM Data
Server Client for Windows on 32-bit AMD and Intel systems (x86) DVD
- IBM Data
Server Client for Windows on AMD64 and Intel EM64T systems (x64) DVD
- IBM Data
Server Driver Package for AIX, Linux, Solaris and HP-UX DVD
- IBM Data
Server Driver Package for Windows on 32-bit AMD and Intel systems
(x86) DVD
- IBM Data
Server Driver Package for Windows on AMD64 and Intel EM64T
systems (x64) DVD
- IBM DB2 Support
Files for SSL Functionality for AIX, Linux, HP-UX, Solaris and Windows DVD
- IBM DB2 Net
Search Extender for AIX, Linux, HP-UX, Solaris, and Windows DVD
- IBM DB2 Spatial
Extender for Linux on
32-bit AMD and Intel systems (x86) CD
- IBM DB2 Spatial
Extender for Linux on
AMD64 and Intel EM64T
systems (x86-64) CD
- IBM DB2 Spatial
Extender for Linux on System
z CD
- IBM DB2 Spatial
Extender for AIX CD
- IBM DB2 Spatial
Extender for HP-UX on HP Integrity Itanium-based systems CD
- IBM DB2 Spatial
Extender for Solaris on UltraSPARC systems CD
- IBM DB2 Spatial
Extender for Solaris on x64 systems CD
- IBM DB2 Spatial
Extender for Windows on 32-bit AMD and Intel systems (x86) CD
- IBM DB2 Spatial
Extender for Windows on AMD64 and Intel EM64T systems (x64) CD
- IBM DB2 Query
Patroller for Linux on 32-bit AMD and Intel systems (x86) CD
- IBM DB2 Query
Patroller for Linux on AMD64 and Intel EM64T systems (x86-64) CD
- IBM DB2 Query
Patroller for Linux on POWER (System i and System p) systems CD
- IBM DB2 Query
Patroller for AIX
5L CD
- IBM DB2 Query
Patroller for HP-UX on HP Integrity Itanium-based systems CD
- IBM DB2 Query
Patroller for Solaris on UltraSPARC systems CD
- IBM DB2 Query
Patroller for Windows on 32-bit AMD and Intel systems (x86) CD
- IBM DB2 Mobility
on Demand DVD
- IBM WebSphere MQSeries CD(s)
- IBM Informix Dynamic
Server Enterprise Edition for Linux on 32-bit AMD and Intel systems
(x86) CD
- IBM Informix Dynamic
Server Enterprise Edition for Linux on AMD64 and Intel EM64T
systems (x86-64) CD
- IBM Informix Dynamic
Server Enterprise Edition for Linux on POWER (System i and System p) systems CD
- IBM Informix Dynamic
Server Enterprise Edition for Linux on System z CD
- IBM Informix Dynamic
Server Enterprise Edition for AIX CD
- IBM Informix Dynamic
Server Enterprise Edition for HP-UX on HP Integrity Itanium-based systems
CD
- IBM Informix Dynamic
Server Enterprise Edition for Solaris on UltraSPARC systems CD
- IBM Informix Dynamic
Server Enterprise Edition for Solaris on x64 systems CD
- IBM Informix Dynamic
Server Enterprise Edition for Windows on 32-bit AMD and Intel systems
(x86) CD
- IBM Informix Dynamic
Server Enterprise Edition for Windows on AMD64 and Intel EM64T
systems (x64) CD
- IBM Tivoli System
Automation for Multiplatform - Windows CD
IBM DB2 Advanced
Access Control Feature
Media:
- IBM DB2 Advanced
Access Control Feature - Quick Start and Activation CD
IBM DB2 Geodetic
Data Management Feature
Media:
- IBM DB2 Geodetic
Data Management Feature - Quick Start and Activation CD
IBM DB2 High
Availability Feature for Express Edition
Media:
- IBM DB2 High
Availability Feature for Express Edition - Quick Start and Activation CD
IBM DB2 Performance
Optimization Feature for Enterprise Server Edition
Media:
- IBM DB2 Performance
Optimization Feature for Enterprise Server Edition - Quick Start and Activation
CD
- IBM DB2 Query
Patroller for Linux on 32-bit AMD and Intel systems (x86) CD
- IBM DB2 Query
Patroller for Linux on AMD64 and Intel EM64T systems (x86-64) CD
- IBM DB2 Query
Patroller for Linux on POWER (System i and System p) systems CD
- IBM DB2 Query
Patroller for AIX
5L CD
- IBM DB2 Query
Patroller for HP-UX on HP Integrity Itanium-based systems CD
- IBM DB2 Query
Patroller for Solaris on UltraSPARC systems CD
- IBM DB2 Query
Patroller for Windows on 32-bit AMD and Intel systems (x86) CD
- IBM DB2 Performance
Expert for Multiplatforms Quick Start CD
- IBM DB2 Performance
Expert for Multiplatforms for Linux on System x® and Windows CD
- IBM DB2 Performance
Expert for Multiplatforms for AIX, HP-UX, Linux on System p and System z, and Solaris CD
IBM DB2 Storage
Optimization Feature
Media:
- IBM DB2 Storage
Optimization Feature - Quick Start and Activation CD
IBM Homogeneous
Replication Feature for DB2 Enterprise Server Edition
Media:
- IBM Homogeneous
Replication Feature for DB2 Enterprise Server Edition - Quick Start and Activation
CD
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
IBM Software
Services has the breadth, depth, and reach to manage your services needs.
You can leverage the deep technical skills of our lab-based, software services
team and the business consulting, project management, and infrastructure expertise
of our IBM Global
Services team. Also, we extend our IBM Software Services reach through IBM Business
Partners to provide an extensive portfolio of capabilities. Together, we provide
the global reach, intellectual capital, industry insight, and technology leadership
to support a wide range of critical business needs.
To learn more about IBM Software Services or to contact a Software Services
sales specialist, visit
- http://www.ibm.com/software/sw-services/
Back to top
This product is only available via Passport Advantage. It is
not available as shrinkwrap.
Product information
Licensed function title Product group Product
category
IBM DB2 Advanced Access Control IBM Database 2™ IBM DB2
Feature Universal
Database
IBM DB2 Enterprise Server Edition IBM Database 2 IBM DB2
Authorized User Universal
Database
Enterprise
Server Edition
IBM DB2 Enterprise Server Edition IBM Database 2 IBM DB2
CPU Option Universal
Database
Enterprise
Server Edition
IBM DB2 Express Edition Authorized IBM Database 2 IBM DB2
User Universal
Database
IBM DB2 Express Edition CPU Option IBM Database 2 IBM DB2
Universal
Database
IBM DB2 Express Edition Server IBM Database 2 DB2
Option
IBM DB2 Express-C IBM Database 2 DB2
IBM DB2 Geodetic Data Management IBM Database 2 IBM DB2
Feature Universal
Database
IBM DB2 High Availability Feature IBM Database 2 IBM DB2
for Express Edition Universal
Database
IBM DB2 Performance Optimization IBM Database 2 IBM DB2
Feature for Enterprise Server Universal
Edition Database
IBM DB2 Personal Edition Client IBM Database 2 IBM DB2
Device Universal
Database
IBM DB2 Storage Optimization IBM Database 2 IBM DB2
Feature Universal
Database
IBM DB2 Workgroup Server Edition IBM Database 2 IBM DB2
Authorized User Universal
Database
IBM DB2 Workgroup Server Edition IBM Database 2 IBM DB2
CPU Option Universal
Database
IBM DB2 Workgroup Server Edition IBM Database 2 DB2
Socket Option
IBM Database Enterprise Developer IBM Database 2 IBM DB2
Edition Universal
Database
Program name PID Charge unit
number description
IBM DB2 Advanced Access Control 5724-N80 Per Processor
Feature Value Unit (PVU)
IBM DB2 Advanced Access Control 5724-N80 PA Per
Feature Authorized User
IBM DB2 Advanced Access Control 5724-N80 Processor-Days
Feature
IBM DB2 Enterprise Server Edition 5765-F41 PA Per
Authorized User Authorized User
IBM DB2 Enterprise Server Edition 5765-F41 Per Processor
CPU Option Value Unit (PVU)
IBM DB2 Enterprise Server Edition 5765-F41 Processor-Days
CPU Option
IBM DB2 Enterprise Server Edition 5765-F41 Per Processor
CPU Option Value Unit for
Linux on System
z
IBM DB2 Express Edition Authorized 5724-E49 PA Per
User Authorized User
IBM DB2 Express Edition CPU Option 5724-E49 Processor-Days
IBM DB2 Express Edition CPU Option 5724-E49 Per Processor
Value Unit (PVU)
IBM DB2 Express Edition Server 5724-E49 Per Limited Use
Option Virtual Server
IBM DB2 Express-C 5724-S40 FTL per Limited
Use Virtual
Server
IBM DB2 Geodetic Data Management 5724-N75 Processor-Days
Feature
IBM DB2 Geodetic Data Management 5724-N75 Per Processor
Feature Value Unit (PVU)
IBM DB2 Geodetic Data Management 5724-N75 PA Per
Feature Authorized User
IBM DB2 High Availability Feature 5724-N85 Per Processor
for Express Edition Value Unit (PVU)
IBM DB2 High Availability Feature 5724-N85 Processor-Days
for Express Edition
IBM DB2 High Availability Feature 5724-N85 PA Per
for Express Edition Authorized User
IBM DB2 Performance Optimization 5724-N77 Per Processor
Feature for Enterprise Server Value Unit (PVU)
Edition
IBM DB2 Performance Optimization 5724-N77 Per Authorized
Feature for Enterprise Server User
Edition
IBM DB2 Performance Optimization 5724-N77 Processor-Days
Feature for Enterprise Server
Edition
IBM DB2 Personal Edition Client 5724-B55 PA Per Client
Device Device
IBM DB2 Storage Optimization Feature 5724-N78 Processor-Days
IBM DB2 Storage Optimization Feature 5724-N78 Per Processor
Value Unit (PVU)
IBM DB2 Workgroup Server Edition 5765-F35 PA Per
Authorized User Authorized User
IBM DB2 Workgroup Server Edition CPU 5765-F35 Per Processor
Option Value Unit (PVU)
IBM DB2 Workgroup Server Edition CPU 5765-F35 Processor-Days
Option
IBM DB2 Workgroup Server Edition 5765-F35 Per Limited Use
Socket Option Socket
IBM Database Enterprise Developer 5724-N76 PA Per
Edition Authorized User
IBM Database Enterprise Developer 5724-N76 Per Authorized
Edition User for Linux
on z
Charge metrics definitions
Processor Value Unit (PVU)
PVU is a unit of measure by which the program can be licensed. PVU entitlements
are based on processor technology (defined within the PVU table* by processor
vendor, brand, type and model number). IBM defines a processor, for purposes of
PVU-based licensing, to be each processor core on a chip. Each software product
has a unique price per PVU. To determine the total cost of deploying an individual
software product in a specific hardware environment, you must take the following
steps:
- For each processor core in the hardware environment on which the software
product is to be licensed, determine the PVU requirement based on its processor
technology per the PVU table*.
- Add the the PVU requirements for all processor cores in the hardware environment.
- Multiply the software product's price per PVU by the total number of PVUs
required as determined in step 2 above.
PVU entitlements are specific to the program and may not be exchanged,
interchanged, or aggregated with PVU entitlements of another software product.
Unless the program and your environment are each eligible for sub-capacity
licensing according to the IBM International Passport Advantage Agreement
Attachment for Sub-Capacity Licensing Terms (the "Attachment")**, you must
obtain PVU Proofs of Entitlement (PoEs) for the maximum number of activated***
physical processor cores in the hardware environment made available to or
managed by the program. This is also referred to as full capacity licensing.
*PVU licensing is subject to additional details and terms, including the
latest PVU requirements table, described at
- http://www.ibm.com/software/lotus/passportadvantage/pvu_licensing_for_customers.html
**Passport Advantage sub-capacity licensing terms, conditions, and eligibility
requirements are described at
- http://www-01.ibm.com/software/lotus/passportadvantage/subcaplicensing.html
***Activated processor cores are physical processor cores that are available
for use in a server. They include processor cores:
- That are activated (available for use) when the server is shipped by the
manufacturer, and
- That are activated subsequently through activation codes purchased from
the server manufacturer by the customer.
In each case regardless of whether the capacity of the processor cores
can be or is limited by the customer through virtualization technologies,
operating system commands, or BIOS settings.
This program is eligible for sub-capacity licensing. In order to take advantage
of sub-capacity licensing, your virtualization environment must meet the eligibility
requirements described in the IBM International Passport Advantage Agreement
Attachment for Sub-Capacity Licensing Terms (the "Attachment"), and you must
accept the terms of the Attachment. You must obtain PVU PoEs for the maximum
processor core capacity available to the program when deployed in an eligible
virtualization environment. This is also referred to as sub-capacity or virtualization
capacity licensing.
You must use the IBM License Metric Tool unless they meet the exceptions
described in the Attachment.
Additional details regarding Passport Advantage sub-capacity
licensing terms, conditions, and eligibility requirements, including the Attachment
and IBM License
Metric Tool ordering information, are described at
- http://www.ibm.com/software/lotus/passportadvantage/subcaplicensing.html
Authorized User
Authorized User is the unit of measure by which this program is licensed.
An Authorized User is an individual (named or unnamed) within or outside of
your enterprise. The program may be installed on one or more computers or
servers and accessed by the number of users authorized by the PoE. You must
have an entitlement for each Authorized User accessing the program or any
program component in any manner directly or indirectly (for example, via a
multiplexing program, device, or application server) through any means.
Client device
Client device is the unit of measure by which this program is licensed.
A client device is a computing device that requests the execution of a set
of commands, procedures, or applications from another computer system that
is typically referred to as a server. Multiple client devices may share access
to a common server. A client device generally has some processing capability
or is programmable to allow a user to do work. A PoE must be obtained for
each client device accessing the program in any manner on each and every single
computer or server where the program is installed.
Examples include, but are not limited to appliances, automated teller machines,
cash registers, desktop computers, kiosks, notebook computers, personal digital
assistant, point-of-sale terminals, and technical workstations.
Processor Day
On/Off Capacity on Demand (OOCoD) extends the use of a perpetual license
on a term basis when a peak situation occurs in a your environment. OOCoD
provides for daily temporary use of additional capacity when it is required
by you. This is measured in processor days which is defined as the number
of physical processor cores that are activated to increase temporary capacity
on a server during a contiguous 24-hour period, beginning at the time when
temporary capacity is initiated. Processor core usage is measured in day increments
and is independent of the time of the day used. At initial activation, each
processor core being used is charged for one day of use; software charges
are incurred on a daily basis for each processor core that has been activated
on a temporary basis for every IBM middleware program that is loaded on
that server. An additional charge of a processor day is made for each 24 hours
of continuous usage after the initial charge.
Limited Use Socket (LU Socket)
This program is licensed on a LU Socket basis, as follows. You must (1)
acquire a one LU Socket entitlement for each socket on the server on which
the program is installed, and (2) comply with the resource use restrictions
further defined below in this License Information. A server is a single physical
computer that executes requested procedures, commands, or applications to
one or more user or client devices. Where blade technology is employed, each
blade is considered a separate server. A socket is electronic circuitry that
accepts a processor chip. A processor chip is electronic circuitry containing
one or more processor cores that plugs into a socket. A processor core is
a functional unit within a computing device that interprets and executes program
instructions, and consists of at least an instruction control unit and one
or more arithmetic or logic units.
This program is eligible for sub-capacity licensing, and you may be permitted
to license less than all sockets on the server. Sub-capacity licensing terms,
conditions and eligibility requirements for LU Socket-charged products are
described at
- ftp://ftp.software.ibm.com/software/smb/pdfs/LicensingGuide.pdf
If your use of the program is not eligible for sub-capacity licensing based
on these terms and conditions, you must acquire LU Socket entitlements for
all sockets on the server on which the program is installed. The LU Socket
entitlements are specific to the program and may not be exchanged, interchanged,
or aggregated with LU Socket entitlements of another software program.
Limited Use Virtual Server (LUV Server)
This program is licensed on a LUV Server basis, as follows. A LUV Server
is a physical server or a virtual server created by partitioning the resources
available to a physical server. A server is a computer system that executes
requested procedures, commands, or applications to one or more user or client
devices. Where blade technology is employed, each blade is considered a separate
server. You must (1) acquire one LUV Server entitlement for each LUV Server
on which an instance of the program is installed, and (2) for each instance
of the program, comply with the resource use restrictions further defined
below in this License Information. In order to license the program on a virtual
server basis, you must meet the sub-capacity licensing terms, conditions and
eligibility requirements for products licensed on a LUV Server basis, which
are described at
- ftp://ftp.software.ibm.com/software/smb/pdfs/LicensingGuide.pdf
If your virtualization environment is not eligible in accordance with these
terms, you must acquire an LUV Server entitlement for each physical server
on which an instance of the program is installed.
Passport
Advantage program licenses
DB2 Advanced
Access Control Feature
Part description Part
number
IBM DB2 Advanced Access Control Feature
DB2 Advanced Access Control Feature PVU Annual SW S&S E02T7LL
Rnwl
DB2 Advanced Access Control Feature PVU Lic + SW S&S 12 D590ZLL
Mo
DB2 Advanced Access Control Feature PVU SW S&S D5912LL
Reinstate 12 Mo
DB2 Advanced Access Control Feature per Aut Usr Annual E02MQLL
SW S&S Rnwl
DB2 Advanced Access Control Feature per Aut Usr Lic + D58N3LL
SW S&S 12 Mo
DB2 Advanced Access Control Feature per Aut Usr SW S&S D58N4LL
Reinstate 12 Mo
DB2 Enterprise
Server Edition
Part description Part
number
IBM DB2 Enterprise Server Edition CPU Option
DB2 ESE CPU Option Per Processor Value Unit (PVU) E020CLL
Annual SW S&S Rnwl
DB2 ESE CPU Option Per Processor Value Unit (PVU) Lic + D55IULL
SW S&S 12 Mo
DB2 ESE CPU Option 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
DB2 Enterprise Server Edition per Authorized User E028NLL
Annual SW S&S Rnwl
DB2 Enterprise Server Edition per Authorized User Lic + D56CILL
SW S&S 12 Mo
DB2 Enterprise Server Edition per Authorized User SW D56CJLL
S&S Reinstate 12 Mo
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 Authorized User
DB2 Express Edition per Authorized User Annual SW S&S E00QULL
Rnwl
DB2 Express Edition per Authorized User Lic + SW S&S 12 D52BKLL
Mo
DB2 Express Edition per Authorized User SW S&S D52BLLL
Reinstate 12 Mo
DB2 Express
Edition
Part description Part
number
IBM DB2 Express Edition CPU Option
DB2 Express Edition CPU Option Processor Value Unit E024QLL
Annual SW S&S Rnwl
DB2 Express Edition CPU Option Processor Value Unit Lic D55TULL
+ SW S&S 12 Mo
DB2 Express Edition CPU Option Processor Value Unit SW D55TVLL
S&S Reinstate 12 Mo
DB2 Geodetic
Data Management Feature
Part description Part
number
IBM DB2 Geodetic Data Management Feature
DB2 Geodetic Data Management Feature PVU Annual SW S&S E021RLL
Rnwl
DB2 Geodetic Data Management Feature PVU Lic + SW S&S D55LVLL
12 Mo
DB2 Geodetic Data Management Feature PVU SW S&S D55LWLL
Reinstate 12 Mo
DB2 Geodetic Data Management Feature per AU SW S&S D585WLL
Reinstate 12 Mo
DB2 Geodetic Data Management Feature per Authorized E02I6LL
User Annual SW S&S Rnwl
DB2 Geodetic Data Management Feature per Authorized D585VLL
User Lic + SW S&S 12 Mo
DB2 High
Availability Feature for EXE
Part description Part
number
IBM DB2 High Availability Feature for Express Edition
DB2 High Availability Feature for EXE Auth User Annual E02MXLL
SW S&S Rnwl
DB2 High Availability Feature for EXE Auth User Lic + D58NJLL
SW S&S 12 Mo
DB2 High Availability Feature for EXE Auth User SW S&S D58NKLL
Reinstate 12 Mo
DB2 High Availability Feature for EXE PVU Annual SW S&S E02T8LL
Rnwl
DB2 High Availability Feature for EXE PVU Lic + SW S&S D5910LL
12 Mo
DB2 High Availability Feature for EXE PVU SW S&S D5913LL
Reinstate 12 Mo
DB2 Performance
Optimization Feature for ESE
Part description Part
number
IBM DB2 Performance Optimization Feature for Enterprise
Server Edition
DB2 POF for ESE 1 Authorized User 1 Contact SW S&S D5875LL
Reinstate 12 Mo
DB2 Performance Optimization Feature for ESE PVU Annual E02STLL
SW S&S Rnwl
DB2 Performance Optimization Feature for ESE PVU Lic + D5907LL
SW S&S 12 Mo
DB2 Performance Optimization Feature for ESE PVU SW S&S D5908LL
Reinstate 12 Mo
DB2 Performance Optimization Ftr for ESE 1 AU 1 Contact E02ICLL
Annual SW S&S Rnwl
DB2 Performance Optimization Ftr for ESE 1 AU 1 Contact D5874LL
Lic + SW S&S 12 Mo
DB2 Personal
Edition
Part description Part
number
IBM DB2 Personal Edition Client Device
DB2 Personal Edition Client Device Annual SW S&S Rnwl E02R7LL
DB2 Personal Edition Client Device Lic + SW S&S 12 Mo D58VLLL
DB2 Personal Edition Client Device SW S&S Reinstate 12 D58VMLL
Mo
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 CPU Option
DB2 Workgroup Server Edition CPU Option PVU Annual SW E024RLL
S&S Rnwl
DB2 Workgroup Server Edition CPU Option PVU Lic + SW D55TWLL
S&S 12 Mo
DB2 Workgroup Server Edition CPU Option PVU SW S&S D55TXLL
Reinstate 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 Authorized User
DB2 Workgroup Server Edition per Authorized User Annual E1B79LL
SW S&S Rnwl
DB2 Workgroup Server Edition per Authorized User Lic + D5B77LL
SW S&S 12 Mo
DB2 Workgroup Server Edition per Authorized User SW S&S D5B7ALL
Reinstate 12 Mo
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-C
DB2 Express Edition Limited Use Virtual Server Initl FT D60PLLL
Lic+S&S 12
DB2 Express Edition Limited Use Virtual Server Subsq FT E03NALL
Lic+S&S 12
Passport
Advantage trade-up licenses
DB2 Enterprise
Server Edition
Precursor product Trade-up product Part
number
IBM DB2 Enterprise Server
Edition Authorized User
Workgroup Server Edition DB2 Enterprise Server Ed D58YTLL
Authorized User AU fr DB2 WSE AU Trdup Lic
+ SW S&S 12 Mo
Qualified Competitor DB2 Enterprise Server Ed D58YULL
Authorized User from Qualified Competitor
Trdup Lic + SW S&S 12 Mo
DB2 Enterprise
Server Edition
Precursor product Trade-up product Part
number
IBM DB2 Enterprise Server
Edition CPU 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 Part
number
IBM DB2 Express Edition
CPU Option
IBM DB2 Personal Edition DB2 EXPRESS ED CPU OPT PVU D59E9LL
Client Device FR PERS ED Client DEV
TRDUP Lic + SW S&S 12 Mo
DB2 Express
Edition
Precursor product Trade-up product Part
number
IBM DB2 Express Edition
Authorized User
Personal Ed Client Device DB2 Express Ed Auth Usr fr D591HLL
Pers Ed Client Dev Trdup
Lic + SW S&S 12 Mo
DB2 Express
Edition
Precursor product Trade-up product 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 Performance
Optimization Feature for ESE
Precursor product Trade-up product Part
number
IBM DB2 Performance
Optimization Feature for
Enterprise Server Edition
IBM DB2 Performance Expert DB2 PO Ftr for ESE PVU fr D59E5LL
for Linux, UNIX, Windows DB2 Perf Expert LUW PVU
Trdup Lic + SW S&S 12 Mo
DB2 Workgroup
Server Edition
Precursor product Trade-up product Part
number
IBM DB2 Workgroup Server
Edition Authorized User
DB2 Express Edition DB2 Wse Auth User from DB2 D58Z4LL
Authorized User Express Ed Auth User Trdup
Lic + SW S&S 12 Mo
Qualified Competitor DB2 Wse Auth User from D58Z5LL
Authorized User Qual Competitor Auth User
Trdup Lic + SW S&S 12 Mo
DB2 Workgroup
Server Edition
Precursor product Trade-up product 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
DB2 Workgroup
Server Edition
Precursor product Trade-up product Part
number
IBM DB2 Workgroup Server
Edition CPU Option
IBM DB2 Express Edition DB2 WSE CPU Option PVU fr D55TZLL
CPU Option DB2 Express Edition CPUO
PVU Lic + SW S&S 12 Mo
Qualified Competitor PVU DB2 WSE CPU Option PVU fr D55TYLL
Qualified Competitor PVU
Lic + SW S&S 12 Mo
Passport Advantage supply
Program name/description Part
number
DB2 Adv Access Ctrl Feature V9.7.0
DB2 Adv Access Ctrl Feature Windows Vista BB0ZYML
Business,Solaris SPARC Platform
DB2 ESE AU Option V9.7.0
DB2 Enterprise Server Edition Authorized User Option BB10CML
DB2 EXE AU Option V9.7.0
DB2 Express Edition Authorized User Option BB10EML
DB2 EXE FTL Server Option V9.7.0
DB2 Express Edition FTL Server Option BB11IML
DB2 EXE Server Option V9.7.0
DB2 Express Edition Server Option BB11VML
DB2 Express Ed CPU Option V9.7.0
DB2 Express Ed CPU Option Linux for System i Integrated BB10FML
Mid-Market Busines
DB2 Geodetic DM Feature V9.7.0
DB2 Geodetic DM Feature Linux for System i Integrated BB102ML
Mid-Market Business
DB2 HAF for Express Edition V9.7.0
DB2 HAF for Express Edition Windows Vista BB103ML
Business,Windows Vista Enterpris
DB2 POF for ESE V9.7.0
DB2 POF for ESE Linux for System i Integrated BB104ML
Mid-Market Business Servers,
DB2 Personal Edition V9.7.0
DB2 Personal Edition Windows 2000,Windows XP BB105ML
Family,Windows Server 2003,Li
DB2 SOF V9.7.0
DB2 SOF Windows Vista Business,Solaris SPARC Platform BB106ML
Edition (Sun),Window
DB2 UDB ESE V9.7.0
DB2 Enterprise Server Edition CPU Option BB10DML
DB2 WSE AU Option V9.7.0
DB2 Workgroup Server Edition Authorized User Option BB107ML
DB2 WSE CPU Option V9.7.0
DB2 WSE CPU Option Linux for System i Integrated BB108ML
Mid-Market Business Serve
DB2 WSE Socket Option V9.7.0
DB2 Workgroup Server Edition Socket Option BB11UML
DEDE V9.7.0
DEDE Linux for System i Integrated Mid-Market Business BB0ZXML
Servers,AIX 6,Windo
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 V9.7.0
Entitled maintenance Media packs description Part
offerings description number
IBM DB2 Storage DB2 SOF Windows Vista BB106ML
Optimization Feature per Business,Solaris SPARC
Value Unit Platform Edition
(Sun),Window
DB2 UDB ESE V9.7.0
Entitled maintenance Media packs description Part
offerings description number
DB2 UDB Enterprise Server DB2 Enterprise Server BB10DML
Edition Linux on z Value Edition CPU Option
Unit
DB2 Universal Database DB2 Enterprise Server BB10DML
Enterprise Server Edition Edition CPU Option
Value Unit
DB2 POF for ESE V9.7.0
Entitled maintenance Media packs description Part
offerings description number
IBM DB2 Performance DB2 POF for ESE Linux for BB104ML
Optimization Feature for System i Integrated
Enterprise Server Edition Mid-Market Business
per Authorized User Servers,
IBM DB2 Performance DB2 POF for ESE Linux for BB104ML
Optimization Feature for System i Integrated
Enterprise Server Edition Mid-Market Business
per Processor Value Unit Servers,
DB2 Personal Edition V9.7.0
Entitled maintenance Media packs description Part
offerings description number
DB2 Personal Edition per DB2 Personal Edition BB105ML
Client Device Windows 2000,Windows XP
Family,Windows Server
2003,Li
DB2 WSE Socket Option V9.7.0
Entitled maintenance Media packs description Part
offerings description number
DB2 Workgroup Server DB2 Workgroup Server BB11UML
Edition Limited Use Socket Edition Socket Option
DEDE V9.7.0
Entitled maintenance Media packs description Part
offerings description number
IBM Database Enterprise DEDE Linux for System i BB0ZXML
Developer Edition per Integrated Mid-Market
Authorized User Business Servers,AIX
6,Windo
IBM Database Enterprise DEDE Linux for System i BB0ZXML
Developer Edition per Integrated Mid-Market
Authorized User for Linux Business Servers,AIX
on Z 6,Windo
DB2 WSE AU Option V9.7.0
Entitled maintenance Media packs description Part
offerings description number
DB2 UDB Workgroup Edition DB2 Workgroup Server BB107ML
User Edition Authorized User
Option
DB2 WSE CPU Option V9.7.0
Entitled maintenance Media packs description Part
offerings description number
IBM DB2 Workgroup Server DB2 WSE CPU Option Linux BB108ML
Edition per Processor for System i Integrated
Value Unit Mid-Market Business Serve
DB2 EXE AU Option V9.7.0
Entitled maintenance Media packs description Part
offerings description number
DB2 Express Edition DB2 Express Edition BB10EML
Authorized User Authorized User Option
DB2 EXE FTL Server Option V9.7.0
Entitled maintenance Media packs description Part
offerings description number
IBM DB2 Express-C Server DB2 Express Edition FTL BB11IML
Server Option
DB2 Adv Access Ctrl Feature V9.7.0
Entitled maintenance Media packs description Part
offerings description number
IBM DB2 Advanced Access DB2 Adv Access Ctrl BB0ZYML
Control Feature per Auth Feature Windows Vista
User Business,Solaris SPARC
Platform
IBM DB2 Advanced Access DB2 Adv Access Ctrl BB0ZYML
Control Feature per Value Feature Windows Vista
Unit Business,Solaris SPARC
Platform
DB2 ESE AU Option V9.7.0
Entitled maintenance Media packs description Part
offerings description number
DB2 Universal Database DB2 Enterprise Server BB10CML
Enterprise Server Edition Edition Authorized User
Authorized User Option
DB2 Geodetic DM Feature V9.7.0
Entitled maintenance Media packs description Part
offerings description number
DB2 Geodetic Data DB2 Geodetic DM Feature BB102ML
Management Feature Value Linux for System i
Unit Integrated Mid-Market
Business
IBM DB2 Geodetic Data DB2 Geodetic DM Feature BB102ML
Management Feature per Linux for System i
Authorized User Integrated Mid-Market
Business
DB2 HAF for Express Edition V9.7.0
Entitled maintenance Media packs description Part
offerings description number
IBM DB2 High Availability DB2 HAF for Express BB103ML
Feature for Express Edition Windows Vista
Edition per Authorized Business,Windows Vista
User Enterpris
IBM DB2 High Availability DB2 HAF for Express BB103ML
Feature for Express Edition Windows Vista
Edition per Value Unit Business,Windows Vista
Enterpris
DB2 EXE Server Option V9.7.0
Entitled maintenance Media packs description Part
offerings description number
DB2 Express Edition DB2 Express Edition Server BB11VML
Limited Use Virtual Server Option
Option
DB2 Express Ed CPU Option V9.7.0
Entitled maintenance Media packs description Part
offerings description number
DB2 Express CPU Option DB2 Express Ed CPU Option BB10FML
Value Unit Linux for System i
Integrated Mid-Market
Busines
Cross-platform products
Cross-platform product 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 and/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 Integrated
Facility for Linux (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 Enterprise
Server Edition
Part description Part
number
IBM DB2 Enterprise Server Edition CPU Option
DB2 ESE CPU Option for Linux on System z PVU Annual SW E020ELL
S&S Rnwl
DB2 ESE CPU Option for Linux on System z PVU Lic + SW D55J0LL
S&S 12 Mo
DB2 ESE CPU Option 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
On/Off CoD
IBM DB2 Advanced
Access Control Feature
Part description Part
number
DB2 Adv Access Ctrl Feature Processor Day Per Use-DAY, D58NELL
On Off Capacity on
IBM DB2 Enterprise
Server Edition CPU Option
Part description Part
number
DB2 ESE CPU Option Processor-Days Per Use-Day OOCoD ASQC8LL
IBM DB2 Express
Edition CPU Option
Part description Part
number
DB2 Express Edition CPU Option Processor Day Per D53H1LL
Use-Day OOCoD
IBM DB2 Geodetic
Data Management Feature
Part description Part
number
DB2 Geodetic Data Mgmnt Feat Proc Day Per Use-DAY, D5865LL
OOCoD Temp Use Charge
IBM DB2 High
Availability Feature for Express Edition
Part description Part
number
DB2 HAF for DB2 Express Ed Processor Day Per Use-DAY, D58NILL
On Off Capacity on
IBM DB2 Performance
Optimization Feature for Enterprise Server Edition
Part description Part
number
DB2 POF for ESE Processor-Days Per Use-Day OOCoD D5869LL
IBM DB2 Storage
Optimization Feature
Part description Part
number
DB2 Storage Optimization Feature Processor Day Per D58UFLL
Use-Day OOCoD
IBM DB2 Workgroup
Server Edition CPU Option
Part description Part
number
DB2 Workgroup Server Edition CPU Option Processor Day ASQH2LL
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 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 Advanced Access Control Feature 5724-N80 L-CLAW-7PURFQ
DB2 Enterprise Server Edition 5765-F41 L-CLAW-7PUR58
DB2 Express Edition 5724-E49 L-CLAW-7PUR79
DB2 Geodetic Data Management Feature 5724-N75 L-CLAW-7PUREE
DB2 High Availability Feature for EXE 5724-N85 L-CLAW-7PURF6
DB2 Performance Optimization Feature for 5724-N77 L-CLAW-7PURH9
ESE
DB2 Personal Edition 5724-B55 L-CLAW-7PUR8W
DB2 Storage Optimization Feature 5724-N78 L-CLAW-7PURGL
DB2 Workgroup Server Edition 5765-F35 L-CLAW-7PUR67
Database Enterprise Developer Edition 5724-N76 L-CLAW-7PUR7Y
IBM DB2 Express Edition FTL 5724-S40 L-CLAW-7PUR79
The program's License Information will be available for review on the IBM Software
License Agreement Web site
- http://www.ibm.com/software/sla/sladb.nsf
Limited warranty applies
Yes
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.
Consult the IBM Software
Support Handbook for further information 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 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, 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
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 programs acquired under the IBM International Passport Advantage Agreement,
this term applies only to your first acquisition of the program.
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.
Authorization for use on home/portable computer
The program may be stored on the primary machine and another machine, provided
that the program is not in active use on both machines at the same time. You
may not copy and use this program on another computer without paying additional
license fees.
DB2 Advanced Access Control Feature: Yes
DB2 Enterprise Server Edition: Yes
DB2 Express Edition: Yes
DB2 Geodetic Data Management Feature: Yes
DB2 High Availability Feature for EXE: Yes
DB2 Performance Optimization Feature for ESE: Yes
DB2 Personal Edition: Yes
DB2 Storage Optimization Feature: Yes
DB2 Workgroup Server Edition: Yes
Database Enterprise Developer Edition: Yes
IBM DB2 Express Edition FTL: Yes
Volume orders (IVO)
No
Passport Advantage applies
Yes, and through the Passport Advantage Web site 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 Web site
- http://www.ibm.com/software/sla/sladb.nsf
International Passport Agreement
Software Subscription and Support (also referred
to as Software Maintenance) applies
Yes. Software Subscription and Support (also referred to as Software Maintenance)
is included with licenses purchased through Passport Advantage and Passport
Advantage Express. Product upgrades and technical support are provided
by the Software Subscription and Support (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.
While your Software Subscription and Support (also referred to as Software
Maintenance) 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 (also referred to as Software Maintenance)
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 Web site
at
- http://www.ibm.com/software/passportadvantage
Other terms
System i Software Maintenance applies
No
Educational allowance available
Not applicable.
On/Off 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.
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
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: YE001
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.
Trademarks
pureXML, Express Middleware, DB2 Connect, POWER4, AIX 5L, POWER, Database 2 and Electronic Service Agent are trademarks of IBM Corporation in the United States, other countries, or both.
DB2, IBM, Informix, Tivoli, System z, Redbooks, Passport Advantage, AIX, System p, System i, WebSphere, MQSeries, System x, iSeries, pSeries 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 registered trademarks of Microsoft Corporation in the United States, other countries, or both.
Java and all Java-based trademarks are trademarks of Sun Microsystems, Inc. in the United States, other countries, or both.
Intel and Itanium are registered trademarks 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/
Back to top
Printable version
