IBM DB2 Universal Database for Linux, UNIX and Windows, V8.2 delivers manageability, performance, and availability for on demand business

IBM United States Software Announcement 204-185
August 17, 2004

 

 ENUS204-185.PDF (210KB)

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

(Corrected on October 14, 2004)

Publication number section — numbers added. Complementary products section — restrictions removed. Ordering information section — charge metrics table added. Terms & conditions Patroller description added.
 

At a glance

DB2 UDB, V8.2 builds on its market-proven industrial strength and on demand capabilities with the following key enhancements:

  • Reduces deployment and management costs
    • Design Advisor
    • Automated statistics collection and object maintenance
    • Self-tuning backup and restore
  • Increases programmer productivity
    • Microsoft.NET integration
    • Java enhancements, including thin client and integrated help
  • Provides a robust infrastructure
    • High Availability Disaster Recovery (HADR)
    • Automated client reroute
    • Linux scalability
    • Security
  • Extends the value of information
    • New queue-based replication architecture
    • Geodetic Extender

For ordering, contact:

Your IBM representative, an IBM Business Partner, or IBM Americas Call Centers at 800-IBM-CALL (Reference: VE001).
 
Back topBack to top
 

Overview

IBM DB2 Universal Database® (UDB) V8.2 offers industry-leading database performance, as highlighted in recent TPC-C and TPC-H benchmarks, while helping customers simplify and automate many of the tasks associated with deploying databases. As a result, organizations can free up skilled DBA resources to focus on next-generation enterprise applications, such as Business Intelligence, Content Management, or Information Integration, and further lower their total cost of ownership (TCO).

This DB2® UDB release delivers over 200 new features; some are highlighted below:

Design Advisor , an industry-leading innovative technology that assists DBAs in making optimal and comprehensive database design decisions. It is a self-configuring autonomic tool that greatly simplifies the database design process by using workload, database, and hardware information to recommend optimal design of database objects.

Automated statistics profiling represents the first deployment from IBM's learning optimizer (LEO) research and development project. LEO is the next generation of IBM's query optimizer technology, in which the database automates, simplifies, and accelerates queries without human intervention.

Autonomic Object Maintenance feature automatically performs policy-based administration and maintenance functions, such as table reorganization, statistics collection, and database backup.

To improve programmer productivity and provide choice of programming environments , DB2 UDB provides deep integration with, or plug-ins for, both Java™/Eclipse and Microsoft™ .NET IDEs, such as IBM WebSphere® Studio and Microsoft Visual Studio .NET.

High Availability Disaster Recovery (HADR) and client reroute features enable 24x7 information availability and resilience required by on demand enterprises.

DB2's Linux™ leadership is extended by supporting the distributions based on the new 2.6 kernel. Exploitation of new I/O and memory management features found in the latest Linux distributions is provided. 64-bit Linux versions of DB2 servers are provided for Linux on Intel™ EM64T, Linux on POWER™ (IBM eServer pSeries® and iSeries™), and Linux on IBM eServer zSeries® hardware architectures.

DB2 UDB Geodetic Extender supports treatment of the Earth like a globe rather than a flat map. Thus, making it easier to develop applications for business intelligence and e-government that require geographical location analysis.
 
Back topBack to top
 

Key prerequisites

Refer to the Hardware requirements and Software requirements sections.
 
Back topBack to top
 

Planned availability dates
  • September 17, 2004: Electronic software delivery
  • October 29, 2004: Media and documentation


 
Back topBack to top
 

Description

Disclaimer: This section provides a technical description of the new features and functions of the DB2 UDB V8.2 products. Some functions may not be available in all editions of the DB2 UDB V8.2 products, and in some cases may not be available on certain operating system and hardware platforms.

Manageability enhancements

Activity Monitor

The Activity Monitor provides easy access to relevant and well organized monitor data through a set of predefined reports such as Top CPU time consuming applications and SQL statements with the largest total sort time. For each predefined report, appropriate actions may be recommended to help resolve resource utilization problems, to optimize performance, or to invoke another tool for further investigation.

Index extensions in partitioned environments

With DB2 Universal Database V8.2, you can create an index extension for use in a partitioned environment. Index extensions allow you to create and apply your own logic for the primary index components, including index maintenance and index exploitation.

Log file inclusion in backup images

When creating an online backup image, you can include the log files required to restore and recover a database in the image. This means that if you need to ship backup images to a disaster recovery site, you do not have to send the log files separately or package them together yourself. Further, you do not have to decide which log files are required to guarantee the consistency of an online backup, and you will not be able to delete the log files that pertain to a particular backup image.

Simplified database recovery

The new RECOVER DATABASE command combines the functionality of the RESTORE DATABASE and ROLLFORWARD DATABASE commands. You do not need to indicate which database backup image must be restored or which log files are required to reach the specified point-in-time (for point-in-time recovery).

Self-tuning backup and restore operations

DB2 will now automatically choose the number of buffers, the buffer size, and the parallelism settings for both backup and restore operations. The values chosen are based on the amount of memory available, the number of processors available, and the database configuration. The objective is to minimize the amount of time required for backup and restore operations to complete.

Automating database maintenance

You can now automate database maintenance activities based on policies that you define, using the Configure Automatic Maintenance wizard. The activities you can configure for automatic maintenance are database backup, data defragmentation (table or index reorganization), and data access optimization (running statistics).

Health Center enhancements

The Health Center for DB2 UDB V8.2 has a number of new features:

  • Health Indicator Configuration launchpad — Provides easy access to various levels of health indicator settings.
  • Recommendation advisor — Makes recommendations on how to resolve certain health alerts and guides you through implemented those recommendations, if selected.
  • Troubleshoot Health Alert Notification wizard — Helps you to troubleshoot various problems related to health alert notification, which ensures that notifications are received properly by the correct contacts.

Simplified memory configuration and reduced memory errors

To simplify configuration of heaps, you will now be able to specify a single value for how much memory DB2 uses for each active database and specify guaranteed minimums reserved for individual heaps.

Advanced alter table functionality from the Control Center

When altering a table from within the Alter Table notebook, you can now make more changes to table columns to be carried out automatically "under-the-covers".

Pattern matching when using the db2look command

The db2look command has a new option, -tw, that can be used to generate the DDL for tables whose names match a specified pattern.

View historical storage information for all objects in the storage management view

Using the storage management tool, you can now view historical storage information for all objects in the storage management view, including the database, table spaces, tables, containers, and indexes.

Column default values can be altered

There are times when the default values of a column in a database table must be changed. The ALTER TABLE SQL statement now allows you to set the default clause of a column in a table.

Performance enhancements

Design Advisor enhancements for recommending indexes, MQTs, MDC tables, and partitions

The DB2 Design Advisor is a tool that can significantly improve your workload performance and boost DBA productivity. It can be utilized while setting up a new database or while validating the design of existing databases. The task of selecting which indexes, clustering dimensions, aggregates, or partitioning keys to create for a complex workload can be very complex. The Design Advisor makes recommendations on which indexes, MQTs, MDCs and/or partitioning keys can be created to improve the performance of a given workload.

Specifying a lock wait mode strategy

Traditional locking approaches can result in applications blocking each other. Strategies to deal with the impact of such blocking usually provide a mechanism to specify the maximum acceptable duration of the lock. That is the amount of time that an application will wait prior to returning without a lock. Previously, this was only possible at the database level by changing the value of the locktimeout database configuration parameter. In V8.2, individual applications or user sessions can now specify their own lock wait strategy with options for no wait, wait for specified time, and wait indefinitely.

Improved query execution plans through better cardinality estimation

In V8.2, the DB2 optimizer can exploit distribution statistics from materialized query tables as well as detect correlation from column group statistics to ensure the most accurate cardinality estimates. This helps DB2 select a more efficient access plan for executing the query and improves query performance.

Reduction of the time and space required to optimize complex queries

The size and complexity of tables within databases is increasing. Longer and more complex queries are being used. Enhancements to the optimizer in V8.2 deliver enhanced query optimization for large, complex queries. There are no changes you need to make to your queries to take advantage of these improvements.

Automatic statistics profiling

Statistics profiles can now be generated automatically by the DB2 automatic statistics profiling feature. When this feature is enabled, information about actual cardinalities encountered in query execution is collected and stored in a statistics profiling warehouse. Based on this data, a statistics profile is generated. Enabling this feature can alleviate the problem of uncertainty about which statistics are relevant to a particular workload and permits the collection of the minimal set of statistics to provide optimal database workload performance. This represents the first step towards a closed-loop LEearning Optimizer in DB2 — LEO.

Improved RUNSTATS performance through sampling

Starting in V8.2, the RUNSTATS command provides the option to collect statistics on a sample of the data in the table by using the TABLESAMPLE option. This feature can increase the efficiency of statistics collection since sampling uses only a subset of the data. At the same time, the sampling methods ensure a high level of accuracy.

Throttling of RUNSTATS utility

Throttling of the RUNSTATS utility limits the amount of resources consumed by the utility, based on the current level of database activity and policies that you set. When database activity is low, the utility runs more aggressively; when database activity increases, the resources allocated to executing RUNSTATS are reduced.

Large page support in buffer pools on DB2 Universal Database (UDB) for Linux

Large page support in buffer pools is supported on DB2 Universal Database (DB2 UDB) for Linux in addition to DB2 UDB for AIX® 64-bit. Buffer pools are kept in memory and are not swapped out when using large pages. This improves performance of the DB2 UDB for Linux databases and applications.

Multipage file allocation on Systems Managed Space (SMS) table spaces enabled by default

A SMS table space file is extended one extent at a time (rather than one page at a time) by default when you create a database unless you have set the DB2_NO_MPFA_FOR_NEW_DB registry variable to "Yes".

Automatic setting of prefetch size

When the prefetch size is not specified for a table space, the DB2 uses the value for DFT_PREFETCH_SZ configuration parameter as the default. This parameter can now be set to AUTOMATIC, which allows DB2 to calculate an appropriate prefetch size for a table space based on the extent size, the number of containers, and the number of physical spindles per container. This frees the user from having to determine the appropriate value for the table space prefetch size and from having to remember to reset this value when any containers are added or removed from a table space.

XA timeout sample code

Refer to the CLI sample program dbxamon.c for an example of how to show and roll back indoubt transactions. The sample program allows you to specify a timeout value for the transaction. If the transaction idle time becomes longer than the timeout value, then the sample will rollback the transaction.

Availability enhancements

High Availability Disaster Recovery (HADR)

The new HADR feature provides a high-availability solution by replicating data from a source database, called the primary, to a target database, called the standby. HADR simplifies the process of setting up and managing a high-availability solution through the following ease-of-use features:

  • Intuitive graphical user interface tools, including a wizard that takes the user through all the necessary steps to setup a standby database. Database administrators with no HADR experience can set up a high-availability solution in as little as 2 1/2 hours.
  • Notification of operational status through automatic integration with the Health Center graphical tool.
  • Simple command-line commands

DB2 HADR is a data replication feature that provides a high-availability solution for both partial and complete site failures. HADR protects against data loss by replicating data changes from a source database, called the primary, to a target database, called the standby.

A partial site failure can be caused by a hardware, network, or software (DB2 or operating system) failure. Without HADR, the database management system (DBMS) server or the machine where the database resides has to be rebooted. With HADR, the standby database can take over in seconds. Further, you can redirect the clients that were using the old primary database to the standby database (new primary database) by using automatic client reroute or retry logic in the application.

A complete site failure can occur when a disaster, such as a fire, causes the entire site to be destroyed. Since HADR uses TCP/IP for communication between the primary and standby databases, the databases can be situated in different locations. If a disaster occurs at the primary site, data availability is maintained by having the remote standby database take over as the primary database with full DB2 functionality. After a takeover operation occurs, you can bring the original primary database backup and return it to its status of primary database; this is known as failback.

With HADR, you can choose the level of protection you want from potential loss of data by specifying one of three synchronization modes: synchronous, near synchronous, or asynchronous.

Once the failed old primary is repaired, it can rejoin the HADR pair as a standby database if the two copies of the database can be made consistent. After the original primary database is reintegrated into the HADR pair as the standby database, a failback operation can be performed so that the original primary database is once again the primary database.

HADR function is available as part of the DB2 UDB Enterprise Server Edition at no extra charge. Users of DB2 UDB Express and DB2 UDB Workgroup Server Editions can add HADR function to their servers by purchasing the DB2 UDB High Availability Disaster Recovery Option.

Set Up HADR wizard

Use the Set Up HADR Databases wizard to set up and configure primary and standby databases for high availability disaster recovery.

Manage High Availability Disaster Recovery window

Use the Manage High Availability Disaster Recovery window to configure and to check the status of your HADR system. This window will notify you if there are any problems with the HADR configuration.

Automatic client reroute

The automatic client reroute feature allows client applications to recover from a loss of communication with the server so that they can continue to work with minimal interruption. After a loss of communication, the client application attempts to reconnect to the server. If this fails, the client is then rerouted to a different server. You can specify an alternate location through the command line processor (CLP), by invoking an API, or when adding a database using the Control Center or the advanced view of the Configuration Assistant.

You can use automatic client reroute with HADR to make client applications connect to the new primary database after a takeover operation.

Usability enhancements

Integration into Microsoft .NET

DB2 is integrated seamlessly into the Microsoft .NET development environment. Microsoft .NET developers can perform the following tasks in their familiar development environment: Create and access DB2 objects, including tables, indexes, views, triggers, and stored procedures. Create and manage DB2 connections through the IBM Explorer, and DB2 Projects through the Solution Explorer.

Design Advisor

Use the Design Advisor when you want advice on changing the physical database design to improve workload performance. The usability and overall effectiveness of the Design Advisor has been enhanced in V8.2 through the following features:

  • More advice and recommendations: Previously the Design Advisor provided advice on indexes. In V8.2, it also provides advice on Materialized Query Tables (MQTs). Multidimensional Clustered Tables (MDC tables), and partitions for DB2's Data Partitioning Feature (DPF). In addition, the Design Advisor now provides more detailed information on the recommendations, and also provides you with the option of saving reports.
  • More sources of workload: The Design Advisor uses a workload as input to provide its recommendations. You can now load the workload from a file and use a workload from the event monitor as well as from Query Patroller historical analysis tables.

Control Center

The Control Center is a graphical tool for database administration and application development with DB2. The Control Center has been simplified and streamlined through two new features: (1) A set of views that tailor the object tree pane to the needs of the user, and (2) An enhanced object details pane that provides "object-at-a-glance" browsing and simplified navigation. A set of predefined views is available for the Control Center object tree pane (that is, the left-hand side of the Control Center window). These views have been introduced to simplify the user interface for novice users while still allowing expert users access to the rich set of features they need. The basic view provides core DB2 functionality, the advanced view displays all objects and actions, and the custom view provides users with the ability to customize the left-hand object tree and the object actions. The object details pane (that is, the lower right-hand side of the Control Center window) provides a fresh, new look at key objects shown in the Control Center. At one glance the user can see key status information, object details, and links to common tasks through hypertext links. This "object-at-a-glance" approach saves the user from navigating through pop-up menus and provides a quick overview of the structure and state information associated with the selected object in the object tree.

Command Editor

In V8.2, the Command Center is replaced by the Command Editor. The Command Editor includes all the function previously available with the Command Center, but provides these functions in a simplified interface which can be quickly accessed within the same window as the Control Center. The Command Editor helps simplify the tasks of generating, editing, executing, and manipulating SQL statements and DB2 commands, and of optimizing SQL statements through graphical representations of access plans.

Utility progress monitoring

You can now monitor the progress of the following operations: backup, restore, crash recovery, load, and rebalance. You can see helpful progress information through either the command line or the Control Center.

Automating the process of altering a table through recreating the table

The Control Center automates the process of altering a table where recreation of the table is necessary, saving the user from performing a lengthy set of manual steps. Specifically, the Control Center will now automate the following operations: rename a column; drop a column; change the data type of a column; change the length, scope, or precision values for a column; change whether a column is nullable. If necessary, the table that is being changed will be dropped and recreated, and DB2 will help the user restore any dependent objects and to transform the existing data into the target data type of each remaining column.

Replication

DB2 V8.2 replication includes enhanced create subscription set functionality with improved error checking for source-target mappings, icons for showing validated and invalid objects, and status line messages to explain missing information. This new functionality has significantly reduced the time to troubleshoot problems during create time (from over 20 minutes previously to less than one minute now). The Replication Center can determine if the user has a gateway configuration and only ask for gateway-related information when appropriate. This has simplified set up and running of commands for users who have basic configurations.

SQL enhancements

Column default values can be altered

There are times when the default values of a column in a database table must be changed. The ALTER TABLE SQL statement allows you to set the default clause of a column in a table.

Changing generated column properties without having to recreate the table

You can now use the ALTER COLUMN clause in the ALTER TABLE statement to alter the various ways that a column value can be generated.

Previously, generated expression or identity attributes could be assigned to a column only when it was created. Although the expression itself could be changed later, once a generated column was created, it could not be changed to a non-generated column without dropping and then recreating the table. Before dropping the table, you had to export the data in the table and then reload that data into the recreated table with a redefined column.

SQL statement size limit increased to 2 MB

The SQL statement size limit is now increased to 2 MB. The new 2 MB limit allows you to use large statements when your application logic is in stored procedures or triggers. The increase in the statement size allows you to migrate a trigger or stored procedure statement from another RDBMS to DB2 UDB.

The new statement limit allows you to record auditing context records that have statement text up to 2 MB.

SQL procedures no longer require a C or C++ compiler

Beginning with DB2 UDB V8.2, the creation of SQL procedures does not require a C or C++ compiler on the server; therefore C or C++ compiler setup is not required, neither on the server nor on the Development Center. When you create an SQL procedure, its procedural statements are converted to a native representation that is stored in the database catalogs, as it is done with other SQL statements. When an SQL procedure is called, the native representation is loaded from the catalogs and the DB2 engine executes the procedure.

Bind option REOPT enables reoptimization of SQL statements

The bind option REOPT enables reoptimization of static and dynamic SQL statements. Specifically, the access path for an SQL statement containing host variables, special registers, or parameter markers is optimized using the values of these variables, rather than the default estimates determined by the compiler.

A new SQL/XML publishing function: XMLSERIALIZE

A new standard SQL/XML function, XMLSERIALIZE (with the CONTENT option), allows you to convert an XML data type value into a result string data type that is appropriate for the length of the XML output.

With XMLSERIALIZE, you can specify a result type like CHAR or VARCHAR, which might be more appropriate and result in better performance than CLOB.

Function XMLNAMESPACES new for V8.2

An XML namespace is a collection of names that is identified by a uniform reference identifier (URI). Namespaces are used in XML documents as element types and attribute names.

A new XML function, XMLNAMESPACES, provides XML namespace declarations within the SQL/XML publishing functions XMLELEMENT and XMLFOREST.

XML Extender platform support for HP-UX 32-bit and 64-bit PA-RISC

DB2 XML Extender is now supported by HP-UX V11 in both 32-bit and 64-bit PA-RISC platforms. This is the first 64-bit platform supported by XML Extender. The XML Extender MQSeries® functions are not yet available for use on the HP-UX platform.

Unicode tables in a non-Unicode database supported

You can now create Unicode tables in non-Unicode databases by invoking the CREATE TABLE statement with the CCSID UNICODE clause.

In conjunction with support for Unicode tables in non-Unicode databases, DB2 features the addition of a new code page attribute: section code page. A section code page is the code page under which an SQL statement runs.

Procedure invocation in a trigger

Procedures can now be invoked from triggers, or any other dynamic compound statement, in single partition environments, by executing a CALL statement that references a procedure within a trigger action. The invocation of a procedure in a trigger-action enables you to encapsulate complex logic in your triggers.

Nested savepoints

Nested savepoints allow for greater control of rollbacks. It allows you to set up a savepoint within another savepoint. DB2 UDB enables you to set as many levels of nested savepoints as you require. With nested savepoints, an application can have multiple levels of savepoints active simultaneously, and the application can roll back to any active savepoint, as required.

