OI feedback

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)

Table of contents   Document options  
At a glance At a glance Publications Publications
Overview Overview Technical information Technical information
Key prerequisites Key prerequisites Software Services Software Services
Planned availability dates Planned availability dates Ordering information Ordering information
Description Description Terms and conditions Terms and conditions
Product positioning Product positioning  IBM  Electronic Services IBM Electronic Services
Program number Program number Prices Prices
Education support Education support Order now Order now
Offering Information Offering Information
 
Printable version Printable version

(Corrected on June 3, 2009)

The Product positioning section is revised.
 
Top rule
At a glance
Bottom rule

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 topBack to top
 
Top rule
Overview
Bottom rule

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 topBack to top
 
Top rule
Key prerequisites
Bottom rule

Refer to the Hardware requirements and Software requirements sections of this document.


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

June 19, 2009: Electronic software delivery

August 28, 2009: Media and documentation


 
Back to topBack to top
 
Top rule
Description
Bottom rule

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 topBack to top
 
Top rule
Product positioning
Bottom rule

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 topBack to top
 
Top rule
Program number
Bottom rule

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 topBack to top
 
Top rule
Education support
Bottom rule

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 topBack to top
 
Top rule
Offering Information
Bottom rule

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 topBack to top
 
Top rule
Publications
Bottom rule

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 topBack to top
 
Top rule
Technical information
Bottom rule

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

  • AIX 5L™ V5.3
  • AIX V6.1

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 topBack to top
 
Top rule
Software Services
Bottom rule

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 topBack to top
 
Top rule
Ordering information
Bottom rule

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:

  1. 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*.
  2. Add the the PVU requirements for all processor cores in the hardware environment.
  3. 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:

  1. That are activated (available for use) when the server is shipped by the manufacturer, and
  2. 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 topBack to top
 
Top rule
Terms and conditions
Bottom rule

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 topBack to top
 
Top rule
IBM Electronic Services
Bottom rule

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 topBack to top
 
Top rule
Prices
Bottom rule

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 topBack to top
 
Top rule
Order now
Bottom rule

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 topBack to top
 
Bottom grey rule
 
Printable version Printable version