IBM DB2 Universal Database V8.1 for Linux, UNIX, and Windows Delivers Enhanced Scalability, Manageability, Performance, and Availability for e-business Deployment

IBM United States Software Announcement 202-214
September 17, 2002

ENUS202-214.PDF (280KB)

Document options

At a glance	Education support
Overview	Offering Information
Key prerequisites	Publications
Planned Availability Dates	Technical information
Description	Ordering information
Product positioning	Terms and conditions
Statement of Direction	Prices
Reference Information	Order now
Additional Information

Printable version

(Corrected on May 4, 2004)

Changed phone number for SHOPIBM in Publications section.

(Corrected on July 1, 2003)

In the License Limitations section, deleted fourth bullet regarding Internet connections. Also deleted third sentence in subsequent paragraph that states "Workgroup Server Unlimited Edition and DB2 Connect Enterprise Edition are not allowed to be installed on the same machine."

(Corrected on June 18, 2003)

References to Kerberos were removed from the announcement.

(Corrected on March 20, 2003)

Replaced text under Tivoli Integration heading in Supplemental Information section.

(Corrected on September 18, 2002)

Added three charts and accompanying text to the Software Requirements section.

At a glance

DB2 V8.1 offers:

Innovative Manageability
- Configuration Advisor
- Health Center
- Memory Visualizer
- Advisors to deliver expert advice on indexes
- Simplified management of large scale partitioned databases
Information Integration Foundation
- Support for both consumer and provider of Web services
- Store, compose, validate, decompose, and manipulate XML data
- DB2 and Informix™ Dynamic Server federation and replication
e-business Foundation
- Connection Concentrator for more user scalability
- Dynamic configuration
- In-place online reorg
- Online load
- Online storage management
- Null and default compression
- Replication enhancements
- New client architecture
Business Intelligence
- Multidimensional data clustering
- Real-time and bulk scoring of data
Application Development Productivity
- Development Center
- WebSphere integration
- Microsoft integration

For ordering, contact:

Your IBM representative, an IBM Business Partner, or IBM Americas Call Centers at 800-IBM-CALL (Reference: YE001).

Back to top

Overview

IBM DB2^® V8 for Linux, UNIX^®, and Windows^® marks the next stage in the evolution of the relational database. DB2 is the database of choice for the development and deployment of critical solutions such as:

e-business
Business intelligence
Content management
Enterprise Resource Planning
Customer Relationship Management

Highlights of this release include:

Innovative Manageability
- Configuration Advisor puts the knowledge of a seasoned DBA at your fingertips
- Health Center/Monitor keeps your database functioning
- Memory Visualizer let's you dynamically see and control DB2's memory usage
- Advisors to deliver expert advice on index and materialized query tables (MQTs)
- Simplified management of large-scale partitioned databases
New Levels of Integrated Information
- Federated Web Services allows combination of data from Web service providers
- XML Productivity Tools simplify integrating XML
Robust e-business Foundation
- Connection Concentrator for more user scalability
- Dynamic configuration
- In-place online reorganization
- Online load
- Online storage management
- Null and default compression
- Replication enhancements
- New client architecture
Integrated Business Intelligence
- Multidimensional data clustering improves performance of complex queries
- Real-time and bulk scoring of data
Enhanced Application Development Productivity
- Development Center
- WebSphere^® integration
- Microsoft™ integration

Key prerequisites

Refer to the Hardware Requirements and Software Requirements sections.

Back to top

Planned Availability Dates

November 21, 2002, for Build to Plan (BTP) Electronic Software Delivery.
December 27, 2002, for BTP Physical Delivery.
January 17, 2003, for Build to Order (BTO) Physical Delivery, except for DB2 Intelligent Miner™ Scoring, Modeling, and Visualization, which will be available on September 27, 2002, for BTP Electronic and Physical Delivery, and October 18, 2002, for BTO Physical Delivery.
e-CONFIG will be enabled on September 24, 2002. No orders can be received before that date.

Description

Manageability

DB2 greatly reduces the complexity of data management by eliminating, simplifying, and automating many tasks traditionally associated with maintaining an enterprise-class database. Some of these advances are the first implementation of the Self-Managing and Resource Tuning (SMART) project and the first steps towards making full autonomic computing a reality for database implementations.

Health Monitoring: DB2 helps you monitor the health of your DB2 systems, the Health Monitor and the Health Center. These tools alert you to potential system health issues and provide advice about resolving them.

Enhancements to the LOAD Utility and the Load Wizard: A single simplified online load utility simplifies the process of loading data into both single-partition and multi-partition database environments.

MQT Delta Refresh After Load: MQTs, previously known as ASTs, can be incrementally refreshed after a load append operation.

Performance and Scalability Enhancements

Connection Concentrator: Reduces memory consumption on the database server by allowing transactions from remote clients to be concentrated or multiplexed across a small number of persistent database connections.

Other Performance and Scalability Enhancements

Improved performance of databases with multiple partitions
Multidimensional data clustering
Prefetching enhancement
Faster page cleaners
User-maintained MQTs (or ASTs)
Support for 64-bit Windows and 64-bit Linux
New streamlined application drivers (ODBC, OLE DB, JDBC, and SQLj) and new client architecture
InfiniBand support
DB2 is the first database to support InfiniBand fabric connectivity for high-speed interconnections. DB2 V8 includes improved support for the InfiniBand architecture to deploy partitioned databases on multiple servers while offering greater scalability and better performance.

For additional details, refer to the Performance and Scalability Enhancements section in the Additional Information section.

Availability Enhancements

Online Table Reorganization Utility: DB2 V8 supports online table reorganization that allows full access to the table being reorganized.

The offline reorganization utility will allow read-only applications to access the original copy of the table except during the last phases of the reorganization process. Both online and offline reorganizations have also been enhanced to improve support for partitioned databases.

Availability enhancements offered in V8 are:

Online index reorganization utility
Online configuration parameters
Online buffer pool operations
Online load
Enhanced table space container operations

For additional details, refer to the Availability Enhancements section in the Additional Information section.

Application Development

DB2 Personal Developer's Edition V8 and DB2 Universal Developer's Edition V8 offer an extensive toolkit for building DB2 applications. These application development (AD) tools focus on maximizing programmer productivity by providing support for major application frameworks popular with both Java™ and Microsoft application programmers. V8 of DB2 products delivers significant enhancements that simplify application development. The enhancements are offered in the following areas:

SQL language enhancements
Enhanced drivers for applications written to ADO, ODBC, OLE DB, DB2 CLI, JDBC, and SQLJ programming interfaces
Enhanced support for XML
Industry-leading Web Services support
New Development Center
New plug-ins for WebSphere Studio integrated development environment
New add-ins for Microsoft VisualStudio development products (VisualBasic, Visual C++, and InterDev)

For additional details, refer to the Application Development section in the Additional Information section.

Business Intelligence

DB2 Warehouse Manager: Data warehousing is the foundation for business intelligence (BI) and Customer Relationship Management.

DB2 Warehouse Manager provides an infrastructure that helps you build, manage, and access the data warehouses that form the backbone of your BI solution. You can then integrate other BI tools and applications with this framework to ensure you get the timely information needed to make your business decisions.

DB2 Warehouse Manager V8 Enhancements

DB2 integration and exploitation
Extended platform support
Information Catalog Manager enhancements
Warehouse Server support for AIX^®
Linux Agent support
Improved population performance.
Information Catalog Manager (ICM) has been rearchitected to provide an extendable metadata store
Desktop and Web interface for the Information Catalog

For additional details, refer to the Business Intelligence section in the Additional Information section.

DB2 Intelligent Miner Products: Specific application enablement requirements addressed by the new DB2 Intelligent Miner V8 offerings include:

Support the deployment of data mining models to score bulk data.
Support the deployment of data mining models to score individual case in customer time, as often is required by real-time recommendation engines.
A programmable interface to DB2 Intelligent Miner modeling, scoring, and visualization technologies to embed analytics inline with the operational application processing.
Support interoperability by supporting industry standards for program interfaces and analytic models.

For additional details, refer to the DB2 Intelligent Miner Scoring, DB2 Intelligent Miner Modeling, and DB2 Intelligent Miner Visualization sections in the Additional Information section.

DB2 OLAP Server™ and DB2 Warehouse Manager Sourcing Agent for z/OS™: Information can be found in the Additional Information section.

Integrated Information

DB2 provides a strong foundation of information integration technologies, including federation, replication, Web services, and XML. With DB2's built-in capabilities, you can query, update, and replicate data across DB2 and IDS data sources. The DB2 Relational Connect V7.2 and DB2 Life Sciences Data Connect V7.2 features provide federated access to heterogeneous data sources. These features will not be offered directly with DB2 V8, but will be reintroduced in a subsequent announcement. In the interim, customers using either feature should remain on DB2 UDB V7.2 until IBM announces an upgrade path.

Enriched Data Type Support: DB2 provides rich type support for spatial data, text data, and flat files, via DB2 Spatial Extender, DB2 Net Search Extender, and DB2 Data Links Manager respectively.

DB2 Spatial Extender V8 — helps you to analyze spatial data, and will be offered on Solaris, HP-UX, and Linux for S/390^®; and 64-bit for all platforms.
DB2 Net Search Extender V8 — has merged the in-memory search capability with the text search capabilities of V7 Text Information Extender, for applications with high-performance and scalability text-search demands.
DB2 Data Links Manager — smart content management blocks simplify and reduce system administration costs and complexities, by providing a single coordinated administration point for file and database data.

For additional details, refer to the Integrated Information section in the Additional Information section.

Linux Enhancements

Platform Support: In addition to being available on 32-bit Intel^®-compatible platforms and zSeries™ platforms, DB2 on Linux V8 will be able to exploit the 64-bit architecture of Itanium Processor Family of chips from Intel. Refer to Statement of Direction for IBM's intentions to release DB2 on iSeries™ and pSeries™ platforms.

For information on the Linux Validation Program and InfiniBand Support, refer to the Additional Information section.

Other Enhancements with DB2 V8 on Linux

Larger Bufferpools
Auto-configuration of Kernel Parameters
zSeries Enhancements
Infinite logging

For additional details, refer to the Linux Enhancements section in the Additional Information section.

Section 508 of the U.S. Rehabilitation Act

The following products are capable as of November 21, 2002, 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.

DB2 Universal Database^® Personal Edition (PE) (5724-B55)
DB2 Personal Developer's Edition (PDE) (5724-B58)
DB2 Data Links Manager (DLM) (5765-F31)
DB2 Net Search Extender (NSE) (5765-F38)
DB2 Spatial Extender (SE) (5765-F40)
DB2 Intelligent Miner Scoring (IMSC) (5765-F36)
DB2 Intelligent Miner Modeling (IMMO) (5765-F32)
DB2 Intelligent Miner Visualization (IMVI) (5765-F33)

The following products are capable, when used in accordance with IBM's associated documentation, of satisfying the applicable requirements of Section 508 of the Rehabilitation Act upon installation of Fixpack 1, provided that any assistive technology used with the product properly interoperates with it. Fixpack 1 is expected to be available in January 2003.

DB2 Universal Database Workgroup Server Edition (WSE) (5765-F35)
DB2 Universal Database Workgroup Server Unlimited Edition (WSUE) (5765-F43)
DB2 Universal Database Enterprise Server Edition (ESE) (5765-F41)
DB2 Universal Developer's Edition (UDE) (5765-F34)

Product positioning

DB2 Enterprise Server Edition (ESE): ESE meets the database server needs of midsize to large businesses. It can be deployed in Linux, UNIX, and Windows server environments on any size server. ESE is the ideal foundation for building data warehouses, transaction processing, or Web-based solutions as well as a backend for packaged solutions like ERP, CRM, and SCM. Additionally, ESE offers connectivity and integration for other enterprise DB2 and Informix data sources.

DB2 Database Partitioning Feature: The Database Partitioning Feature allows ESE customers to partition a database within a single system or across a cluster of systems. The DPF capability provides the customer with multiple benefits including scalability to support very large databases or complex workloads and increased parallelism for administration tasks.

DB2 Workgroup Server Edition (WSE): WSE is the database server designed for deployment in a departmental or small business environment that involves a small number of internal users. WSE uses a licensing model designed to provide an attractive price point for smaller installations while still providing a full function database server. WSE can be deployed in Linux, UNIX, and Windows server environments on systems with up to four CPUs.

DB2 Workgroup Server Unlimited Edition (WSUE): This product offers a simplified per processor licensing model for deployment in a departmental or small business environment that has Internet users or number of users that makes per processor licensing more attractive than the WSE licensing model. The WSUE can be deployed in Linux, UNIX, and Windows environments on systems with up to four CPUs.

DB2 Personal Edition (PE): PE provides a single user database engine ideal for deployment to PC-based users. PE can be remotely managed, making it the perfect choice for deployment in occasionally connected or remote office implementations that don't require multi-user capability.

DB2 Universal Developer's Edition (UDE): UDE offers a low-cost package for a single application developer to design, build, or prototype applications for deployment of any of the DB2 client or server platforms. It includes all client and server DB2 editions, DB2 Connect^®, DB2 Extenders^®, Warehouse Manager, and Intelligent Miner. The software in this package cannot be used for production systems.

DB2 Personal Developer's Edition (PDE): PDE enables a developer to design and build single user desktop applications. This offering includes Windows and Linux versions of the DB2 PE products as well as the DB2 Extenders.

DB2 Warehouse Manager: This product extends the scalability, manageability, and accessibility of DB2 data warehouses and data marts built using the Data Warehouse Center. It provides an integrated and flexible set of tools for key steps of designing, populating, and managing data warehouses.

DB2 Intelligent Miner Products: These products provide the analysis capabilities needed to make insightful business decisions.

DB2 Spatial Extender: This product enables users to leverage the power of the Relational Database model for managing their location-based data just as easily as traditional business data, and use industry-standard SQL for spatial data analysis, which can add competitive advantages to existing and new applications.

The DB2 Spatial Extender is available free of charge in the DB2 PE and DB2 WSE for up to five users. It is also available as a separate program for DB2 UDB WSUE and DB2 UDB ESE.

DB2 Net Search Extender: This product enables a solution to include a powerful in-memory search capability for text-based data. The integration of these 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 searching demanded by e-commerce applications.

The DB2 Net Search Extender is available free of charge in the DB2 PE and DB2 WSE for up to five users. It is also available as a separate program for DB2 UDB WSUE and DB2 UDB ESE.

Back to top

Statement of Direction

IBM is restructuring and enhancing its offerings to further focus on integrating diverse and distributed information. Some of these information integration activities are currently showcased at IBM's demo Web site at:

http://xperanto.dfw.ibm.com/demo/

In particular, IBM is restructuring the federated features previously available as DB2 Relational Connect V7.2 and DB2 Life Sciences Data Connect V7.2. These features will not be offered directly with DB2 V8, but will be reintroduced in a subsequent announcement.

Customers accessing federated data sources using DB2 Relational Connect V7.2, DB2 Life Sciences Data Connect V7.2, or using this functionality in DB2 Universal Developers Edition V7.2 or DB2 for e-business CEO Bundle should wait until this new functionality is available before upgrading to DB2 Universal Database V8.1. Details will be announced later.

IBM plans to release DB2 Query Patroller V8 that will work with DB2 Universal Database V8. DB2 Query Patroller V8 will deliver enhanced function to manage and control all aspects of query submission and execution. Some of the enhancements will include the ability to intercept SQL from more sources, better SQL statement costing, more options on result set storage; and easier installation, configuration and administration.

IBM intends to release DB2 Universal Database on Linux for the iSeries and pSeries platforms. Customers will be able to benefit from the advanced function delivered in DB2 Universal Database V8, and will have more Linux platform choices for DB2-based solutions. You can exploit the iSeries' advanced logical partitioning technology to consolidate database workloads. With Linux for pSeries, you can exploit the industry-leading architecture, performance, and scalability of IBM's POWER processors to deliver robust solutions.

All statements regarding IBM's plans, directions, and intent are subject to change or withdrawal without notice.

Back to top

Reference Information

Software Announcement 202-215 , dated September 17, 2002 (DB2 Connect V8.1)
Software Announcement 202-045 , dated February 26, 2002 (DB2 QMF™ for Windows V7.2)
Software Announcement 202-199 , dated August 27, 2002 (DB2 Everyplace™ V8.1)
Software Announcement 201-326 , dated November 13, 2001 DB2 Server for VSE and VM V7.2
Software Announcement 202-172 , dated July 19, 2002 (DB2 OLAP Server V8.1)
Software Announcement 202-102 , dated April 30, 2002 (DB2 Distributed Tools)
- DB2 High Performance Unload for Multiplatforms V2.1
- DB2 Recovery Expert for Multiplatforms V1.1
- DB2 Performance Expert for Multiplatforms V1.1
- DB2 Table Editor for Multiplatforms V4.3
- DB2 Web Query Tool for Multiplatforms V1.3
Software Announcement 202-216 , dated September 17, 2002 (DB2 Warehouse Manager for z/OS V8.1)
Software Announcement 202-213 , dated September 17, 2002 (DB2 Intelligent Miner for Data V8.1)