CURRENT PACKAGE PATH

The CURRENT PACKAGE PATH special register enables you to specify a list of package qualifiers with which the DB2 server can select a package. This feature is useful when you have multiple variants of a package, that is, when multiple packages share the same name and consistency tokens. Rather than maintain different versions of an application to work with each version of a package, you can use the CURRENT PACKAGE PATH special register to associate a single compiled program with multiple versions of a package.

Serviceability enhancements

New utility to retrieve statistics from a running DB2 instance or database (similar to "onstat" for Informix™)

db2pd is a new utility that can be used to retrieve statistics from a running DB2 instance or database. It is similar to the onstat utility for Informix.

The tool can provide a wide range of information useful for troubleshooting and problem determination, performance improvements, and application development design.

db2diag.log format message enhancements

The db2diag.log format has been improved in a number of ways for V8.2. The log file is now easier to read manually and easier to parse in software.

Diagnostic log analysis tool for filtering and formatting db2diag.log

A new tool for filtering and formatting db2diag.log files (db2diag) is now available. You can use this tool to filter diagnostic log files, which use a new message format for V8.2.

This command line tool has a wide range of options that you can use to modify the output to suit your needs. Among other options, you can indicate which fields to display, use a "grep" like filter to reduce the number of records, and have the empty fields omitted.

Trace facility improved

The DB2 trace facilities and the db2trc command have been improved for V8.2. The layout of the formatted trace record has been modified to reflect the new, wider range of trace types.

Application Development enhancements

Enhanced integration with Microsoft .Net, J2EE/WebSphere Studios and Web services improves developer productivity

DB2 UDB V8.2 is a major release for application developers with significant new SQL features, better support for open standard APIs, Web services, and seamless integration with the key development environments for both Java and Microsoft .NET platforms.

Microsoft .Net enhancements

The DB2 .NET data provider has much improved performance. DB2 UDB servers on Windows™ Server 2000 and Windows Server 2003 also support stored procedures written in Microsoft Common Language Runtime (CLR) compliant languages such as Visual Basic and C#. The additional language choice for server side logic allows customers flexibility to leverage their existing skill set. The DB2 tools add-ins to Microsoft Visual Studio .NET, first delivered in V8.1.2 are further enhanced with schema operation capabilities, wizards for developing and deploying .NET CLR stored procedures as well as Web services that can be deployed to Microsoft IIS or IBM DB2 Embedded Application Server.

J2EE enhancements

There are numerous improvements to the DB2 Universal JDBC Driver for V8.2, including distributed transaction or JTA support, connection pooling support and JDBC 3.0 compliance. Other new features increase the flexibility of iterator use in SQLJ and enhance interactivity with host and iSeries databases. The JTA support in the Type 4 connectivity of the Universal JDBC driver enables DB2 JDBC applications to participate in two-phase commit transactions that conforms to the XA-open specification, which along with connection pooling is required by many mission-critical enterprise applications. The Universal driver also implement all the new JDBC 3.0 features required to be JDBC 3.0/J2EE 1.4 compliant. For SQLJ developers, multiple instances of an iterator can be open concurrently in a single SQLJ application. One application for this ability is to open several instances of an iterator that uses host expressions. Each instance can use a different set of host expression values. You can perform one operation on a table using one iterator while you perform a different operation on the same table using another iterator.JDK 1.4 runtime as well as the development kit is supported for all DB2 platforms (except for AIX 4.3.x and 64-bit Linux on Intel) in addition to JDK 1.3.1.

Development Center

The Development Center support for DB2 Universal Database for z/OS®, V8.0 enables you to build Java stored procedures up to 10 MB in size. A new terminate feature in the debugger enables you to quickly terminate the debugger at any time without waiting for the current debugging session to reach the end of the stored procedure. It also supports the debugging of SQL stored procedures for UNIX® 64-bit platforms.

Web services

Web services continues to be our focus as the new application development paradigm. V8.2 has enhanced Web service support as a provider. Simple Object Access Protocol (SOAP) engine transparency is now provided, allowing more choices of SOAP engines to be plugged into the run time. With the new dynamic query capability the Web service client can determine at invocation which query should be executed, in addition to the fixed transactions/queries in DADXes. A tracing component has also been added to make it easier to diagnose errors in the provider. Another important feature is the support for Web Service Inspection Language (WSIL) so that users can easily explore the Web services that are offered in the DB2 Web services provider.

Run-Time Client Lite

DB2 Run-Time Client Lite (DB2 RTCL) is a new installable component that makes it much easier to provide access to DB2 servers from Windows-based applications. The DB2 RTCL is designed to be redistributable by independent software vendors (ISVs) and to be used for application distribution in mass deployment scenarios typical of large enterprises. Similar to the DB2 Run-Time Client component, the new DB2 RTCL provides application interfaces (CLI, ODBC, OLE DB, .NET Data provider, and JDBC) and the network libraries that are required for applications to run. The main distinguishing features of the DB2 RTCL are:

  • Significantly smaller disk footprint, shipped as a single executable, making it easy to redistribute and deploy.
  • Windows Installer Merge Modules (.msm file) are available which simplifies the integration of the DB2 RTCL code within a larger application.
  • Terms and conditions pertaining to the redistribution of the DB2 RTCL by ISVs and in-house programmers.

Type 4 JDBC driver

A redistributable Type 4 JDBC driver is available for download. It packages the Type 4 connectivity of the DB2 Universal Driver. The pure-Java implementation is a JDBC 3.0 compliant driver with a footprint of less than 2 MB and comes with terms and conditions pertaining to the redistribution of the DB2 RTCL by ISVs and in-house programmers.

National language enhancements

Thai and Unicode collation algorithm differences

The collation algorithm used in the Thai Industrial Standard (TIS) TIS620-1 (code page 874) Thai database with the NLSCHAR collation option is similar to (but not identical to) the collation algorithm used in a Unicode database with the UCA400_LTH collation option. The differences identified in the standard include sorting character weight, as well as detailed differences in the weights of the space, hyphen, and full-stop characters. The standard also includes a discussion of specific Thai characters.

Users of Thai and Unicode databases should investigate and test the algorithm differences to ensure that collation is occurring according to their business practices.

New collators for Unicode databases

Two new collators for Unicode databases are now supported: UCA400_NO and UCA400_LTH.

Security enhancements

Common Criteria certification of DB2 Universal Database products

At the time of this announcement, DB2 Universal Database is being evaluated for certification under the Common Criteria at evaluation assurance level 4 (EAL4). For information on the Common Criteria certification status of DB2, refer to

System security enhancements for Windows improve usability

  • Accepting additional special characters in user IDs and security mechanism group names (and consequently in authorization-names and authorization-ids) including &, —, and blank
  • Accepting security mechanism group names that are longer than eight characters
  • Allowing two-part names on CONNECT and ATTACH that contain a Windows domain name and the user ID to avoid the network traffic associated with looking up the user name in the trusted domain forest
  • Support for "access token" enhances DB2 integration with Windows Active Directory. When access token support is enabled, DB2 UDB will take advantage of Active Directory nested global groups, domain local groups, and cached credentials.

Support for Windows Local System account (LSA)

Support for LSA is provided for various DB2 services, as well as for applications that access them. You can silently install DB2 (using the "response file" mechanism) such that DB2 services are executing under SYSTEM (local system account) instead of running under a dedicated user account.

This feature makes it easier to deploy DB2 by avoiding, where appropriate, the complexities associated with handling of user IDs and passwords. Another enhancement is the ability for DB2 applications that are running in the context of the LSA to access and use the local DB2 server.

Prevention of access to DB2 system files on Windows-based platforms

The new DB2_EXTSECURITY registry variable prevents unauthorized access to DB2 system files. By default, this registry variable is set to ON.

Custom security plugins for authentication and group management

Users of DB2 UDB Enterprise Server Edition can now create their own authentication and group management mechanisms in the form of loadable plugins that DB2 will load and access to perform user authentication. Several security plugins are available as samples written in C source code. You may use them "as is" or modify them as required by your organizational security needs.

The ability to create custom security plugins presents you with alternatives to the authentication methods currently provided by DB2. You can write your own plugins, and then compile and install them. Installation is simple: the plugins must be copied to the correct directories and then specific database manager configuration parameters must be updated.

Kerberos authentication support for AIX

Kerberos is a third-party network authentication protocol that employs a system of shared secret keys to securely authenticate a user in an insecure network environment without sending a text user ID or password. Using Kerberos provides the advantages of single sign-on access to resources, such as a DB2 UDB server, and the centralization of user (principal) administration. Kerberos authentication support is extended to DB2 UDB Enterprise Server Edition for AIX, in addition to existing support for Windows operating systems that support Active Directory.

This support is provided as a security plug-in.

Encryption of client/server communications

To improve the security of user data, there are two new authentication types that allow you to manage the encryption of user data flowing between the DB2 client and DB2 server on the network. One new authentication type, SQL_AUTHENTICATION_DATAENC, requires connections to use the data encryption. The other new authentication type, SQL_AUTHENTICATION_DATAENC_CMP, allows for a compatibility mode with downlevel products that do not support the new authentication type.

FIPS 140-2 certification of DB2 Universal Database products

At the time of this announcement, DB2 Universal database products comply with FIPS 140-2 U.S. Federal Government standard on Windows, Solaris, and Linux operating systems.

DB2 Spatial Extender and DB2 UDB Geodetic Extender

DB2 UDB Geodetic Extender can construct a virtual globe at any scale. Most location information is collected using worldwide systems such as global positioning satellite (GPS) and represented in latitude/longitude coordinates (geocode). Business data such as addresses can be converted to a geocode by DB2 Spatial Extender and enterprise applications work better when they keep the data in this unprojected form, leaving map projections (earth to flat map) where they belong: in the presentation layer to display and print maps. DB2 Spatial Extender is available with DB2 UDB servers at no extra charge. DB2 UDB Geodetic Extender is a product that is available at extra charge.

Mobility on Demand

DB2 UDB V8.2 customers can easily extend the reach of their DB2 solutions to include mobile devices such as mobile phones, PDAs, and other pervasive devices. This capability is delivered via DB2 Mobility on Demand feature and is included with all server-based editions of the DB2 UDB product (all DB2 UDB for Linux, UNIX, and Windows with the exception of DB2 UDB Personal Edition). DB2 Mobility on Demand capability includes the high-performance, robust DB2 Everyplace™ database as well as a powerful synchronization solution for use with DB2 UDB servers. This solution allows users of PDAs and mobile phones to conduct business transactions in environments where physical connectivity to the database server is not available or is not financially viable and have these transactions synchronized with the enterprise data store when connection with the database server is available (that is, device is in a sync cradle or within wireless network range). DB2 UDB Mobility on Demand feature allows deployment of unlimited number of mobile devices provided these devices synchronize data with a properly licensed DB2 UDB server.

Section 508 of the U.S. Rehabilitation Act

DB2 Warehouse Manager Standard Edition is capable as of October 29, 2004, 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.

FIPS 140-2 certification of DB2 Universal Database products

At the time of this announcement, DB2 Universal database products comply with FIPS 140-2 U.S. Federal Government standard on Windows, Solaris, and Linux operating systems.

For information on the Common Criteria certification status of DB2 UDB, refer to


 
Back topBack to top
 
Product positioning

IBM DB2 UDB is available in four production deployment and two application development deployment editions, which are designed to meet various customer scenarios. IBM DB2 UDB also offers several options for application-specific customer requirements. The following positions these various editions and options.

DB2 UDB Editions for production deployment

DB2 UDB Enterprise Server Edition (ESE): DB2 ESE is designed to meet the relational database server needs of mid- to large-size businesses. It can be deployed on Linux, UNIX, or Windows servers of any size, from one CPU to hundreds of CPUs. DB2 ESE is an ideal foundation for building on demand enterprise-wide solutions, such as large data warehouses of multiple terabyte size or high performing 24x7 available high volume transaction processing business solutions, or Web-based solutions. It is the database backend of choice for industry-leading ISVs building enterprise solutions, such as Business Intelligence, Content Management, e-Commerce, ERP, CRM, or SCM. Additionally, DB2 ESE offers connectivity, compatibility, and integration with other enterprise DB2 and Informix data sources.

DB2 UDB Workgroup Server Unlimited Edition (WSUE): DB2 WSUE offers a per-processor licensing model for relational database deployment in a departmental or workgroup or medium-sized business environment that has Internet users or number of users that makes per-processor licensing more attractive than the WSE per-user licensing model. DB2 WSUE can be deployed in Linux, UNIX, and Windows environments on systems with up to four CPUs.

DB2 UDB Workgroup Server Edition (WSE): DB2 WSE is the relational database server of choice for deployment in a departmental or workgroup or medium-sized business environment that has a reasonable number of internal users. WSE is licensed on a per-user model, designed to provide an attractive price point for medium-size installations while providing a full-function relational database server. DB2 WSE can be deployed in Linux, UNIX, and Windows server environments on systems with up to four CPUs.

DB2 UDB Express Edition (DB2 Express): DB2 Express is a full-function DB2 relational database, which provides very attractive entry-level pricing for the Small and Medium Business (SMB) market. It is offered in both per-user or per-processor pricing models to provide choices to match SMB customer needs. It comes with simplified packaging, and is easy to transparently install within an application. It is fully compatible with, scalable to, and has all the autonomic manageability features of its higher priced family of offerings. DB2 Express can be deployed on pervasive SMB operating systems, that is, Linux or Windows, with up to two CPUs.

DB2 UDB Personal Edition (PE): DB2 PE provides a single user full-function relational database, with built-in replication, ideal for desktop or laptop PC-based deployments. DB2 PE can be remotely managed, making it the perfect choice for deployment in occasionally connected or remote office implementations that don't require multiuser capability. DB2 PE can be deployed in Linux or Windows single user, with inbound connection limited to administration use only, desktop or laptop workstations.

DB2 UDB Editions for Application Development deployment

DB2 Universal Developer's Edition (UDE): DB2 UDE offers a low-cost package for use by an individual application developer to design, build, or prototype applications for deployment on any of the DB2 client or server platforms. It includes all DB2 client and server editions, DB2 Everyplace, DB2 Connect®, DB2 Extenders® including Geodetic and NSE, DPF, all DB2 priced options, DB2 Table Editor and Web Query Tools, DB2 Warehouse Manager, and Intelligent Miner™. The software in this edition cannot be used for production systems.

DB2 Personal Developer's Edition (PDE): DB2 PDE enables an individual application developer to design, build, or prototype single user desktop or laptop workstation applications. This offering includes Windows and Linux versions of DB2 PE, DB2 Connect Personal Edition, DB2 Everyplace SDK, as well as the DB2 Extenders. The software in this edition cannot be used for production systems.

DB2 UDB options

DB2 UDB Database Partitioning Feature (DPF): DB2 DPF is an optional priced feature of DB2 ESE that allows partitioning of a database within a single (SMP) system or across a cluster of (MPP) systems. The DPF provides its customers with multiple benefits, including scalability to support very large databases with complex workloads, increased parallelism for faster query processing, and execution of various database administration tasks.

DB2 UDB High Availability Disaster Recovery (HADR) option: DB2 HADR allows 24x7 continuous availability required by on demand businesses running critical enterprise applications that must be available 24 hours a day, and seven days a week. This allows failover to a standby system, in the event of a software or hardware failure in primary system. DB2 HADR is included free of charge in the ESE, where as it is an optional priced offering for the DB2 WSUE/WSE or DB2 Express editions.

DB2 Query Patroller (QP): DB2 QP is a powerful query workload management offering that proactively and dynamically controls submission and execution of queries to better manage DB2 database workloads to meet business needs. It is available as an optional priced offering for the DB2 WSUE/WSE or DB2 ESE editions.

DB2 Spatial Extender: DB2 Spatial Extender leverages the power of the relational database model to store, access, manage, or analyze location-based flat map information just as easily as traditional business data, it uses industry-standard SQL for spatial data types and functions. The DB2 Spatial Extender is included free of charge in applicable DB2 UDB editions.

DB2 UDB Geodetic Extender: DB2 UDB Geodetic Extender provides the ability to store, access, manage, or analyze location-based round earth information for weather, defense, intelligence, Home Land Security, or natural resources applications for commercial or government applications. 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. The DB2 Geodetic Extender is available as a priced option for DB2 ESE only.

DB2 Net Search Extender (NSE): DB2 NSE provides high-speed, SQL-integrated, and federated full-text search capability for text documents stored in DB2 and other databases. DB2 NSE offers excellent query performance by using caching technologies and DB2 optimizer integration. The integration of advanced searching capabilities directly into the database saves the time and expense of integrating third-party text-based solutions while providing the speed and flexibility in text-based applications. The DB2 UDB Text Extender, providing text search and linguistic functions, is available as part of DB2 NSE. The DB2 NSE is available as a priced option for DB2 ESE or WSUE.
 
Back topBack to top
 

Reference information

Refer to Software Announcement 204-186 , dated August 17, 2004.

Trademarks

 
POWER, iSeries, Informix, Everyplace, and Intelligent Miner are trademarks of International Business Machines Corporation in the United States or other countries or both.
 
DB2 Universal Database, DB2, WebSphere, pSeries, the e-business logo, zSeries, AIX, MQSeries, z/OS, DB2 Connect, and DB2 Extenders are registered trademarks of International Business Machines Corporation in the United States or other countries or both.
 
Intel is a trademark of Intel Corporation.
 
Microsoft and Windows are trademarks of Microsoft Corporation.
 
Java is a trademark of Sun Microsystems, Inc.
 
UNIX is a registered trademark of the Open Company in the United States and other countries.
 
Linux is a trademark of Linus Torvalds in the United States, other countries or both
 
Other company, product, and service names may be trademarks or service marks of others.
DB2 Universal Database features and editions

               DB2(R)     DB2            DB2           DB2 Enterprise
Feature/       Personal   Express        Workgroup     Server
Capability     Edition    Edition        Edition       Edition
 
Memory         No limit   4 GB           16 GB         No limit
 (maximum
 usable
 memory)
CPUs           No limit   2              4             No limit
Database       NA         NA             NA            Priced
 Partitioning                                           feature
 Feature                                                (DPF)
Query          NA         NA             Priced        Priced
 Patroller                                feature       feature
                                          (Query        (Query
                                          Patroller)    Patroller)
High           NA         Priced         Priced        Included
 Availability              feature (DB2   feature (DB2
 Disaster                  HADR Option)   HADR Option)
 Recovery
 Option

NA = Not applicable

Customers of DB2 UDB Express Edition and Business Partners can download the Spatial Extender and Data directly from the DB2 Web site. The license is included with the Extender. To install Spatial Extender V8, you will need 31 MB of disk space for the Spatial Extender server library code, sample geocoder reference data, and documentation; in addition, you will need 563 MB of disk space if you plan to install the geocoder reference data for the United States, which is optional and available.

To download, simply go to

  • Select the DB2 Spatial Extender
  • Choose the language
  • Continue through the registration process
  • Download the Spatial Extender and Data content as desired

 
Back topBack to top
 
Education support

The following courses will be updated as a result of this product announcement. Course updates are traditionally completed within three months of the availability date of the product. Check with your country's ITES Web site or contact person to determine exactly when the new course material will be available.

The following educational offerings are available as listed below:

                           Course    Course
Course title               number    type
 
DB2 Universal              CF23G     Classroom
 Database
 Administration
 Workshop for Windows(TM)
DB2 UDB                    CF27G     Classroom
 Administration
 Workshop for Sun
 Solaris
DB2 UDB Advanced           CF45G     Classroom
 Administration
 Workshop
DB2 UDB Advanced           CF48G     Classroom
 Administration for
 Experienced
 Relational DBAs
DB2 UDB Advanced           CF49G     Classroom
 Recovery for Single
 Partition Databases
Fast Path to DB2 UDB       CF28G     Classroom
 for Experienced
 Relational DBAs