Trademarks

: Intelligent Miner, Informix, z/OS, DB2 OLAP Server, the e-business logo, zSeries, iSeries, pSeries, QMF, and Everyplace are trademarks of International Business Machines Corporation in the United States or other countries or both.
: DB2, WebSphere, AIX, S/390, DB2 Universal Database, 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 registered trademark of Intel Corporation.
: Microsoft is a trademark of Microsoft Corporation.
: Windows and Windows NT are registered 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.
: Other company, product, and service names may be trademarks or service marks of others.

Additional Information

Manageability

Health Monitoring Tools: The Health Monitor is a server-side tool that constantly monitors the health of the instance without user interaction. If the Health Monitor finds that a defined threshold has been exceeded, or it detects an abnormal state for an object, the Health Monitor will raise an alert. The Health Center provides a graphical interface to the Health Monitor. It is used to configure the Health Monitor, and to see the alert state of your instances and database objects. Using the Health Monitor's drill-down capability, you can access details about current alerts and obtain a list of recommended actions describing how to resolve the alert. It provides a mechanism to execute some of these recommendations immediately.

Web Health Center: DB2^® V8 also provides a new Web Health Center that can be used to access the Health Monitor information from a Web browser or PDA, allowing you to execute new DB2 commands. The Memory Visualizer tool helps you to uncover and fix memory-related problems on a DB2 instance. It uses visual displays and plotted graphs to help you understand memory components and their relationships to one another. You can invoke it from a Health Center recommendation, or use it on its own as a monitoring tool.

Enhancements to the LOAD Utility and the Load Wizard: Load operations now take place at the table level. Concurrent access to other table objects in the same table space is possible during a load operation, while allowing read access to the table being loaded.

A new locking option is introduced in this release that forces applications to release the locks they have on a particular table, allowing the load operation to proceed. In addition, the load utility itself now has a graphical progress monitor to easily monitor progress.

There are many diverse configuration options that can affect a load. The Load Wizard groups the options into affected areas such as performance, recoverability, and diagnostics. It then asks questions about each option to help guide the decision-making process to get the most effective result. The wizard also offers advice about how the various options affect the rest of the system and provides space and time estimates. Whether you wish to load data into a single partition, or a large number of partitions across a number of machines, the Load Wizard provides the assistance and direction you need as a database administrator to get the job done right, and in a timely manner.

Improvements to Statistics Collection

New options for usability (ON ALL COLUMNS, ON KEY COLUMNS, ability to specify individual index names)
New statistics for LIKE predicate processing
Ability to specify distribution statistics limits at the table and column level
Ability to perform sampling for detailed index statistics to improve performance
Ability to gather statistics during index creation

Online Inspect and Improved Trace Performance: DB2 V8 enhances the customer's ability to examine and diagnose error conditions by delivering a much improved trace facility with greatly improved performance and an online Database Analysis and Recovery Tool (DB2DART). The new trace facility provides very low overhead, high-performance operation that allows customers to have tracing activated in the most demanding production environments. The ability to have trace active in production without adverse effects on operation allows customers to more easily diagnose error conditions without having to engage in off-line problem determination. The online DART tool allows database administrators to verify the integrity of DB2 data on disk without taking the database off-line.

Other manageability enhancements are:

Backup and recovery enhancements
Enhanced monitoring
Tivoli^® integration

For additional details, refer to the Manageability section in the Additional Information section.

Information Management System (IMS™) Control Center: IBM provides an IMS Control Center capability as an alternative GUI for the new IMS V8 Operations Manager through IMS Connect, greatly easing IMS operations. The IMS Control Center capability will be integrated with the DB2 UDB V8 administration tools in the near future. A single user interface lets you control both IMS and DB2. The administration tools include a Control Center for navigating IMS Sysplex systems, wizards for creating the new IMS V8 Operations Manager commands, and a results window for sorting and filtering single-system image command results. The tools also include a Command Center for typing and executing both the new commands and the old operations commands.

IMS Connect is being enhanced to allow the DB2 Control Center to communicate with the IMS V8 Operations Manager. Additional IMS Connect service stream enhancements include J2EE Connect or Architecture two-phase commit support, ipv6 support, and enhanced security.

Load from Cursor (Cross-Loader): DB2 V8 LOAD command has been enhanced to allow loading from a cursor. This new option can be used to provide high-speed transfer of data from any data source that can be queried with a SELECT statement. For example, data can be loaded into DB2 from a SELECT statement issued against a DB2 for OS/390^® table (via DB2 Connect^®). By utilizing federated database feature DB2 and full power of SQL, data can loaded from multiple heterogeneous remote databases and data sources. For example DB2 table can be loaded from a join of an Informix™ Dynamic Server table and data delivered through an MQ message. An additional benefit of loading from a cursor is the ability to complete load operation in a single step without a need for cumbersome export and file transfer steps.

MQT Delta Refresh After Load: DB2 has enhanced the support for Materialized Query Tables (MQTs, previously known as ASTs) to enable them to be incrementally refreshed after a load append operation. The MQT will be available during the load operation and once the load operation completes, the data that was appended to the table can be incrementally added to the MQT.

AUTOCONFIGURE Command: DB2 V8 introduces a new command that recommends and optionally applies new values for buffer pool sizes, database configuration, and database manager configuration. This command provides initial tuning for a database, to which additional tuning can be applied. AUTOCONFIGURE can also be used with the CREATE DATABASE command to configure databases as soon as they are created.

New Storage Management Tool: A Storage Management tool is now part of the GUI Control Center. From this tool you can access the Storage Management view that displays a snapshot of the storage for a particular database, database partition group, or table space. This tool can periodically capture and display statistical information on a variety of storage objects.

Use the information displayed in this view to monitor and set thresholds for various aspects of your storage, such as space usage for table spaces, data skew in database partitions, and index cluster ratio. A warning or alarm flag will let you know if a target object exceeds a specified threshold.

Logging Enhancements: In V8, dual logging is provided on all platforms supported by DB2 UDB. The maximum amount of log space that can be defined has increased from 32 GB to 256 GB. This provides support for more concurrent transactions and transactions that do more work.

DB2 V8 allows an active unit of work to span both active and archive logs. A single transaction can access a number of log files limited only by the total physical storage available across your primary and archive systems. This support for "infinite active logs" can be used to support environments with large jobs that require more log space than you would normally allocate to the primary logs.

The "block on log disk full" capability allows you to specify that DB2 should not terminate when the log disk runs out of storage. When you enable this option, DB2 will retry every five minutes allowing you to resolve the disk full situation followed by resumption of normal operation.

Backup and Recovery Enhancements: DB2 UDB V8 includes several backup and recovery enhancements.

During the recovery of a table space, only the log files required to recover the table space are processed. Log files that are not required are skipped, thus improving recovery time.
The backup utility now supports backup solutions from storage vendors that have implemented the XBSA industry-standard interface.
A database created on a system with one code page can be backed up and then recovered to a system with a different code page.
When using point in time (PIT) rollforward recovery, you can now specify the time as local time instead of Greenwich Mean Time (GMT). Rolling forward to a specific point in time is easier, and it eliminates potential errors due to the translation of local to GMT time.

Diagnostics and Serviceability Improvements: DB2 V8 places diagnostics information in two distinct log files, depending on its intended use and target audience.

When significant events occur that may require DBA intervention, DB2 writes information to the administration notification log.

Diagnostic information about database operation errors are recorded in the diagnostic db2diag.log file. This information is used for problem determination and is intended for DB2 customer support.

Support for Multiple Fixpacks on a Single System: DB2 V8 will support multiple service (Fixpack) levels simultaneously on the same system. This support is only available with DB2 UDB Enterprise Server Edition on UNIX platforms.

Support for multiple service levels allows the testing of a new service level while an older service level continues to support a production environment. Once testing is complete, the production environment can be switched to the new service level. Different applications that have been certified with different DB2 service levels can now be hosted on a single server.

Version Identifier for Packages: DB2 V8 provides the ability to support multiple versions of the same package (database object associated with each application) in a single system. This option allows:

Multiple packages that share both the schema and package identification to coexist in the DB2 system catalogs
Introduction and testing of a new version of an application on the system without affecting users of the existing version of the application

Database Maintenance Mode: In quiesced mode, the DBA can control who can access the database and limit database activities to only those authorized users.

Enhanced Monitoring: Event monitors can now write data to SQL tables in addition to files or pipes. This provides the following benefits:

Storing the data in an SQL table means you can define exactly which data elements you need to keep while discarding the rest. Storing the data in an SQL table makes it easy to prune the data using timestamps or other relational criteria.
With event monitor data located in tables, users can now query and aggregate data easily using SQL operations.
Event monitors that write to tables can capture data on any or all database partitions. By inserting into the same table on each database partition, DB2 delivers global event monitoring across the whole database.

Snapshot monitoring can now be done using SELECT statements against a set of new table functions shipped with DB2 V8. Taking snapshots using SQL enables you to retrieve system status data without having to write an application that invokes the DB2 API interface. You can now use all of the power of SQL to filter the data and correlate the different types of snapshot information.

Enhancements to the deadlock event monitor assist the DBA in determining why deadlocks occur. The deadlock event monitor now provides more information than it did in previous releases by identifying which statements are involved in the deadlock, and by pinpointing which locks are held by each application involved in the deadlock.

Tivoli Integration: Advanced database manageability is achieved through IBM Tivoli Monitoring for Databases. The ITM for Databases product uses the new advanced edition Distributed Monitoring product (called IBM Tivoli Monitoring or ITM) and provides significant enhancement in monitoring capability based on the use of this new monitoring engine. ITM for Databases provides DB2 support through a Proactive Analysis Component (PAC). This PAC is tightly integrated with DB2 and provides an out-of-the-box set of monitors for quick deployment and activation.

Performance and Scalability Enhancements

Connection Concentrator: The DB2 concentrator is beneficial in a transactional workload environment where each transaction is of relatively short duration and there is no requirement to use an external transaction manager such as Encina^® or Microsoft™ Transaction Server (MTS).

Improved Performance of Databases with Multiple Partitions: DB2 V8 supports caching of system catalog and authorization data at each partition of a partitioned database.

These caching enhancements will improve the performance of workloads that perform a great number of dynamic SQL or consist of a large number of database connections that are short in duration, which is typical of some transactional workloads.

Improved Performance of DB2 Routines: DB2 V8 routines (stored procedures, user-defined functions, and methods) written in Java™ language are implemented using a thread-based model that results in a dramatic performance increase when many routines are running at the same time. DB2 routines that are defined as thread-safe will be executed inside a single DB2 task, which will reduce the amount of context switching for users that run large numbers of fenced mode routines. There is one task for all Java routines and one task for all non-Java routines.

Multidimensional Data Clustering: DB2 V8 marks the introduction of multidimensional clustering (MDC) technology, which is an innovative method for flexible, continuous, and automatic organization and storage of data along multiple dimensions instead of the more common data clustering in a single dimension.

Using MDC to organize a table along multiple dimensions such as year and region can result in significant improvement in query performance. Using MDC can also significantly reduce the overhead of data maintenance operations, such as reorganization, and index maintenance during insert, update, and delete operations.

Prefetching Enhancement: In DB2 V8 the performance of data prefetching can be improved by creating block-based buffer pools. This facility enables a single block I/O operation to read multiple pages from disk into contiguous pages of a DB2 buffer pool, which leads to better performance.

Faster Page Cleaners: DB2 V8 exploits asynchronous I/O facilities to improve I/O performance. This can significantly improve the performance of DB2 page cleaning tasks, which flush modified buffer pool pages to disk.

User-Maintained MQTs: Many warehouses have custom applications that maintain and load tables that are, in reality, pre-computed data that represents the result of a query. Designating a table as an MQT (formerly ASTs, automatic summary tables) can improve dynamic query performance without requiring users to modify the table.

With DB2 V8, an MQT (an AST whose capabilities have been enhanced for V8) can remain available during a load append operation on the underlying table.

After the load of the underlying table is complete, the MQT may be refreshed incrementally using only the appended data, which significantly reduces the refresh time. This improves the availability of MQTs to your users.

Type-2 Indexes: DB2 V8 adds support for type-2 indexes. This provides improved concurrency, and the ability to invoke online reorganization and online load utilities. They are required for the new multidimensional clustering facility.

Support for 64-bit Windows and 64-bit Linux: DB2 Universal Database^® will take the next leap in performance and scalability on 64-bit Windows and 64-bit Linux platforms by exploiting systems built around the 64-bit IPF processors from Intel^®. Systems built around Itanium and Itanium 2 processors will also be supported.

In addition, DB2 V8 for Windows exploits the features of Intel Xeon MP processors by taking advantage of the new hyper-threading feature developed by Intel.

Replication Enhancements: DB2 V8 Replication features improved usability, reliability, performance, serviceability, and security.

The new DB2 Replication Center is a user interface tool that you can use to set up and administer your replication environment. It supports administration for DB2-to-DB2 replication environments, and administration for replication between DB2 and non-DB2 relational databases. Part of the DB2 Control Center set of tools, the Replication Center includes all of the replication functionality previously available from the DB2 Control Center and the DB2 DataJoiner^® Replication Administration (DJRA) tool.

Use the Replication Center to:

Define defaults in profiles for creating control tables, source objects, and target objects
Create replication control tables
Register replication sources
Create subscription sets and add subscription-set members to subscription sets
Operate the capture program
Operate the apply program
Monitor the replication process

The Replication Center also includes a launchpad that allows you to perform the basic functions needed to set up a DB2 replication environment. The launchpad also shows you graphically how the different steps are related to one another.

Basic replication performance has improved with JOINs eliminated in many situations, multithreaded capture, and faster full refreshes of target tables by exploiting DB2 LOAD improvements.

Availability Enhancements

Online Load Index Reorganization Utility: New in DB2 V8 is the ability to read and update a table and its existing indexes during an index reorganization using the REORG INDEXES command.

Online Load Utility: With DB2 V8, you now have read access to the existing portion of a table during a load append operation.
Online Reorganization Utility: DB2 V8 enhances database availability by allowing you to reorganize tables while permitting read and write online table access.

Online Configuration Parameters: DB2 V8 improves availability characteristics with the capability to modify key database and database manager configuration parameters online so that they take immediate effect. This gives you more flexibility for deciding when to change the configuration to better suit current workload characteristics.

In some cases you can set a parameter to be automatic, which allows DB2 to adjust the parameter's value without user intervention as workload on the system changes.

Online Buffer Pool Operations: Efficient memory management is one of the key aspects of performance tuning. In DB2 V8, you can change how DB2 uses memory without stopping database activity. You can also add, drop, and change the size of a buffer pool without stopping database activity.

Enhanced Table Space Container Operations: Table spaces that use Database-Managed Storage mechanism (DMS table spaces) support new operations that allow you to drop a container from a table space, reduce the size of existing containers, and add new containers to a table space without rebalancing. These operations allow greater flexibility in managing physical storage, such as ability to reclaim over-allocated space.

All of these operations can be accomplished online with full access to the table space.

INSERT through UNION ALL Views: The SQL INSERT statement is now supported for views that use a UNION ALL construction. This augments the UPDATE and DELETE capabilities provided in previous releases.

Definition of a UNION ALL view over separate tables can be useful in an HSM environment where the view may range over a number of tables with some tables being stored by HSM on tertiary storage while other tables are stored on disk.

The UNION ALL technique can also be used to deliver improved database scalability by allowing complete SQL functionality through a view, while at the same time maintaining database manageability through granular maintenance of individual tables.

Application Development

SQL is the language of DB2. With every release, DB2 enhances the SQL language to ensure that application programmers have rich language to improve their productivity and improve performance while adhering to the industry standards for SQL. V8 is no exception. SQL enhancements in DB2 V8 are standards-based and provide function that simplifies application development.

V8 further enhances the power of the DB2 SQL language by introducing new SQL statements such as MERGE, and enhancing existing SQL by providing support for INSERT through UNION ALL, adding support for INSTEAD OF TRIGGER, ORDER BY and FETCH FIRST in subqueries, and supporting SQL queries in user defined functions. There are also significant enhancements to the CALL statement as well as addition of numerous new functions. Scrollable Cursors also benefit from several important enhancements.