DB2 Universal              CF41G     Classroom
 Database Performance
 Tuning and Monitoring
 Workshop
DB2 Universal              CF20G     Classroom
 Database
 Administration
 Workshop for Linux(TM)
 
                           Course    Course
Course title               number    type
 
DB2 Universal Database     CF21G     Classroom
 Administration
 Workshop for UNIX(R)
DB2 UDB Data               DW35G     Classroom
 Warehouse Edition
 Components
DB2 UDB for UNIX           CF44G     Classroom
 Multi Partition
 Performance Workshop
DB2 UDB Multi              CF24G     Classroom
 Partition Database
 Administration
 Workshop for UNIX
DB2 UDB Multi              CG24G     Classroom
 Partition Environment
 for Single Partition
 DBAs

IBM Global Services, IT Education Services, provides education to support many IBM offerings. Descriptions of courses for IT professionals and managers are on the IBM IT Education Services Web site

Refer to the IBM IT Education Services Web site for information on course locations and availability dates.

Call IBM IT Education Services at 800-IBM-TEACH (426-8322) for catalogs, schedules, and enrollments.

To assist Visual Basic programmers needing to learn how to program against a DB2 UDB database, and in addition to the DB2 access plug-in supporting Microsoft™ Visual Basic Studio .NET environment, IBM has created a tutorial titled "Fast Path to DB2 UDB in a Visual Basic.NET Environment".
 
Back topBack to top
 

Offering information

Product information is available via the Offering Information Web site

Also, visit the Passport Advantage® Web site


 
Back topBack to top
 
Publications

                                                  Form
Description                   Language            number
 
IBM DB2 UDB Quick             English             GC09-4838-01
 Beginnings for               French              GC11-1881-01
 DB2 Personal Edition         German              GC12-3045-01
                              Spanish             GC10-3771-01
                              Br.Portuguese       G517-7387-01
                              Norwegian           GA15-4822-01
                              Polish              GC85-0100-01
                              Czech               GC09-3705-01
                              Japanese            GC88-9150-01
                              Korean              GA30-1494-01
                              S. Chinese          G152-0175-01
                              T. Chinese          GC40-0733-01
 
                                                  Form
Description                   Language            number
 
IBM DB2 UDB Quick             English             GC09-7851-01
 Beginnings for               French              GC11-2017-01
 DB2 UDB Express              German              GC12-3277-01
                              Spanish             GC10-3959-01
                              Br.Portuguese       G517-7773-01
                              Danish              G511-5836-01
                              Finnish             GB11-9184-01
                              Norwegian           GA15-4842-01
                              Swedish             GC14-0089-01
                              Russian             GC43-0294-01
                              Polish              GC85-0106-01
                              Czech               GC09-3706-01
                              Japanese            GC88-9690-01
                              Korean              GA30-2024-01
                              S. Chinese          G152-0655-01
                              T. Chinese          GC40-1847-01
 
IBM DB2 UDB Quick             English             GC09-4836-01
 Beginnings for               French              GC11-1879-01
 DB2 Servers                  German              GC12-3047-01
                              Spanish             GC10-3773-01
                              Br.Portuguese       G517-7385-01
                              Danish              G511-5822-01
                              Finnish             GB11-9172-01
                              Norwegian           GA15-4821-01
                              Swedish             GC14-0078-01
                              Russian             GH43-0221-01
                              Polish              GC85-0082-01
                              Czech               GC09-3704-01
                              Japanese            GC88-9148-01
                              Korean              GA30-1492-01
                              S. Chinese          G152-0173-01
                              T. Chinese          GC40-0731-01
 
IBM DB2 Application           English             SC09-4825-01
 Development Guide:           Spanish             SC10-3733-01
 Building & Running           Japanese            SC88-9137-01
 Applications V3              Korean              SA30-1482-01
                              S. Chinese          S152-0168-01
                              T. Chinese          SC40-0726-01

The IBM Publications Center

The Publications Center is a worldwide central repository for IBM product publications and marketing material with a catalog of 70,000 items. Extensive search facilities are provided. Payment options for orders are via credit card (in the U.S.) or customer number for 50 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.

The IBM Publications Notification System (PNS)

PNS enables subscribers to set up profiles of interest by order number/product number. PNS subscribers automatically receive e-mail notifications of all new publications defined in their profiles. These may then be ordered/downloaded from the Publications Center.

The PNS site is available in English and Canadian French.

Description             Language      Form number
 
IBM DB2 Net Search      English       SH12-6740-04
 Administration &       French        SH11-1287-01
 User's Guide           German        SH12-3021-01
                        Spanish       SH10-9305-04
                        Japanese      SH88-8546-02
                        Korean        SA30-1506-04
                        Simplified    S152-0596-01
                         Chinese
 
IBM DB2 Universal       English       GC09-4829-01
 Database Quick         French        GC11-1858-01
 Beginnings for Data    German        GC12-3056-01
 Links Manager          Spanish       GC10-3726-01
                        Brazilian     G517-7362-01
                         Portuguese
                        Japanese      GC88-9141-01
                        Korean        GA30-1485-01
                        Simplified    G152-0169-01
                         Chinese
                        Traditional   GC40-0727-01
                         Chinese
 
IBM DB2 Query           English       GC09-7658-01
 Patroller Guide:       French        GC11-2016-01
 Installation,          German        GC12-3225-01
 Administration and     Korean        GA30-1921-01
 Usage                  Japanese      GC88-9154-01
 
IBM DB2 Warehouse       English       GC27-1122-01
 Manager Installation   French        GC11-1868-01
 Guide                  German        GC12-3069-01
                        Brazilian     G517-7366-01
                         Portuguese
                        Russian       GH43-0204-01
                        Japanese      GC88-9164-01
                        Korean        GA30-1508-01
                        Simplified    G152-0187-01
                         Chinese
                        Traditional   GC40-0749-01
                         Chinese
                        Czech         GC09-3714-01
 
IBM DB2 Installing      English       SH12-6802-00
 the Intelligent Miner(TBrazilian     S517-7956-00
 Products                Portuguese
                        Czech         SH09-4210-00
                        Hungarian     SH22-0017-00
                        Polish        SH12-6509-00
                        Russian       SH43-0379-00
                        Spanish       SH10-9287-00
                        Korean        SA30-2244-00
                        Japanese      SH88-8587-00
                        Simplified    S152-0846-00
                         Chinese
                        Traditional   SH40-0388-00
                         Chinese

 
Back topBack to top
 
Technical information

Specified operating environment

Hardware requirements

  • For DB2 products running on 32-bit Intel™ systems, a Pentium™ central processing unit (CPU), or higher
  • For 32-bit AMD systems, an Athlon CPU
  • For 31-bit DB2 products running on Linux for S/390® and IBM eServer zSeries®, a 9672 G5, or higher, Multiprise® 3000
  • For 64-bit DB2 products for Linux on zSeries, any zSeries system that supports running Linux
  • For DB2 products running on Solaris, CPUs prior to UltraSparc are not supported
  • For DB2 products on all other systems, the CPU requirements are determined by the operating system being used. Refer below for information on which operating systems are supported.

Memory requirements: The amount of memory required for the DB2 Run-Time 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 DB2 Run-Time client. Graphical tools that are part of an Administration and Application Development client will require additional 256 MB. The following table shows applicable recommended minimum memory for installation prerequisite in megabytes (MB). The actual requirement depends on the applications the customer intends to run. Additional memory may be required to handle heavy workloads and large numbers of users. The numbers below are for reference only.

            HP-UX       Solaris    AIX(R)      Windows    Linux
 
DB2         64          64         64          64         64
 Personal
 Edition
DB2         256         256        256         256        256
 Server
 Editions
Data        N/A         256        256         256        N/A
 Links
 Manager
Net         256         256        256         256        256
 Search
 Extender
Spatial     16          16         16          16         16
 Extender
Intelligent 256         256        256         256        256
 Miner
 Modeling/
 Scoring/
 Visualization
Query       256         256        256         256        256
 Patroller
Warehouse   NA          512        512         512        NA
 Manager
 Standard
 Edition(1)
Warehouse   NA          256        256         256        NA
 Manager
 Standard
 Edition(2)
1
Development environment: Heavy GUI usage, minimal DWC server and default agent work.
2
Production environment: Minimal GUI usage, heavy DWC server usage, minimal default agent work.

Disk Space requirements: The following table shows applicable recommended minimum disk space for a typical install in megabytes (MB). The actual space required may vary depending on the customers' file system and the components installed. The numbers below are for reference only.

            HP-UX       Solaris    AIX         Windows    Linux
 
DB2         NA          NA         NA          200        200
 Personal
 Edition
DB2         450         450        450         350        450
 Enterprise
 Server
 Edition
DB2         450         450        450         350        450
 Workgroup
 Server
 Edition
DB2         60          60         60          30         60
 Run-Time
 Client
DB2         125         125        125         110        125
 Administration
 Client
DB2 Appl    160(1)      160(1)     160(1)      325(2)     160(1)
 Development
 Client
Spatial     600(3)      600(3)     600(3)      600(3)     600(3)
 Extender
Data        85          85         85          85         85
 Links
 Manager
Net         50          50         50          50         50
 Search
 Extender
 
            HP-UX       Solaris    AIX         Windows    Linux
 
Intelligent 200         200        150         150        150
 Miner
 Modeling/
 Scoring/
 Visualization
Query       14          14         14          14         14
 Patroller
Warehouse   1000        1000       1000        1000       1000
 Manager
 Standard
 Edition
1
Does not include the Java™ Developer's Kit (JDK).
2
Includes the JDK.
3
563 Mb of 600 Mb is for United States geocoder reference data.

Software requirements

The operating system support level by various DB2 products is frequently updated. To obtain the current information for supported software levels, including recommended maintenance levels, refer to

JRE 1.4.1 is required for developing and running applications and tools in all platforms, except for 64-bit Linux on Itanium-based systems, which requires JRE 1.3.1.

Minimal requirements for operating systems at the time of announcement are:

Windows

  • Windows 2000 Professional, Server, Advanced Server, and Datacenter Editions.
  • Windows Server 2003, Standard Server, Enterprise Server, and Datacenter Editions.
  • Windows XP (32-bit) Home Edition and Professional Edition.
  • Windows XP 64-bit Edition (for 64-bit Itanium systems).
  • Support for Windows XP 64-bit Edition for 64-bit Extended Systems and Windows Server 2003 for 64-bit Extended Systems Standard and Enterprise Editions (supporting AMD64 and Intel EM64T systems) will be available after these operating systems become generally available.

Linux

The following Linux distributions are recommended for new DB2 deployments on Linux:

  • Red Hat Enterprise Linux (RHEL) 2.1, Update 4
  • Red Hat Enterprise Linux (RHEL) 3, Update 2
  • SUSE LINUX Enterprise Server (SLES) 8 (SP3)
  • SUSE LINUX Enterprise Server (SLES) 9

The validation status for new Linux kernels and distributions is frequently updated. To obtain the current information for supported Linux software levels, refer to:

AIX

  • AIX 5.1 with maintenance level 6, or later
  • AIX 5.2 with maintenance level 3, or later

HP-UX

  • HP-UX 11i V1 for HP9000 servers
  • HP-UX 11i V2 for HP Integrity servers (Itanium-based systems)

Solaris

  • Solaris 8
  • Solaris 9

Note 1: Support for 64-bit for DB2 UDB Express and Workgroup products will be available at a later date on a variety of 64-bit platforms.

Note 2: Net Search Extender (NSE) — Partitioned database support through NSE is only available for AIX operating systems and not for the other supported operating systems as announced with DB2 UDB V8.1. 64-bit support for Windows and Linux operating systems as announced with DB2 UDB V8.1, will not be provided with V8.2. DB2 NSE V8.1 has been providing a legacy V7.2 interface for compatibility reasons. The V7.2 interface will not be provided and supported with V8.2 and beyond anymore. However, there might be customer-specific situations where this interface is still needed. In such cases, customers should contact their IBM representative.

For more information, refer to the Installation Prerequisites in the documentation accompanying each product.

Planning information

Software Maintenance, previously referred to as Software Subscription and Technical Support, is included in the Passport Advantage Agreement. Installation and technical support is provided by the Software Maintenance offering of the IBM International Passport Advantage Agreement. This fee service enhances customer productivity, with voice and electronic access into IBM support organizations.

Packaging

IBM DB2 Personal Edition V8.2

Publications:

  • IBM DB2 Universal Database® Quick Beginnings for DB2 Personal Edition

Media:

  • DB2 Information Center Documentation Windows CDs
  • DB2 Information Center Documentation Linux Intel CDs
  • DB2 PDF Documentation CD
  • DB2 Personal Edition for Windows 32- and 64-bit CD
  • DB2 Personal Edition for Linux Intel 32- and 64-bit CD
  • DB2 Personal Edition for Linux on AMD 64-bit CD
  • DB2 Embedded Application Server and Applications (XML registry, Web Administration tools and Java distributed debugger) for Linux (x86), Linux (IBM eServer iSeries™ and pSeries®), and Windows 32-bit, and Linux (S/390, zSeries) 31-bit CDs
  • AIV CD
  • DB2 Spatial Extender (2)
    • DB2 Spatial Extender Windows 32- and 64-bit CD
    • DB2 Spatial Extender AIX 32- and 64-bit CD
    • DB2 Spatial Extender Linux S/390 31-bit CD
    • DB2 Spatial Extender Linux Intel 32- and 64-bit CD
    • DB2 Spatial Extender HP-UX 32- and 64-bit CD
    • DB2 Spatial Extender Solaris 32- and 64-bit CD
    • DB2 Spatial Geocoder Data CD

Complimentary products/Additional media:

  • DB2 Net Search Extender
    • DB2 Net Search Extender for AIX, HP-UX, and Solaris 32- and 64-bit, Linux (x86) and Windows 32-bit, and Linux (S/390, zSeries) 31-bit CD
    • DB2 UDB Text Extender CD
  • WebSphere® Studio Site Developer V5.1.2
    • WebSphere Studio Site Developer for Windows CD
    • WebSphere Studio Site Developer for Linux CD

IBM DB2 Universal Database Express Edition Named User Option V8.2

Publications:

  • IBM DB2 Universal Database Quick Beginnings for DB2 UDB Express

Media:

  • DB2 Information Center Documentation Windows CDs
  • DB2 Information Center Documentation Linux Intel CDs
  • DB2 UDB Express Edition Windows 32-bit CDs
  • DB2 UDB Express Edition Linux Intel 32-bit CDs
  • DB2 UDB Express Edition for Linux for iSeries and pSeries 32-bit CDs
  • DB2 Embedded Application Server and Applications (XML registry, Web Administration tools and Java distributed debugger) for Linux (x86), Linux (iSeries and pSeries), and Windows 32-bit, and Linux (S/390, zSeries) 31-bit CDs
  • DB2 Spatial Extender (download only) (2)
  • DB2 UDB Mobility On Demand (download only) (3)

Complimentary products/Additional media:

  • DB2 UDB Additional Features for Linux 31- and 64-bit

IBM DB2 Universal Database Express Edition CPU Option V8.2

Publications:

  • IBM DB2 Universal Database Quick Beginnings for DB2 UDB Express

Media:

  • DB2 Information Center Documentation Windows CDs
  • DB2 Information Center Documentation Linux Intel CDs
  • DB2 UDB Express Edition CPU Option Windows 32-bit CDs
  • DB2 UDB Express Edition CPU Option Linux Intel 32-bit CDs
  • DB2 UDB Express Edition CPU Option for Linux for iSeries and pSeries 32-bit CDs
  • DB2 Embedded Application Server and Applications (XML registry, Web Administration tools and Java distributed debugger) for Linux (x86), Linux (iSeries and pSeries), and Windows 32-bit, and Linux (S/390, zSeries) 31-bit CDs
  • DB2 Spatial Extender (download only) (2)
  • DB2 UDB Mobility On Demand (download only) (3)

Complimentary products/Additional media:

  • DB2 UDB Additional Features for Linux 31- and 64-bit

IBM DB2 UDB Workgroup Server Edition V8.2

Publications:

  • IBM DB2 Universal Database Quick Beginnings for DB2 Servers

Media:

  • DB2 Information Center Documentation Windows CDs
  • DB2 Information Center Documentation AIX V5L CDs
  • DB2 Information Center Documentation Solaris V8 CDs
  • DB2 Information Center Documentation HP-UX 11i CDs
  • DB2 Information Center Documentation Linux Intel CDs
  • DB2 PDF Documentation CDs
  • DB2 Workgroup Server Edition Windows 32-bit CDs
  • DB2 Workgroup Server Edition AIX V4 32-bit CDs
  • DB2 Workgroup Server Edition AIX V5 32-bit CDs
  • DB2 Workgroup Server Edition Solaris 32-bit CDs
  • DB2 Workgroup Server Edition HP-UX 11i 64-bit CDs
  • DB2 Workgroup Server Edition Linux Intel 32-bit CDs
  • DB2 Workgroup Server Edition Linux for iSeries and pSeries 32-bit CDs
  • DB2 Administration Client for Windows 32- and 64-bit CDs
  • DB2 Administration Client for AIX V4 32-bit CDs
  • DB2 Administration Client for AIX V5 32- and 64-bit CDs
  • DB2 Administration Client for Solaris 32- and 64-bit CDs
  • DB2 Administration Client for HP-UX 32- and 64-bit CDs
  • DB2 Administration Client for HP-UX IA64 64-bit CDs
  • DB2 Administration Client for Linux Intel 32-bit CDs
  • DB2 Administration Client for Linux for iSeries and pSeries 32- and 64-bit CDs
  • DB2 Administration Clients for Linux for S/390 CDs
  • DB2 Administration Clients for Linux for S/390 and zSeries 64-bit CDs
  • DB2 Administration Clients for Linux on AMD64 and Intel EM64T s
  • DB2 Runtime Client Lite for Windows 32-bit CDs (1)
  • DB2 Runtime Client for Windows 32- and 64-bit CDs
  • DB2 Runtime Client for AIX V4 32- and 64-bit CDs
  • DB2 Runtime Client for AIX V5 32- and 64-bit CDs
  • DB2 Runtime Client for HP-UX 11 32- and 64-bit CDs
  • DB2 Runtime Client for HP-UX IA64 64-bit CDs
  • DB2 Runtime Client for Solaris 32- and 64-bit CDs
  • DB2 Runtime Client for Linux Intel 32- and 64-bit CDs
  • DB2 Runtime Client for Linux for iSeries and pSeries 32- and 64-bit CDs
  • DB2 Runtime Client for Linux for S/390 CDs
  • DB2 Runtime Client for Linux for S/390 and zSeries 64-bit CDs
  • DB2 Runtime Client for Linux on AMD 64-bit CDs
  • IBM Developer Kit, Java Technology Edition for AIX CDs
  • DB2 Embedded Application Server and Applications (XML registry, Web Administration tools and Java distributed debugger) for Linux (x86), Linux (iSeries and pSeries), and Windows 32-bit, and Linux (S/390, zSeries) 31-bit CDs
  • DB2 Embedded Application Server and Applications (XML registry, Web Administration tools and Java distributed debugger) for AIX 32-bit, HP-UX and Solaris CDs
  • DB2 UDB AIV Extenders for AIX, HP-UX, Solaris, and Windows 32-bit CDs
  • DB2 Spatial Extender (2)
    • DB2 Spatial Extender for Windows 32- and 64-bit CDs
    • DB2 Spatial Extender for AIX V4 32-bit CDs
    • DB2 Spatial Extender for AIX V5 32- and 64-bit CDs
    • DB2 Spatial Extender for Linux 32- and 64-bit CDs
    • DB2 Spatial Extender for Linux for S/390 64-bit CDs
    • DB2 Spatial Extender for HP-UX 32- and 64-bit CDs
    • DB2 Spatial Extender for Solaris 32- and 64-bit CDs
    • DB2 Spatial Geocoder Data CDs
  • DB2 UDB Mobility On Demand (3)

    Complimentary products/Additional media:

    • DB2 Net Search Extender
      • DB2 Net Search Extender for AIX, HP-UX, and Solaris 32- and 64-bit, Linux (x86) and Windows 32-bit, and Linux (S/390, zSeries) 31-bit CD
      • DB2 UDB Text Extender for AIX, HP-UX, Solaris, and Windows 32-bit CDs
    • WebSphere Studio Site Developer V5.1.2 for Windows and Linux CDs
    • WebSphere MQSeries® V5.3.1 (Windows, AIX, HP-UX, Solaris and Linux CDs)
    • DB2 QMF™ for Windows V8.1 60-day Try and Buy
    • DB2 UDB Additional Features for Linux 31- and 64-bit

IBM DB2 UDB Workgroup Server Unlimited Edition V8.2

Publications:

  • IBM DB2 Universal Database Quick Beginnings for DB2 Servers

Media:

  • DB2 Information Center Documentation Windows CDs
  • DB2 Information Center Documentation AIX V5L CDs
  • DB2 Information Center Documentation Solaris V8 CDs
  • DB2 Information Center Documentation HP-UX 11i CDs
  • DB2 Information Center Documentation Linux Intel CDs
  • DB2 PDF Documentation CDs
  • DB2 Workgroup Server Unlimited Edition Windows 32-bit CDs
  • DB2 Workgroup Server Unlimited Edition AIX V4 32-bit CDs
  • DB2 Workgroup Server Unlimited Edition AIX V5 32-bit CDs
  • DB2 Workgroup Server Unlimited Edition HP-UX 64-bit CDs
  • DB2 Workgroup Server Unlimited Edition Linux Intel 32-bit CDs
  • DB2 Workgroup Server Unlimited Edition Linux for iSeries and pSeries 32-bit CDs
  • DB2 Workgroup Server Unlimited Edition Solaris 32-bit CDs
  • DB2 Administration Client for Windows 32- and 64-bit CDs
  • DB2 Administration Client for AIX V4 32-bit CDs
  • DB2 Administration Client for AIX V5 32- and 64-bit CDs
  • DB2 Administration Client for Solaris 32- and 64-bit CDs
  • DB2 Administration Client for HP-UX 32- and 64-bit CDs
  • DB2 Administration Client for HP-UX IA64 64-bit CDs
  • DB2 Administration Client for Linux Intel 32- and 64-bit CDs
  • DB2 Administration Client for Linux for iSeries and pSeries 32- and 64-bit CDs
  • DB2 Administration Clients for Linux for S/390 CDs
  • DB2 Administration Clients for Linux for S/390 and zSeries 64-bit CDs
  • B2 Administration Clients for Linux on AMD64 and Intel EM64Ts
  • DB2 Runtime Client Lite for Windows 32-bit CDs (1)
  • DB2 Runtime Client for Windows 32- and 64-bit CDs
  • DB2 Runtime Client for AIX V4 32- and 64-bit CDs
  • DB2 Runtime Client for AIX V5 32- and 64-bit CDs
  • DB2 Runtime Client for HP-UX 11 32- and 64-bit CDs
  • DB2 Runtime Client for HP-UX IA64 64-bit CDs
  • DB2 Runtime Client for Solaris 32- and 64-bit CDs
  • DB2 Runtime Client for Linux Intel 32- and 64-bit CDs
  • DB2 Runtime Client for Linux for iSeries and pSeries 32- and 64-bit CDs
  • DB2 Runtime Client for Linux for S/390 CDs
  • DB2 Runtime Client for Linux for S/390 and zSeries 64-bit CDs
  • DB2 Runtime Client for Linux on AMD 64-bit CDs
  • IBM Developer Kit, Java Technology Edition for AIX CDs
  • DB2 Embedded Application Server and Applications (XML registry, Web Administration tools and Java distributed debugger) for Linux (x86), Linux (iSeries and pSeries), and Windows 32-bit, and Linux (S/390, zSeries) 31-bit CDs
  • DB2 Embedded Application Server and Applications (XML registry, Web Administration tools and Java distributed debugger) for AIX 32-bit, HP-UX, and Solaris CDs
  • DB2 UDB AIV Extenders for AIX, HP-UX, Solaris and Windows 32-bit CDs
  • DB2 UDB Mobility On Demand V8.2 (3)
  • DB2 Spatial Extender (2)
    • DB2 Spatial Extender for Windows 32- and 64-bit CDs
    • DB2 Spatial Extender for AIX V4 32-bit CDs
    • DB2 Spatial Extender for AIX V5 32- and 64-bit CDs
    • DB2 Spatial Extender for Linux 32- and 64-bit CDs
    • DB2 Spatial Extender for Linux for S/390 64-bit CDs
    • DB2 Spatial Extender for HP-UX 11 32- and 64-bit CDs
    • DB2 Spatial Extender for Solaris 32- and 64-bit CDs
    • DB2 Spatial Geocoder Data CDs
    • DB2 UDB Additional Features for Linux 31- and 64-bit

Complimentary products/Additional media:

  • DB2 QMF for Windows V8.1 60-day Try and Buy
  • WebSphere Studio Site Developer V5.1.2 for Windows and Linux CDs
  • WebSphere MQSeries V5.3.1 (Windows CDs, AIX CDs, HP-UX CDs, Solaris CDs and Linux CDs)

IBM DB2 UDB Enterprise Server Edition V8.2

Publications:

  • IBM DB2 Universal Database Quick Beginnings for DB2 Servers

Media:

  • DB2 Information Center Documentation Windows CDs
  • DB2 Information Center Documentation AIX V5L CDs
  • DB2 Information Center Documentation Solaris V8 CDs
  • DB2 Information Center Documentation HP-UX 11i CDs
  • DB2 Information Center Documentation Linux Intel CDs
  • DB2 PDF Documentation CDs
  • DB2 Enterprise Server Edition Windows 32- and 64-bit CDs
  • DB2 Enterprise Server Edition AIX V4 32-bit CDs
  • DB2 Enterprise Server Edition AIX V5 32- and 64-bit CDs
  • DB2 Enterprise Server Edition Solaris 32- and 64-bit CDs
  • DB2 Enterprise Server Edition HP-UX 32- and 64-bit CDs
  • DB2 Enterprise Server Edition HP-UX IA64 64-bit CDs
  • DB2 Enterprise Server Edition Linux Intel 32- and 64-bit CDs
  • DB2 Enterprise Server Edition Linux for iSeries and pSeries 32- and 64-bit CDs
  • DB2 Enterprise Server Edition for Linux on AMD 64-bit CDs
  • DB2 Enterprise Server Edition Linux for zSeries 32-bit CDs
  • DB2 Enterprise Server Edition Linux for S/390 CDs
  • DB2 UDB ESE V8.2 DPF and Geodetic Extender Features Activation CD
  • DB2 Administration Client for Windows 32- and 64-bit CDs
  • DB2 Administration Client for AIX V4 32-bit CDs
  • DB2 Administration Client for AIX V5 32- and 64-bit CDs
  • DB2 Administration Client for Solaris 32- and 64-bit CDs
  • DB2 Administration Client for HP-UX 32- and 64-bit CDs
  • DB2 Administration Client for HP-UX IA64 64-bit CDs
  • DB2 Administration Client for Linux Intel 32- and 64-bit CDs
  • DB2 Administration Client for Linux for iSeries and pSeries 32- and 64-bit CDs
  • DB2 Administration Clients for Linux for S/390 CDs
  • DB2 Administration Clients for Linux for S/390 and zSeries 64-bit CDs
  • B2 Administration Clients for Linux on AMD64 and Intel EM64Ts
  • DB2 Runtime Client Lite for Windows 32-bit CDs (1)
  • DB2 Runtime Client for Windows 32- and 64-bit CDs
  • DB2 Runtime Client for AIX V4 32- and 64-bit CDs
  • DB2 Runtime Client for AIX V5 32- and 64-bit CDs
  • DB2 Runtime Client for HP-UX 11 32- and 64-bit CDs
  • DB2 Runtime Client for HP-UX IA64 64-bit CDs
  • DB2 Runtime Client for Solaris 32- and 64-bit CDs
  • DB2 Runtime Client for Linux Intel 32- and 64-bit CDs
  • DB2 Runtime Client for Linux for iSeries and pSeries 32- and 64-bit CDs
  • DB2 Runtime Client for Linux for S/390 CDs
  • DB2 Runtime Client for Linux for zSeries 64-bit CDs
  • DB2 Runtime Client for Linux on AMD 64-bit CDs
  • IBM Developer Kit, Java Technology Edition for HP-UX, and Solaris
  • IBM Developer Kit, Java Technology Edition for AIX
  • DB2 Embedded Application Server and Applications (XML registry, Web Administration tools and Java distributed debugger) for Linux (x86), Linux (iSeries and pSeries), and Windows 32-bit, and Linux (S/390, zSeries) 31-bit CDs
  • DB2 Embedded Application Server and Applications (XML registry, Web Administration tools and Java distributed debugger) for AIX 32-bit, HP-UX and Solaris CDs
  • DB2 UDB AIV Extenders for AIX, HP-UX, Solaris, and Windows 32-bit CDs
  • DB2 UDB Mobility On Demand V8.2 (3)
  • DB2 Spatial Extender (2)
    • DB2 Spatial Extender for Windows 32- and 64-bit CDs
    • DB2 Spatial Extender for AIX V4 32-bit CDs
    • DB2 Spatial Extender for AIX V5 32- and 64-bit CDs
    • DB2 Spatial Extender for Linux 32- and 64-bit CDs
    • DB2 Spatial Extender for Linux for S/390 64-bit CDs
    • DB2 Spatial Extender for HP-UX 11 32- and 64-bit CDs
    • DB2 Spatial Extender for Solaris 32- and 64-bit CDs
    • DB2 Spatial Geocoder Data CDs

Complimentary products/Additional media:

  • DB2 QMF for Windows V8.1 60-day Try and Buy
  • WebSphere Studio Site Developer V5.1.2 for Windows and Linux CDs
  • WebSphere MQSeries V5.3.1 (Windows CDs, AIX CDs, HP-UX CDs, Solaris CDs and Linux CDs)
  • DM Tools
    • DB2 Web Query Tool for Multiplatforms (Try and Buy) CDs V1.3
    • DB2 Table Editor for Multiplatforms (Try and Buy) CDs V4.3
    • DB2 High Performance Unload for Multiplatforms (Try and Buy) CDs V2.1
    • Recovery Expert for Multiplatforms (Try and Buy) CDs V1.1
    • Performance Expert for Multiplatforms (Try and Buy) CDs V2.1
  • DB2 UDB Additional Features for Linux 31- and 64-bit

IBM DB2 Personal Developer's Edition V8.2

Publications:

  • IBM DB2 Application Development Guide: Building and Running Applications

Media:

  • DB2 Information Center Documentation Windows CDs
  • DB2 Information Center Documentation AIX V5L CDs
  • DB2 Information Center Documentation Solaris V8 CDs
  • DB2 Information Center Documentation HP-UX 11i CDs
  • DB2 Information Center Documentation Linux Intel CDs
  • DB2 PDF Documentation CDs
  • DB2 Personal Edition for Windows 32- and 64-bit CDs
  • DB2 Personal Edition for Linux Intel 32- and 64-bit CDs
  • DB2 Personal Edition for Linux on AMD 64-bit CDs
  • DB2 Connect® Personal Edition Windows 32- and 64-bit CDs
  • DB2 Connect Personal Edition Linux Intel 32- and 64-bit CDs
  • DB2 Connect Personal Edition Linux on AMD 64-bit CDs
  • DB2 Application Development Client Windows 32- and 64-bit CDs
  • DB2 Application Development Client AIX V4 32-bit CDs
  • DB2 Application Development Client AIX V5 32- and 64-bit CDs
  • DB2 Application Development Client Solaris 32- and 64-bit CDs
  • DB2 Application Development Client HP-UX 32- and 64-bit CDs
  • DB2 Application Development Client HP-UX on IA 64-bit CDs
  • DB2 Application Development Client Linux Intel 32- and 64-bit CDs
  • DB2 Application Development Client Linux for iSeries and pSeries 32- and 64-bit CDs
  • DB2 Application Development Client Linux for S/390 CDs
  • DB2 Application Development Client Linux for S/390 and zSeries 64-bit CDs
  • DB2 Application Development Client Linux on AMD 64-bit CDs
  • IBM Developer Kit, Java Technology Edition for AIX
  • DB2 Embedded Application Server and Applications (XML registry, Web Administration tools and Java distributed debugger) for Linux (x86), Linux (iSeries and pSeries), and Windows 32-bit, and Linux (S/390, zSeries) 31-bit CDs
  • DB2 Embedded Application Server and Applications (XML registry, Web Administration tools and Java distributed debugger) for AIX 32-bit, HP-UX and Solaris CDs
  • DB2 UDB AIV Extenders for AIX, HP-UX, Solaris and Windows 32-bit CDs
  • DB2 UDB Mobility On Demand
  • DB2 Spatial Extender (2)
    • DB2 Spatial Extender for Windows 32- and 64-bit CDs
    • DB2 Spatial Extender for AIX V4 32-bit CDs
    • DB2 Spatial Extender for AIX V5 32- and 64-bit CDs
    • DB2 Spatial Extender for Linux 32- and 64-bit CDs
    • DB2 Spatial Extender for Linux for S/390 64-bit CDs
    • DB2 Spatial Extender for HP-UX 32- and 64-bit CDs
    • DB2 Spatial Extender for Solaris 32- and 64-bit CDs
    • DB2 Spatial Geocoder Data CDs

Complimentary products/Additional media:

  • DB2 Net Search Extender
    • DB2 Net Search Extender for AIX, HP-UX, and Solaris 32- and 64-bit, Linux (x86) and Windows 32-bit, and Linux (S/390, zSeries) 31-bit CD
    • DB2 UDB Text Extender for AIX, HP-UX, Solaris and Windows 32-bit CDs
  • WebSphere Studio Site Developer V5.1.2 for Windows and Linux CDs
  • DB2 Test Database Generator for Multiplatforms V2.1 Try and Buy

IBM DB2 Universal Developer's Edition V8.2

Publications:

  • IBM DB2 Application Development Guide: Building and Running Applications

Media:

  • Information Center Documentation Windows CDs
  • DB2 Information Center Documentation AIX V5L CDs
  • DB2 Information Center Documentation Solaris V8 CDs
  • DB2 Information Center Documentation HP-UX 11i CDs
  • DB2 Information Center Documentation Linux Intel CDs
  • DB2 PDF Documentation CDs
  • DB2 Personal Edition for Windows 32- and 64-bit CDs
  • DB2 Personal Edition for Linux Intel 32- and 64-bit CDs
  • DB2 Personal Edition for Linux on AMD 64-bit CDs
  • DB2 Workgroup Server Edition Windows 32-bit CDs
  • DB2 Workgroup Server Edition AIX V4 32-bit CDs
  • DB2 Workgroup Server Edition AIX V5 32-bit CDs
  • DB2 Workgroup Server Edition Solaris 32-bit CDs
  • DB2 Workgroup Server Edition HP-UX 11i 32- and 64-bit CDs
  • DB2 Workgroup Server Edition Linux Intel 32-bit CDs
  • DB2 Workgroup Server Edition Linux for iSeries and pSeries 32-bit CDs
  • DB2 Workgroup Server Edition for Linux on AMD 64-bit CDs
  • DB2 Enterprise Server Edition Windows 32- and 64-bit CDs
  • DB2 Enterprise Server Edition AIX V4 32-bit CDs
  • DB2 Enterprise Server Edition AIX V5 32- and 64-bit CDs
  • DB2 Enterprise Server Edition Solaris 32- and 64-bit CDs
  • DB2 Enterprise Server Edition HP-UX 32- and 64-bit CDs
  • DB2 Enterprise Server Edition HP-UX IA64 64-bit CDs
  • DB2 Enterprise Server Edition Linux Intel 32- and 64-bit CDs
  • DB2 Enterprise Server Edition Linux for iSeries and pSeries 32- and 64-bit CDs
  • DB2 Enterprise Server Edition for Linux on AMD 64-bit CDs
  • DB2 Enterprise Server Edition Linux for zSeries 32-bit CDs
  • DB2 Enterprise Server Edition Linux for S/390 CDs
  • DB2 UDB ESE V8.2 DPF and Geodetic Extender Features Activation CD
  • DB2 Connect Personal Edition Windows 32- and 64-bit CDs
  • DB2 Connect Personal Edition Linux Intel 32- and 64-bit CDs
  • DB2 Connect Personal Edition Linux on AMD 64-bit CDs
  • DB2 Connect Enterprise Edition Windows 32- and 64-bit CDs
  • DB2 Connect Enterprise Edition AIX V4 32-bit CDs
  • DB2 Connect Enterprise Edition AIX V5 32- and 64-bit CDs
  • DB2 Connect Enterprise Edition Solaris 32- and 64-bit CDs
  • DB2 Connect Enterprise Edition HP-UX 32- and 64-bit CDs
  • DB2 Connect Enterprise Edition HP-UX IA64 64-bit CDs
  • DB2 Connect Enterprise Edition Linux Intel 32- and 64-bit CDs
  • DB2 Connect Enterprise Edition Linux for iSeries and pSeries 32- and 64-bit CDs
  • DB2 Connect Enterprise Edition Linux for S/390 CDs
  • DB2 Connect Enterprise Edition Linux for zSeries 64-bit CDs
  • DB2 Connect Enterprise Edition for Linux on AMD 64-bit CDs
  • DB2 Intelligent Miner Modeling/Scoring/Visualization Windows 32- and 64-bit CDs
  • DB2 Intelligent Miner Modeling/Scoring/Visualization AIX 32- and 64-bit CDs
  • DB2 Intelligent Miner Modeling/Scoring/Visualization HP-UX 32- and 64-bit CDs
  • DB2 Intelligent Miner Modeling/Scoring/Visualization Linux (x86) 32- and 64-bit CD
  • DB2 Intelligent Miner Modeling/Scoring/Visualization Solaris 32- and 64-bit, and Linux (S/390, zSeries) 31-bit CD
  • DB2 Data Links Manager Windows 32-bit CDs
  • DB2 Data Links Manager AIX V4 32-bit CDs
  • DB2 Data Links Manager AIX V5 32-bit CDs
  • DB2 Data Links Manager Solaris 32-bit CDs
  • DB2 Warehouse Manager Standard Edition Windows 32-bit CDs
  • DB2 Warehouse Manager Standard Edition AIX V4 32-bit CDs
  • DB2 Warehouse Manager Standard Edition AIX V5 32- and 64-bit CDs
  • DB2 Warehouse Manager Standard Edition Solaris 32-bit CDs
  • DB2 Warehouse Manager Standard Edition Linux Intel 32-bit CDs
  • DB2 Warehouse Manager Standard Edition iSeries CDs
  • DB2 Net Search Extender for AIX, HP-UX, and Solaris 32- and 64-bit, Linux (x86) and Windows 32-bit, and Linux (S/390, zSeries) 31-bit CD
  • DB2 UDB Text Extender for AIX, HP-UX, Solaris and Windows 32-bit CDs
  • DB2 UDB AIV Extenders for AIX, HP-UX, Solaris and Windows 32-bit CDs
  • DB2 Administration Client for Windows 32- and 64-bit CDs
  • DB2 Administration Client for AIX V4 32-bit CDs
  • DB2 Administration Client for AIX V5 32- and 64-bit CDs
  • DB2 Administration Client for Solaris 32- and 64-bit CDs
  • DB2 Administration Client for HP-UX 32- and 64-bit CDs
  • DB2 Administration Client for HP-UX IA64 64-bit CDs
  • DB2 Administration Client for Linux Intel 32- and 64-bit CDs
  • DB2 Administration Client for Linux for iSeries and pSeries 32- and 64-bit CDs
  • DB2 Administration Clients for Linux for S/390 CDs
  • DB2 Administration Clients for Linux for zSeries 64-bit CDs
  • B2 Administration Clients for Linux on AMD64 and Intel EM64Ts
  • DB2 Runtime Client Lite for Windows 32-bit CDs (1)
  • DB2 Runtime Client for Windows 32- and 64-bit CDs
  • DB2 Runtime Client for AIX V4 32- and 64-bit CDs
  • DB2 Runtime Client for AIX V5 32- and 64-bit CDs
  • DB2 Runtime Client for HP-UX 11 32- and 64-bit CDs
  • DB2 Runtime Client for HP-UX IA64 64-bit CDs
  • DB2 Runtime Client for Solaris 32- and 64-bit CDs
  • DB2 Runtime Client for Linux Intel 32- and 64-bit CDs
  • DB2 Runtime Client for Linux for iSeries and pSeries 32- and 64-bit CDs
  • DB2 Runtime Client for Linux for S/390 CDs
  • DB2 Runtime Client for Linux for zSeries 64-bit CDs
  • DB2 Runtime Client for Linux on AMD 64-bit CDs
  • DB2 Application Development Client Windows 32- and 64-bit CDs
  • DB2 Application Development Client AIX V4 32-bit CDs
  • DB2 Application Development Client AIX V5 32- and 64-bit CDs
  • DB2 Application Development Client Solaris 32- and 64-bit CDs
  • DB2 Application Development Client HP-UX 32- and 64-bit CDs
  • DB2 Application Development Client HP-UX on IA 64-bit CDs
  • DB2 Application Development Client Linux Intel 32- and 64-bit CDs
  • DB2 Application Development Client Linux for iSeries and pSeries 32- and 64-bit CDs
  • DB2 Application Development Client Linux for S/390 CDs
  • DB2 Application Development Client Linux for zSeries 64-bit CDs
  • DB2 Application Development Client Linux on AMD 64-bit CDs
  • IBM Developer Kit, Java Technology Edition for HP-UX and Solaris CDs
  • IBM Developer Kit, Java Technology Edition for AIX CDs
  • DB2 Embedded Application Server and Applications (XML registry, Web Administration tools and Java distributed debugger) for Linux (x86), Linux (iSeries and pSeries), and Windows 32-bit, and Linux (S/390, zSeries) 31-bit CDs
  • DB2 Embedded Application Server and Applications (XML registry, Web Administration tools and Java distributed debugger) for AIX 32-bit, HP-UX and Solaris CDs
  • DB2 UDB Mobility On Demand V8.2 (3)
  • DB2 Spatial Extender 2
    • DB2 Spatial Extender for Windows 32- and 64-bit CDs
    • DB2 Spatial Extender for AIX V4 32-bit CDs
    • DB2 Spatial Extender for AIX V5 32- and 64-bit CDs
    • DB2 Spatial Extender for Linux 32- and 64-bit CDs
    • DB2 Spatial Extender for Linux for S/390 64-bit CDs
    • DB2 Spatial Extender for HP-UX 11 32- and 64-bit CDs
    • DB2 Spatial Extender for Solaris 32- and 64-bit CDs
    • DB2 Spatial Geocoder Data CDs
    • DB2 UDB Additional Features for Linux 31- and 64-bit
    • DB2 Test Database Generator for Multiplatforms V2.1

Complimentary products/Additional media:

  • DB2 QMF for Windows V8.1 60-day Try and Buy
  • WebSphere Studio Site Developer V5.1.2 for Windows and Linux CDs
  • WebSphere Application Server Advanced Developer Edition V5.1 for Windows and Linux CDs
  • WebSphere MQSeries V5.3.1 (Windows CDs, AIX CDs, HP-UX CDs, Solaris CDs and Linux CDs)
  • DM Tools
    • DB2 Web Query Tool for Multiplatforms CDs V1.3
    • DB2 Table Editor for Multiplatforms CDs V4.3

IBM DB2 High Availability Disaster Recovery Option V8.2

Publications: None

Media:

  • DB2 High Availability Disaster Recovery CD

Complimentary products/Additional media: None

IBM DB2 Query Patroller V8.2

Publications:

  • IBM DB2 Query Patroller Guide — Installation, Administration and Usage

Media:

  • DB2 Information Center Documentation Windows CDs
  • DB2 Information Center Documentation AIX V5L CDs
  • DB2 Information Center Documentation Solaris V8 CDs
  • DB2 Information Center Documentation HP-UX 11i CDs
  • DB2 Information Center Documentation Linux Intel CDs
  • DB2 PDF Documentation CDs
  • DB2 Query Patroller Windows 32- and 64-bit CDs
  • DB2 Query Patroller AIX V4 32-bit CDs
  • DB2 Query Patroller AIX V5 32- and 64-bit CDs
  • DB2 Query Patroller Solaris 32- and 64-bit CDs
  • DB2 Query Patroller HP-UX 32- 64-bit CDs
  • DB2 Query Patroller Linux Intel 32- and 64-bit CDs
  • IBM Developer Kit, Java Technology Edition for HP-UX and Solaris
  • IBM Developer Kit, Java Technology Edition for AIX

Complimentary products/Additional media: None

IBM DB2 Data Links Manager V8.2

Publications:

  • IBM DB2 Universal Database Quick Beginnings for Data Links Manager

Media:

  • DB2 Information Center Documentation Windows CDs
  • DB2 Information Center Documentation AIX V5L CDs
  • DB2 Information Center Documentation Solaris V8 CDs
  • DB2 Information Center Documentation HP-UX 11i CDs
  • DB2 Information Center Documentation Linux Intel CDs
  • DB2 PDF Documentation CDs
  • DB2 Data Links Manager Windows 32-bit CDs
  • DB2 Data Links Manager AIX V4 32-bit CDs
  • DB2 Data Links Manager AIX V5 32-bit CDs
  • DB2 Data Links Manager Solaris 32-bit CDs
  • IBM Developer Kit, Java Technology Edition for HP-UX and Solaris CDs
  • IBM Developer Kit, Java Technology Edition for AIX CDs

Complimentary products/Additional media: None

IBM DB2 Warehouse Manager Standard Edition V8.2

Publications:

  • IBM DB2 Warehouse Manager Installation Guide

Media:

  • DB2 Information Center Documentation Windows CDs
  • DB2 Information Center Documentation AIX V5L CDs
  • DB2 Information Center Documentation Solaris V8 CDs
  • DB2 Information Center Documentation HP-UX 11i CDs
  • DB2 Information Center Documentation Linux Intel CDs
  • DB2 PDF Documentation CDs
  • DB2 Warehouse Manager Standard Edition Windows 32-bit CDs
  • DB2 Warehouse Manager Standard Edition AIX V4 32-bit CDs
  • DB2 Warehouse Manager Standard Edition AIX V5 32- and 64-bit CDs
  • DB2 Warehouse Manager Standard Edition Solaris 32-bit CDs
  • DB2 Warehouse Manager Standard Edition Linux Intel 32-bit CDs
  • DB2 Warehouse Manager Standard Edition iSeries CDs
  • DB2 Enterprise Server Edition Windows 32- and 64-bit CDs
  • DB2 Enterprise Server Edition AIX V4 32-bit CDs
  • DB2 Enterprise Server Edition AIX V5 32- and 64-bit CDs
  • IBM Developer Kit, Java Technology Edition for HP-UX and Solaris CDs
  • IBM Developer Kit, Java Technology Edition for AIX CDs
  • DB2 Embedded Application Server and Applications (XML registry, Web Administration tools and Java distributed debugger) for Linux (x86) 32-bit , Linux (iSeries and pSeries), Linux (S/390, zSeries), and Windows 32-bit.CDs
  • DB2 Embedded Application Server and Applications (XML registry, Web Administration tools and Java distributed debugger) for AIX 32-bit, HP-UX and Solaris CDs

Complimentary products/Additional media: None

IBM DB2 Net Search Extender V8.2

Publications:

  • DB2 Net Search Extender Administration and User's Guide

Media:

  • DB2 Net Search Extender for AIX, HP-UX, and Solaris 32- and 64-bit, Linux (x86) and Windows 32-bit, and Linux (S/390, zSeries) 31-bit CD
  • DB2 UDB Text Extender for AIX, HP-UX, Solaris and Windows 32-bit CDs

Complimentary products/Additional media: None

IBM DB2 Intelligent Miner Modeling/Scoring/Visualization V8.2

Publications:

  • Installing the Intelligent Miner products

Media:

  • DB2 Intelligent Miner Modeling/Scoring/Visualization Windows 32- and 64-bit CDs
  • DB2 Intelligent Miner Modeling/Scoring/Visualization AIX 32- and 64-bit CDs
  • DB2 Intelligent Miner Modeling/Scoring/Visualization HP-UX 32- and 64-bit CDs
  • DB2 Intelligent Miner Modeling/Scoring/Visualization Linux (x86) 32- and 64-bit CD
  • DB2 Intelligent Miner Modeling/Scoring/Visualization Solaris 32- and 64-bit, and Linux (S/390, zSeries) 31-bit CD

Complimentary products/Additional media: None

(1) To quickly download DB2 Run-Time Client Lite, obtain it from:

(2) Customers of DB2 UDB Express Edition and Business Partners can download the Spatial Extender and Data directly from the DB2 Web site. The license is included with the Extender.

To download, simply go to:

  • Select the DB2 Spatial Extender
  • Choose the language
  • Continue through the registration process
  • Download the Spatial Extender and Data content as desired

(3) Existing customers of DB2 UDB Express Edition, DB2 UDB Workgroup Server Edition, DB2 UDB Workgroup Server Unlimited Edition, DB2 UDB Enterprise Server Edition, and DB2 Universal Developer's Edition as well as Business Partners can download the Mobility on Demand Feature directly from the DB2 Everyplace™ Web site. To download, visit

  • Select the mobility on demand feature
  • Select a language
  • Continue through the registration process
  • Download the feature

Security, auditability, and control

To protect data and resources associated with a database server, DB2 Universal Database 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 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 topBack to top
 

Ordering information

This product is only available via Passport Advantage. It is not available as shrinkwrap.

Product information

Licensed function       Product group          Product category
title
 
IBM DB2 Warehouse       IBM Information        IBM Information
 Manager Standard        Integrator             Integrator
 Edition
DB2 Query Patroller     IBM DATABASE 2(TM)     DB2 Universal
                                                Database
DB2 Universal           IBM Database 2         DB2 Universal
 Database Express                               Database
 Edition
DB2 Universal           IBM Database 2         DB2 Universal
 Database Express                               Database
 Edition CPU Option
DB2 Universal           IBM Database           Database Management
 Database Personal       Management Other       Other
 Edition
DB2 Personal            IBM Database           Database Management
 Developers Edition      Management Other       Other
DB2 Universal           IBM Database 2         DB2
 Developers Edition
DB2 Intelligent Miner   IBM Intelligent Miner  Intelligent Miner
 Visualization
DB2 Intelligent Miner   IBM Intelligent Miner  Intelligent Miner
 Scoring
DB2 Intelligent Miner   IBM Intelligent Miner  Intelligent Miner
 Modeling
DB2 UDB Enterprise      IBM Database           Database Management
 Server Edition          Management Other       Other
 Geodetic Feature
DB2 UDB Database        IBM Database           Database Management
 Partitioning Feature    Management Other       Other
DB2 UDB Enterprise      IBM Database           Database Management
 Server Edition          Management Other       Other
DB2 Net Search          IBM Database 2         DB2
 Extender
DB2 UDB Workgroup       IBM Database           Database Management
 Server Edition          Management Other       Other
DB2 UDB WorkGroup       IBM Database 2         DB2 Universal
 Unlimited Edition                              Database
DB2 Data Links          IBM Database           Database Management
 Manager                 Management Other       Other
DB2 High Availability   IBM Database           Database Management
 Disaster Recovery       Management Other       Other

Metric descriptions

Processors

Each CPU available to the installed software must have a separate entitlement.

Users

They can be counted as either concurrent users or named users.

  • A concurrent user is a person, application, or device that has established a connection to one or more databases on one server. A user with multiple connections to a single server counts as only one concurrent user. The one exception is where multiple connections are made by a multiplexing program, application server, other program, or Web server that connects to DB2 providing access on behalf of other users.
  • A named or registered user is a person, application, or device entitled to establish one or more connections to any authorized server install of a DB2 Universal Database product in the customer's enterprise, either directly or through a multiplexing program or application server.

Installs

Each installation of the program must have a separate entitlement. Refer to the License limitations section for details.

Charge Structure

                        PID                  Charge Unit
Program name            number               description
 
DB2 UDB Personal        5724-B55             Install
 Edition
DB2 UDB Express         5724-E49             Server and
 Edition Named User                           Named User
 Option
DB2 UDB Express         5724-E49             Processor
 Edition CPU Option
DB2 UDB Workgroup       5765-F35             Install, User
 Server Edition
DB2 UDB Workgroup       5765-F43             Processor
 Server Unlimited
 Edition
DB2 UDB Enterprise      5765-F41             Processor
 Server Edition
DB2 UDB Data            5765-F41             Processor
 Partitioning Feature
DB2 UDB Geodetic        5765-F41             Processor
 Extender
DB2 High Availability   5724-J20             Processor
 Disaster Recovery
DB2 Personal            5724-B58             Install
 
 Developer's Edition
DB2 Universal           5765-F34             Install
 Developer's Edition
DB2 Data Links          5765-F31             Processor
 Manager
DB2 Net Search          5765-F38             Processor
 Extender
DB2 Intelligent Miner   5765-F36             Processor
 Scoring
DB2 Intelligent Miner   5765-F32             Server Install
 Modeling
DB2 Intelligent Miner   5765-F33             Server Install
 Visualization
DB2 Query Patroller     5724-E25             Processor
DB2 Warehouse Manager   5724-E66             Processor
 Standard Edition

Passport Advantage program licenses

Part description                             Part number
 
DB2 Data Links Manager
DB2 Data Links Manager Per                   E1ARHLL
 Processor SW Maintenance Annual
 Renewal
DB2 Data Links Manager Per                   D5ARFLL
 Processor License & SW
 Maintenance 12 Months
DB2 Data Links Manager Per                   D5ARILL
 Processor SW Maintenance
 Reinstatement 12 Months
 
Part description                             Part number
 
DB2 Intelligent Miner
 Visualization
DB2 IMVI Server Install SW                   D518ELL
 Maintenance Reinstatement
  12 Months
DB2 IMVI Server Install License              D518ALL
 & SW Maintenance 12 Months
DB2 IMVI Server Install SW                   E00BGLL
 Maintenance Annual Renewal
 
Part description                             Part number
 
DB2 Intelligent Miner
 Scoring
DB2 IMSC Per Processor License               D5CVDLL
 & SW Maintenance 12 Months
DB2 IMSC Per Processor SW                    D5CVGLL
 Maintenance Reinstatement
 12Months
DB2 IMSC Per Processor SW                    E1CVFLL
 Maintenance Annual Renewal
 
Part description                             Part number
 
DB2 Intelligent Miner
 Modeling
DB2 IMMO Server Install SW                   E00BHLL
 
 Maintenance Annual Renewal
DB2 IMMO Server Install License              D518BLL
 & SW Maintenance 12 Months
DB2 IMMO Server Install SW                   D518FLL
 Maintenance Reinstatement
 12 Months
 
Part description                             Part number
 
DB2 Net Search Extender
DB2 Net Search Extender Per                  E1ASMLL
 Processor SW Maintenance Annual
 Renewal
DB2 Net Search Extender Per                  D5ASKLL
 Processor License & SW
 Maintenance 12 Months
DB2 Net Search Extender Per                  D5ASNLL
 Processor SW Maintenance
 Reinstatement 12 Months
 
Part description                             Part number
 
DB2 Personal Developers
 Edition
DB2 PDE Server Install License               D5B4QLL
 & SW Maintenance 12 Months
DB2 PDE Server Install SW                    D5B4ULL
 Maintenance Reinstatement
 12 Months
DB2 PDE Server Install SW                    E1B4TLL
 Maintenance Annual Renewal
 
Part description                             Part number
 
DB2 Query Patroller
DB2 Query Patroller                          E00PLLL
 Per Processor, Annual SW Maint
 Renewal
DB2 Query Patroller Per                      D528WLL
 Processor, License & SW Maint
 12 months
DB2 Query Patroller Per                      D528XLL
 Processor, SW Maint
 Reinstatement, 12 Months
 
Part description                             Part number
 
DB2 UDB Enterprise Server
 Edition Geodetic Feature
DB2 Geodetic                                 D53Y2LL
 Extender feat Per
 Processor License & SW
 Maintenance 12 Months
DB2 Geodetic Extender feat Per               D53Y3LL
 Processor SW Maintenance
 Reinstatement 12 Months
DB2 Geodetic Extender feat Per               E01BNLL
 Processor SW Maintenance Annual
 Renewal
 
Part description                             Part number
 
DB2 UDB Enterprise Server
 Edition
DB2 UDB Enterprise Server ED                 E00IGLL
 Proc for zLinux SW Maintenance
 Annual Renewal
DB2 UDB Enterprise Svr Ed Proc               D51NCLL
 for zLinux SW Maintenance
 Reinstatement 12 Months
DB2 UDB ESE Proc from WKGUNLTD               D51QILL
 Proc Trdup License & SW
 Maintenance 12 Months
DB2 UDB Enterprise Server Ed Per             E00BILL
 Processor SW Maintenance Annual
 Renewal
DB2 UDB Enterprise Server Ed Per             D518GLL
 Processor License & SW
 Maintenance 12 Months
DB2 ESE Processor from Qualified             D52VBLL
 Competitor Proc Trdup
DB2 ESE zSeries fr DB2 ESE                   D51QJLL
 zLinux Restrct Use Proc Trdup
 Lic+SW Mtnce 12 Months
DB2 UDB ESE Proc for zLinux                  D51NALL
 License & SW Maintenance 12 Mont
DB2 UDB Enterprise Server Ed Per             D518ILL
 Processor SW Maintenance
 Reinstatement 12 Months
 
Part description                             Part number
 
DB2 UDB Database
 Partitioning Feature
DB2 UDB DPF Per                              E00BJLL
 Processor SW
 Maintenance Annual Renewal
DB2 UDB DPF Per Processor                    D518JLL
 License & SW Maintenance
 12 Months
DB2 UDB DPF Per Processor SW                 D518LLL
 Maintenance Reinstatement
 12 Months
 
Part description                             Part number
 
DB2 High Availability
 Disaster Recovery
DB2 HADR Per                                 E01C4LL
 Processor SW
 Maintenance Annual Renewal
DB2 HADR Per Processor License &             D53Z9LL
 SW Maintenance 12 Months
DB2 HADR Per Processor SW                    D53ZALL
 Maintenance Reinstatement
 12 Months
 
Part description                             Part number
 
DB2 UDB Workgroup Server
 Edition
DB2 UDB WSE Users SW                         E1B79LL
 Maintenance Annual Renewal
DB2 UDB WSE Users License & SW               D5B77LL
 Maintenance 12 Months
DB2 UDB WSE Installs License &               D5B7FLL
 SW Maintenance 12 Months
DB2 UDB WSE Installs SW                      E1B7HLL
 Maintenance Annual Renewal
DB2 UDB WSE Users SW Maintenance             D5B7ALL
 Reinstatement 12 Months
 
Part description                             Part number
 
DB2 UDB WSE from DB2 Personal                D5B7NLL
 Edition Svr Trdup Lic & SW
 Maintenance 12 Months
DB2 UDB WSE Installs SW                      D5B7ILL
 Maintenance Reinstatement
 12 Months
 
Part description                             Part number
 
DB2 UDB WorkGroup Unlimited
 Edition
DB2 UDB WSUE Per Processor                   E00IHLL
 SW Maintenance Annual Renewal
DB2 UDB WSUE from DB2 Expr Ed                D53GYLL
 CPU Option Processor Trdup
 Lic+SW Maint 12 Months
DB2 WSUE Processor fr Qual                   D52VCLL
 Compet Trdup License & SW
 Maintenance 12 Months
DB2 UDB WSUE Per Processor                   D51NDLL
 License & SW Maintenance
 12 Months
DB2 UDB WSUE Per Processor SW                D51NFLL
 Maintenance Reinstatement
 12 Months
 
Part description                             Part number
 
DB2 Universal Database
 Express Edition CPU Option
DB2 UDB Expr Ed CPU Option Per               D535PLL
 Processor License & SW
 Maintenance 12 Months
DB2 UDB Expr Ed CPU Option Per               D535QLL
 Processor SW Maintenance
 Reinstatement 12 Months
DB2 UDB Expr Ed CPU Option Per               E013SLL
 Processor SW Maintenance Annual
 Renewal
 
Part description                             Part number
 
DB2 Universal Database
 Express Edition
DB2 UDB Express Server                       D52BILL
 Install License & SW
 Maintenance 12 Months
DB2 UDB Express Server Install               E00QTLL
 SW Maintenance Annual Renewal
DB2 UDB Express Users SW                     E00QULL
 Maintenance Annual Renewal
DB2 UDB Express Server Install               D52BJLL
 SW Maintenance Reinstatement
 12 Months
DB2 UDB Express Users SW                     D52BLLL
 Maintenance Reinstatement
 12 Months
DB2 UDB Express Users License &              D52BKLL
 SW Maintenance 12 Months
 
Part description                             Part number
 
DB2 Universal Database
 
 Personal Edition
DB2 UDB PE Server                            D5B69LL
 Install License & SW
 Maintenance 12 Months
DB2 UDB PE Server Install SW                 D5B6CLL
 Maintenance Reinstatement
 12 Months
DB2 UDB PE Server Install SW                 E1B6BLL
 Maintenance Annual Renewal
 
Part description                             Part number
 
DB2 Universal Developers
 Edition
DB2 UDE Installs SW                          E1B51LL
 Maintenance Annual Renewal
DB2 UDE Installs for zLinux SW               E005HLL
 Maintenance Annual Renewal
DB2 UDE Installs for zLinux                  D50NDLL
 License & SW Maintenance
 12 Months
DB2 UDE Installs SW Maintenance              D5B52LL
 Reinstatement 12 Months
DB2 UDE Installs for zLinux SW               D50NFLL
 Maintenance Reinstatement
 12 Months
DB2 UDE Installs License & SW                D5B4ZLL
 Maintenance 12 Months
 
Part description                             Part number
 
IBM DB2 Warehouse Manager
 Standard Edition
DB2 Warehouse Manager Standard               D52A0LL
 Ed Per Processor, SW Maint
 Reinstate, 12 Months
DB2 Warehouse Mgr Standard Ed                E00Q3LL
 Per Processor , Annual SW
 Maintenance Renewal
DB2 Warehouse Manager Standard               D529ZLL
 Ed Per Processor, License & SW
 Maint, 12 Months

Passport Advantage supply

Program name/description                     Part number
 
DB2 Data Links Manager
 V8.2.0
Media Pack English US Windows                BB0KXNA
 2000, AIX V4.x, Solaris (SUN
 Microsystems), Windows NT(TM), AIX
 V5.x CD-ROM Digital Disk -- ISO
 9660 Standard V8.2.0
Media Pack Spanish Windows 2000,             BB0KXES
 AIX V4.x, Solaris (SUN
 Microsystems), Windows NT, AIX
 V5.x CD-ROM Digital Disk -- ISO
 9660 Standard V8.2.0
 
DB2 HADR V8.2.0
Media Pack Multilingual (French,             BB0M5ML
 Danish, Russian, Korean, Chinese
 -- Simplified, Spanish, Norwegian
 Bokmal, Brazilian Portuguese,
 German, Swedish, Japanese,
 Chinese -- Traditional, English
 US, Czech, Finnish, Polish)
 Linux for iSeries Integrated
 Mid-Market Business Servers,
 Windows 2000, AIX V4.x, Windows
 XP, Solaris (SUN Microsystems),
 Windows Server 2003, Linux for
 pSeries Unix Servers (incl
 pSeries IntelliStation(R)), Windows
 NT, AIX V5.x, HP-UX 11.x, Linux
 for x86Series Intel-based
 servers CD-ROM Digital Disk --
 ISO 9660 Standard V8.2.0
 
Part description                             Part number
 
DB2 IMSC/IMMO/IMVI V8.2.0
Media Pack English US Windows                BB0L0NA
 2000, AIX V4.x, Windows XP,
 Solaris (SUN Microsystems),
 Windows Server 2003, Linux for
 zSeries Enterprise Servers
 (Mainframes), Windows NT, AIX
 V5.x, HP-UX 11.x, Linux for
 x86Series Intel-based servers
 CD-ROM Digital Disk -- ISO 9660
 Standard V8.2.0
Media Pack Spanish Windows 2000,             BB0L0ES
 AIX V4.x, Windows XP, Solaris
 (SUN Microsystems), Windows
 Server 2003, Linux for zSeries
 Enterprise Servers (Mainframes),
 Windows NT, AIX V5.x, HP-UX
 11.x, Linux for x86Series
 Intel-based servers CD-ROM
 Digital Disk -- ISO 9660 Standard
 V8.2.0
 
DB2 Net Search Extender
 V8.2.0
Media Pack English US Windows                BB0KYNA
 2000, AIX V4.x, Windows XP,
 Solaris (SUN Microsystems),
 Windows Server 2003, Linux for
 zSeries Enterprise Servers
 (Mainframes), Linux for pSeries
 Unix Servers (incl pSeries
 IntelliStation), Windows NT, AIX
 V5.x, HP-UX 11.x, Linux for
 x86Series Intel-based servers
 CD-ROM Digital Disk -- ISO 9660
 Standard V8.2.0
Media Pack Spanish Windows 2000,             BB0KYES
 AIX V4.x, Windows XP, Solaris
 (SUN Microsystems), Windows
 Server 2003, Linux for zSeries
 Enterprise Servers (Mainframes),
 Linux for pSeries Unix Servers
 (incl pSeries IntelliStation),
 Windows NT, AIX V5.x, HP-UX
 11.x, Linux for x86Series
 Intel-based servers CD-ROM
 Digital Disk -- ISO 9660 Standard
 V8.2.0
 
DB2 PDE V8.2.0
Media Pack English US Windows                BB0LVNA
 2000, Windows XP, Windows Server
 2003, Windows NT, Windows Me,
 Linux for x86Series Intel-based
 servers CD-ROM Digital Disk --
 ISO 9660 Standard V8.2.0
Media Pack Spanish Windows 2000,             BB0LVES
 Windows XP, Windows Server 2003,
 Windows NT, Windows Me, Linux
 for x86Series Intel-based
 servers CD-ROM Digital Disk --
 ISO 9660 Standard V8.2.0
 
DB2 Query Patroller V8.2.0
Media Pack English US Windows                BB0LFNA
 2000, AIX V4.x, Windows XP,
 Solaris (SUN Microsystems),
 Windows Server 2003, Windows 98,
 Windows NT, AIX V5.x, Windows
 Me, HP-UX 11.x, Linux for
 x86Series Intel-based servers
 CD-ROM Digital Disk -- ISO 9660
 Standard V8.2.0
 
Part description                             Part number
 
DB2 UDB ESE V8.2.0
Media Pack English US Linux for              BB0LXNA
 iSeries Integrated Mid-Market
 Business Servers, Windows 2000,
 AIX V4.x, Solaris (SUN
 Microsystems), Windows Server
 2003, Linux for zSeries
 Enterprise Servers (Mainframes),
 Linux for pSeries Unix Servers
 (incl pSeries IntelliStation),
 Windows NT, AIX V5.x, HP-UX
 11.x, Linux for x86Series
 Intel-based servers CD-ROM
 Digital Disk -- ISO 9660 Standard
 V8.2.0
Media Pack Spanish Linux for                 BB0LXES
 iSeries Integrated Mid-Market
 Business Servers, Windows 2000,
 AIX V4.x, Solaris (SUN
 Microsystems), Windows Server
 2003, Linux for zSeries
 Enterprise Servers (Mainframes),
 Linux for pSeries Unix Servers
 (incl pSeries IntelliStation),
 Windows NT, AIX V5.x, HP-UX
 11.x, Linux for x86Series
 Intel-based servers CD-ROM
 Digital Disk -- ISO 9660 Standard
 V8.2.0
 
DB2 UDB Express CPU Option
 V8.2.0
Media Pack English US Windows                BB0KSNA
 XP, Windows NT, Linux for
 x86Series Intel-based servers
 CD-ROM Digital Disk -- ISO 9660
 Standard V8.2.0
Media Pack Spanish Windows XP,               BB0KSES
 Windows NT, Linux for x86Series
 Intel-based servers CD-ROM
 Digital Disk -- ISO 9660 Standard
 V8.2.0
 
DB2 UDB Express V8.2.0
Media Pack English US Windows                BB0LSNA
 XP, Windows NT, Linux for
 x86Series Intel-based servers
 CD-ROM Digital Disk -- ISO 9660
 Standard V8.2.0
Media Pack Spanish Windows XP,               BB0LSES
 Windows Server 2003, Windows NT,
 Linux for x86Series Intel-based
 servers CD-ROM Digital Disk --
 ISO 9660 Standard V8.2.0
 
DB2 UDB PE V8.2.0
Media Pack English US Windows                BB0LRNA
 2000, Windows XP, Windows Server
 2003, Windows NT, Windows Me,
 Linux for x86Series Intel-based
 servers CD-ROM Digital Disk --
 ISO 9660 Standard V8.2.0
Media Pack Spanish Windows 2000,             BB0LRES
 Windows XP, Windows Server 2003,
 Windows NT, Windows Me, Linux
 for x86Series Intel-based
 servers CD-ROM Digital Disk --
 ISO 9660 Standard V8.2.0
 
Part description                             Part number
 
DB2 UDB WSE V8.2.0
Media Pack English US Linux for              BB0LUNA
 iSeries Integrated Mid-Market
 Business Servers, Windows 2000,
 AIX V4.x, Windows XP, Solaris
 (SUN Microsystems), Windows
 Server 2003, Linux for zSeries
 Enterprise Servers (Mainframes),
 Linux for pSeries Unix Servers
 (incl pSeries IntelliStation),
 Windows NT, AIX V5.x, HP-UX
 11.x, Linux for x86Series
 Intel-based servers CD-ROM
 Digital Disk -- ISO 9660 Standard
 V8.2.0
 
DB2 UDB WSUE V8.2.0
Media Pack English US Windows                BB0KRNA
 2000, AIX V4.x, Windows XP,
 Solaris (SUN Microsystems),
 Linux for pSeries Unix Servers
 (incl pSeries IntelliStation),
 Windows NT, AIX V5.x, HP-UX 11.x
 CD-ROM Digital Disk -- ISO 9660
 Standard V8.2.0
 
DB2 UDE V8.2.0
Media Pack English US Linux for              BB0LTNA
 iSeries Integrated Mid-Market
 Business Servers, Windows 2000,
 AIX V4.x, Windows XP, Solaris
 (SUN Microsystems), Windows
 Server 2003, Linux for zSeries
 Enterprise Servers (Mainframes),
 Linux for pSeries Unix Servers
 (incl pSeries IntelliStation),
 Windows 98, Windows NT, AIX
 V5.x, Windows Me, HP-UX 11.x,
 Linux for x86Series Intel-based
 servers CD-ROM Digital Disk --
 ISO 9660 Standard V8.2.0
Media Pack Spanish Linux for                 BB0LTES
 iSeries Integrated Mid-Market
 Business Servers, Windows 2000,
 AIX V4.x, Windows XP, Solaris
 (SUN Microsystems), Windows
 Server 2003, Linux for zSeries
 Enterprise Servers (Mainframes),
 Linux for pSeries Unix Servers
 (incl pSeries IntelliStation),
 Windows 98, Windows NT, AIX
 V5.x, Windows Me, HP-UX 11.x,
 Linux for x86Series Intel-based
 servers CD-ROM Digital Disk --
 ISO 9660 Standard V8.2.0
 
DB2 WHM Standard Edition
 V8.2.0
Media Pack English US Windows                BB0LWNA
 2000, AIX V4.x, Windows XP,
 Solaris (SUN Microsystems),
 Windows NT, AIX V5.x, Windows Me
 CD-ROM Digital Disk -- ISO 9660
 Standard V8.2.0

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 Data Links Manager V8.2.0

Entitled maintenance    Media packs               Part
offerings description   description               number
 
DATA LINKS MGR          DB2 Data Links            BB0KXNA
 PROCESSOR ENT           Manager English US
                         Windows 2000, AIX
                         V4.x, Solaris (SUN
                         Microsystems),
                         Windows NT, AIX V5.x
                         CD-ROM Digital Disk --
                         ISO 9660 Standard
DATA LINKS MGR          DB2 Data Links            BB0KXES
 PROCESSOR ENT           Manager Spanish
                         Windows 2000, AIX
                         V4.x, Solaris (SUN
                         Microsystems),
                         Windows NT, AIX V5.x
                         CD-ROM Digital Disk --
                         ISO 9660 Standard

DB2 HADR V8.2.0

Entitled maintenance    Media packs               Part
offerings description   description               number
 
IBM DB2 High            DB2 HADR                  BB0M5ML
Availability Disaster    Multilingual (French,
Recovery Processor       Danish, Russian,
                         Korean, Chinese --
                         Simplified, Spanish,
                         Norwegian Bokmal,
                         Brazilian Portuguese,
                         German, Swedish,
                         Japanese, Chinese --
                         Traditional, English
                         US, Czech, Finnish,
                         Polish) Linux for
                         iSeries Integrated
                         Mid-Market Business
                         Servers, Windows
                         2000, AIX V4.x,
                         Windows XP, Solaris
                         (SUN Microsystems),
                         Windows Server 2003,
                         Linux for pSeries
                         Unix Servers (incl
                         pSeries
                         IntelliStation),
                         Windows NT, AIX V5.x,
                         HP-UX 11.x, Linux for
                         x86Series Intel-based
                         servers CD-ROM
                         Digital Disk -- ISO
                         9660 Standard

DB2 IMSC/IMMO/IMVI V8.2.0

Entitled maintenance    Media packs               Part
offerings description   description               number
 
DB2 INTELGNT MINER      DB2 IMSC/IMMO/IMVI        BB0L0NA
 VISULZTN SERVER         English US Windows
                         2000, AIX V4.x,
                         Windows XP, Solaris
                         (SUN Microsystems),
                         Windows Server 2003,
                         Linux for zSeries
                         Enterprise Servers
                         (Mainframes), Windows
                         NT, AIX V5.x, HP-UX
                         11.x, Linux for
                         x86Series Intel-based
                         servers CD-ROM
                         Digital Disk -- ISO
                         9660 Standard
 
Entitled maintenance    Media packs               Part
offerings description   description               number
 
DB2 INTELGNT MINER      DB2 IMSC/IMMO/IMVI        BB0L0ES
 VISULZTN SERVER         Spanish Windows 2000,
                         AIX V4.x, Windows XP,
                         Solaris (SUN
                         Microsystems),
                         Windows Server 2003,
                         Linux for zSeries
                         Enterprise Servers
                         (Mainframes), Windows
                         NT, AIX V5.x, HP-UX
                         11.x, Linux for
                         x86Series Intel-based
                         servers CD-ROM
                         Digital Disk -- ISO
                         9660 Standard
DB2 INTELGNT MINER      DB2 IMSC/IMMO/IMVI        BB0L0NA
 SCORING PROC            English US Windows
                         2000, AIX V4.x,
                         Windows XP, Solaris
                         (SUN Microsystems),
                         Windows Server 2003,
                         Linux for zSeries
                         Enterprise Servers
                         (Mainframes), Windows
                         NT, AIX V5.x, HP-UX
                         11.x, Linux for
                         x86Series Intel-based
                         servers CD-ROM
                         Digital Disk -- ISO
                         9660 Standard
DB2 INTELGNT MINER      DB2 IMSC/IMMO/IMVI        BB0L0ES
 SCORING PROC            Spanish Windows 2000,
                         AIX V4.x, Windows XP,
                         Solaris (SUN
                         Microsystems),
                         Windows Server 2003,
                         Linux for zSeries
                         Enterprise Servers
                         (Mainframes), Windows
                         NT, AIX V5.x, HP-UX
                         11.x, Linux for
                         x86Series Intel-based
                         servers CD-ROM
                         Digital Disk -- ISO
                         9660 Standard
DB2 INTELGNT MINER      DB2 IMSC/IMMO/IMVI        BB0L0NA
 MODELING SERVER         English US Windows
                         2000, AIX V4.x,
                         Windows XP, Solaris
                         (SUN Microsystems),
                         Windows Server 2003,
                         Linux for zSeries
                         Enterprise Servers
                         (Mainframes), Windows
                         NT, AIX V5.x, HP-UX
                         11.x, Linux for
                         x86Series Intel-based
                         servers CD-ROM
                         Digital Disk -- ISO
                         9660 Standard
DB2 INTELGNT MINER      DB2 IMSC/IMMO/IMVI        BB0L0ES
 MODELING SERVER         Spanish Windows 2000,
                         AIX V4.x, Windows XP,
                         Solaris (SUN
                         Microsystems),
                         Windows Server 2003,
                         Linux for zSeries
                         Enterprise Servers
                         (Mainframes), Windows
                         NT, AIX V5.x, HP-UX
                         11.x, Linux for
                         x86Series Intel-based
                         servers CD-ROM
                         Digital Disk -- ISO
                         9660 Standard

DB2 Net Search Extender V8.2.0

Entitled maintenance    Media packs               Part
offerings description   description               number
 
DB2 NET SEARCH          DB2 Net Search            BB0KYNA
 EXTENDER                Extender English US
 PROCESSOR               Windows 2000, AIX
                         V4.x, Windows XP,
                         Solaris (SUN
                         Microsystems),
                         Windows Server 2003,
                         Linux for zSeries
                         Enterprise Servers
                         (Mainframes), Linux
                         for pSeries Unix
                         Servers (incl pSeries
                         IntelliStation),
                         Windows NT, AIX V5.x,
                         HP-UX 11.x, Linux for
                         x86Series Intel-based
                         servers CD-ROM
                         Digital Disk -- ISO
                         9660 Standard
DB2 NET SEARCH          DB2 Net Search            BB0KYES
 EXTENDER                Extender Spanish
 PROCESSOR               Windows 2000, AIX
                         V4.x, Windows XP,
                         Solaris (SUN
                         Microsystems),
                         Windows Server 2003,
                         Linux for zSeries
                         Enterprise Servers
                         (Mainframes), Linux
                         for pSeries Unix
                         Servers (incl pSeries
                         IntelliStation),
                         Windows NT, AIX V5.x,
                         HP-UX 11.x, Linux for
                         x86Series Intel-based
                         servers CD-ROM
                         Digital Disk -- ISO
                         9660 Standard

DB2 PDE V8.2.0

Entitled maintenance    Media packs               Part
offerings description   description               number
 
IBM DB2 PERS            DB2 PDE English US        BB0LVNA
 DEV ED                  Windows 2000, Windows
                         XP, Windows Server
                         2003, Windows NT,
                         Windows Me, Linux for
                         x86Series Intel-based
                         servers CD-ROM
                         Digital Disk -- ISO
                         9660 Standard
IBM DB2 PERS            DB2 PDE Spanish           BB0LVES
 DEV ED                  Windows 2000, Windows
                         XP, Windows Server
                         2003, Windows NT,
                         Windows Me, Linux for
                         x86Series Intel-based
                         servers CD-ROM
                         Digital Disk -- ISO
                         9660 Standard

DB2 Query Patroller V8.2.0

Entitled maintenance    Media packs               Part
offerings description   description               number
 
IBM DB2 Query           DB2 Query Patroller       BB0LFNA
Patroller Processor      English US Windows
                         2000, AIX V4.x,
                         Windows XP, Solaris
                         (SUN Microsystems),
                         Windows Server 2003,
                         Windows 98, Windows
                         NT, AIX V5.x, Windows
                         Me, HP-UX 11.x, Linux
                         for x86Series
                         Intel-based servers
                         CD-ROM Digital Disk --
                         ISO 9660 Standard

DB2 UDB ESE V8.2.0

Entitled maintenance    Media packs               Part
offerings description   description               number
 
DB2 Geodetic            DB2 UDB ESE English       BB0LXNA
 Extender Feature        US Linux for iSeries
 Processor               Integrated Mid-Market
                         Business Servers,
                         Windows 2000, AIX
                         V4.x, Solaris (SUN
                         Microsystems),
                         Windows Server 2003,
                         Linux for zSeries
                         Enterprise Servers
                         (Mainframes), Linux
                         for pSeries Unix
                         Servers (incl pSeries
                         IntelliStation),
                         Windows NT, AIX V5.x,
                         HP-UX 11.x, Linux for
                         x86Series Intel-based
                         servers CD-ROM
                         Digital Disk -- ISO
                         9660 Standard
DB2 Geodetic            DB2 UDB ESE Spanish       BB0LXES
 Extender Feature        Linux for iSeries
 Processor               Integrated Mid-Market
                         Business Servers,
                         Windows 2000, AIX
                         V4.x, Solaris (SUN
                         Microsystems),
                         Windows Server 2003,
                         Linux for zSeries
                         Enterprise Servers
                         (Mainframes), Linux
                         for pSeries Unix
                         Servers (incl pSeries
                         IntelliStation),
                         Windows NT, AIX V5.x,
                         HP-UX 11.x, Linux for
                         x86Series Intel-based
                         servers CD-ROM
                         Digital Disk -- ISO
                         9660 Standard
DB2 UDB Database        DB2 UDB ESE English       BB0LXNA
 Partitioning Feature    US Linux for iSeries
 Processor               Integrated Mid-Market
                         Business Servers,
                         Windows 2000, AIX
                         V4.x, Solaris (SUN
                         Microsystems),
                         Windows Server 2003,
 
Entitled maintenance    Media packs               Part
offerings description   description               number
 
                         Linux for zSeries
                         Enterprise Servers
                         (Mainframes), Linux
                         for pSeries Unix
                         Servers (incl pSeries
                         IntelliStation),
                         Windows NT, AIX V5.x,
                         HP-UX 11.x, Linux for
                         x86Series Intel-based
                         servers CD-ROM
                         Digital Disk -- ISO
                         9660 Standard
DB2 UDB Database        DB2 UDB ESE Spanish       BB0LXES
 Partitioning Feature    Linux for iSeries
 Processor               Integrated Mid-Market
                         Business Servers,
                         Windows 2000, AIX
                         V4.x, Solaris (SUN
                         Microsystems),
                         Windows Server 2003,
                         Linux for zSeries
                         Enterprise Servers
                         (Mainframes), Linux
                         for pSeries Unix
                         Servers (incl pSeries
                         IntelliStation),
                         Windows NT, AIX V5.x,
                         HP-UX 11.x, Linux for
                         x86Series Intel-based
                         servers CD-ROM
                         Digital Disk -- ISO
                         9660 Standard
DB2 Universal           DB2 UDB ESE English       BB0LXNA
 Database Enterprise     US Linux for iSeries
 Server Edition          Integrated Mid-Market
 Processor               Business Servers,
                         Windows 2000, AIX
                         V4.x, Solaris (SUN
                         Microsystems),
                         Windows Server 2003,
                         Linux for zSeries
                         Enterprise Servers
                         (Mainframes), Linux
                         for pSeries Unix
                         Servers (incl pSeries
                         IntelliStation),
                         Windows NT, AIX V5.x,
                         HP-UX 11.x, Linux for
                         x86Series Intel-based
                         servers CD-ROM
                         Digital Disk -- ISO
                         9660 Standard
DB2 Universal           DB2 UDB ESE Spanish       BB0LXES
 Database Enterprise     Linux for iSeries
 Server Edition          Integrated Mid-Market
 Processor               Business Servers,
                         Windows 2000, AIX
                         V4.x, Solaris (SUN
                         Microsystems),
                         Windows Server 2003,
                         Linux for zSeries
                         Enterprise Servers
                         (Mainframes), Linux
                         for pSeries Unix
                         Servers (incl pSeries
                         IntelliStation),
                         Windows NT, AIX V5.x,
                         HP-UX 11.x, Linux for
                         x86Series Intel-based
                         servers CD-ROM
 
Entitled maintenance    Media packs               Part
offerings description   description               number
 
                         Digital Disk -- ISO
                         9660 Standard
DB2 UDB Enterprise      DB2 UDB ESE English       BB0LXNA
 Server Edition          US Linux for iSeries
 zLinux Proc             Integrated Mid-Market
                         Business Servers,
                         Windows 2000, AIX
                         V4.x, Solaris (SUN
                         Microsystems),
                         Windows Server 2003,
                         Linux for zSeries
                         Enterprise Servers
                         (Mainframes), Linux
                         for pSeries Unix
                         Servers (incl pSeries
                         IntelliStation),
                         Windows NT, AIX V5.x,
                         HP-UX 11.x, Linux for
                         x86Series Intel-based
                         servers CD-ROM
                         Digital Disk -- ISO
                         9660 Standard
DB2 UDB Enterprise      DB2 UDB ESE Spanish       BB0LXES
 Server Edition          Linux for iSeries
 zLinux Proc             Integrated Mid-Market
                         Business Servers,
                         Windows 2000, AIX
                         V4.x, Solaris (SUN
                         Microsystems),
                         Windows Server 2003,
                         Linux for zSeries
                         Enterprise Servers
                         (Mainframes), Linux
                         for pSeries Unix
                         Servers (incl pSeries
                         IntelliStation),
                         Windows NT, AIX V5.x,
                         HP-UX 11.x, Linux for
                         x86Series Intel-based
                         servers CD-ROM
                         Digital Disk -- ISO
                         9660 Standard

DB2 UDB Express CPU Option V8.2.0

Entitled maintenance    Media packs               Part
offerings description   description               number
 
DB2 Express CPU         DB2 UDB Express CPU       BB0KSNA
 Option Processor        Option English US
                         Windows XP, Windows
                         NT, Linux for
                         x86Series Intel-based
                         servers CD-ROM
                         Digital Disk -- ISO
                         9660 Standard
DB2 Express CPU         DB2 UDB Express CPU       BB0KSES
 Option Processor        Option Spanish
                         Windows XP, Windows
                         NT, Linux for
                         x86Series Intel-based
                         servers CD-ROM
                         Digital Disk -- ISO
                         9660 Standard
DB2 Express CPU         DB2 UDB Express CPU       BB0KSNA
 Option Processor        Option English US
                         Windows XP, Windows
                         NT, Linux for
                         x86Series Intel-based
                         servers CD-ROM
 
Entitled maintenance    Media packs               Part
offerings description   description               number
 
                         Digital Disk -- ISO
                         9660 Standard
DB2 Express CPU         DB2 UDB Express CPU       BB0KSES
 Option Processor        Option Spanish
                         Windows XP, Windows
                         NT, Linux for
                         x86Series Intel-based
                         servers CD-ROM
                         Digital Disk -- ISO
                         9660 Standard

DB2 UDB Express V8.2.0

Entitled maintenance    Media packs               Part
offerings description   description               number
 
DB2 Universal           DB2 UDB Express           BB0LSNA
 Database Express        English US Windows
 Edition Server          XP, Windows NT, Linux
                         for x86Series
                         Intel-based servers
                         CD-ROM Digital Disk --
                         ISO 9660 Standard
DB2 Universal           DB2 UDB Express           BB0LSES
 Database Express        Spanish Windows XP,
 Edition Server          Windows Server 2003,
                         Windows NT, Linux for
                         x86Series Intel-based
                         servers CD-ROM
                         Digital Disk -- ISO
                         9660 Standard
DB2 Universal           DB2 UDB Express           BB0LSNA
 Database Express        English US Windows
 Edition User            XP, Windows NT, Linux
                         for x86Series
                         Intel-based servers
                         CD-ROM Digital Disk --
                         ISO 9660 Standard
DB2 Universal           DB2 UDB Express           BB0LSES
 Database Express        Spanish Windows XP,
 Edition User            Windows Server 2003,
                         Windows NT, Linux for
                         x86Series Intel-based
                         servers CD-ROM
                         Digital Disk -- ISO
                         9660 Standard

DB2 UDB PE V8.2.0

Entitled maintenance    Media packs               Part
offerings description   description               number
 
IBM DB2 UDB             DB2 UDB PE English US     BB0LRNA
 PERS ED                 Windows 2000, Windows
                         XP, Windows Server
                         2003, Windows NT,
                         Windows Me, Linux for
                         x86Series Intel-based
                         servers CD-ROM
                         Digital Disk -- ISO
                         9660 Standard
IBM DB2 UDB             DB2 UDB PE Spanish        BB0LRES
 PERS ED                 Windows 2000, Windows
                         XP, Windows Server
                         2003, Windows NT,
                         Windows Me, Linux for
                         x86Series Intel-based
                         servers CD-ROM
                         Digital Disk -- ISO
                         9660 Standard
DB2 UDB WSE V8.2.0

Entitled maintenance    Media packs               Part
offerings description   description               number
 
IBM DB2 UDB WKGRP       DB2 UDB WSE English       BB0LUNA
 ED SVR                  US Linux for iSeries
                         Integrated Mid-Market
                         Business Servers,
                         Windows 2000, AIX
                         V4.x, Windows XP,
                         Solaris (SUN
                         Microsystems),
                         Windows Server 2003,
                         Linux for zSeries
                         Enterprise Servers
                         (Mainframes), Linux
                         for pSeries Unix
                         Servers (incl pSeries
                         IntelliStation),
                         Windows NT, AIX V5.x,
                         HP-UX 11.x, Linux for
                         x86Series Intel-based
                         servers CD-ROM
                         Digital Disk -- ISO
                         9660 Standard
IBM DB2 UDB WKGRP       DB2 UDB WSE English       BB0LUNA
 ED USR                  US Linux for iSeries
                         Integrated Mid-Market
                         Business Servers,
                         Windows 2000, AIX
                         V4.x, Windows XP,
                         Solaris (SUN
                         Microsystems),
                         Windows Server 2003,
                         Linux for zSeries
                         Enterprise Servers
                         (Mainframes), Linux
                         for pSeries Unix
                         Servers (incl pSeries
                         IntelliStation),
                         Windows NT, AIX V5.x,
                         HP-UX 11.x, Linux for
                         x86Series Intel-based
                         servers CD-ROM
                         Digital Disk -- ISO
                         9660 Standard

DB2 UDB WSUE V8.2.0

Entitled maintenance    Media packs               Part
offerings description   description               number
 
DB2 UDB                 DB2 UDB WSUE English      BB0KRNA
 WORKGROUP SVR           US Windows 2000, AIX
 UNLTD PROC              V4.x, Windows XP,
                         Solaris (SUN
                         Microsystems), Linux
                         for pSeries Unix
                         Servers (incl pSeries
                         IntelliStation),
                         Windows NT, AIX V5.x,
                         HP-UX 11.x CD-ROM
                         Digital Disk -- ISO
                         9660 Standard

DB2 UDE V8.2.0

Entitled maintenance    Media packs               Part
offerings description   description               number
 
DB2 UNIV DEVLPR LNX     DB2 UDE English US        BB0LTNA
 S/390 CLI INS           Linux for iSeries
                         Integrated Mid-Market
                         Business Servers,
                         Windows 2000, AIX
                         V4.x, Windows XP,
                         Solaris (SUN
                         Microsystems),
                         Windows Server 2003,
                         Linux for zSeries
                         Enterprise Servers
                         (Mainframes), Linux
                         for pSeries Unix
                         Servers (incl pSeries
                         IntelliStation),
                         Windows 98, Windows
                         NT, AIX V5.x, Windows
                         Me, HP-UX 11.x, Linux
                         for x86Series
                         Intel-based servers
                         CD-ROM Digital Disk --
                         ISO 9660 Standard
DB2 UNIV DEVLPR LNX     DB2 UDE Spanish Linux     BB0LTES
 S/390 CLI INS           for iSeries
                         Integrated Mid-Market
                         Business Servers,
                         Windows 2000, AIX
                         V4.x, Windows XP,
                         Solaris (SUN
                         Microsystems),
                         Windows Server 2003,
                         Linux for zSeries
                         Enterprise Servers
                         (Mainframes), Linux
                         for pSeries Unix
                         Servers (incl pSeries
                         IntelliStation),
                         Windows 98, Windows
                         NT, AIX V5.x, Windows
                         Me, HP-UX 11.x, Linux
                         for x86Series
                         Intel-based servers
                         CD-ROM Digital Disk --
                         ISO 9660 Standard
IBM DB2 UDB             DB2 UDE English US        BB0LTNA
 DEV ED                  Linux for iSeries
                         Integrated Mid-Market
                         Business Servers,
                         Windows 2000, AIX
                         V4.x, Windows XP,
                         Solaris (SUN
                         Microsystems),
                         Windows Server 2003,
                         Linux for zSeries
                         Enterprise Servers
                         (Mainframes), Linux
                         for pSeries Unix
                         Servers (incl pSeries
                         IntelliStation),
                         Windows 98, Windows
                         NT, AIX V5.x, Windows
                         Me, HP-UX 11.x, Linux
                         for x86Series
                         Intel-based servers
                         CD-ROM Digital Disk --
                         ISO 9660 Standard
 
Entitled maintenance    Media packs               Part
offerings description   description               number
 
IBM DB2 UDB             DB2 UDE Spanish Linux     BB0LTES
 DEV ED                  for iSeries
                         Integrated Mid-Market
                         Business Servers,
                         Windows 2000, AIX
                         V4.x, Windows XP,
                         Solaris (SUN
                         Microsystems),
                         Windows Server 2003,
                         Linux for zSeries
                         Enterprise Servers
                         (Mainframes), Linux
                         for pSeries Unix
                         Servers (incl pSeries
                         IntelliStation),
                         Windows 98, Windows
                         NT, AIX V5.x, Windows
                         Me, HP-UX 11.x, Linux
                         for x86Series
                         Intel-based servers
                         CD-ROM Digital Disk --
                         ISO 9660 Standard

DB2 WHM Standard Edition V8.2.0

Entitled maintenance    Media packs               Part
offerings description   description               number
 
DB2 Warehouse           DB2 WHM Standard          BB0LWNA
 Manager                 Edition English US
 Standard Edition        Windows 2000, AIX
 Processor               V4.x, Windows XP,
                         Solaris (SUN
                         Microsystems),
                         Windows NT, AIX V5.x,
                         Windows Me CD-ROM
                         Digital Disk -- ISO
                         9660 Standard

Cross-Platform Product for Use on zSeries

Order the part numbers that follow when there is an intention to acquire this cross-platform product for deployment on the zSeries/S/390 platform. This set of part numbers provides the identical supply and authorization as the other set in this announcement. The distinction is to identify the planned deployment platform.

Program Name/                           Part
Description                             number
 
DB2 UDE Installs for zLinux SW          E005HLL
 Maintenance Annual Renewal
DB2 UDE Installs for zLinux SW          D50NFLL
 Maintenance Reinstatement
 12 Months
DB2 UDE Installs for zLinux             D50NDLL
 License & SW Maintenance
 12 Months
DB2 UDB ESE Proc for zLinux             D51NALL
 License & SW Maintenance 12 Mont
DB2 UDB Enterprise Server ED            E00IGLL
 Proc for zLinux SW Maintenance
 Annual Renewal
DB2 UDB Enterprise Svr Ed Proc          D51NCLL
 for zLinux SW Maintenance
 Reinstatement 12 Months

On/Off Capacity on Demand

DB2 Data Links Manager

                                        Part
Part description                        number
 
DB2 Data Links Manager Per              ASQ74LL
Processor Per Use-DAY, On Off
Capacity on demand

DB2 High Availability Disaster Recovery

                                        Part
Part description                        number
 
DB2 HADR Per Processor Per              D53ZDLL
Use-DAY, On Off Capacity on
demand Temporary Us

DB2 Intelligent Miner Scoring

                                        Part
Part description                        number
 
DB2 IMSC Per Processor Per              ASPM1LL
Use-DAY, On Off Capacity on
demand Temporary Us

DB2 Net Search Extender

                                        Part
Part description                        number
 
DB2 Net Search Extender Per             ASQ86LL
Processor Per Use-DAY, On Off
Capacity on demand

DB2 Query Patroller

                                        Part
Part description                        number
 
DB2 Query Patroller Processor           ASQ98LL
Day OOCoD Temp Use Chrg

DB2 UDB Enterprise Server Edition

                                        Part
Part description                        number
 
DB2 UDB Enterprise Server Ed Per        ASQC8LL
Processor Per Use-DAY, On Off
Capacity on demand

DB2 UDB WorkGroup Unlimited Edition

                                        Part
Part description                        number
 
DB2 UDB WSUE Processor Day Per          ASQH2LL
Use-DAY, On Off Capacity on
demand Temporary

DB2 Universal Database Express Edition CPU Option

                                        Part
Part description                        number
 
 
DB2 UDB Expr Ed CPU Option              D53H1LL
Processor Day Per Use-DAY, On
Off Capacity on demand

IBM DB2 Warehouse Manager Standard Edition

                                        Part
Part description                        number
 
DB2 Warehouse Manager Standard          ASQD7LL
Edition Processor Day OOCoD Temp
Use Chrg

 
Back topBack to top
 
Terms and conditions

This product is only available via Passport Advantage. It is not available as shrinkwrap.

Licensing: IBM International Program License Agreement. Proofs of Entitlement (PoE) 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 Maintenance, previously referred to as Software Subscription and Technical Support.

License information form numbers

                         Program             Form
Program name             number              number
 
DB2 Warehouse Manager    5724-E66            L-SBEE-5K648T
 Standard Edition
DB2 Query Patroller      5724-E25            L-SBEE-5K64AL
DB2 Universal            5724-E49            L-SBEE-5XANLD,
 Database Express                            L-SBEE-5XANJH
 Edition
DB2 Universal            5724-B55            L-SBEE-5XANTU
 Database Personal
 Edition V8.2.0
DB2 Personal             5724-B58            N/A
 Developer's Edition
DB2 Universal            5765-F34            N/A
 Developer's Edition
DB2 Intelligent Miner    5765-F36            L-SBEE-5XANN7
 Scoring
DB2 UDB Enterprise       5765-F41            L-SBEE-5XANGM
 Server Edition
DB2 Intelligent Miner    5765-F32            L-SBEE-5XANN7
 Modeling
DB2 Net Search           5765-F38            L-SBEE-5XANS2
 Extender
DB2 UDB Workgroup        5765-F35            L-SBEE-5XANYW
 Server Edition
DB2 Intelligent Miner    5765-F33            L-SBEE-5XANN7
 Visualization
DB2 UDB Workgroup        5765-F43            L-SBEE-5XAP2J
 Server Unlimited
 Edition
DB2 Data Links           5765-F31            L-SBEE-5XANEQ
 Manager
DB2 UDB High Avail.      5724-J20            L-SBEE-622TGA
 Disaster Recovery
 V8.2.0

Limited warranty applies: Yes

Warranty: This program has warranty for a minimum of one year from acquisition from IBM or authorized IBM Business Partner. The warranty provided to the customer, for at least one year from acquisition, is access to databases (read Web sites) for program information and FAQs, including any known fixes to defects, which the customer can download or obtain otherwise and install at leisure.

Program technical support: Technical support of a program product will be available for a minimum of three 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. Customers 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, return it within 30 days from the invoice date, to the party (either IBM or its reseller) from whom you acquired it, for a refund. This applies only to your first acquisition of the program.

Copy and use on home/portable computer

                                             Copy and use on
Product                                      home/portable
name                                         computer?
 
DB2 Warehouse Manager Standard               Yes
 Edition
DB2 Query Patroller                          Yes
DB2 Universal Database Express               Yes
 
 Edition
DB2 Universal Database Personal              Yes
 Edition V8.2.0
DB2 Personal Developer's Edition             Yes
DB2 Universal Developer's                    Yes
 Edition
DB2 Intelligent Miner Scoring                Yes
DB2 UDB Enterprise Server                    Yes
 Edition
DB2 Intelligent Miner Modeling               Yes
DB2 Net Search Extender                      Yes
DB2 UDB Workgroup Server Edition             Yes
DB2 Intelligent Miner                        Yes
 Visualization
DB2 UDB Workgroup Server                     Yes
 Unlimited Edition
DB2 Data Links Manager                       Yes
DB2 UDB High Avail.  Disaster                Yes
 Recovery V8.2.0

Volume orders (IVO): No

Passport Advantage applies: Yes and through the Passport Advantage Web site at

Usage restriction: Yes

The following is a summary of the licensing terms. For information on full terms and conditions, refer to the Licensing terms included with your product, located in the "db2/license/ <language locale>" directory.

Terms and conditions for all products

If obtaining this program through another IBM program

If this program is acquired through another IBM program, then the program unique terms contained within that other IBM program take precedence.

Usage restriction — Development use

If this program is acquired through DB2 Personal Developer's Edition, then this program is licensed for installation and use by an individual user on a single machine within your Enterprise. You may only use the program for the purposes of evaluating, demonstrating, testing, and developing application programs.

If this program is acquired through DB2 Universal Developer's Edition, then the program can be installed on a shared server for use by all users with valid DB2 Universal Developer's Edition licenses. You may only use the program for the purposes of evaluating, demonstrating, testing, and developing application programs.

Program components

The program contains components that are provided to support your authorized use of the program on server machines within your Enterprise. If you want to perform multiple installations and/or distribution of these components, then you must contact IBM or its reseller to obtain the appropriate licenses. For further details, refer to the specific terms and conditions which are located in the "db2/license/ <language locale>" directory.

Definition of charges

Refer to Metrics for definitions of charges. For further details on charge metrics, refer to the specific program terms and conditions which are located in the "db2/license/ <language locale>" directory.

Terms and conditions for specific products

Note the High Availability Licensing follows this section:

IBM DB2 Universal Database Personal Edition

This program is licensed for installation and use by an individual user at one workstation. Inbound connections to this product are licensed for administration use only.

IBM DB2 Universal Database Express Edition Named User Option

This program is licensed for install on a single server. You must acquire a separate user license for each named user of the product as described below. Connections made from the Internet require the acquisition of DB2 Universal Database Express Edition CPU Option.

The following restrictions apply to the program:

  • Use of this program is restricted to servers with up to two (2) processors per server.
  • Connections made to this product through the intranet (connections from within your Enterprise) must be counted as DB2 Users.
  • This program does not permit connections from the internet (connections outside your enterprise).
  • Use of the Connection Concentrator is not permitted.
  • User connections made to this product from DB2 Universal Database Personal Edition do not require the need to purchase an additional named user license for this product.
  • Connections made from the Internet require the acquisition of DB2 Universal Database Express Edition CPU Option.
  • Maximum memory per server is 4 G.

IBM DB2 Universal Database Express Edition CPU Option

This program includes one processor entitlement with unlimited users

The following restrictions apply to the program:

  • Use of this program is restricted to servers with up to two (2) processors per server.
  • Use of the Connection Concentrator is not permitted.
  • Maximum memory per server is 4 G.

IBM DB2 Universal Database Workgroup Server Edition

This program is licensed for one (1) server install. Connections made from the Internet require the acquisition of the DB2 Workgroup Unlimited Edition product as it provides Unlimited User/Web access.

Use-based Charges — Users — Either concurrent or registered users Use-Based Charges for defined users applies to any single server installation of this product.

The following restrictions apply to the program:

  • Use of this program is restricted to servers with up to four (4) processors per server.
  • Connections made to this product through the intranet (connections from within your Enterprise) must be counted as DB2 Users.
  • Connections made from the Internet require the acquisition of DB2 Workgroup Unlimited Edition.
  • User connections made to this product from DB2 Universal Database Personal Edition need not be counted as DB2 users of this product.
  • Maximum memory per server is 16 G.

IBM DB2 Universal Database Workgroup Server Unlimited Edition

The program includes one (1) processor entitlement.

The following restrictions apply to the program:

  • Use of this program is restricted to servers with up to four (4) processors per server.
  • Maximum memory per server is 16 G.

IBM DB2 Universal Database Enterprise Server Edition

The program includes one processor entitlement.

Usage Restriction — DB2 UDB Database Partitioning Feature:

A separately chargeable database partitioning feature of DB2 UDB ESE provides the ability to create multiple database partitions on a single server or across multiple servers, while preserving a single database image of the data. An entitlement to this feature, licensed on per processor basis for every processor in the single database image across a single or multiple server configuration, must be acquired separately before operating the feature.

You are only authorized to use the database partitioning feature of the DB2 Universal Database Enterprise Server Edition (ESE) to create multiple database partitions on a single server or across multiple servers, only if you have acquired the applicable number of entitlements for the DB2 UDB ESE separately chargeable database partitioning feature.

The database partitioning feature may also be used without charge with the development use copy of ESE that is available in the DB2 Universal Developer's Edition for the purposes of evaluating, demonstrating, testing, and developing application programs.

Usage Restriction — DB2 UDB Geodetic Extender Feature:

You are authorized to use the Geodetic Extender feature of the DB2 Universal Database Enterprise Server Edition (ESE) only if you have acquired the applicable number of entitlement(s) for the DB2 Geodetic Extender feature. Entitlement to a separately chargeable Geodetic Extender feature of DB2 UDB ESE licensed on per processor basis for every processor must be acquired separately before installing or operating the feature.

The Geodetic Extender feature may also be used without charge with the development use copy of ESE that is available in the DB2 Universal Developer's Edition for the purposes of evaluating, demonstrating, testing, and developing application programs.

Usage Restriction — DB2 Connect

Use of the DB2 Connect component is limited to five (5) registered users per server. This product contains DB2 Connect component to provide connectivity, DB2 for z/OS® for OS/390®, DB2 Server for VSE and VM and DB2 for iSeries database servers. If additional users need to connect to any of the above mentioned database servers, a separate DB2 Connect program must be acquired.

DB2 Universal Database V8.2

Spatial Extender and Geodetic Extender Features

See also DB2 Universal Database Enterprise Server Edition (ESE) below for further details for the DB2 UDB Geodetic Extender Feature.

Usage Restriction — DB2 UDB Spatial Extender Feature — If you have acquired DB2 Spatial Extender component outside an 8.2 DB2 UDB program then you may not copy or distribute the components.

Usage Restriction — DB2 UDB Geodetic Extender Feature — You are authorized to use the Geodetic Extender Feature of the DB2 Universal Database Enterprise Server Edition (ESE) only if you have acquired the applicable number of entitlement(s) for the DB2 UDB Geodetic Extender Feature. It may also be used without charge with the development use copy of ESE that is available in the DB2 Universal Developer's Edition for the purposes of evaluating, demonstrating, testing, and developing application programs.

IBM DB2 Query Patroller

This program is licensed for use with:

  • DB2 Universal Database Workgroup Server Edition V8.2
  • DB2 Universal Database Workgroup Server Unlimited Edition V8.2
  • DB2 Universal Database Enterprise Server Edition V8.2

Charges for DB2 Query Patroller are based on the number of processors available to all DB2 Servers managed by DB2 Query Patroller.

This product includes one processor entitlement. Charges for DB2 Query Patroller are not based on the number of processors attached or available to DB2 Query Patroller itself.

IBM DB2 Warehouse Manager Standard Edition

This program is licensed for use with DB2 Universal Database Enterprise Server Edition V8.2. This product includes one processor entitlement.

IBM DB2 Intelligent Miner Modeling, Scoring, and Visualization

This license applies to the following three programs which are packaged together on optical disk(s) or in a software download package. The programs may be installed on the same or on different servers under the following program-unique terms:

  1. IBM DB2 Intelligent Miner Modeling: This program comes with one server install entitlement.
  2. IBM DB2 Intelligent Miner Scoring: This program comes with one processor entitlement.
  3. IBM DB2 Intelligent Miner Visualization: This program comes with one server install entitlement.

Usage Restriction — Non-purchased programs — If you have not purchased all three programs then the Usage Restriction in the Evaluation License applies for the non-purchased programs. That is, if you have purchased only programs 1 and 2 then program 3 will be licensed under the Evaluation license.

Usage Restriction — IBM DB2 UDB Data Warehouse Editions — If the programs are acquired through DB2 UDB Data Warehouse Edition then the terms and conditions of the DB2 UDB Data Warehouse Edition license shall apply.

IBM DB2 Data Links Manager

This program must be used with a licensed copy of DB2 Universal Database Enterprise Server Edition V8. The database software provided on the program Product media is provided solely for use with your licensed use of the program. One processor entitlement is included.

IBM DB2 Net Search Extender

This program is licensed for use with DB2 Universal Database Enterprise Server Edition V8.2, or DB2 Universal Database Workgroup Server Unlimited Edition V8.2. One processor entitlement is included.

If the program is acquired through DB2 Universal Database Personal Edition or DB2 Universal Database Workgroup Server Edition, then this program is licensed for installation and use as follows:

  • DB2 Universal Database Personal Edition — Use is limited to one user
  • DB2 Universal Database Workgroup Server Edition — Use is limited to five users per server install

Terms and conditions for High Availability/Failover Licensing

High Availability/Failover Licensing

  • IBM DB2 Universal Database Express Edition CPU Option
  • IBM DB2 Universal Database Workgroup Server Unlimited Edition
  • IBM DB2 Universal Database Enterprise Server Edition
  • IBM DB2 Query Patroller
  • IBM DB2 Warehouse Manager Standard Edition
  • IBM DB2 Intelligent Miner Scoring
  • IBM DB2 Data Links Manager
  • IBM DB2 Net Search Extender
  • IBM DB2 High Availability Disaster Recovery

After the server is licensed, it can be used to service user workload. In High Availability scenarios this server is called a Primary server; Additional servers acting as backups are called Standby servers that may be deployed in Active or Idle configurations.

In Active Standby or Idle Standby, you must acquire correct number of processor entitlements in addition to the processor entitlements you obtained for the primary server.

In an active standby configuration, the program is operational on all servers to service user transactions or queries. Because each of the active standby servers is used to operate the program for user transactions or queries before or after a failure, the program must be fully licensed. In Active Standby, you must license the program for the number of processors attached or available to the active standby servers. For example, consider an environment with three servers, one primary server with four processors and the other two are active standby servers with two processors each. This environment must be licensed for eight processors (4 for primary and 2 + 2 for active standby).

In an idle standby configuration, idle standby servers have the program installed, however, they do not have the program operational to service user transactions or query workloads. A server is considered "idle" if it is used exclusively for administrative actions that assist in failover scenarios such as having a database in rollforward pending state to support log shipping, or in making a flash copy of a DB2 database and then performing a database backup of this copy on another server. In Idle Standby, you must license the program for one processor per idle server only, regardless of the number of processors attached or available to the server. For example, consider an environment with three servers, one primary server with four processors and the other two are idle standby servers with two processors each. This environment must be licensed for six processors (4 for primary and 1+1 for idle standby).

High Availability/Failover Licensing

  • IBM DB2 Universal Database Express Edition Named User Option
  • IBM DB2 Universal Database Workgroup Server Edition
  • IBM DB2 Intelligent Miner Modeling
  • IBM DB2 Intelligent Miner Visualization

After the server is licensed, it can be used to service user workload. In High Availability scenarios this server is called a Primary server; Additional servers acting as backups are called Standby servers that may be deployed in Active or Idle configurations.

In Active Standby or Idle Standby, you must acquire correct number of server install entitlements and the correct number of users: in addition to the entitlements you obtained for the primary server. Note that no user entitlement are required for DB2 Intelligent Miner Modeling and DB2 Intelligent Miner Visualization only.

In an active standby configuration, the programs are operational on all servers to service user transactions or queries. Because each of the active standby servers is used to operate the programs for user transactions or queries before or after a failure, the programs must be fully licensed on both primary server and active standby servers. In Active Standby, you must license one server install per program for each active standby server and the number of users accessing the server before the failover. During the failover, the user licenses on the failed server are transferred to the active standby. For example, consider an environment with 2 servers, one primary server with 10 users and the other one an active standby server with 20 users. This environment must be licensed for 2 server installs and 30 users (10 for primary and 20 for active standby).

In an idle standby configuration, all servers have the programs installed, however, at least one of the servers does not have the programs operational to service end-user transactions or query workloads. A server is considered 'idle' if it is used exclusively for administrative actions that assist in failover scenarios such as having a database in rollforward pending state to support log shipping, or in making a flash copy of a DB2 database and then performing a database backup of this copy on another server. In Idle standby, you must license the program for one server install for each idle standby server. No additional user entitlements need to be acquired in the idle standby server. For example, consider an environment with 2 servers, one primary server with 10 users and the other one an idle standby server (with 0 active users). This environment must be licensed for 2 server installs and 10 users (10 for primary and 0 for idle standby).

For DB2 Intelligent Miner Modeling and DB2 Intelligent Miner Visualization only: In an idle standby configuration, all servers have the programs installed, however, at least one of the servers does not have the programs operational to service end-user transactions or query workloads. A server is considered "idle" if it is used exclusively for administrative actions that assist in failover scenarios such as having a database in rollforward pending state to support log shipping, or in making a flash copy of a DB2 database and then performing a database backup of this copy on another server. Therefore, you do NOT have to license the programs for an idle standby server.

HADR purchasing guidelines

The DB2 UDB Enterprise Server Edition incorporates the HADR functionality as part of the base product.

HADR is also available as a separate add-on product (DB2 HADR V8.2) for customers of DB2 UDB Workgroup Server Edition and DB2 UDB Express products. DB2 HADR V8.2 is licensed on a per-processor basis only. Customers who choose to acquire DB2 Workgroup or Express products on a per-user basis may use DB2 HADR product to support high-availability scenarios after licensing it on a per-processor basis.

The number of DB2 HADR processor licenses that should be acquired equals to number of processors on the main server plus one for the standby server. For example, if you configured two four-processor servers with HADR such that one server backs up the other one, then you should acquire a total of 4 + 1 = 5 processor licenses of DB2. Refer to the High Availability/Failover Licensing section above for more background.

Software maintenance applies: Yes

Software Maintenance, previously referred to as Software Subscription and Technical Support, is included in the Passport Advantage Agreement. Installation and technical support is provided by the Software Maintenance offering of the IBM International Passport Advantage Agreement. This fee service enhances customer productivity, with voice and electronic access into IBM support organizations.

IBM includes one year of Software Maintenance with the initial license acquisition of each program acquired. The initial period of Software Maintenance can be extended by the purchase of a renewal option that is available.

While your 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, only to your information systems (IS) technical support personnel during the normal business hours (published prime shift hours) of your IBM support center. (This assistance is not available to your end users.) IBM provides Severity 1 assistance 24 hours a day, every day of the year. For additional details, consult your IBM Software Support Guide at

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 this agreement.

For more information about the Passport Advantage Agreement, refer to the IBM International Passport Advantage Agreement Software Announcement 201-202 , dated July 10, 2001. or visit the Passport Advantage Web site at

Complimentary products: IBM provides licensed copies of complimentary products in our product boxes. The complimentary products are not upgradeable through the originally ordered product. They are only upgradeable separately as individual products. If a fully licensed product is required, contact IBM or your reseller.

iSeries software subscription applies: No

Educational allowance available: Not applicable.

On/Off Capacity on Demand

To be eligible for On/Off Capacity on Demand 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 topBack to top
 

IBM Electronic Services

IBM Global Services has transformed its delivery of hardware and software support services to put you on the road to higher systems availability. IBM Electronic Services is a Web-enabled solution that provides you with an exclusive, no-additional-charge enhancement to the service and support on the IBM eServer. You should benefit from greater system availability due to faster problem resolution and preemptive monitoring. IBM Electronic Services is comprised of two separate but complementary elements: IBM Electronic Services news page and IBM Electronic Service Agent™.

IBM Electronic Services news page provides you with a single Internet entry point that replaces the multiple entry points traditionally used by customers to access IBM Internet services and support. By using the news page, it enables you to gain easier access to IBM resources for assistance in resolving technical problems.

The IBM Electronic Service Agent is no-additional charge software that resides on your IBM eServer system. It is designed to proactively monitor events and transmit system inventory information to IBM on a periodic customer-defined timetable. The IBM Electronic Service Agent tracks system inventory, hardware error logs, and performance information. If the server is under a current IBM maintenance service agreement or within the IBM warranty period, the Service Agent automatically reports hardware problems to IBM. Early knowledge about potential problems enables IBM to provide proactive service that maintains higher system availability and performance. In addition, information collected through the Service Agent will be made available to IBM service support representatives when they are helping answer your questions or diagnosing problems.

To learn how IBM Electronic Services can work for you, visit


 
Back topBack to top
 
Prices

Passport Advantage

For Passport Advantage information and charges, contact your IBM representative or authorized IBM Business Partner. Additional information is also available at

To order, contact the Americas Call Centers, your local IBM representative, or your IBM Business Partner.

To identify your local IBM Business Partner or IBM representative, call 800-IBM-4YOU (426-4968).

Global Financing

IBM Global Financing offers competitive financing to credit-qualified customers to assist them in acquiring IT solutions. Offerings include financing for IT acquisition, including hardware, software, and services, both from IBM and other manufacturers or vendors. Offerings (for all customer segments: small, medium, and large enterprise), rates, terms, and availability can vary by country. Contact your local IBM Global Financing organization or visit

IBM Global Financing offerings are provided through IBM Credit LLC in the United States and other IBM subsidiaries and divisions worldwide to qualified commercial and government customers. Rates are based on a customer's credit rating, financing terms, offering type, equipment type, and options, and may vary by country. Other restrictions may apply. Rates and offerings are subject to change, extension, or withdrawal without notice.
 
Back topBack to top
 

Order now

To order, contact the Americas Call Centers, your local IBM representative, or your IBM Business Partner.

To identify your local IBM representative or IBM Business Partner, call 800-IBM-4YOU (426-4968).

 Phone:     800-IBM-CALL (426-2255)
 Fax:       800-2IBM-FAX (242-6329)
 Internet:  ibm_direct@vnet.ibm.com
 Mail:      IBM Americas Call Centers
            Dept:  IBM CALL, 11th Floor
            105 Moatfield Drive
            North York, Ontario
            Canada M3B 3R1
 
 Reference: VE001

The Americas Call Centers, our national direct marketing organization, can add your name to the mailing list for catalogs of IBM products.

Note: Shipments will begin after the planned availability date.

Trademarks

 
Intelligent Miner, iSeries, QMF, Everyplace, DATABASE 2, and Electronic Service Agent are trademarks of International Business Machines Corporation in the United States or other countries or both.
 
DB2, Passport Advantage, S/390, Multiprise, zSeries, the e-business logo AIX, DB2 Universal Database, pSeries, WebSphere, MQSeries, DB2 Connect, IntelliStation, OS/390, and z/OS are registered trademarks of International Business Machines Corporation in the United States or other countries or both.
 
Intel and Pentium are trademarks of Intel Corporation.
 
Windows, Microsoft, and Windows NT are trademarks of Microsoft Corporation.
 
Java is a trademark of Sun Microsystems, Inc.
 
UNIX is a registered trademark of the Open Company in the United States and other countries.
 
Linux is a trademark of Linus Torvalds in the United States, other countries or both
 
Other company, product, and service names may be trademarks or service marks of others.

Back to topBack to top
 

 
Printable version Printable version