All of the key application drivers, ODBC, DB2 CLI, JDBC, SQLJ, and Embedded SQL, have been rearchitected for much higher performance and greatly reduced resource utilization. The new driver architecture provides excellent support for application servers with heavy work loads. In addition, key new features have been implemented in each of the drivers and a new Type 4 driver is now available.

DB2 V8 delivers industry-leading support for XML, the standard data interchange for the next generation of business-to-business solutions. XML document storage and retrieval forms an integral part of DB2 and is provided as a combination of SQL language (library of XML functions) and DB2 XML Extender enhancements.

Web Services is a key emerging technology for integrating applications and building applications from components. DB2 V8 delivers industry leading Web Services support by providing DBAs with ability to present stored procedures and SQL statements as Web Services and for application developers with ability to use these Web Services without having intimate knowledge of the details of their implementation. DB2 V8 can also act as a consumer of Web Services, presenting data provided by a Web service as if it was stored in DB2.

More application developers build applications with component-based architectures, including applications that are based on Java 2 Platform Enterprise Edition (J2EE) and Java beans as components, Microsoft COM, and the new .NET architecture. Web Services is an emerging technology that takes component-based application development to a new level. DB2 V8 improves on existing support for both Java and Microsoft component architectures, and also delivers industry-leading support for Web Services. XML has become the lingua franca of data interchange between applications and systems. DB2 V8 also delivers leading support for working with XML through improvements in SQL and the XML Extender.

Development Center is a replacement for the Stored Procedure Builder. It offers application developers facilities to build, debug, test, and deploy Java and SQL stored procedures, SQL functions, and table functions that read MQSeries^® messages, access OLE DB data sources and extract data from XML documents.

Development Center: Database server-side business logic (stored procedures, user-defined functions and structured data types) is an important part of many well-designed applications. DB2 Development Center provides an easy-to-use development environment that greatly simplifies the entire process of building stored procedures, user-defined functions (UDFs), and structured data types. It helps with developing, debugging, testing, and deployment of these application objects for DB2 servers. z/OS. While it provides support for developing and debugging server-side logic in Java and Procedural SQL, stored procedures written in any language (for example, COBOL) can be tested within the Development Center.

DB2 Development Center also provides an integrated debugger for debugging stored procedures and usability enhancements that allow programmers to browse contents of remote databases, as well as numerous project management features.

To improve programmer productivity in Microsoft environments, the Development Center also provides a DB2 Add-In for Microsoft, Visual C++, Visual Basic, and Visual InterDev. With the add-ins, you can easily develop DB2 server-side logic without leaving your Microsoft development environment.

WebSphere^® Studio plug-ins and Microsoft VisualStudio add-ins allow programmers using these integrated development environments (IDE) to build complete applications, including DB2 server business logic (stored procedures and user defined functions) without leaving the comfort of their favorite IDE.

These plug-ins extend WebSphere Studio functionality to include development of DB2 server-side application logic.

Applications that generate large amounts of data that need to be loaded into a table can now use a Call Level Interface (CLI) API that invokes the DB2 LOAD utility instead of using an array insert method. Using this option provides significant performance benefit for loading large amounts of data without the need to create an intermediate flat file.

WebSphere Studio Site Developer V5 and WebSphere Application Server Advanced for Developers V4: These complementary products provide DB2 application developers with tools for building, debugging, and testing DB2 stored procedures and user-defined functions. WebSphere Studio Site Developer also provides full feature XML-to-relational schema mapping environment to utilize the native XML capabilities of DB2 UDB. Dynamic Web applications can be created using the latest Web Services framework that encapsulate DB2 server logic such as SQL statements, and stored procedures as Web Service providers. WebSphere Application Server Advanced for Developers provides a Java 2 Platform, Enterprise Edition 1.3 (J2EE) compliant server that can be used for development and testing of applications based on J2EE architecture. The use of these complementary products is restricted by a DB2-specific set of terms and conditions. Consult license information for additional information.

SQL Assist Enhancements: With SQL Assist and some knowledge of SQL, you can create SELECT, INSERT, UPDATE, and DELETE statements. SQL Assist is a tool that uses an outline and details panels to help you organize the information that you need to create an SQL statement.

DB2 V8 enhancements include:

A redesigned user interface for easy inspection and modification of SQL statement elements
Assistance for creating table joins
SQL syntax checking
The option to copy and paste an existing SQL statement into SQL Assist, then use the SQL Assist interface to make modifications

Note: SQL Assist V7.2 remains in the Data Warehouse Center.

SQL Enhancements

Instead of Triggers: This type of trigger can simplify application programming. It allows developers to code inserts, updates, and deletes against views, while the actual update operation is re-directed to the appropriate underlying table.

Insert through UNION ALL Views: The SQL INSERT statement is now supported for views that use a UNION ALL construction, augmenting the UPDATE and DELETE capabilities provided in previous releases.

New Built-in Functions: The following trigonometric functions have been added to the SYSIBM schema:

ATANH
COSH
SINH
TANH
ACOS
ASIN
ATAN
ATAN2
COS
COT
SIN
TAN

ATANH, COSH, SINH, and TANH are new. The other functions were available under the SYSFUN schema; having them in SYSIBM offers a performance advantage.

TRUNCATE, CEILING, and FLOOR have also been added to the SYSIBM schema. These built-in functions now support decimal values.

Informational Constraints: DB2 V8 introduces a new type of constraint called informational constraints.

The DB2 query optimizer can be enabled to perform query optimization on application-enforced constraints that DB2 knows about but does not enforce. Use of such informational constraints can eliminate the overhead of DB2 performing constraint checking, while still providing the benefit of optimized query performance. Not enforcing constraints by the database manager reduces the workload on DB2 while still retaining the performance advantage of performing query optimization in order to improve performance.

User-Defined Functions and Methods: External user-defined functions and methods can now contain read-only SQL statements. Both static and dynamic SQL can be used. Other routines can be called from a function or method. Such nesting can include recursive calls of the routine and may invoke routines written in different languages. Some attributes of functions and methods can now be changed using the ALTER statement, rather than by dropping and recreating the routine.

Stored Procedures: The CALL statement is now a fully compiled statement. This means that the CALL statement can now be dynamically prepared in CLI, ODBC, JDBC, and SQLJ. Input arguments to a procedure call can be expressions. Some attributes of stored procedures can now be changed using the ALTER statement, rather than by dropping and recreating the routine. The limit of 90 parameters for SQL procedures has been removed.

Secure External Routines: A new authority has been defined to explicitly control who can and cannot create external routines (functions, methods, and procedures). Restricting who can create external routines is important; an external routine (especially a routine that is defined as THREADSAFE) can interfere with the execution of other external routines or with the database manager.

Declared Global Temporary Table Enhancements: Enhancements to declared global temporary tables (DGTTs) include:

Index support: the ability to create indexes using the CREATE INDEX statement.
Undo logging supports the rollback of data changes to DGTTs.
Statistics support: improved performance as a result of using the RUNSTATS command to update statistics about the physical characteristics of the DGTT.
Merge. Allows for a single SQL statement to inserted records into a table when the record does not already exist or update the record if the row already exists in the target table.

API Enhancements

ODBC, DB2 CLI Driver and ADO API Enhancements

Server-side scrollable cursors for easier application development and better performance.
Reduced resource contention for multithreaded applications.
Separate memory pools for lower resource contention.
Improved context support makes developing X/Open XA applications easier.
Simplified development of applications using mixed Embedded SQL and CLI/ODBC model.
Higher function and more efficient ADO interface through Extended Describe (table names from column names, leads to more efficient scrollable cursors).
Support for calls to nested and recursive stored procedures.
Improved handling of repeated calling of the same stored procedure that returns result sets. This will help eliminate many of the "cursor already open" error conditions common in this configuration.
Utilize the new SQL CALL statement to dynamically prepare (for example, use package cache) for better performance.
Reduced server load through off-load of code page conversion to the client from the database server.
Enhanced support for distributed transactions in Microsoft COM+ (Microsoft Transaction Server) environments.

JDBC Driver and SQLJ Enhancements: Many new features and enhancements have been put into the JDBC drivers in DB2 V8. The most important of them is the new architecture that will ultimately deliver significant performance and scalability improvements for JDBC and SQLJ, and any applications built with the DB2 JDBC drivers. Here is a list of the major changes:

A brand new type 4 JDBC driver built with the new architecture. This two-tier, pure-Java driver simplifies the deployment and configuration process. It is designed to replace the type 3 driver.
Type 2 and type 3 driver usability and performance enhancements. The drivers are made available on 64-bit platforms. Memory management is enhanced, which makes the drivers more robust and better performing. JDBC tracing is improved to provide better diagnostics. Support for DATALINK as a data type is also added. DATE, TIME, and TIMESTAMP values now can be set or retrieved for a particular time zone using a Calendar object. Unicode support is enhanced, so that unnecessary code page conversion between a DB2 client and a DB2 server when connecting to a Unicode database (which may cause data loss) is eliminated. OUTPUT LOB parameter support for CallableStatement is added. The performance of PreparedStatements is improved. FetchSize for ResultSets is supported by the type 3 JDBC driver.
The type 2 driver is now J2EE-certified. It continues to be the recommended driver to be used by application servers such as WebSphere Application Server and other enterprise solutions.
The new SQLJ profile customizer supports the java.sql.Blob and java.sql.Clob types of JDBC 2.0, as well as host variable expressions.

XML Support: Many relational database systems are not equipped to deal with XML documents. Programmers had to choose between using an XML-based database management system, writing custom code to transform data between relational and XML forms, or storing XML documents in their entirety as binary objects thereby giving up the benefit of understanding the business context that XML documents represent. DB2 offers an alternative. It allows programmers to:

Store XML documents intact with XML tags, yet provide fast search and retrieval by creating relational side tables and indexes.
Automatically transform XML documents into traditional relational representation (rows and columns in relational tables), and to automatically create XML documents from relational data.

For customers who choose to use automatic transformations between relational data and XML documents, DB2 provides additional flexibility. Programmers have a choice of declaring a mapping between XML elements/attributes and relational rows and columns using Document Access Definitions (DAD) files, or using built-in SQL functions (XMLELEMENT, XMLATTRIBUTES, REC2XML, and XMLAGG). These SQL functions can be used to produce XML documents or fragments with an element or an attribute whose specific name is derived from a column in the database, or with elements and attributes which have default names, and to combine multiple XML strings.

XML programmers spend a considerable amount of effort transforming XML documents to other data forms. For example, transforming XML to HTML is common in Web programming while transforming between different XML schemas is a staple of business-to-business systems. These transformations are accomplished using XSL Transformations (XSLT). DB2 provides SQL functions that automatically apply XSLT to XML documents. Results of these transformations are stored in DB2, provided to other systems via Web Service or can be stored in a file system where they can be used to serve Web pages.

In addition to the flexible XML storage options, DB2 allows programmers to manipulate XML documents by using SQL instead of the DOM and SAX APIs commonly used by XML programmers. DB2 provides SQL functions for importing and exporting XML documents between DB2 and the file system extracting XML document fragments, elements and attribute values, and updating XML documents. DB2 also provides SVALIDATE and DVALIDATE SQL functions to assist programmers in validating XML documents against XML Schema or DTD. These functions are flexible enough to use XML Schemas and DTDs stored in DB2 or the local file system and industry defined schemas stored on remote Web servers, for example:

http://www.xml.org

To complement XML storage and processing options, DB2 provides several alternatives for both the source and destination of the XML data. XML documents can originate or be output as files, come from other systems or be delivered to other systems via MQSeries. XML schemas and DTDs used in document validation can be located locally in either DB2 or a local file system or be obtained from remote servers.

Included in DB2 are the tools typically used by XML programmers. DB2 provides XML parsers (XML4C, XML4J) and XML stylesheet processors (Xalan-C and Xalan-J). More importantly, DB2 XML capability is tightly integrated into WebSphere Studio products for improved programmer productivity. WebSphere Studio products for DB2 XML includes DAD generator, DAD checker, and a DTD to XML schema transformer.

DB2 XML Extender: XML is the standard for data interchange for the next generation of business-to-business, e-commerce solutions. With the XML Extender for DB2, it is easy to leverage your critical business information in DB2 databases to engage in business-to-business solutions using XML-based interchange formats.

DB2 XML Extender provides new data types that let you store XML documents in DB2 databases and new functions that assist you in working with these structured documents. Entire XML documents can be stored in DB2 databases as character data or stored as external files but still managed by DB2. Retrieval functions allow you to retrieve either the entire XML document or individual elements or attributes. Included with all editions of DB2 UDB, the DB2 XML Extender:

Extracts XML elements and attributes into traditional SQL data types, leveraging the sophisticated indexing and SQL query of DB2
Provides storage, retrieval, and updates of XML documents in a single column
Composes existing DB2 data into XML documents
Stores XML documents as a collection of DB2 data, in multiple columns and tables

Web Services Applications: Web Services are a powerful new programming paradigm that enables the development and deployment of loosely coupled applications within a company or across industries. Web Services are based on emerging technologies including Simple Object Access Protocol (SOAP), Web Services Description Language (WSDL), and Universal Description, Discovery, and Integration (UDDI).

A Web service is created by wrapping an application so that it can be accessed using XML messages which, in turn, are wrapped to mask the underlying transport protocol. The service is publicized in a standard format registry, allowing people and applications to find and use the service over the Web. DB2 can be accessed as a Web service provider, and it is usually teamed with WebSphere family products to provide a complete Web services framework. An easy way to develop data-intensive Web Services applications is through DB2's document access definition extension (DADx) programming model. DADx files are simply XML documents that contain stored procedure references, DB2 XML Extender references, or traditional SQL. Best of all, DADx files can be created quickly without any Java programming.

For a demonstration of DB2 as a Web service provider, view the IBM Video Central for e-business tutorial at:

http://www.ibm.com/software/data/webservices/

For information on how to use the Java Type 4 driver, view the following Web page:

http://www.ibm.com/software/data/db2/java

Borland C++, Delphi and Kylix complementary products: DB2 Personal Developers Edition and DB2 Universal Developers Edition products include Borland 30-day trial CD-ROM that contains:

Borland Delphi Studio Architect,
Borland C++Builder=B7 Enterprise, and
Borland Kylix Enterprise

This CD-ROM can be used to evaluate these award-winning products for developing Windows and Linux DB2 applications.

OLE DB2 Provider for DB2: Key attributes of the new architecture include:

Streamlined implementation for better performance
New memory management model for fewer memory copies and reduced memory contention for better scalability and performance
Improved data binding algorithms for faster parameter and variable binding processing

V8 of the OLE DB provider delivers a new Data Link user interface that simplifies data link creation and configuration using standard Windows Data Link Properties dialog.

Business Intelligence (BI)

DB2 is "built for BI." IBM is ensuring that DB2 is the best database for data warehousing and mixed workload environments. No other database has the scalability of DB2, from palm-held to enterprise clustered servers, and IBM continues to drive BI functionality into the database.

Warehouse Manager: DB2 Warehouse Manager provides enhanced ETL (extract/transform/load) functionality over and above the base DB2 capabilities. DB2 Warehouse Manager also provides metadata management and repository (Information Catalog) functionality. The Information Catalog also provides an integration point for third-party ISVs to perform bidirectional metadata and job scheduling exchange. DB2 Warehouse Manager provides one of the most powerful distributed ETL job scheduling systems in the industry. DB2 Warehouse Manager agents allow direct data movement between source and target systems without the overhead of a centralized server. QMF™ for Windows is included with the DB2 Warehouse Manager. It queries DB2 from its own Windows interface or from your favorite Web browser and integrates with multiple Windows desktop tools.

DB2 Warehouse Manager V8 Enhancements

DB2 Integration and Exploitation
- With V8, the load utility will now support multiple partitions using DB2 ESE and will split and load the data in a significantly reduced load time, which will substantially decrease the batch processing time.
- Integrated Control Center and Replication Center: Built on DB2, DB2 Warehouse Manager continues to integrate warehouse capabilities with DB2. With V8, DWC will provide improved integration with the Control Center utility functions as well as a replication step GUI that is consistent with the Replication Center.
Warehouse Server on AIX^®: Prior to V8, the Warehouse Server had to be installed on a Windows NT^® or 2000 server. With V8, users will now be able to install their Warehouse Servers on AIX as well.
Linux Agent support: Linux platform users will be able to utilize Extract, Transform, Load (ETL) capabilities of DB2 Warehouse Manager via the Linux agent introduced in V8.
Performance: Warehouse definition and population operations have been enhanced in V8.1. The technique used for defining the warehouse sources has been streamlined to improved definitional performance. A new transformer pushes transformation work to the DB2 engine, resulting in improved population performance.
Usability and functionality: V8 introduces SQL Update capability, which is frequently used in a warehouse environment to update the target data with the data selected from the source. In addition, DB2 V8 users will be able to define a process, which waits for multiple steps to complete. Furthermore, DB2 Warehouse Manager V8 includes usability enhancements in the areas of SQL Step, process, column mapping, and process modeller.
Information Catalog Manager (ICM): ICM has been rearchitected to provide an extendable metadata store, which can be used by the Information Catalog Center on multiple DB2 platforms. It now includes metadata object level security and user-defined relationship types. The Information Catalog Center is a Control Center client of the ICM, providing a new easier to use interface. In addition, there is a Web interface for ICC business users.

Information Catalog Manager Enhancements

New enhanced desktop interface
Web interface via WebSphere application
New Java interfaces

IBM plans to release DB2 Query Patroller V8 that will work with DB2 UDB V8. DB2 Query Patroller V8 will deliver enhanced functionality to manage and control all aspects of query submission and execution. DB2 Warehouse Manager V7.2 customers can continue to use DB2 Query Patroller V7.2 (which is shipped with DB2 Warehouse Manager V7.2) with IBM Universal Database V7.2. DB2 WHM V8 customers can order a media pack that contains DB2 Query Patroller V7.2 until Version 8 of DB2 Query Patroller is available. However, DB2 Query Patroller V7.2 can only be used with DB2 UDB V7.2 databases.

DB2 Warehouse Manager Sourcing Agent for z/OS: The DB2 Warehouse Manager Sourcing Agent for z/OS allows customers running Warehouse Manager on Linux, UNIX, or Windows platforms to run a separate Sourcing Agent on z/OS. This means data extract and transformation can occur on the same platform as the source data, regardless of where the target data warehouse and other components of Warehouse Manager reside.

For additional details, refer to Software Announcement 202-216 , dated September 17, 2002 (DB2 Warehouse Manager for z/OS V8.1).

Intelligent Miner™ Products: Having accepted the advantages of data mining analytics In the Business Intelligence space, particularly in the area of Customer Relationship Management, there is growing recognition of new opportunities for business improvement that can be achieved by driving data mining into operational systems. There are requirements to:

Better serve business and consumer users alike
Provide more informed recommendations
Alter the process based on past history
Build more efficiencies in the online experience
Be more responsive to the specific situation at hand

With these requirements, there is recognition that applications require inline analytical capabilities and that advanced analytics should be driven into the DBMS layer for reasons of enablement, productivity, and operating efficiency.

DB2 Intelligent Miner Modeling: Delivers DB2 Extenders^® (specifically, stored procedures) for the following modeling operations:

Associations discovery — Application examples include: The discovery of product associations in a market basket analysis, site visit patterns at eCommerce site, or combinations of financial offerings purchased.
Demographic clustering — Application examples include: Market segmentation, store profiling, buying-behavior patterns.
Tree classification — Application examples include: Profiling customers based on a desired outcome such as propensity to buy, projected spending level, likelihood to attrit within a period of time.

DB2 Intelligent Miner Modeling supports the development of data mining models in a format which conforms with Predictive Model Markup Language (PMML) V2.0, the new industry standard for analytic models.

DB2 Intelligent Miner Scoring: Delivers database extenders (both DB2 extenders and Oracle cartridges) supporting the application of PMML 2.0 models to new data.

Support is provided for all models developed via Intelligent Miner Modeling and for algorithms of DB2 Intelligent Miner for data that support an application mode, which includes:

Neural clustering
Demographic clustering
Neural classification
Tree induction classification
Neural prediction
Radial Basic Function (RBF) prediction
Linear regression
Stepwise polynomial regression
Logistic regression

Application programs can utilize DB2 Intelligent Miner Scoring to classify, rank, or predict the most likely business results for all rows of a large database, a subset of the database, or a single row or case. DB2 Intelligent Miner Scoring V8.1 also delivers an in-memory scoring capability through the use of a Java applet. This capability may be particularly useful where an application is assembling information for a new customer or product for the first time — that is, the information has not yet been recorded in a database. This may be a frequent occurrence for eCommerce or call center applications.

DB2 Intelligent Miner Visualization: Provides Java visualizers, to interact and graphically present the results of associations, demographic clustering, and tree classification modeling operations. Input to the visualizers are PMML 2.0 conforming models.

The visualizers can operate inline in support of transaction processing or as an applet in a Web browser. The visualizers enable customers to analyze model results in order to gain new business insights.

The DB2 Universal Database Inheritance: With the federated functionality that is built into DB2 Universal Database, Intelligent Miner operations can access DB2 data directly, as well as a variety of other data sources supported by DB2. Intelligent Miner models stored in DB2 databases inherent in all the administrative and processing advantages inherent in a DB2 Universal Database implementation. Meanwhile application developers avail themselves of familiar SQL and Java program interfaces, improving productivity and minimizing new skill requirements. The integration of Intelligent Miner and DB2 technologies provides a solid foundation for mainstreaming advanced analytics in core business applications.

DB2 OLAP Server™: DB2 OLAP Server provides a fast path to turn your warehouse data into business insight and is built for e-business with tools to help you quickly deploy Web-based analytical applications. DB2 OLAP Server employs the widely accepted Essbase OLAP technology, which is supported by over 350 business partners and over 70 tools and applications. DB2 OLAP Server V8.1 continues to deliver results of joint development between IBM and Hyperion. DB2 OLAP Server V8.1 introduces significant improvements, such as Hybrid Analysis for Cube Scalability and Improved Parallelism for Performance and Throughput.

Integrated Information

DB2 has established its reputation as a data management platform that can be easily extended to accommodate requirements of new technologies. This is based on an extensible architecture providing a strong foundation of information integration technologies and enriched data types.

Information Integration Foundation: Information integration is a key element of IBM's overall Data Management direction, differentiating us from Oracle and Microsoft and their centralized or platform-specific data management approach. DB2 provides a strong foundation of information integration technologies, including federation, caching, replication, Web services, and XML.

Federation: DB2 is the core federation engine, which provides data source transparency, rich query, and transformation features for federated data sources, functional compensation, and global optimization for distributed data access. DB2 lets you access and update your DB2 and Informix Dynamic Server (IDS) data sources no matter where they reside. DB2 Connect enables federation for zSeries™ and iSeries™. Through its object-relational technology infrastructure, DB2 provides built-in functions that enable federated access to MQ Series message queues, and OLE DB data sources. Thus a single DB2 query can access and integrate data across relational databases, message queues, and OLE DB data sources.

With DB2 UDB V7, DB2 Relational Connect provides federated connectivity to Oracle, Microsoft SQL Server, and Sybase databases and DB2 Life Sciences Data Connect provides federated connectivity to spreadsheets, flat files, XML documents, and Life Science specific data sources. These features will not be offered directly with DB2 V8, but will be reintroduced in a subsequent announcement. In the interim, customers using either feature should remain on DB2 UDB V7.2 until IBM announces an upgrade path.

Replication: DB2 UDB V8 provides integrated replication among DB2 and IDS. DB2 DataPropagator™ enables replication to and from DB2 on zSeries and iSeries. DB2 V8 replication features improved usability, reliability, performance, serviceability, and security.

The new DB2 Replication Center is a graphical tool, part of the DB2 Control Center, that helps you to set up and administer your replication environment. It supports administration for DB2-to-DB2 and IDS replication environments. It includes all the replication functionality previously available from the DB2 Control Center and the DB2 DataJoiner Replication Administration (DJRA) tool. Use the Replication Center to:

Define defaults in profiles for creating control tables, source objects, and target objects
Create replication control tables
Register replication sources
Create subscription sets and add subscription-set members to subscription sets
Operate the capture program
Operate the apply program
Monitor the replication process

Basic replication performance has improved with JOINs eliminated in many situations, multithreaded capture, and faster full refreshes of target tables by exploiting DB2 LOAD improvements.

Web Services: Web services are a powerful new paradigm in building open systems, enabling the development and deployment of loosely coupled applications within a company or across many enterprises. They are based on emerging industry standards including Simple Object Access Protocol (SOAP), Web Services Description Language (WSDL), Universal Description, Discovery, and Integration (UDDI).

Web services can be easily created by wrapping existing applications, masking the underlying implementation and transport mechanisms. These newly created services are then publicized in a standard format registry, allowing people and applications to find and use the services over the Web. The published Web services can be combined in many ways, providing a building block approach to system development which leverages existing applications and infrastructure.

DB2 supports Web services in a variety of ways. DB2 stored procedures or user-defined functions can be wrapped and invoked as Web services. Alternatively, DB2 applications can invoke Web services directly through SQL, allowing queries to join Web service results, like a current stock price, with data stored in the database.

XML: XML is emerging as a key language for information interchange and integration. With this evolution, the demands on database systems to store, compose, validate, decompose, and manipulate XML documents are increasing rapidly. DB2's built-in XML support provides these capabilities, and allows XML documents to be either stored intact or transformed into relational form. DB2 V8.1 includes enhancements in support of SQLX standards for publishing XML data, as well as XML Extender enhancements in storage and retrieval. DB2 also enables the publishing of XML documents composed from diverse and distributed sources, as well as the ability to decompose and store XML documents across DB2 and IDS data stores. To complement XML storage and processing options, DB2 provides several alternatives for both the source and destination of XML data. XML documents can originate or be generated as files, come from other systems or be delivered to other systems via MQSeries. XML schemas and Document Type Definitions (DTDs) used in document validation can be stored locally in either DB2 or a local file system, or be obtained from remote servers.

Enriched Data Type Support

DB2 Spatial Extender: Time and space are the cornerstones of twenty-first century data warehouses. Spatial objects deals with the location of objects with regard to surroundings, including those that comprise the earth's surface and those that occupy it. They make up the natural environment (such as rivers, forests, and hills) and the cultural environment (cities, office buildings, and landmarks). Eighty percent of existing data has implied spatial value, such as names and addresses, which can be converted to explicit spatial values you can use to make more informed business and policy decisions. This data can be further enhanced by viewing results on a map. DB2 Spatial Extender allows you to store, access, manage and analyze spatial information along with the rest of your business data. It provides spatial data types to describe spatial data and allows you to leverage the power of SQL, including spatial functions, for spatial data retrieval and analysis. DB2 Spatial Extender continues its support of industry standards with its Open GIS Consortium Simple Features conformance and ISO SQL standard support.

Recognizing your need to exploit your spatial intelligence to gain a competitive edge, IBM is now providing the following offerings and enhancements to DB2 Spatial Extender V8:

Enhancements

DB2 Spatial Extender V8 now supports Solaris, HP-UX and Linux on Intel and S/390^® platforms, in addition to Windows and AIX.
64-bit environments for all supported platforms.
A new Spatial Indexing guidance tool to analyze an existing index or recommend an ideal index based on the spatial data.
New spatial SQL functions have been added.
A new spatial import facility with expanded functionality for loading spatial data from Shapefiles and SDE format.
A new spatial command line processor, db2se, with significantly expanded capability.
A new trace facility to provide enhanced diagnosis capability for applications.
A revised spatial catalog and enhanced stored procedures to more effectively manage spatial metadata.
A migration tool to migrate DB2 V7 spatial data to DB2 V8.

DB2 Spatial Extender continues its support of industry standards with its Open GIS Consortium Simple Feature.

Enhanced spatial control center panels and online maintain our relentless focus on improving overall system manageability. DB2 Spatial Extender focuses on how to make the spatial database extension smarter by adding Spatial Indexing guidance to analyze your existing index and recommend an ideal index based on the spatial data. In addition, DB2 Spatial Extender provides additional spatial SQL functions and support for SQL methods.

Not only have we integrated the management of the DB2 Spatial Extender into the DB2 UDB Control Center, we have made sure it works with other DB2 UDB and Informix databases through the federated support.

DB2 Net Search Extender: Adding smart, usable text search extensions to your database provides you with more intelligent information related to your business needs. With V8, IBM merges the in-memory search capability with the powerful text search capabilities of the V7 Text Information Extender in a single easy-to-use DB2 option. The high performance of in-memory search is indispensable for e-commerce applications or any other application with high performance and scalability text-search demands. For example, you can now use in-memory search with your XML documents.

Integrated solutions means ensuring all parts of the solution work together. So now you can manage the DB2 Net Search Extender right from the DB2 UDB Control Center, significantly simplifying basic tasks like creation of a text index.

You can use DB2 Net Search Extender with DB2 UDB's built in federated support to index and search your text data stored in other DB2 and Informix IDS databases. Integration with the DB2 optimizer's intelligent strategies ensure high-performance, full-text search working seamlessly within an SQL full select. The text search interface is based on the SQL/MM standard.

Text Extender providing text search with linguistic functions is now shipped with DB2 Net Search Extender.

DB2 Data Links Manager: DB2 Data Links Manager allows access and management of external files as though they are logically stored within the database. DB2 Data Links Manager guarantees referential integrity to these external files, provides enhanced access control to them, and supports automatic and coordinated backup and restore capabilities that are crucial for data management in transactional environments. This smart addition to your DB2 solution simplifies and reduces system administration costs and complexities by providing a single coordinated administration point for file and database data.

Manage Files on Multiple Distinct File Servers

Enterprises can now manage files on multiple distinct file servers within a DB2 Data Links Database allowing robust centralized control over distributed resources across intranets. Data in files no longer needs to be imported into the database and can continue to be accessed directly by applications.

Consistent Replication of DB2 and File Data

V8 delivers replication of both DB2 data and DB2 Data Links Manager with complete integrity.

ANSI and ISO Standards Support

The DATALINK type is now part of the ANSI and ISO standard for the SQL Management of External Data (SQL/MED).

High Availability

Ensuring your data is available whenever you need it is critical to running your business. IBM understands your need for constant access to your enterprise information including the files that are outside your database. DB2 Data Links Manager has:

Reduced time for running the reconcile utility
Reduced time for beginning backups involving linked files
Improved throughput on replication of linked files using DB2 Data Propagator
Removed the need to have all Data Links Managers available in order for utilities to run successfully

High Availability for DB2 Utilities Support

You no longer need all Data Links Managers (DLMs) to be available in order for utilities to complete successfully.

Usability Improvements

Replication support improved: Support for replication is now more fully integrated into Data Links. This means less work to set up and maintain the environment.
Ability to update data links files without unlinking the file: The user no longer has to unlink the file in order to modify the Data Link file.
Ability to drop individual DB2 Data Links Managers: Allows users to drop individual data links managers when no longer needed, thereby removing unnecessary storage and processing overhead.
A new DB2 Data Links Administration Guide and Reference book for system administrators, database administrators, and application programmers.

Security Features

The security of your data and information is critical to your business success. Knowing who is managing your data ensures it remains safe. We have added the capability to restrict the linking of files to authorized users.

Additional Operating Systems

DB2 Data Links Manager now supports external files stored on Windows 2000 and Sun Solaris V8 in addition to the platforms supported in previous releases.

Linux Enhancements

Validation: The Linux Validation Program has been introduced with DB2 V8 to ensure better interoperability of DB2 on Linux platforms and enhance customer experience. IBM is working closely with the Linux Community, Linux Distribution Partners, and Independent Software Vendors to test DB2 using various Linux environments. All kernels, distributions, and software that have been successfully tested with DB2 as part of the Linux Validation Program will be supported for use with DB2 on Linux. More information is available at:

http://www.ibm.com/db2/linux/validate

InfiniBand Support: DB2 is the first database to support InfiniBand fabric connectivity for high-speed interconnections. DB2 V8 includes improved support for the InfiniBand architecture to deploy partitioned databases on Linux clusters while offering greater scalability and better performance.

Other enhancements with DB2 V8 on Linux include

Larger Bufferpools: In DB2 V8 larger bufferpools are possible on Linux systems with kernels that support lowered mapped base addresses. With the ability to create larger buffer pools, DB2 performance can be enhanced.
Auto-configuration of kernel parameters: Previously it was necessary to manually change default values of certain Linux kernel parameters for use with DB2. In DB2 V8 these kernel parameters are automatically configured by DB2 for optimized DB2 usage. This results in improved manageability.
zSeries Enhancements: The following features, previously in DB2 on Linux for 32-bit Intel-compatible platforms are now available in DB2 on Linux V8 running on zSeries:
- Access to Raw I/O devices
- Support for 2.4 kernel
- 64-bit file I/O and support for file sizes greater than 2 GB

Product and Feature Availability

Certain products and functions described in this announcement will not be available on the published availability date. Instead, they will be delivered at a later date:

Ability to capture changed on partitioned databases for replication purposes
Identity and Sequence datatype support for partitioned databases
Backup Compression
Merge/Upsert support
Enhanced availability features including ability to throttle utilities
DB2 UDB Audio, Image, and Video extenders
The following DB2 Net Search Extender functions:
- Text Extender
- Support for partitioned tables
- Support for 64-bit platforms (Windows XP, Windows .Net, AIX 5L, HP-UX 11i, Solaris 7, Solaris 8, Solaris 9, and Linux on Intel)
- Support for HP-UX, Linux, and Linux on zSeries
DB2 Spatial Extender support for Windows 64-bit and Linux 64-bit platforms

Data Management Enhancements

Reduced operating costs by utilizing:

SMART technology to simplify DB2
Storage Manager for a comprehensive analysis of disk usage, data distribution and skew, clustering, and other attributes of the storage subsystem usage.
Rearchitected Control Center for improved DBA productivity and ability to manage DB2 servers from anywhere by using standard a Web browser or Personal Digital Assistant (PDA).
Enhanced support for operation and administration of partitioned databases by utilizing procedures and tools for multi-partition load, backup, and restore as well as simplified procedures for adding and removing database partitions and redistributing data over existing database partitions.

Enhanced Scalability and Performance: The DB2 Database Partitioning Feature (DPF) authorizes you to use the database partitioning feature of ESE to enhance the scalability of DB2 ESE by creating multiple database partitions within a single server, or across multiple servers. DPF is not supported on Linux for zSeries.

Connection concentrator support, minimizes the resources required by the DB2 server to support very large numbers of application users.
Improved performance for stored procedures written in Java programming language by using a single shared Java Virtual Machine (JVM).
Improved application performance and reduced client resource consumption due to the new client architecture. The new client architecture includes new implementations of ODBC/CLI, JDBC, and OLE DB2 drivers and new SQLJ support. These drivers have been rearchitected to minimize path lengths, copying of data from one place to another, and resource consumption to accommodate demands of today's Web-based applications.

Improved Availability for Critical e-business Applications

New and improved online utilities for loading data, index creation and table and index reorganization
Dynamic configuration parameter update without needing to stop database activity
Much faster tablespace roll forward recovery due to greatly improved log processing algorithms
More robust log archiving that allows archiving of logs even while transactions are in flight and for log archiving to use parallel I/O

IBM Will Not Be Releasing the Following Programs in V8.1

DB2 Warehouse Manager Connector for i2 TradeMatrix BPI. This was an optional priced feature of DB2 Warehouse Manager.
DB2 Universal Database Enterprise Edition and DB2 Universal Database Enterprise Extended Edition. These programs have become DB2 ESE and DB2 ESE with Partitioning Option, respectively.
DB2 Universal Database Satellite Edition. The function of DB2 Universal Database Satellite Edition was merged into DB2 Universal Database Personal Edition. The end of service date for customers who continue to use Satellite Edition V6 was extended from December 31, 2001, to December 31, 2002.
DB2 UDB Workgroup Edition and DB2 UDB Workgroup Unlimited Edition are offered in V8 as DB2 UDB Workgroup Server Edition, and DB2 UDB Workgroup Server Unlimited Edition, respectively.

Functions to be Discontinued in V8.1

DB2 V8 products no longer support Java Virtual Machine (JVM) and JDK provided by the Microsoft Corporation. DB2 product for Windows platforms include JVM and JDK at the supported levels.
The back level JDBC 1.2 drivers (both type 2 and type 3) are no longer offered. Customers using these drivers should switch to the JDBC 2.0 drivers provided with DB2 UDB V8. Customers have access to the full license version of this Program through DB2 Connect Unlimited Edition.
Net.Data^® will no longer be enhanced or made available as a component of DB2 Universal Database. Customers that wish to utilize Net.Data with DB2 UDB for UNIX, Windows, and Linux V8 servers can download V7.2 of Net.Data from:
While V7.2 of Net.Data continues to be available free of charge, customers are encouraged to consider migrating applications to use WebSphere Application Server. Net.Data V7.2 will continue to be available for download while DB2 UDB V7.2 is sold by IBM. Net.Data V7.2 usage will be supported with DB2 UDB V8 servers for as long as DB2 UDB V7.2 remains supported.
For DB2 V8, the DB2 Administration Server (DAS) is no longer an instance.
The asnmobile function and the asnjet function are removed from replication.
The generalize replication subscription function is removed from the Satellite Administration Center.
IPX/SPX is no longer supported. Users are requested to migrate to TCP/IP.
DB2 Performance Monitor function of the Control Center is being replaced. Many of its capabilities are now integrated into the Health Center to deal with XML documents. Performance Expert for Multiplatforms is a separately priced product that is provided in DB2 Universal Database Enterprise Server Edition V8.1 as a Try & Buy offering.
DCE security and DCE directory are no longer supported. Customers that wish to use single sign-on function provided by the DCE security should consider using Kerberos security and Microsoft Active Directory security. Customers that need global directory function should consider using LDAP directory and Microsoft Active Directory.
Control Center will not support administering DB2 for OS/390, V5 servers.
- DB2 UDB V8 servers will no longer support SNA (APPC) connections from client workstations and mainframe and midrange systems.
- DB2 UDB V8 clients will no longer provide capability to establish SNA (APPC) connections to DB2 UDB servers on Linux, UNIX, and Windows.
- DB2 UDB Enterprise Server Edition V8 servers will not support SNA (APPC) connections to DB2 mainframe and midrange servers at the date of general availability. Enabling this support will require installing Fixpack 1.
DB2 UDB V8 provides support for AIX 5L 64-bit implementation. Users of DB2 UDB on AIX 4.X need to migrate to AIX 5L technology in order to exploit advantages of the DB2 UDB 64-bit implementation. DLC and DLS restrictions are addressed in the Limitations section.
NUMA-Q^® products. The following DB2 products have been discontinued: DB2 UDB Enterprise Edition for NUMA-Q, DB2 UDB Enterprise Extended Edition for NUMA-Q, DB2 Connect Enterprise Edition for NUMA-Q.
DB2 UDB Text Information Extender, included with certain DB2 programs in V7.2, has been merged with DB2 Net Search Extender, and is available through DB2 Net Search Extender. DB2 Net Search Extender V8.1 provides a new interface in addition to the existing V7.2 interface. The V7.2 interface is supported in V8, but will not be provided and supported beyond V8.

Education support

Courses (self-study courses), classes, CBR and laserdisk courses will be available from November 21, 2002. Courses for DB2 Intelligent Miner products will be available from September 27, 2002.

Visit the following Web site for additional information:

http://www-3.ibm.com/services/learning/

The appropriate curriculum will include the enhancements described in this announcement.

Refer to the IBM Learning Services Home Page for available courses in your country

http://www-3.ibm.com/services/learning/

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

Back to top

Offering Information

Product information will be available on day of announcement through Offering Information (OITOOL) at:

http://www.ibm.com/common/ssi

Publications

Printed publications can be ordered from January 17, 2002. Electronic, softcopy versions of the documentation for DB2 UDB V8.1 will be available for download on November 21, 2002. DB2 Intelligent Miner publications can be downloaded from September 27, 2002. Printed publications can be ordered from October 18, 2002.

To order, contact your IBM representative or call 888-SHOP-IBM (746-7426) in North America. Other geographies can contact an IBM representative or send a note to mdcinfo@us.ibm.com.

The IBM Publications Center Portal is at:

http://www.ibm.com/shop/publications/order

The Publications Center is a worldwide central repository for IBM product publications and marketing material with a catalog of 70,000 items. Extensive search facilities are provided, as well as payment options via credit card. Furthermore, a large number of publications are available online in various file formats, which can currently be downloaded free of charge at:

http://www.ibm.com/software/data/db2/udb/winos2unix/support

This Web site offers publications for Windows and UNIX platforms.

Note: PNS subscribers most often order their publications via the Publications Center. All publications listed in the Publications Section will be available for separate order on January 17, 2003, for a fee. Publications for Intelligent Miner products will be available for order on October 18, 2002. To order these publications separately, contact your IBM representative.

Displayable Softcopy Publications

Displayable Softcopy Publications for DB2 are included in softcopy form on the DB2 Publications CD-ROMs, included in the media pack. To assist with the initial installation, each product's Quick Beginnings book is also provided in hardcopy within the media pack.

The HTML CD included in the media pack contains HTML topics, and the PDF CD contains the books in a format viewable using Adobe Acrobat. The PDF files can produce high-quality reproductions of the documentation on local laser printers.

The displayable HTML topics can be viewed using an HTML browser (minimum requirements: Internet Explorer 5 or Netscape 6.1) on your system.

HTML topics are displayed in the new browser-based DB2 Information Center. For better retrievability, the browser-based DB2 Information Center provides an integrated navigation tree that is organized by information type (tasks, concepts, and reference). The browser-based DB2 Information Center also provides a search facility, master glossary, and master index to help you find the information you need.

Another new feature for DB2 V8 is documentation Fixpacks. With a few easy steps, you can update the HTML documentation you have installed from the DB2 HTML Documentation CD when documentation Fixpacks are made available.

                                                       Order
Title                                                  Number
 
IBM DB2 Universal Database                             SC09-4839
  Master Index
IBM DB2 Universal Database
  Application Development Guide:
    Programming Server Applications                    SC09-4826
                                                       SC09-4827
    Building and Running Applications                  SC09-4825
IBM DB2 Universal Database Call Level                  SC09-4849
  Interface Guide and Reference,
  Volume 1
IBM DB2 Universal Database Call Level                  SC09-4850
  Interface Guide and Reference,
  Volume 2
 
                                                       Order
Title                                                  Number
 
IBM DB2 Spatial Extender User's Guide                  SC27-1226
  and Reference
IBM DB2 Universal Database Data Links                  SC27-1221
  Manager Administration Guide and
  Reference
IBM DB2 Universal Database Data                        SC27-1124
  Warehouse Center Application
  Integration Guide
IBM DB2 Warehouse Manager Information                  SC27-1125
  Catalog Centre Administration Guide
IBM DB2 Universal Database                             SC09-4824
  Administrative API Reference
IBM DB2 Universal Database                             GC27-1224
  Federated Systems Guide
IBM DB2 Data Warehouse Manager                         GC27-1122
  Installation Guide
IBM DB2 Universal Database Net Search                  SH12-6740
  Extender Administration and
  Programming Guide
IBM DB2 Intelligent Miner Scoring                      SH12-6745
  Administration and Programming for DB2
IBM DB2 Intelligent Miner Scoring                      SH12-6746
  Administration and Programming
  for Oracle
IBM DB2 Intelligent Miner Modeling                     SH12-6736
  Administration and Programming
IBM DB2 Intelligent Miner                              SH12-6737
  Visualizing Using the
  Intelligent Miner Visualizers
IBM DB2 Universal Database                             GC09-4838
  Quick Beginnings for DB2
  Personal Edition
IBM DB2 Universal Database                             GC09-4836
  Quick Beginnings for DB2
  Servers
IBM DB2 Universal Database Quick                       GC09-4829
  Beginnings for Data Links
  Manager
IBM DB2 Universal Database                             SC27-1123
 Data Warehouse Center Administration
  Guide
IBM DB2 Universal Database What's New                  SC09-4848
IBM DB2 Universal Database                             SC09-4822
  Administration Guide:  Planning
IBM DB2 Universal Database                             SC09-4821
  Administration Guide:  Performance
IBM DB2 Universal Database                             SC09-4820
  Administration Guide:  Implementation
IBM DB2 Universal Database                             SC09-4844
  SQL Reference, Volume 1
IBM DB2 Universal Database                             SC09-4844
  SQL Reference, Volume 2
IBM DB2 Universal Database                             SC09-4828
  Command Reference
IBM DB2 Universal Database                             SC27-1121
  Replication Guide and Reference
IBM DB2 Universal Database                             GC09-4837
  Installation and Configuration
  Supplement
IBM DB2 Universal Database                             GC09-4840
  Message Reference, Volume 1
IBM DB2 Universal Database                             GC09-4841
  Message Reference, Volume 2
IBM DB2 Universal Database                             SC09-4830
  Data Movement Utilities
  Guide and Reference
IBM DB2 Universal Database                             SC09-4831
  Data Recovery and High
  Availability Guide and Reference
 
                                                       Order
Title                                                  Number
 
IBM DB2 Universal Database System                      SC09-4847
  Monitor Guide and Reference
IBM DB2 Universal Database                             GC09-4832
  Quick Beginnings for DB2 Clients
IBM DB2 Universal Database                             SC09-4851
  Guide to GUI Tools for
  Administration and Development
IBM DB2 Installing and Administering                   GC09-4823
  a Satellite Environment
IBM DB2 XML Extender Administration                    SC27-1234
  and Programming
IBM DB2 OLAP Server (Spec. Sheet)                      GC26-9311
IBM DB2 Warehouse Manager                              GC26-9309
  (Spec. Sheet)
IBM Business Intelligence Solutions                    GC26-9312
  (Spec. Sheet)
IBM DB2 Spatial Extender User's Guide                  SC27-1226
  and Reference

Technical information

Hardware requirements

For DB2 products running on Intel systems, a Pentium^® central processing unit (CPU), or higher
For AMD systems, an AMD Athlon CPU
For DB2 products running on Linux for S/390 and zSeries, a 9672 G5, or higher, Multiprise^® 3000
For DB2 products running on Solaris, CPUs prior to UltraSparc are not supported.
For DB2 products running on HP-UX, PA-RISC CPU is required
For DB2 on 64-bit Windows and Linux systems, Intel Itanium, or higher, is required.

Memory Requirements: DB2 Clients: 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 192 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  Windows  Linux
 
DB2 Server Editions       256    256     256    256     256
DB2 Personal Edition       64     64      64     64      64
Data Links Manager        N/A    205     205    205     N/A
Net Search Extender        30     30      30     30      30
Spatial Extender           16     16      16     16      16
Int. Miner Modeling       N/A     65      50     40      45
Int. Miner Scoring        N/A     65      60     40      50
Int. Miner Visualization  N/A     10      10     35(1)   10
Warehouse Manager(2)      N/A    512     512    512     N/A
Warehouse Manager(3)      N/A    256     256    256     N/A
 
(1) Includes Java Runtime Environment (JRE).
(2) Development environment:  Heavy GUI usage, minimal
    DWC server and default agent work.
(3) 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 Personal Edition   N/A    N/A      N/A    200     200
DB2 Enterprise Server  450    450      450    350     450
  Edition
DB2 Workgroup Server   450    450      450    350     450
  Edition
DB2 Run-Time Client     60     60       60     30      60
DB2 Administration     125    125      125    110     125
  Client
DB2 Appl. Development  160(1) 160(1)   160(1) 325(2)  160(1)
  Client
Spatial Extender       600(3) 600(3)   600(3) 600(3)  600(3)
Net Search Extender     50     50       50     50      50
Warehouse Manager     1000   1000     1000   1000    1000
 
(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 offerings in this announcement have the following requirements for operating systems:

JRE 1.3.1 is required for running applications and tools in all platforms, except for 64-bit HP-UX and 64-bit Solaris, which require JRE 1.4. JDK 1.3.1 is required to develop applications on all platforms, except 64-bit HP-UX and 64-bit Solaris, which require JDK 1.4.

Windows

Windows 98
Windows ME
Windows NT 4.0 with SP™ 6a, or later, and Internet Explorer 4.01 with SP2^®, or later
Windows 2000 Professional, Standard Server, Advanced Server, and Datacenter Servers
Windows XP (32-bit) Home Edition and Professional Edition
Support for 32-bit Windows .NET and 64-bit Windows .NET operating systems will be provided after these operating systems become generally available. Windows XP 64-bit Professional Edition will also be supported at the same time as Windows .NET 64-bit.

Linux

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

http://www.ibm.com/software/data/db2/linux/validate

AIX

AIX (32-bit) 4.3.3 with maintenance level 9, or later, and APARs IY22308, Y32690, and IY33024
AIX (32-bit) 5.1.0 with maintenance level 2, or later, and APARs IY31254, IY32217, IY32905, and IY33023
AIX (64-bit) 5.1.0 with maintenance level 2, or later, and APARs IY31254, IY32217, IY32905, Y33023, and IY32466
V5.2.0 (32-bit and 64-bit)

HP-UX

HP-UX 11i or later (32-bit and 64-bit) with December 2001 GOLDBASE11i and December 2001 GOLDAPPS11i bundles, patches for Java SDK 1.3.1.
For required patches, refer to:

Solaris

Solaris 7 (32-bit and 64-bit) with Recommended & Security Patches plus patches 107226-17 and 107153-01 from:
Solaris 8 (32-bit and 64-bit) with Recommended & Security Patches plus patches 108921-12 and 108940-24 from:
Solaris 9 (32-bit and 64-bit)

Platform Matrix: DB2 product and component acronyms used in the table that follow:

DB2 UDB Enterprise Server Edition (ESE)
DB2 UDB Personal Edition (PE)
DB2 UDB Workgroup Server Edition (WSE)
DB2 Universal Developer's Edition (UDE)
DB2 Personal Developer's Edition (PDE)
DB2 Data Links Manager (DLM)
DB2 Net Search Extender (NSE)
DB2 Spatial Extender (SPE)
DB2 Intelligent Miner Scoring (IMSC)
DB2 Intelligent Miner Scoring (IMSC)
DB2 Intelligent Miner Modeling (IMMO)
DB2 Intelligent Miner Visualization (IMVI)
Runtime Client (RTC)
Net.Data (ND)
DB2 XML Extender (XML)
DB2 UDB Audio/Image/Video Extender (AIV)
DB2 UDB Text Extender (TE)
DB2 Federated (F)

Support for operating systems by DB2 products and components:

Platform            RTC  PE WSE ESE PDE UDE XML NSE SPE DLM
 
Windows 98           Y   N   N   N   Y   N   N   N   N   N
Windows ME           Y   Y   N   N   Y   N   Y   N   Y   N
Windows XP           Y   Y   Y   N   Y   Y   Y   Y   Y   N
Windows XP 64-bit    Y*  Y*  N   N   Y*  N   N   Y*  Y*  N
Windows NT           Y   Y   Y   Y   Y   Y   Y   Y   Y   Y
Windows 2000         Y   Y   Y   Y   Y   Y   Y   Y   Y   Y
Windows .NET         Y*  Y*  Y*  Y*  Y*  Y*  N   N   Y*  N
Windows .NET 64-bit  Y*  Y*  N   Y*  Y*  Y*  N   Y*  Y*  N
AIX 4.3 32-bit       Y   N   Y   Y   Y   Y   Y   Y   Y   Y
AIX 5L 32-bit        Y   N   Y   Y   Y   Y   Y   Y   Y   Y
AIX 5L 64-bit        Y   N   N   Y   N   Y   N   Y*  Y   N
HP-UX 32-bit         Y   N   Y   Y   N   Y   N   Y*  Y   N
HP-UX 64-bit         Y   N   N   Y   N   Y   N   Y*  Y   N
Solaris 32-bit       Y   N   Y   Y   N   Y   Y   Y   Y   Y
Solaris 64-bit       Y   N   N   Y   N   Y   N   Y*  Y   N
Linux 32-bit         Y   Y   Y   Y   Y   Y   Y   Y   Y   N
Linux Itanium 64-bit Y*  Y*  N   Y*  Y*  Y*  N   Y*  Y*  N
Linux zSeries        Y   N   N   Y   N   Y   N   Y*  Y   N
 
Platform            AIV  TE  ND IMSC IMMO IMVI F
 
Windows ME           N   N   N   N    N    N   N
Windows XP           Y*  Y*  Y   Y    Y    Y   Y
Windows XP 64-bit    N   N   Y*  N    N    N   Y*
Windows NT           Y*  Y*  Y   Y    Y    Y   Y
Windows 2000         Y*  Y*  Y   Y    Y    Y   Y
Windows .NET         N   N   Y*  N    N    N   Y*
Windows .NET 64-bit  N   N   Y*  N    N    N   Y*
AIX 4.3 32-bit       Y*  Y*  Y   Y    Y    Y   Y
AIX 5L 32-bit        Y*  Y*  Y   Y    Y    Y   Y
AIX 5L 64-bit        N   N   Y   N    N    N   Y*
HP-UX 32-bit         Y*  Y*  Y   N    N    N   Y
HP-UX 64-bit         N   N   Y   N    N    N   Y*
Solaris 32-bit       Y*  Y*  Y   Y    Y    Y   Y
Solaris 64-bit       N   N   Y   N    N    N   Y*
Linux 32-bit         N   N   Y   Y    Y    Y   Y
Linux Itanium 64-bit N   N   Y*  N    N    N   N
Linux zSeries        N   N   Y   Y    Y    Y   Y

Key to Table of Warehouse Manager Components:

Platform        WAT ICMM DWCM   ICC WMCW  DWC  WS  WMC
 
Windows 98       N    N    N    Y    N    Y    N    N
Windows NT       Y    Y    Y    Y    Y    Y    Y    Y
Windows 2000     Y    Y    Y    Y    Y    Y    Y    Y
Windows ME       N    N    N    Y    N    Y    N    N
Windows XP 32    Y    Y    Y    Y    Y    Y    Y    Y
Windows XP 64    N    N    N    N    N    N    N    N
Windows .NET     Y*   Y*   Y*   Y*   Y*   Y*   Y*   Y*
Windows .NET 64  N    N    N    N    N    N    N    N
AIX V4 32        Y    Y    Y    Y    Y    Y    Y    N
AIX V4 64        N    N    N    N    N    N    N    N
AIX V5 32        Y    Y    Y    Y    Y    Y    Y    N
AIX V5 64        N    N    N    N    N    N    N    N
HP-UX 11 32      N    N    Y    N    N    N    N    N
HP-UX 11 64      N    N    N    N    N    N    N    N
Solaris 7 32     Y    Y    Y    Y    Y    Y    N    N
Solaris 7 64     N    N    N    N    N    N    N    N
Solaris 8 32     Y    Y    Y    Y    Y    Y    N    N
Solaris 8 64     N    N    N    N    N    N    N    N
Solaris 9 32     Y    Y    Y    Y    Y    Y    N    N
Solaris 9 64     N    N    N    N    N    N    N    N
Linux 32         Y    Y    Y    Y    N    N    N    N
Linux Itanium 64 N    N    N    N    N    N    N    N
Linux zSeries    N    N    N    N    N    N    N    N
iSeries V5R1     Y    Y    N    N    N    N    N    N
iSeries V5R2     Y    Y    N    N    N    N    N    N
OS/390 V2R10     Y    Y    N    N    N    N    N    N
z/OS (all)       Y    Y    N    N    N    N    N    N
 
Note 1: The support for DB2 platform/component combinations
marked with (*) in the tables above will be delivered as
part of the periodic maintenance.
 
Note 2: DPF is not supported on Linux zSeries.
 
Note 3: Using development center, one can only debug Java
stored procedures running on DB2 servers on 32-bit Windows,
AIX, and Solaris operating systems.

Additional Software Requirements by Product

Intelligent Miner Products

DB2 Intelligent Miner Visualization requires JRE 1.3.1 on all platforms except Windows
DB2Intelligent Miner Modeling and DB2 Intelligent Miner Scoring require DB2 V7.2 or DB2 V8.1

Limitations: For known limitations, refer to Part 1 of "Known limitations, problems, and workarounds" section of the DB2 UDB V8 Release Notes at:

http://www.ibm.com/software/data/db2/udb/v8releasenotes.html

Planning information

Agreement: Customers are responsible for determining their license requirements with DB2 Programs. The DB2 license entitlements are by users, processors, and installations.

User Entitlement: There are two methods of counting users of the DB2 product and of determining the required user entitlements. Customers should plan on which of the two methods should be applied to the DB2 server products based on usage requirements, and then obtain additional user entitlements to the extent required. The two methods are counting concurrent users and counting registered users.

The definition of concurrent and registered users is as follows:

Concurrent 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, or other program that connects to DB2 providing access on behalf of other users. When this exception occurs in a DB2 Workgroup Server Edition environment, users cannot be counted properly, so customers must purchase the Connect Unlimited Edition, or Internet Processor license of the Workgroup Edition for Web connection. When these configurations are in use, customers need to consider each concurrent user of that program as a concurrent DB2 user. In the concurrent user model, the customer must ensure that each server is licensed for the maximum number of users that will use that server product at any one time.
The concurrent user licensing model is the only choice in situations where the identity of users is unknown. The concurrent user model is also appropriate where users require only occasional access to a particular server.
Registered Users: A 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 or DB2 Connect product in the customer's enterprise, either directly or through a multiplexing program or application server. Registered users are counted, and DB2 User entitlements are not transferable between products. Customers should compare the total number of users requiring access to the DB2 server product with the sum of user entitlements provided with each install license, and obtain additional user entitlements, if required.
Registered users may be the appropriate choice where there are many users, for example, at client workstations, who need to access databases on multiple database servers, or who connect to databases for long periods of time. Determining required licensing and monitoring the licensing requirements is the responsibility of the customer.

Special Licensing Considerations

Licensing of Standby Servers

In idle standby or active standby, you must acquire correct number of server installs and the correct number of users.

DB2 Workgroup Server Editions

A DB2 Workgroup Server Edition server, when configured with high-availability software solely for use as an idle standby for one or more active DB2 Workgroup Server Edition licenses, customers must obtain one server install. No additional user requirements need to be acquired in the idle standby server. A DB2 Workgroup Server Edition or license installed and used as an active standby server and configured as a backup for one or more other DB2 Workgroup Server Edition server must be licensed for one server install and the number of users accessing the server before failover. Should failover occur, the user licenses from a failed DB2 Workgroup Server Edition are transferred to the active standby machine. Customers must ensure with this transfer of entitlement, the standby backup machine is fully licensed. For example, if the active server is licensed for 50 users and the standby server is licensed for 80 users, after failover, the active standby server is licensed for 130 users.

WSUE, ESE, WHM, DLM, NSE, SPE, IMSC, DPF. These programs, when configured with high-availability software are solely for use as an idle standby for one or more active DB2 Program licenses. Customers need to obtain one processor entitlement for the idle standby machine. When the program is installed and used as an active standby, the program needs to be licensed for the number of processors on the active standby server. For example, if the active standby machine has four processors then you must purchase four licenses.

IMMO, IMSC. In idle standby or active standby, you must acquire the correct number of server installs: In idle standby, you must license the program for one server install. In active standby, you must license the program in the active standby server for one server install.

For specific product restrictions on High Availability/Failover Licensing: This applies to WSE, WSUE, ESE, WHM, DLM, NSE, SPE, IMVI, IMMO, and IMSC. For details on restrictions, refer to the unique license information provided with each product electronically.

DB2 UDB Workgroup Server Edition and DB2 UDB Workgroup Server Unlimited Edition: DB2 UDB Workgroup Server Edition or DB2 UDB Workgroup Server Unlimited Edition license does not permit creating 64-bit instances on servers where the products are installed. DB2 Universal Database Workgroup Server Edition and DB2 Connect Enterprise Edition are not allowed to be installed on the same machine.

Connection Concentrator may not be used with WSE or WSUE. WSUE must be licensed for all processors in the server.

DB2 Warehouse Manager Connectors

DB2 Warehouse Manager Connector for SAP R/3, and DB2 Warehouse Manager Connector for the Web are optional chargeable features of DB2 Warehouse Manager V8.1. Use authorization of each option is required and must be acquired separately. The entitlement of each Warehouse Manager Connector is per install per processor and customers are responsible for acquiring the correct option for the Connector they want to install and use.

Complementary Products

IBM provides licensed copies of complementary products in our product boxes. The Complementary Products can not be upgraded through the originally ordered product, under the terms and conditions of this announcement. They must instead be purchased separately to allow for periodic upgrade under the maintenance. If a fully licensed product is required, contact IBM or your reseller. In addition, complementary products do not entitle customers to receive service support.

To speak to an IBM representative about personal systems software, call 800-IBM-4YOU (426-4968).

DB2 support can be found at:

http://www.ibm.com/software/data/db2/udb/winos2unix/support

All support or advice provided through the above channel is provided on an as-is basis.

For further information on licensing, also refer to:

Planning Information
Usage Restriction
Metric Descriptions
For full details on terms and conditions, refer to the unique license information provided with each product.

Packaging

CEO Bundle: To support our small, medium, and large customers, take advantage of simple per-user pricing and licensing offered with the DB2 for e-business Complete Enterprise Option (CEO) bundle. Updates announced today reflect additions and other adjustments to the bundle.

The CEO bundle now includes the following products:

DB2 UDB Personal Edition
DB2 UDB Workgroup Server Edition (both Server and Users)
DB2 UDB Enterprise Server Edition
DB2 Connect Personal Enterprise
DB2 Connect Enterprise Edition
DB2 Personal Developer's Edition
DB2 Universal Developer's Edition
DB2 Net Search Extender
DB2 Everyplace™ Database Edition
DB2 Everyplace Enterprise Edition

IBM Program Packages include:

DB2 UDB Personal Edition V8.1

Publications

IBM DB2 Universal Database Quick Beginnings for DB2 Personal Edition
Media
Personal Edition Windows 32-bit CD
Personal Edition Windows 64-bit CD (refer to note 1)
Personal Edition Linux 32-bit CD
Personal Edition Linux 64-bit CD (refer to note 1)
IBM Developer Kit, Java Technology for AIX
IBM Developer Kit, Java Technology for HP-UX and Solaris
Distributed Debugger for Java Stored Procedures CD
HTML Documentation CD
PDF Documentation CD
Complementary Products
DB2 Net Search Extender (NSE)
- NSE Windows/AIX/Solaris 32-bit CD
- NSE HP-UX/Linux/Linux for S/390 and zSeries 32-bit and 64-bit CD (refer to note 1)
- Text Extender Windows/AIX/HP-UX/Solaris 32-bit CD (refer to note 1)
Audio, Image, and Video Extenders Windows/AIX/HP-UX/Solaris 32-bit CD (refer to note 1)
DB2 Spatial Extender (SPE)
- SPE Windows/AIX/Linux/HP-UX/Solaris CDs
- Geocoder Data CD
- ESRI Map Data CDs
WebSphere Studio Site Developer Advanced V4.0.3 Trial (refer to note 5)
Distributed Debugger for Java Stored Procedures

DB2 UDB Workgroup Server Edition V8.1

Publications

IBM DB2 Universal Database Quick Beginnings for DB2 Servers
Media
Workgroup Server Edition Windows 32-bit CD
Workgroup Server Edition AIX V4/V5 32-bit CD
Workgroup Server Edition HP-UX 32-bit CD
Workgroup Server Edition Linux 32-bit CD
Workgroup Server Edition Solaris 32-bit CD
Administration Client Windows 32-bit CDs
Administration Client AIX 32-bit CDs
Administration Client HP-UX 32-bit CDs
Administration Client Linux 32-bit CDs
Administration Client Solaris 32-bit CDs
Run-Time Client Windows 32-bit CDs
Run-Time Client AIX/HP-UX/Solaris/ 32-bit CD
Run-Time Client Linux 32-bit CD
IBM Developer Kit, Java Technology for AIX
IBM Developer Kit, Java Technology for HP-UX and Solaris
Distributed Debugger for Java Stored Procedures CD
HTML Documentation CD
PDF Documentation CD
Complementary Products
DB2 Net Search Extender (NSE)
- NSE Windows/AIX/Solaris 32-bit CD
- NSE HP-UX/Linux/Linux for S/390 and zSeries 32-bit and 64-bit CD (refer to note 1)
- Text Extender Windows/AIX/HP-UX/Solaris 32-bit CD (refer to note 1)
Audio, Image, and Video Extenders Windows/AIX/HP-UX/Solaris 32-bit CD (refer to note 1)
DB2 Spatial Extender (SPE)
- SPE Windows/AIX/Linux/HP-UX/Solaris CDs
- Geocoder Data CD
- ESRI Map Data CDs
- Distributed Debugger for Java Stored Procedures
WebSphere Studio Site Developer Advanced V4.0.3 Trial (refer to note 5)
QMF for Windows 60-Day Trial Version
WebSphere MQ 5.3 (refer to note 4)

DB2 UDB Workgroup Server Unlimited Edition V8.1

Publications

IBM DB2 Universal Database Quick Beginnings for DB2 Servers
Media
Workgroup Server Unlimited Edition Windows 32-bit CD
Workgroup Server Unlimited Edition AIX V4/V5 32-bit CD
Workgroup Server Unlimited Edition HP-UX 32-bit CD
Workgroup Server Unlimited Edition Linux 32-bit CD
Workgroup Server Unlimited Edition Solaris 32-bit CD
Administration Client Windows 32-bit CD
Administration Client AIX 32-bit CD
Administration Client HP-UX 32-bit CD
Administration Client Linux 32-bit CD
Administration Client Solaris 32-bit CD
Run-Time Client Windows 32-bit CD
Run-Time Client AIX/HP-UX/Solaris/ 32-bit CD
Run-Time Client Linux 32-bit CD
IBM Developer Kit, Java Technology for AIX
IBM Developer Kit, Java Technology for HP-UX and Solaris
Distributed Debugger for Java Stored Procedures CD
HTML Documentation CD
PDF Documentation CD
Complementary Products
Audio, Image, and Video Extenders Windows/AIX/HP-UX/Solaris 32-bit CD (refer to note 1)
WebSphere Studio Site Developer Advanced V4.0.3 Trial (refer to note 5)
QMF for Windows 60-Day Trial Version
WebSphere MQ 5.3 (refer to note 4)
Distributed Debugger for Java Stored Procedures

DB2 UDB Enterprise Server Edition V8.1

Publications

IBM DB2 Universal Database Quick Beginnings for DB2 Servers
Media
Enterprise Server Edition Windows 32-bit CD
Enterprise Server Edition Windows 64-bit CD (refer to note 1)
Enterprise Server Edition AIX V4 32- and 64-bit CD
Enterprise Server Edition AIX V5 32- and 64-bit CD
Enterprise Server Edition Linux 32-bit CD
Enterprise Server Edition Linux 64-bit CD (refer to note 1)
Enterprise Server Edition Linux for S/390 and zSeries 32-bit CD
Enterprise Server Edition HP-UX 32- and 64-bit CD
Enterprise Server Edition Solaris 32-and 64-bit CD
Administration Client Windows 32-bit CD
Administration Client Windows 64-bit CD (refer to note 1)
Administration Client AIX V4 32- and 64-bit CD
Administration Client AIX V5 32- and 64-bit CD
Administration Client HP-UX 32- and 64-bit CD
Administration Client Solaris 32- and 64-bit CD
Administration Client Linux 32-bit CD
Administration Client Linux 64-bit CD (refer to note 1)
Administration Client Linux for S/390 and zSeries 32-bit CD
Run Time Client Windows 32-bit CD
Run Time Client Windows 64-bit CD (refer to note 1)
Run Time Client AIX V4/HP-UX/Solaris 32- and 64-bit CD
Run Time Client AIX V5 32- and 64-bit CD
Run Time Client Linux 32-bit CD
Run Time Client Linux 64-bit CD (refer to note 1)
Run Time Client Linux for S/390 and zSeries 32-bit CD
IBM Developer Kit, Java Technology for AIX
IBM Developer Kit, Java Technology for HP-UX and Solaris
Distributed Debugger for Java Stored Procedures CD
HTML Documentation CD
PDF Documentation CD
Complementary Products
Audio, Image, and Video Extenders Windows/AIX/HP-UX/Solaris 32-bit CD (refer to note 1)
WebSphere Studio Site Developer Advanced V4.0.3 Trial (refer to note 5)
QMF for Windows 60-Day Trial Version
WebSphere MQ 5.3 (refer to note 4)
Data Management Tools
- DB2 Web Query Tool (Try & Buy) CD
- DB2 Table Editor (Try & Buy) CD
- DB2 High Performance Unload (Try & Buy) CD
- Recovery Expert V1.1 (Try & Buy) CD
- Performance Expert V.1 (Try & Buy) CD
- Distributed Debugger for Java Stored Procedures

DB2 Personal Developer's Edition V8.1

Publications

IBM DB2 Universal Database Quick Beginnings for DB2 Personal Edition
IBM DB2 Connect Quick Beginnings for DB2 Connect Personal Edition
Media
Personal Edition Windows 32-bit CD
Personal Edition Windows 64-bit CD (refer to note 1)
Personal Edition Linux 32-bit CD
Personal Edition Linux 64-bit CD (refer to note 1)
Connect Personal Edition Windows 32-bit CD
Connect Personal Edition Windows 64-bit CD (refer to note 1)
Connect Personal Edition Linux 32-bit CD
Connect Personal Edition Linux 64-bit CD (refer to note 1)
Application Development Client Windows 32-bit CD
Application Development Client Windows 64-bit CD
Application Development Client AIX V4 32- and 64-bit CD
Application Development Client AIX V5 32- 64-bit CD
Application Development Client Linux 32-bit CD
Application Development Client Linux 64-bit CD
Application Development Client Linux for S/390 and zSeries 32-bit CD
Application Development Client HP-UX 32- and 64-bit CD
Application Development Client Solaris 32- and 64-bit CD
IBM Developer Kit, Java Technology for AIX
IBM Developer Kit, Java Technology for HP-UX and Solaris
Distributed Debugger for Java Stored Procedures CD
HTML Documentation CD
PDF Documentation CD
Complementary Products
DB2 Net Search Extender (NSE)
- NSE Windows/AIX/Solaris 32-bit CD
- NSE HP-UX/Linux/Linux for S/390 and zSeries 32-bit and 64-bit CD (refer to note 1)
- Text Extender Windows/AIX/HP-UX/Solaris 32-bit CD (refer to note 1)
Audio, Image, and Video Extenders Windows/AIX/HP-UX/Solaris 32-bit CD (refer to note 1)
DB2 Spatial Extender (SPE)
- SPE Windows/AIX/Linux/HP-UX/Solaris CDs
- Geocoder Data CD
- ESRI Map Data CDs
WebSphere Studio Site Developer Advanced V4.0.3 Trial (refer to note 5)
Borland products CD (30-day trial):
- Borland Delphi Enterprise
- Borland C++ Builder Enterprise
- Borland Kylix Enterprise
- Distributed Debugger for Java Stored Procedures

DB2 Universal Developer's Edition V8.1 (5765-F34)

Publications

IBM DB2 Application Development Guide: Building and Running Applications
Media
Personal Edition Windows 32-bit CD
Personal Edition Windows 64-bit CD (refer to note 1)
Personal Edition Linux 32-bit CD
Personal Edition Linux 64-bit CD (refer to note 1)
Workgroup Server Edition Windows 32-bit CD
Workgroup Server Edition AIX V4/V5 32-bit CD
Workgroup Server Edition HP-UX 32-bit CD
Workgroup Server Edition Linux 32-bit CD
Workgroup Server Edition Solaris 32-bit CD
Enterprise Server Edition Windows 32-bit CD
Enterprise Server Edition Windows 64-bit CD (refer to note 1)
Enterprise Server Edition AIX V4 32- and 64-bit CD
Enterprise Server Edition AIX V5 32- and 64-bit CD
Enterprise Server Edition HP-UX 32- and 64-bit CD
Enterprise Server Edition Linux 32-bit CD
Enterprise Server Edition Linux 64-bit CD (refer to note 1)
Enterprise Server Edition Linux for S/390 and zSeries 32-bit CD
Enterprise Server Edition Solaris 32- and 64-bit CD
Connect Personal Edition Windows 32-bit CD
Connect Personal Edition Windows 64-bit CD (refer to note 1)
Connect Personal Edition Linux 32-bit CD
Connect Personal Edition Linux 64-bit CD (refer to note 1)
Connect Enterprise Edition Windows 32-bit CD
Connect Enterprise Edition Windows 64-bit CD (refer to note 1)
Connect Enterprise Edition AIX V4 32- and 64-bit CD
Connect Enterprise Edition AIX V5 32- and 64-bit CD
Connect Enterprise Edition HP-UX 32- and 64-bit CD
Connect Enterprise Edition Linux 32-bit CD
Connect Enterprise Edition Linux 64-bit CD (refer to note 1)
Connect Enterprise Edition Linux for S/390 and zSeries 32-bit CD
Connect Enterprise Edition Solaris 32- and 64-bit CD
Data Links Manager Windows 32-bit CD
Data Links Manager AIX 32-bit CD
Data Links Manager Solaris 32-bit CD
Warehouse Manager Windows 32-bit CD
Warehouse Manager AIX V4 32-bit CD
Warehouse Manager AIX V5 32-bit CD
Warehouse Manager Linux 32-bit CD
Warehouse Manager Solaris 32- bit CD
Warehouse Manager iSeries CD
Warehouse Manager Connectors Windows 32-bit CD
Warehouse Manager Connectors AIX V4 32-bit CD
Warehouse Manager Connectors AIX V5 32-bit CD
Warehouse Manager Connectors Solaris 32-bit CD
Spatial Extender Windows 32-bit CD
Spatial Extender AIX 32-bit CD
Spatial Extender Linux 32-bit CD
Spatial Extender Linux for S/390 and zSeries 32-bit CD
Spatial Extender HP-UX 32-bit CD
Spatial Extender Solaris 32-bit CD
Geocoder Data CD
ESRI Map Data CD
Administration Client Windows 32-bit CD
Administration Client Windows 64-bit CD (refer to note 1)
Administration Client AIX V4 32- and 64-bit CD
Administration Client AIX V5 32- and 64-bit CD
Administration Client HP-UX 32- and 64-bit CD
Administration Client Linux 32-bit CD
Administration Client Linux 64-bit CD (refer to note 1)
Administration Client Linux for S/390 and zSeries 32-bit CD
Administration Client Solaris 32- and 64-bit CD
Run Time Client Windows 32-bit CD
Run Time Client Windows 64-bit CD (refer to note 1)
Run Time Client AIX V4/HP-UX/Solaris 32- and 64-bit CD
Run Time Client AIX V5 32- and 64-bit CD
Run Time Client Linux 32-bit CD
Run Time Client Linux 64-bit CD (refer to note 1)
Run Time Client Linux for S/390 and zSeries 32-bit CD
Application Development Client Windows 32-bit CD
Application Development Client Windows 64-bit CD
Application Development Client AIX V4 32- and 64-bit CD
Application Development Client AIX V5 32- and 64-bit CD
Application Development Client HP-UX 32- and 64-bit CD
Application Development Client Linux 64-bit CD
Application Development Client Linux for S/390 and zSeries 32-bit CD 64-bit CD
Application Development Client Solaris 32- and 64-bit CD
Intelligent Miner Scoring Windows/AIX/Solaris/Linux 32-bit CD
Intelligent Miner Modeling Windows/AIX/Solaris/Linux 32-bit CD
Intelligent Miner Visualization Windows/AIX/Solaris/Linux 32-bit CD
IBM Developer Kit, Java Technology for AIX
IBM Developer Kit, Java Technology for HP-UX and Solaris
Distributed Debugger for Java Stored Procedures CD
HTML Documentation CD
PDF Documentation CD
Complementary Products
DB2 Net Search Extender (NSE)
- NSE Windows/AIX/Solaris 32-bit CD
- NSE HP-UX/Linux/Linux for S/390 and zSeries 32-bit and 64-bit CD (refer to note 1)
- Text Extender Windows/AIX/HP-UX/Solaris 32-bit CD (refer to note 1)
Audio, Image, and Video Extenders Windows/AIX/HP-UX/Solaris 32-bit CD (refer to note 1)
DB2 Spatial Extender (SPE)
- SPE Windows/AIX/Linux/HP-UX/Solaris CDs
- Geocoder Data CD
- ESRI Map Data CDs
WebSphere Studio Site Developer Advanced V4.0.3 Trial (refer to note 5)
QMF for Windows for DB2 Workstations Databases
QMF for Windows for iSeries
WebSphere MQ 5.3 (refer to note 4)
Data Management Tools
- DB2 Web Query Tool for Multiplatforms (Full Function Unrestricted) CD
- DB2 Table Editor for Multiplatforms (Full Function Unrestricted) CD
WebSphere Application Server Advanced for Developers V4 (refer to notes 2, 3, 4)
DB2 Everyplace SDK
Borland products CD (30-day trial):
- Borland Delphi Enterprise
- Borland C++ Builder Enterprise
- Borland Kylix Enterprise
- Distributed Debugger for Java Stored Procedures

DB2 Warehouse Manager, V8.1

Publications

IBM DB2 Warehouse Manager Installation Guide
Media
Warehouse Manager Windows 32-bit CD
Warehouse Manager AIX V4/V5 32-bit CD
Warehouse Manager Solaris 32-bit CD
Warehouse Manager iSeries CD
Warehouse Manager Connectors Windows 32-bit CD
Warehouse Manager Connectors AIX 32-bit CD
Warehouse Manager Connectors Solaris 32-bit CD
Warehouse Manager Linux 32-bit CD
Enterprise Server Edition Windows 32-bit CD
Enterprise Server Edition AIX V4 32-bit CD
Enterprise Server Edition AIX V5 32-bit CD
IBM Developer Kit, Java Technology for AIX
IBM Developer Kit, Java Technology for HP-UX and Solaris
HTML Documentation CD
PDF Documentation CD
Complementary Products
QMF for Windows for DB2 Workstations Databases
QMF for Windows for iSeries

DB2 Data Links Manager

Publications

IBM DB2 Universal Database Quick Beginnings for Data Links Manager
Media
Data Links Manager Windows 32-bit CD
Data Links Manager AIX 32-bit CD
Data Links Manager Solaris 32-bit CD
IBM Developer Kit, Java Technology Edition for HP-UX and Solaris
IBM Developer Kit, Java Technology Edition for AIX
HTML Documentation CD
PDF Documentation CD

DB2 Net Search Extender V8.1

Publications

DB2 Net Search Extender Administration and Programming
Media
Net Search Extender Windows/AIX/Solaris/Linux/Linux for S/390 and zSeries 32-bit CD
Net Search Extender Windows/AIX/Solaris 32-bit CD
NSE HP-UX/Linux/Linux for S/390 and zSeries 32-bit and 64-bit CD (refer to note 1)
Text Extender Windows/AIX/HP-UX/Solaris 32-bit CD (refer to note 1)

DB2 Spatial Extender V8.1

Publications

IBM DB2 Spatial Extender User's Guide and Reference
Media
Spatial Extender Windows 32-bit CD
Spatial Extender AIX 32-bit CD
Spatial Extender HP-UX 32-bit CD
Spatial Extender Linux 32-bit CD
Spatial Extender Linux for S/390 and zSeries 32-bit CD
Spatial Extender Solaris 32-bit CD
Geocoder Data CD
ESRI Map Data CD
HTML Documentation CD
PDF Documentation CD

DB2 Intelligent Miner Scoring V8.1

Publications

IBM DB2 Intelligent Miner Scoring Administration and Programming for DB2
IBM Intelligent Miner Scoring Administration and Programming for Oraclei8
Media
Intelligent Miner Scoring Windows/AIX/Solaris/Linux/Linux for S/390 and zSeries 32-bit

DB2 Intelligent Miner Modeling V8.1

Publications

DB2 Intelligent Miner Modeling Application Programming Guide
Media
Intelligent Miner Modeling Windows/AIX/Solaris/Linux/Linux for S/390 and zSeries 32-bit CD

DB2 Intelligent Miner Visualization V8.1

Publications

IBM DB2 Intelligent Miner Visualizing User's Guide
Media
Intelligent Miner Visualization Windows/AIX/Solaris/Linux/Linux for S/390 and zSeries 32-bit

Documentation Packages

DB2 UDB Personal Edition V8.1 Documentation Pack English

IBM DB2 Universal Database What's New V8
IBM DB2 Universal Database Administration Guide: Planning

DB2 UDB Workgroup Server Edition V8.1 Documentation Pack

English

IBM DB2 Universal Database What's New V8
IBM DB2 Universal Database Administration Guide: Planning
IBM DB2 Universal Database SQL Reference, Volume 1
IBM DB2 Universal Database SQL Reference, Volume 2

DB2 UDB Enterprise Server Edition V8.1 Documentation Pack

English

IBM DB2 Universal Database What's New V8
IBM DB2 Universal Database Administration Guide: Planning
IBM DB2 Universal Database Administration Guide: Performance
IBM DB2 Universal Database Administration Guide: Implementation
IBM DB2 Universal Database SQL Reference, Volume 1
IBM DB2 Universal Database SQL Reference, Volume 2
IBM DB2 Universal Database Command Reference
IBM DB2 Universal Database Administrative API Reference

DB2 Personal Developer's Edition V8.1 Documentation Pack

English

IBM DB2 Universal Database What's New V8
IBM DB2 Universal Database SQL Reference, Volume 1
IBM DB2 Universal Database SQL Reference, Volume 2
IBM DB2 Universal Database Application Development Guide: Building and Running Applications
IBM DB2 Universal Database Application Development Guide: Programming Client Applications
IBM DB2 Universal Database Call Level Interface Guide and Reference, Volume 1
IBM DB2 Universal Database Call Level Interface Guide and Reference, Volume 2
IBM DB2 Universal Database Data Warehouse Center Administration Guide
IBM DB2 Universal Database Replication Guide and Reference
IBM DB2 Universal Database XML Extender Administration and Programming

DB2 Universal Developer's Edition V8.1 Documentation Pack

English

IBM DB2 Universal Database What's New V8
IBM DB2 Universal Database SQL Reference, Volume 1
IBM DB2 Universal Database SQL Reference, Volume 2
IBM DB2 Universal Database Application Development Guide: Building and Running Applications
IBM DB2 Universal Database Application Development Guide: Programming Client Applications
IBM DB2 Universal Database Call Level Interface Guide and Reference, Volume 1
IBM DB2 Universal Database Call Level Interface Guide and Reference, Volume 2
IBM DB2 Universal Database Data Warehouse Center Administration Guide
IBM DB2 Universal Database Replication Guide and Reference
IBM DB2 Universal Database XML Extender Administration and Programming

DB2 Warehouse Manager V8.1 Documentation Pack

English

IBM DB2 Universal Database Data Warehouse Center Administration Guide
IBM DB2 Universal Database Data Warehouse Center Application Integration Guide
IBM DB2 Warehouse Manager Information Catalog Center Administration Guide

DB2 Data Links Manager V8.1 Documentation Pack

English

IBM DB2 Universal Database Data Links Manager Administration Guide and Reference

Notes

The CDs marked with (refer to note 1) in the section above will not be available on the date of general availability. These CDs will be delivered at a future date.
WebSphere Application Server Advanced for Developers V4 will be replaced with WebSphere Application Server Advanced for Developers V5 when it is available.
If installing WebSphere Application Server Advanced for Developers V4 obtain latest service from:
Install the latest Fixpack to comply with U.S. Accessibility Requirements.
WebSphere Studio Site Developer Advanced V4.0.3 Trial will be replaced with WebSphere Studio Site Developer V5, when it is available.

This program, when downloaded from a Web site, contains the applicable IBM license agreement and License Information (LI), if appropriate, and will be presented for acceptance at the time of installation of the program. The license and LI will be stored in a directory such as LICENSE.TXT for future reference.

Security, auditability, and control

DB2 Universal Database uses the security and auditability feature of the host software: Password protection.

The customer is responsible for evaluation, selection, and implementation of security features, administrative procedures, and appropriate controls in application systems and communication facilities.

Back to top

Ordering information

Use the table below to determine the required license entitlements for each product, and for further interpretation, refer to the descriptions of the metrics following the table.

Product                                      Metrics
 
DB2 UDB Personal Edition                     Install
 
DB2 UDB Workgroup Server                     Install, User
 Edition
 
DB2 UDB Workgroup Server                     Processor
 Unlimited Edition
 
DB2 UDB Enterprise                           Processor
 Server Edition
 
DB2 Data Links Manager                       Processor
 
DB2 Net Search Extender                      Processor
 
Product                                      Metrics
 
DB2 Spatial Extender                         Processor
 
DB2 Warehouse Manager                        Processor
 
DB2 Personal Developer's                     Install
 Edition
 
DB2 Universal Developer's                    Install
 Edition
 
DB2 Intelligent Miner Scoring                Processor
 
DB2 Intelligent Miner Modeling               Install
 
DB2 Intelligent Miner Visualization          Install

Metric Descriptions

Processors
- Each CPU available to the installed software must have a separate entitlement.
Users
- They can be counted as either concurrent user or registered user.
  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 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.

Build-to-Plan (BTP) Offering

DB2 UDB Workgroup Server Edition V8.1

                                                            Part
Program Name                                                Number
 
Media Packs
 
English                                                     BB06WNA
 
Doc Packs
 
English                                                     BB06XNA

DB2 UDB Workgroup Server Unlimited Edition V8.1

                                                            Part
Program Name                                                Number
 
Media Packs
 
English                                                     BB09ZNA
 
Doc Packs
 
English                                                     BB0A0NA

DB2 UDB Enterprise Server Edition V8.1

                                                            Part
Program Name                                                Number
 
Media Packs
 
English                                                     BB0ABNA
 
Doc Packs
 
English                                                     BB0ADNA

DB2 Warehouse Manager V8.1

                                                            Part
Program Name                                                Number
 
Media Packs
 
English                                                     BB09VNA
 
Doc Packs
 
English                                                     BB09WNA

DB2 Data Links Manager V8.1

                                                            Part
Program Name                                                Number
 
Media Packs
 
English                                                     BB09TNA
 
Doc Packs
 
English                                                     BB09UNA

DB2 Spatial Extender V8.1

                                                            Part
Program Name                                                Number
 
Media Packs
 
English                                                     BB09XNA

DB2 Net Search Extender V8.1

                                                            Part
Program Name                                                Number
 
Media Packs
 
English                                                     BB09RNA

DB2 Personal Developer's Edition

                                                            Part
Program Name                                                Number
 
Media Packs
 
English                                                     BB09PNA
 
Doc Packs
 
English                                                     BB09QNA

DB2 Universal Developer's Edition V8.1

                                                            Part
Program Name                                                Number
 
Media Packs
 
English                                                     BB09LNA
 
Doc Packs
 
English                                                     BB09MNA

DB2 Intelligent Miner Scoring V8.1

                                                            Part
Program Name                                                Number
 
Media Packs
 
English                                                     BB0A7NA

DB2 Intelligent Miner Modeling V8.1

                                                            Part
Program Name                                                Number
 
Media Packs
 
English                                                     BB0AANA

DB2 Intelligent Miner Visualization V8.1

                                                            Part
Program Name                                                Number
 
Media Packs
 
English                                                     BB0ACNA

                                                            Passport
                                                            Advantage
                                                            Part
Description                                                 Number
 
Passport Advantage -- New SKUs
 
DB2 UDB Workgroup Server Unlimited                          D51NDLL
 Ed Processor LIC/SW MAINT 1 ANNIV
DB2 UDB Workgroup Server Unlimited                          D51NELL
 Ed Processor LIC/SW MAINT 2 ANNIV
DB2 UDB Workgroup Server Unlimited                          E00IHLL
 Ed Processor SW MAINT RNWL 1 ANNIV
DB2 UDB Workgroup Server Unlimited                          D51NFLL
 Ed Processor SW MAINT AFT LIC 1 ANNIV
DB2 UDB Enterprise Server Edition                           D518GLL
 Processor LIC/SW MAINT  1 ANNIV
DB2 UDB Enterprise Server Edition                           D518HLL
 Processor LIC/SW MAINT  2 ANNIV
DB2 UDB Enterprise Server Edition                           E00BILL
 Processor SW MAINT RNWL 1 ANNIV
DB2 UDB Enterprise Server Edition                           D518ILL
 Processor SW MAINT AFT LIC 1 ANNIV
DB2 ESE Processor From DB2 ESE Restricted                   D51QHLL
 Use TRD LIC/SW MAINT 1 ANNIV
DB2 ESE Processor From WKGUNLTD                             D51QILL
 Processor TRD LIC/SW MAINT 1 ANNIV
DB2 ESE zSeries Proc From DB2 ESE zSeries                   D51QJLL
 Restricted Use Trd/Lic/SWM
DB2 Enterprise Server ED Proc for zSeries                   D51NALL
 (S/390) LIC/SW MAINT 1 ANNIV
DB2 Enterprise Server ED Proc for zSeries                   D51NBLL
 (S/390) LIC/SW MAINT 2 ANNIV
DB2 Enterprise Server ED Proc for zSeries                   E00IGLL
 (S/390) SW MAINT RNWL 1 ANNIV
DB2 Enterprise Server ED Proc for zSeries                   D51NCLL
 (S/390) SW MAINT AFT LIC 1 ANNIV
DB2 UDB Entp Svr Ed Dbse Partitioning Ftr                   D518JLL
 Pro LIC/SW MAINT  1 ANNIV
DB2 UDB Entp Svr Ed Dbse Partitioning Ftr                   D518KLL
 Pro LIC/SW MAINT  2 ANNIV
DB2 UDB Entp Svr Ed Dbse Partitioning Ftr                   E00BJLL
 Pro SW MAINT RNWL 1 ANNIV
DB2 UDB Entp Svr Ed Dbse Partitioning Ftr                   D518LLL
 Pro SW MAINT AFT LIC 1 ANNIV
DB2 Intelligent Miner Modeling Server                       D518BLL
 LIC/SW MAINT 1 ANNIV
DB2 Intelligent Miner Modeling Server                       D518DLL
 LIC/SW MAINT 2 ANNIV
DB2 Intelligent Miner Modeling Server                       E00BHLL
 SW MAINT RNWL 1 ANNIV
DB2 Intelligent Miner Modeling Server                       D518FLL
 SW MAINT AFT LIC 1 ANNIV
DB2 Intelligent Miner Visualization Server                  D518ALL
 LIC/SW MAINT 1 ANNIV
DB2 Intelligent Miner Visualization Server                  D518CLL
 LIC/SW MAINT 2 ANNIV
DB2 Intelligent Miner Visualization Server                  E00BGLL
 SW MAINT RNWL 1 ANNIV
DB2 Intelligent Miner Visualization Server                  D518ELL
 SW MAINT AFT LIC 1 ANNIV
 
Existing Passport Advantage SKUs
 
DB2 UDB Personal Edition Install                            D5B69LL
 LIC/SW MAINT 1 ANNIV
DB2 UDB Personal Edition Install                            D5B6ALL
 LIC/SW MAINT 2 ANNIV
DB2 UDB Personal Edition Install                            E1B6BLL
 SW MAINT RNWL 1 ANNIV
DB2 UDB Personal Edition Install S                          D5B6CLL
 SW MAINT AFT LIC 1 ANNIV
DB2 Personal Developer's Edition Install                    D5B4QLL
 LIC/SW MAINT 1 ANNIV
DB2 Personal Developer's Edition Install                    D5B4RLL
 LIC/SW MAINT 2 ANNIV
DB2 Personal Developer's Ed fr Personal                     D5B4SLL
 
 Ed Instl TRD/LIC/SW MAINT 1 ANNIV
DB2 Personal Developer's Edition Install                    E1B4TLL
 SW MAINT RNWL 1 ANNIV
DB2 Personal Developer's Edition Install                    D5B4ULL
 SW MAINT AFT LIC 1 ANNIV
DB2 UDB Workgroup Server Edition User                       D5B77LL
 LIC/SW MAINT 1 ANNIV
DB2 UDB Workgroup Server Edition User                       D5B78LL
 LIC/SW MAINT 2 ANNIV
DB2 UDB Workgroup Server Edition User                       E1B79LL
 SW MAINT RNWL 1 ANNIV
DB2 UDB Workgroup Server Edition User                       D5B7ALL
 SW MAINT AFT LIC 1 ANNIV
DB2 UDB Workgroup Server Edition Server                     D5B7FLL
 LIC/SW MAINT 1 ANNIV
DB2 UDB Workgroup Server Edition Server                     D5B7GLL
 LIC/SW MAINT 2 ANNIV
DB2 UDB Workgroup Server Edition Server                     E1B7HLL
 SW MAINT RNWL 1 ANNIV
DB2 UDB Workgroup Server Edition Server                     D5B7ILL
 SW MAINT AFT LIC 1 ANNIV
DB2 Universal Developer's Edition Install                   D5B4ZLL
 LIC/SW MAINT 1 ANNIV
DB2 Universal Developer's Edition Install                   D5B50LL
 LIC/SW MAINT 2 ANNIV
DB2 Universal Developer's Edition Install                   E1B51LL
 SW MAINT RNWL 1 ANNIV
DB2 Universal Developer's Edition Install                   D5B52LL
 SW MAINT AFT LIC 1 ANNIV
DB2 Universal Dev.Ed. Instl for zSeries                     D50NDLL
 (S/390) LIC/SW MAINT 1 ANNIV
DB2 Universal Dev.Ed. Instl for zSeries                     D50NELL
 (S/390) LIC/SW MAINT 2 ANNIV
DB2 Universal Dev.Ed. Instl for zSeries                     E005HLL
 (S/390) SW MAINT RNWL 1 ANNIV
DB2 Universal Dev.Ed. Instl for zSeries                     D50NFLL
 (S/390) SW MAINT AFT LIC 1 ANNIV
DB2 Data Links Manager Processor                            D5ARFLL
 LIC/SW MAINT 1 ANNIV
DB2 Data Links Manager Processor                            D5ARGLL
 LIC/SW MAINT 2 ANNIV
DB2 Data Links Manager Processor                            E1ARHLL
 SW MAINT RNWL 1 ANNIV
DB2 Data Links Manager Processor                            D5ARILL
 SW MAINT AFT LIC 1 ANNIV
DB2 Net Search Extender Processor                           D5ASKLL
 LIC/SW MAINT 1 ANNIV
DB2 Net Search Extender Processor                           D5ASLLL
 LIC/SW MAINT 2 ANNIV
DB2 Net Search Extender Processor                           E1ASMLL
 SW MAINT RNWL 1 ANNIV
DB2 Net Search Extender Processor                           D5ASNLL
 SW MAINT AFT LIC 1 ANNIV
DB2 Warehouse Manager Processor                             D5ATYLL
 LIC/SW MAINT 1 ANNIV
DB2 Warehouse Manager Processor                             D5ATZLL
 LIC/SW MAINT 2 ANNIV
DB2 Warehouse Manager Processor                             E1AU0LL
 SW MAINT RNWL 1 ANNIV
DB2 Warehouse Manager Processor                             D5AU1LL
 SW MAINT AFT LIC 1 ANNIV
DB2 Warehouse Manager SAP Connector                         D5C7TLL
 Install LIC/SW MAINT 1 ANNIV
DB2 Warehouse Manager SAP Connector                         D5C7ULL
 Install LIC/SW MAINT 2 ANNIV
DB2 Warehouse Manager SAP Connector                         E1C7VLL
 Install SW MAINT RNWL 1 ANNIV
DB2 Warehouse Manager SAP Connector                         D5C7WLL
 Install SW MAINT AFT LIC 1 ANNIV
DB2 Warehouse Manager Web Connector                         D5C89LL
 Install LIC/SW MAINT 1 ANNIV
DB2 Warehouse Manager Web Connector                         D5C8ALL
 Install LIC/SW MAINT 2 ANNIV
DB2 Warehouse Manager Web Connector                         E1C8BLL
 Install SW MAINT RNWL 1 ANNIV
DB2 Warehouse Manager Web Connector                         D5C7WLL
 Install SW MAINT AFT LIC 1 ANNIV
DB2 Spatial Extender Processor                              D5ATQLL
 LIC/SW MAINT 1 ANNIV
DB2 Spatial Extender Processor                              D5ATRLL
 LIC/SW MAINT 2 ANNIV
DB2 Spatial Extender Processor                              E1ATSLL
 SW MAINT RNWL 1 ANNIV
DB2 Spatial Extender Processor                              D5ATTLL
 SW MAINT AFT LIC 1 ANNIV
Intelligent Miner Scoring Processor                         D5CVDLL
 LIC/SW MAINT 1 ANNIV
Intelligent Miner Scoring Processor                         D5CVELL
 LIC/SW MAINT 2 ANNIV
Intelligent Miner Scoring Processor                         E1CVFLL
 SW MAINT RNWL 1 ANNIV
Intelligent Miner Scoring Processor                         D5CVGLL
 SW MAINT AFT LIC 1 ANNIV
 
CEO Bundle
 
DB2 FOR EBUSINESS USER CEO                                  D5BISLL
 LIC/SW MAINT 1 ANNIV
DB2 FOR EBUSINESS USER CEO                                  D5BIRLL
 LIC/SW MAINT 2 ANNIV
DB2 FOR EBUSINESS USER CEO                                  D5BIPLL
 SW MAINT AFT LIC 1 ANNIV
DB2 FOR EBUSINESS USER CEO                                  E1BIQLL
 SW MAINT RNWL 1 ANNIV
DB2 FOR EBUSINESS USER CEO                                  D5BIMLL
 TRD/LIC/SW/MAINT 1 ANNIV
DB2 FOR EBUSINESS USER CEO                                  D5BINLL
 COMTRD/LIC/SW/MAINT 1

Passport Advantage Customer Media Pack Entitlement Details: Customers with active Maintenance or subscription for the products listed below are entitled to receive the corresponding media pack.

Passport Advantage subscription entitlement table from Enablement SPOC.

DB2 UDB Personal Edition V8.1 Media Pack

                                             Part
Description                                  Number
 
English                                      BB06UNA
French                                       BB06UFR
German                                       BB06UDE
Spanish                                      BB06UES
Italian                                      BB06UIT
Brazilian Portuguese                         BB06UBP
Danish                                       BB06UDA
Finnish                                      BB06UFI
Norwegian                                    BB06UNO
Swedish                                      BB06USV
 
                                             Part
Description                                  Number
 
Polish                                       BB06UPL
Japanese                                     BB06UJA
Korean                                       BB06UKO
Simplified Chinese                           BB06USC
Traditional Chinese                          BB06UTC