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)

Table of contents   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

 
Back to top
 
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.

 
Back to top
 
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 eServer 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 eServer 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)

 
Back to top
 
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:

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.

 
Back to top
 
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:

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:

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

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

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.

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:

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.

 
Back to top
 
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:

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

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:


 
Back to top
 
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:

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:

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

 
Back to top
 
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:

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

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:


    WAT = Warehouse Agent and Transformers
    ICMM = Information Catalog Manager Metadata
    DWCM = Data Warehouse Center Metadata
    ICC = Information Catalog Center GUI
    WMCW = Warehouse Manager Connnector for the Web
    DWC = Data Warehouse Center GUI
    WS = Warehouse Server
    WMCS = Warehouse Manager Connector for SAP

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:

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:

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

  1. 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.
  2. WebSphere Application Server Advanced for Developers V4 will be replaced with WebSphere Application Server Advanced for Developers V5 when it is available.
  3. If installing WebSphere Application Server Advanced for Developers V4 obtain latest service from:
  4. Install the latest Fixpack to comply with U.S. Accessibility Requirements.
  5. 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

Entitled Maintenance Offerings Description

    CEODB2PERED
    DB2SATLT
    UDBPRSED

DB2 UDB Workgroup Server Edition V8.1 Media Pack

                                             Part
Description                                  Number
 
English                                      BB09ZNA
French                                       BB09ZFR
German                                       BB09ZDE
Brazilian Portuguese                         BB09ZBP
Danish                                       BB09ZDA
Finnish                                      BB09ZFI
Norwegian                                    BB09ZNO
Swedish                                      BB09ZSV
Russian                                      BB09ZRU
Polish                                       BB09ZPL
Japanese                                     BB09ZJA
Korean                                       BB09ZKO
Simplified Chinese                           BB09ZSC
Traditional Chinese                          BB09ZTC

Entitled Maintenance Offerings Description


    CEO DB2 WORKGROUP SERVER
    CEO DB2 WORKGROUP USER
    IBM DB2 UDB WKGRP ED USR
    IBM DB2 UDB WKGRP ED SVRN INTERNET
    DB2 UDB WORKGROUP DOM/NOTES

DB2 UDB Workgroup Server Unlimited Edition V8.1 Media Pack

                                             Part
Description                                  Number
 
English                                      BB09KNA
French                                       BB09ZFR
German                                       BB09ZDE
Brazilian Portuguese                         BB09ZBP
Danish                                       BB09ZDA
Finnish                                      BB09ZFI
Norwegian                                    BB09ZNO
Swedish                                      BB09ZSV
Russian                                      BB09ZRU
Polish                                       BB09ZPL
Japanese                                     BB09ZJA
Korean                                       BB09ZKO
Simplified Chinese                           BB09ZSC
Traditional Chinese                          BB09ZTC

Entitled Maintenance Offerings Description


    DB2 UDB WORKGROUP EDITION INTERNETR
    DB2 UDB WORKGROUP SVR UNLTD PROC
    IBM DB2 WORKGROUP UNLIMITED ED SRVR
    IBM DB2 WRKGRP UNLMTD ED UNLTD USER

DB2 UDB Enterprise Server Edition V8.1 Media Pack

                                             Part
Description                                  Number
 
English                                      BB0ABNA
French                                       BB0ABFR
German                                       BB0ABDE
Spanish                                      BB0ABES
Brazilian Portuguese                         BB0ABBP
Russian                                      BB0ABRU
Polish                                       BB0ABPL
Danish                                       BB0ABDA
Finnish                                      BB0ABFI
Norwegian                                    BB0ABNO
Swedish                                      BB0ABSV
Japanese                                     BB0ABJA
Korean                                       BB0ABKO
Simplified Chinese                           BB0ABSC
Traditional Chinese                          BB0ABTC

Entitled Maintenance Offerings Description


    CEO DB2 UDB EE USERENTPR SVR PROC
    CEO VISUAL WAREHOUSEP SCL FEAT PROC
    DB2 UNIVERSL DBASE ENTPR SVR PROC
    DB2 UNV DB ENT SV DB PRT FEAT PROC
    DB2 ENTERPRISE SVR ZSERIES PROC
    DB2 UNIV DB ENTPR LNX S/390 PROC
    IBM DB2 UDB ENT ED 1 PROC SVR
    IBM DB2 UDB ENTED 4FR1 PROC S
    IBM DB2 UDB ENTED 8FR1 PROC S
    DB2 UDB EE ADD'L PROC ENTC SV
    INM ENTERPRISE EXT ED 1 PROC
    IBM DB2 UDB EEE 24FR4 PROC SV
    IBM ENTERPRISE EXT ED 4 F 1ROC
    DB2 UDB EEE ADD'L PROC ENT
    DB2 UDB ENT EXT ED NUMA-Q PROC
    DB2 UDB ENT ED NUMA-Q PROC ED
    VIS WHSE SVR INST COGNOS ED
    VIS WHSE SVR INST BUS OBJS ED
    VIS WHSE SVR INST COGNOS ED
    VIS WHSE OLAP SVR INST

DB2 UDB Personal Developer's Edition V8.1 Media Pack

                                             Part
Description                                  Number
 
English                                      BB09PNA
French                                       BB09PFR
German                                       BB09PDE
Spanish                                      BB09PES
Japanese                                     BB09PJA
Korean                                       BB09PKO
Simplified Chinese                           BB09PSC
Traditional Chinese                          BB09PTC

Entitled Maintenance Offerings Description


    IBM DB2 PERS DEV ED

DB2 Universal Developer's Edition V8.1 Media Pack

                                             Part
Description                                  Number
 
English                                      BB09LNA
French                                       BB09LFR
German                                       BB09LDE
Spanish                                      BB09LES
Japanese                                     BB09LJA
Korean                                       BB09LKO
Simplified Chinese                           BB09LSC
Traditional Chinese                          BB09LTC

Entitled Maintenance Offerings Description


    CEO DB2 UDB DEV ED
    IBM DB2 UDB DEV ED
    DB2 UNIV DEVLPR LNX S/390 CLI INS

DB2 Warehouse Manager V8.1 Media Pack

                                             Part
Description                                  Number
 
English                                      BB09VNA
French                                       BB09VFR
German                                       BB09VDE
Spanish                                      BB09VES
Italian                                      BB09VIT
Brazilian Portuguese                         BB09VBP
Danish                                       BB09VDA
Finnish                                      BB09VFI
Norwegian                                    BB09VNO
Swedish                                      BB09VSV
Polish                                       BB09VPL
Japanese                                     BB09VJA
Korean                                       BB09VKO
Simplified Chinese                           BB09VSC
Traditional Chinese                          BB09VTC

Entitled Maintenance Offerings Description


    CEO Visual Warehouse®
    DB2 QUERY PATROLLER
    DB2 WAREHOUSE MANAGER I2 CONNECTOR
    DB2 WAREHOUSE MGR ISERIES PROCSSR
    DB2 WAREHOUSE MANAGER PROCESSOR
    DB2 WAREHOUSE MANAGER SAP CONNECTOR
    DB2 WAREHOUSE MANAGER WEB CONNECTOR
    IBM VISUAL WAREHOUSE
    VIS WHSE AGT SVR INST
    VIS WHSE AGT ADDL PROC
    VIS WHSE SVR INST
    VIS WAREHOUSE BRIO ED SVR
    VIS WHSE SVR INST BUS OBJS ED
    VIS WHSE SVR INST COGNOS ED
    VIS WHSE OLAP SVR INST
    VIS WAREHOUSE OLAP SERVER
    VIS WHSE OLAP SVR INST BUS OBJS ED
    VIS WAREHOUSE OLAP BRIO SVR
    VIS WHSE OLAP SVR INST COGNOS ED

DB2 Data Links Manager V8.1 Media Pack

                                             Part
Description                                  Number
 
English                                      BB09TNA
French                                       BB09TFR
German                                       BB09TDE
Spanish                                      BB09TES
Brazilian Portuguese                         BB09TBP
Japanese                                     BB09TJA
Korean                                       BB09TKO
Simplified Chinese                           BB09TSC
Traditional Chinese                          BB09TTC

Entitled Maintenance Offerings Description


    DATA LINKS MGR PROCESSOR ENT
    DATA LINKS MANAGER
    DATA LINKS MGR AIX 16F4
    DATA LINKS MGR AIX 16F8
    DATA LINKS MGR AIX 24F16
    DATA LINKS MGR AIX 24F4
    DATA LINKS MGR AIX 24F8
    DATA LINKS MGR AIX 8F4

DB2 Net Search Extender V8.1 Media Pack

                                             Part
Description                                  Number
 
English                                      BB09RNA
German                                       BB09RDE
Spanish                                      BB09RES
Japanese                                     BB09RJA
Korean                                       BB09RKO
Simplified Chinese                           BB09RSC
Traditional Chinese                          BB09RTC

Entitled Maintenance Offerings Description


    DB2 NET SEARCH EXTENDER PROCESSOR

DB2 Spatial Extender V8.1 Media Pack

                                             Part
Description                                  Number
 
English                                      BB09XNA
French                                       BB09XFR
German                                       BB09XDE
Spanish                                      BB09XES
Brazilian Portuguese                         BB09XBP
Danish                                       BB09XDA
Finnish                                      BB09XFI
Norwegian                                    BB09XNO
Swedish                                      BB09XSV
Japanese                                     BB09XJA
Korean                                       BB09XKO
Simplified Chinese                           BB09XSC
Traditional Chinese                          BB09XTC

Entitled Maintenance Offerings Description


    DB2 SPATIAL EXTENDER PROCESSOR

DB2 Intelligent Miner Scoring V8.1 Media Pack

                                             Part
Description                                  Number
 
English                                      BB0A7NA
Spanish                                      BB0A7ES
Japanese                                     BB0A7JA
Korean                                       BB0A7KO
Simplified Chinese                           BB0A7SC
Traditional Chinese                          BB0A7TC

Entitled Maintenance Offerings Description


    DB2 INTELGNT MINER SCORING PROC

DB2 Intelligent Miner Modeling V8.1 Media Pack

                                             Part
Description                                  Number
 
English                                      BB0AANA
Spanish                                      BB0AAES
Japanese                                     BB0AAJA
Korean                                       BB0AAKO
Simplified Chinese                           BB0AASC
Traditional Chinese                          BB0AATC

Entitled Maintenance Offerings Description


    DB2 INTELGNT MINER MODELING SERVER

DB2 Intelligent Miner Visualization V8.1 Media Pack

                                             Part
Description                                  Number
 
English                                      BB0ACNA
French                                       BB0ACFR
German                                       BB0ACDE
Spanish                                      BB0ACES
Hungarian                                    BB0ACHU
Russian                                      BB0ACRU
Brazilian Portuguese                         BB0ACBP
Japanese                                     BB0ACJA
Korean                                       BB0ACKO
 
Simplified Chinese                           BB0ACSC
Traditional Chinese                          BB0ACTC

Entitled Maintenance Offerings Description


    DB2 INTELGNT MINER VISULZTN SERVER

Build-to-Order (BTO) Offering — New Customers

DB2 Universal Database Universal Developer's Edition V8.1 (Type/Model: 5765-F34)

                                             Supply         OTC
                                             Feature        Feature
Description                                  Number         Number
 
Media Packs
 
Per Installs with 1 Year SW Maintenance                     0001
English                                      5839

DB2 Universal Database Universal Developer's Edition V8.1 1 yr (5733-M61)

                                                            OTC
                                                            Feature
                                                            Number
 
Per Installs SW Maintenance Registration                    2593
Per Installs SW Maintenance 1 Year Renewal                  2594
Per Installs SW Maintenance 1 Year                          2595
 After License

DB2 Universal Database Universal Developer's Edition V8.1 1 yr (5733-M61)

                                             Supply         Language
                                             Feature        Feature
Description                                  Number         Number
 
Media Packs
 
English                                      5809           2924

DB2 Universal Database Universal Developer's Edition V8.1 3 yr (5733-M62)

                                                            OTC
                                                            Feature
                                                            Number
 
Per Installs SW Maintenance 3 Year                          2596
 Registration
Per Installs SW Maintenance 3 Year                          2597
 Renewal
Per Installs SW Maintenance 3 Year                          2598
 After License

DB2 Universal Database Universal Developer's Edition V8.1 3 yr (5733-M62)

                                             Supply         Language
                                             Feature        Feature
Description                                  Number         Number
 
Media Packs
 
English                                      5809           2924

DB2 Warehouse Manager V8.1 (Type/Model: 5765-F42)

                                             Supply         OTC
                                             Feature        Feature
Description                                  Number         Number
 
Media Packs
 
Per Install with 1 Year SW Maintenance
 Warehouse Manager-English                   5839           0001
 Connector for the Web-English               5839           0002
 Connector for SAP R/3-English               5839           0003

DB2 Warehouse Manager V8.1 1 yr (5733-M63)

                                                            OTC
                                                            Feature
                                                            Number
 
DB2 Warehouse Manager V8.1 1 yr 5733-M63
 Per Processor SW Maintenance Registration                  2509
 Per Processor SW Maintenance 1 Year Renewal                2510
 Per Processor SW Maintenance 1 Year                        2511
  After License
 
DB2 SAP Connector
 Per Installs SW Maintenance Registration                   2548
 Per Installs SW Maintenance 1 Year Renewal                 2549
 Per Installs SW Maintenance 1 Year                         2550
  After License
 
DB2 WM Web Connector
 Per Installs SW Maintenance Registration                   2551
 Per Installs SW Maintenance 1 Year Renewal                 2552
 Per Installs SW Maintenance 1 Year                         2553
  After License

DB2 Warehouse Manager V8.1 1 yr (5733-M63)

                                                            Supply
                                                            Feature
Description                                                 Number
 
Media Packs
 
English                                                     5819

DB2 Warehouse Manager V8.1 3 yr (5733-M64)

                                                            OTC
                                                            Feature
Description                                                 Number
 
DB2 Warehouse Manager V8.1 3 yr 5733-M64
 Per SW Maintenance 3 Year Registration                     2524
 Per SW Maintenance 3 Year Renewal                          2525
 Per SW Maintenance 3 Year After License                    2526
 
DB2 SAP Connector
 Per SW Maintenance 3 Year Registration                     2617
 Per SW Maintenance 3 Year Renewal                          2618
 Per SW Maintenance 3 Year After License                    2619
 
                                                            OTC
                                                            Feature
Description                                                 Number
 
DB2 WM Web Connector
 Per SW Maintenance 3 Year Registration                     2620
 Per SW Maintenance 3 Year Renewal                          2621
 Per SW Maintenance 3 Year After License                    2622

DB2 Warehouse Manager V8.1 3 yr (5733-M64)

                                                            Supply
                                                            Feature
Description                                                 Number
 
Media Packs
 
English                                                     5859

Note: DB2 Warehouse Manager Connector for i2 TradeMatrix is not offered in V8.1. No upgrade path is available, and no new orders will be accepted. For more information, refer to Software Withdrawal 902-203 , dated September 17, 2002 (DB2 Universal Database V7.2).

DB2 Data Links Manager V8.1 (Type/Model: 5765-F31)

                                             Supply         OTC
                                             Feature        Feature
Description                                  Number         Number
 
Media Packs
 
Per Processor with 1 Year SW Maintenance
 English                                     5829           0001

DB2 Data Links Manager 1 yr (5733-M65)

                                                            OTC
                                                            Feature
Description                                                 Number
 
Per Processor SW Maintenance Registration                   2687
Per Processor SW Maintenance 1 Year Renewal                 2688
Per Processor SW Maintenance 1 Year                         2689
 After License

DB2 Data Links Manager 1 yr (5733-M65)

                                                            Supply
                                                            Feature
Description                                                 Number
 
Media Packs
 
English                                                     5879

DB2 Data Links Manager 3 yr (5733-M66)

                                                            OTC
                                                            Feature
Description                                                 Number
 
Per Processor SW Maintenance 3 Year                         2693
 Registration
Per Processor SW Maintenance 3 Year                         2694
 Renewal
Per Processor SW Maintenance 3 Year                         2695
 After License

DB2 Data Links Manager 3 yr (5733-M66)

                                                            Supply
                                                            Feature
Description                                                 Number
 
Media Packs
 
English                                                     5869

IBM DB2 Net Search Extender V8.1 (Type/Model: 5765-F38)

                                             Supply         OTC
                                             Feature        Feature
Description                                  Number         Number
 
Media Packs
 
Per Processors with 1 Year SW Maintenance
 English                                     5829           0001

IBM DB2 Net Search Extender V8.1 1 yr (5733-M67)

                                                            OTC
                                                            Feature
Description                                                 Number
 
Per Processor SW Maintenance Registration                   2783
Per Processor SW Maintenance 1 Year Renewal                 2784
Per Processor SW Maintenance 1 Year                         2785
 After License

IBM DB2 Net Search Extender V8.1 1 yr (5733-M67)

                                                            Supply
                                                            Feature
Description                                                 Number
 
Media Packs
 
English                                                     5809

IBM DB2 Net Search Extender V8.1 3 yr (5733-M68)

                                                            OTC
                                                            Feature
Description                                                 Number
 
Per Processor SW Maintenance 3 Year                         2795
 Registration
Per Processor SW Maintenance 3 Year                         2796
 Renewal
Per Processor SW Maintenance 3 Year                         2797
 After License

IBM DB2 Net Search Extender V8.1 3 yr (5733-M68)

                                                            Supply
                                                            Feature
Description                                                 Number
 
Media Packs
 
English                                                     5829

DB2 Spatial Extender V8.1 (Type/Model: 5765-F40)

                                             Supply         OTC
                                             Feature        Feature
Description                                  Number         Number
 
Media Packs
 
Per Processor w/1 yr SW Maint
 English                                     5859           0001

DB2 Spatial Extender V8.1 1 yr (5733-MV4)

                                                            OTC
                                                            Feature
Description                                                 Number
Per Processor SW Maintenance Registration                   2732
Per Processor SW Maintenance 1 Year Renewal                 2733
Per Processor SW Maintenance 1 Year                         2734
 After License

DB2 Spatial Extender V8.1 1 yr (5733-MV4)

                                                            Supply
                                                            Feature
Description                                                 Number
 
Media Packs
 
English                                                     5859

DB2 Spatial Extender V8.1 3 yr (5733-MV5)

                                                            OTC
                                                            Feature
Description                                                 Number
Per Processor SW Maintenance 3 Year                         2777
 Registration
Per Processor SW Maintenance 3 Year                         2778
 Renewal
Per Processor SW Maintenance 3 Year                         2779
 After License

DB2 Spatial Extender V8.1 3 yr (5733-MV5)

                                                            Supply
                                                            Feature
Description                                                 Number
 
Media Packs
 
English                                  5879

DB2 Intelligent Miner Modeling V8.1 (Type/Model: 5765-F32)

                                             Supply         OTC
                                             Feature        Feature
Description                                  Number         Number
 
Media Packs
 
Per Installs w/1 yr SW Maint
 English                                     5839           0001

DB2 Intelligent Miner Modeling V8.1 1 yr (5765-F76)

                                                            OTC
                                                            Feature
Description                                                 Number
Per Installs SW Maintenance Registration                    0001
Per Installs SW Maintenance 1 Year Renewal                  0002
Per Installs SW Maintenance 1 Year                          0003
 After License

DB2 Intelligent Miner Modeling V8.1 1 yr (5765-F76)

                                                            Supply
                                                            Feature
Description                                                 Number
 
Media Packs
 
English                                                     5839

DB2 Intelligent Miner Modeling V8.1 3 yr (5765-F77)

                                                            OTC
                                                            Feature
Description                                                 Number
 
Per Installs SW Maintenance 3 Year                          0001
 Registration
Per Installs SW Maintenance 3 Year                          0002
 Renewal
Per Installs SW Maintenance 3 Year                          0003
 After License

DB2 Intelligent Miner Modeling V8.1 3 yr (5765-F77)

                                                            Supply
                                                            Feature
Description                                                 Number
 
Media Packs
 
English                                                     5809

DB2 Intelligent Miner Visualization V8.1 (Type/Model: 5765-F33)

                                             Supply         OTC
                                             Feature        Feature
Description                                  Number         Number
 
Media Packs
 
Per Installs w/1 yr SW Maint
 English                                     5839           0001

DB2 Intelligent Miner Visualization V8.1 1 yr (5765-F78)

                                                            OTC
                                                            Feature
Description                                                 Number
 
Per Installs SW Maintenance Registration                    0001
Per Installs SW Maintenance 1 Year Renewal                  0002
Per Installs SW Maintenance 1 Year                          0003
 After License

DB2 Intelligent Miner Visualization V8.1 1 yr (5765-F78)

                                                            Supply
                                                            Feature
Description                                                 Number
 
Media Packs
 
English                                                     5839

DB2 Intelligent Miner Visualization V8.1 3 yr (5765-F81)

                                                            OTC
                                                            Feature
Description                                                 Number
 
Per Installs SW Maintenance 3 Year                          0001
 Registration
Per Installs SW Maintenance 3 Year                          0002
 Renewal
Per Installs SW Maintenance 3 Year                          0003
 After License

DB2 Intelligent Miner Visualization V8.1 3 yr (5765-F81)

                                                            Supply
                                                            Feature
Description                                                 Number
 
Media Packs
 
English                                                     5809

DB2 Intelligent Miner Scoring V8.1 (Type/Model: 5765-F36)

                                             Supply         OTC
                                             Feature        Feature
Description                                  Number         Number
 
Media Packs
 
Per Processor with 1 Year SW Maintenance
 English                                     5829           0001

DB2 Intelligent Miner Scoring V8.1 1 yr (5765-F79)

                                                            OTC
                                                            Feature
Description                                                 Number
 
 
Per Processor SW Maintenance Registration                   0001
Per Processor SW Maintenance 1 Year Renewal                 0002
Per Processor SW Maintenance 1 Year                         0003
 After License

DB2 Intelligent Miner Scoring V8.1 1 yr (5765-F79)

                                                            Supply
                                                            Feature
Description                                                 Number
 
Media Packs
 
English                                                     5859

DB2 Intelligent Miner Scoring V8.1 3 yr (5765-F80)

                                                            OTC
                                                            Feature
Description                                                 Number
 
Per Processor SW Maintenance 3 Year                         0001
 Registration
Per Processor SW Maintenance 3 Year                         0002
 Renewal
Per Processor SW Maintenance 3 Year                         0003
 After License

DB2 Intelligent Miner Scoring V8.1 3 yr (5765-F80)

                                                            Supply
                                                            Feature
Description                                                 Number
 
Media Packs
 
English                                                     5859

DB2 Enterprise Server Edition (ESE) V8.1 (Type/Model: 5765-F41)

                                             Supply         OTC
                                             Feature        Feature
Description                                  Number         Number
 
Media Packs
 
DB2 UDB ESE
 Per Processor w/1 yr SW Maint                              0001
  Database Partitioning Feature
 Per Processor w/1 yr SW Maint                              0002
  English                                    5869

DB2 Enterprise Server Edition V8.1 1 yr (5765-F94)

                                                            OTC
                                                            Feature
Description                                                 Number
 
DB2 UDB ESE
 Per Processor SW Maintenance 1 Year                        0004
  Registration
 Per Processor SW Maintenance 1 Year                        0005
  Renewal
 Per Processor SW Maintenance 1 Year                        0006
  After License
 
Database Partitioning Feature
 Per Processor SW Maintenance 1 Year                        0001
  Registration
 Per Processor SW Maintenance 1 Year                        0002
  Renewal
 Per Processor SW Maintenance 1 Year                        0003
  After License

DB2 Enterprise Server Edition V8.1 1 yr (5765-F94)

                                                            Supply
                                                            Feature
Description                                                 Number
 
Media Packs
 
English                                                     5869

DB2 Enterprise Server Edition V8.1 3 yr (5765-F95)

                                                            OTC
                                                            Feature
Description                                                 Number
 
DB2 UDB ESE
 Per Processor SW Maintenance                               0004
  3 Year Registration
 Per Processor SW Maintenance                               0005
  3 Year Renewal
 Per Processor SW Maintenance                               0006
  3 Year After License
 
                                                            OTC
                                                            Feature
Description                                                 Number
 
Database Partitioning Feature
 Per Processor SW Maintenance                               0001
  3 Year Registration
 Per Processor SW Maintenance                               0002
  3 Year Renewal
 Per Processor SW Maintenance                               0003
  3 Year After License

DB2 Enterprise Server Edition V8.1 3 yr (5765-F95)

                                                            Supply
                                                            Feature
Description                                                 Number
 
Media Packs
 
English                                                     5889

DB2 Workgroup Server Edition V8.1 (Type/Model: 5765-F35)

                                             Supply         OTC
                                             Feature        Feature
Description                                  Number         Number
 
Media Packs
 
Per Server Install with 1 Year                              0004
 SW Maintenance
Per Users with 1 Year                                       0005
 SW Maintenance
English                                      6652

DB2 Workgroup Server Edition V8.1 1 yr (5765-F98)

                                                            OTC
                                                            Feature
Description                                                 Number
 
Per Users SW Maintenance Registration                       0001
Per Server Install SW Maintenance                           0002
 Registration
Per Users SW Maintenance 1 Year Renewal                     0003
Per Users SW Maintenance 1 Year                             0004
 After License
Per Server Install SW Maintenance                           0005
 1 Year Renewal
Per Server Install SW Maintenance                           0006
 1 Year After License

DB2 Workgroup Server Edition V8.1 1 yr (5765-F98)

                                                            Supply
                                                            Feature
Description                                                 Number
 
Media Packs
 
English                                                     5889

DB2 Workgroup Server Edition V8.1 3 yr (5765-F99)

                                                            OTC
                                                            Feature
Description                                                 Number
 
Per Users SW Maintenance 3 Year                             0001
 Registration
Per Users SW Maintenance 3 Year                             0002
 Renewal
Per Users SW Maintenance 3 Year                             0003
 After License
Per Server Install SW Maintenance                           0004
 3 Year Registration
Per Server Install SW Maintenance                           0005
 3 Year Renewal
Per Server Install SW Maintenance                           0006
 3 Year After License

DB2 Workgroup Server Edition V8.1 3 yr (5765-F99)

                                                            Supply
                                                            Feature
Description                                                 Number
 
Media Packs
 
English                                                     5899

DB2 Workgroup Server Unlimited Edition V8.1 (Type/Model: 5765-F43)

                                             Supply         OTC
                                             Feature        Feature
Description                                  Number         Number
 
Media Packs
 
Per Processor with 1 yr
 SW Maintenance
  English                                    5839           0001

DB2 Workgroup Server Unlimited Edition V8.1 3 yr (5765-F96)

                                                            OTC
                                                            Feature
Description                                                 Number
 
Per Processor SW Maintenance 1 Year                         0001
 Registration
Per Processor SW Maintenance 1 Year                         0002
 Renewal
Per Processor SW Maintenance 1 Year                         0003
 After License

DB2 Workgroup Server Unlimited Edition V8.1 1 yr (5765-F96)

                                                            Supply
                                                            Feature
Description                                                 Number
 
Media Packs
 
English                                                     5829

DB2 Workgroup Server Unlimited Edition V8.1 3 yr (5765-F97)

                                                            OTC
                                                            Feature
Description                                                 Number
 
Per Processor SW Maintenance                                0001
 3 Year Registration
Per Processor SW Maintenance                                0002
 3 Year Renewal
Per Processor SW Maintenance                                0003
 3 Year After License

DB2 Workgroup Server Unlimited Edition V8.1 3 yr (5765-F97)

                                                            Supply
                                                            Feature
Description                                                 Number
 
Media Packs
 
English                                                     5957

This software license includes Software Maintenance, previously referred to as Software Subscription and Technical Support.

Extending coverage for a total of three years from date of acquisition may be elected. Order the Program Number, Feature Number and quantity to extend coverage for your software licenses. If maintenance has expired, specify the after license feature number.

BTO customers who have DB2 V7.1 or V7.2 will be able to process after license or a renewal order via the configurator. For Software Maintenance upgrades, the configurator will not recognize versions of DB2 prior to V7.1. Customers with versions of DB2 prior to V7.1 without Software Maintenance, who wish to utilize the after license option for V8.1, need to contact their Pre-sales Support.

Build-to-Order (BTO) Offering — Existing Customers

SW Maintenance Order Table

DB2 Universal Database Universal Developer's Edition V8.1 (Type/Model: 5765-F34): Customers who have purchased previous versions of DB2 Universal Database Universal Developer's Edition (5648-D37) including maintenance 5733-M61 or 5733-M62 and who have current maintenance coverage are entitled to receive DB2 Database Universal Developer's Edition V8.1 at no charge. Eligible customers should add the applicable media feature number from the table below to their existing record.

                                                  Media/
Maintenance IASP PID                              Language
 
5733-M61
5733-M62
 
English                                           5809/2924

DB2 Warehouse Manager V8.1 (Type/Model: 5765-F42)

Note: DB2 Warehouse Manager Connector for i2 TradeMatrix is not offered in V8.1. No upgrade path is available, and no new orders will be accepted. For more information, refer to Software Announcement 902-203 , dated September 17, 2002 (DB2 Withdrawal V7.2).

Customers who have purchased previous versions of DB2 Warehouse Manager (5724-A90) including maintenance 5733-M63 or 5733-M64 and who have current maintenance coverage are entitled to receive DB2 Warehouse Manager V8.1 at no charge. Maintenance on Program Package qualifies for Processor install media.

Customers who have purchased previous versions of DB2 Warehouse Manager Connector for the Web and who have current maintenance coverage are entitled to receive DB2 Warehouse Connector for the Web V8.1 at no charge.

Customers who have purchased previous versions of DB2 Warehouse Manager Connector for SAP and who have current maintenance coverage are entitled to receive DB2 Warehouse Connector for SAP V8.1 at no charge. Eligible customers should add the applicable media feature number from the table below to their existing record.

                                                  Media/
Maintenance IASP PID                              Language
 
5733-M63
 
English                                           5819
 
5733-M64
 
English                                           5859

DB2 Data Links Manager V8.1 (Type/Model: 5765-F31): Customers who have purchased previous versions of DB2 Data Links Manager (5648-D43) including maintenance 5733-M65 or 5733-M66 and who have current maintenance coverage are entitled to receive DB2 Data Links Manager V8.1 at no charge. Eligible customers should add the applicable media feature number from the table below to their existing record.

                                                  Media/
Maintenance IASP PID                              Language
 
5733-M65
 
English                                           5879
 
5733-M66
 
English                                           5869

IBM DB2 Net Search Extender V8.1 (Type/Model: 5765-F38): Customers who have purchased previous versions of DB2 Net Search Extender (5648-D66) including maintenance 5733-M67 or 5733-M68 and who have current maintenance coverage are entitled to receive DB2 Net Search Extender V8.1 at no charge. Eligible customers should add the applicable media feature number from the table below to their existing record.

                                                  Media/
Maintenance IASP PID                              Language
 
5733-M67
 
English                                           5809
 
5733-M68
 
English                                           5829

DB2 Spatial Extender V8.1 (Type/Model: 5765-F40): Customers who have purchased previous versions of DB2 Spatial Extender (PDI 5648-D61) including maintenance 5733-MV4 or 5733-MV5 and who have current maintenance coverage are entitled to receive DB2 Spatial Extender V8.1 at no charge. Eligible customers should add the applicable media feature number from the table below to their existing record.

                                                  Media/
Maintenance IASP PID                              Language
 
5733-MV4
 
English                                           5859
 
5733-MV5
 
English                                           5879

DB2 Enterprise Server Edition V8.1 (Type/Model: 5765-F41): Customers who have purchased previous versions of DB2 Enterprise Edition (5648-D48) and who have current maintenance coverage for Processor Entitlements on 5733-MU2 or 5733-MU3 are entitled to receive DB2 Enterprise Server Edition V8.1 (5765-F41) at no charge.

Customers with current maintenance coverage for Host User Connections on 5733-MU2 or 5733-MU3 will be migrated to DB2 Connect Enterprise Edition (5765-F30) and are entitled to receive one DB2 Connect Enterprise Edition user license for each Host User license, and will receive one DB2 Connect Enterprise Edition Server License (regardless of number of Host User Licenses).

Customers who have purchased previous versions of DB2 Enterprise Extended Edition (5648-D50) with current maintenance coverage for Processor Entitlements on 5733-M57 or 5733-M58 are entitled to receive DB2 Enterprise Server Edition V8.1 (5765-F41) plus the DB2 Database Partitioning Feature for Enterprise Server Edition at no charge.

Customers with current maintenance for User Connections on 5733-M57 or 5733-M58 will be migrated to DB2 Connect Enterprise Edition (5765-F30) and are entitled to receive one DB2 Connect Enterprise Edition User license for each User license, and will receive one DB2 Connect Enterprise Edition Server License (regardless of number of User Licenses).

Customers with current maintenance on 5733-MU2, 5733-MU3, 5733-M57, and 5733-M58 will need to migrate to the appropriate maintenance PIDs upon renewal date. Eligible customers should add the applicable media feature number from the table below to their existing record.

                                                  Media/
Maintenance IASP PID                              Language
 
5733-MU2
 
English                                           5809
 
5733-MU3
 
English                                           5809
 
5733-M57
 
Media Packs
 
English                                           5859
 
5733-M58
 
Media Packs
 
English                                           5879

Migration Scenarios: Existing customers of 5648-D48 V7.1, processor entitlement, without maintenance and 5648-D48 V7.2 with expired maintenance contracts are able to receive DB2 UDB ES V8.1 through the 1- and 3-year maintenance products (5765-F94 and 5765-F95). Place an order for one of the following products and feature numbers.

                                             OTC            Media
                                             Feature        Feature
Description                                  Number         Number
 
5765-F94 UDB ESE 1 yr
 
UDB ESE
 Per processor SW Maintenance                0006
  1 yr After License
 Media pack (English)                                       5869
 
5765-F95 UDB ESE 3 yr
 
UDB ESE
 Per processor SW Maintenance                0006
  3 yr After License
 Media pack (English)                                       5889

Existing customers of 5648-D48 V7.2 Host User Connection with expired maintenance contracts are able to receive DB2 Connect Enterprise Ed V8.1 through the 1- and 3-year maintenance products (5733-M59 and 5733-M60). Place an order for one of the following products and feature numbers.

                                             OTC            Media
                                             Feature        Feature
Description                                  Number         Number
 
5733-M59 DB2 Connect Enterprise
 Edition 1 yr
  Per users SW Maintenance 1 yr              2675
   After License
  Per installs SW Maintenance 1 yr           2677
   After License
  Media pack (English)                                      5829
 
5733-M60 DB2 Connect Enterprise
 Edition 3 yr
  Per users SW Maintenance 3 yr              2683
   After License
  Per installs SW Maintenance 3 yr           2686
   After License
  Media pack (English)                                      5849

Existing customers of 5648-D50 V7.1, DB2 Ext. Ed. processor entitlement, without maintenance and 5648-D50 V7.2 with expired maintenance contracts are able to receive DB2 UDB ES V8.1 through the 1- and 3-year maintenance products (5765-F94 and 5765-F95). Place an order for one of the following products and feature numbers.

                                             OTC            Media
                                             Feature        Feature
Description                                  Number         Number
 
5765-F94 UDB ESE 1 yr
 Per processor SW Maintenance                0006
  1 yr After License
  Database partitioning feature
 Per processor SW Maintenance                0003
  1 yr After License
  Media pack (English)                                      5869
 
5765-F95 UDB ESE 3 yr
 Per processor SW Maintenance                0006
  3 yr After License
  Data Partitioning Feature
 Per processor SW Maintenance                0003
  3 yr After License
  Media pack (English)                                      5889

Existing customers of 5648-D50 V7.1, DB2 Ext. Ed. Host User with expired maintenance contracts are able to receive DB2 Connect Enterprise Ed V8.1 through the 1- and 3-year maintenance products (5765-F94 and 5765-F95). Place an order for one of the following products and feature numbers.

                                             OTC            Media
                                             Feature        Feature
Description                                  Number         Number
 
5733-M59 DB2 Conn Enterprise
 Edition 1 yr
  Per users SW Maintenance 1 yr              2675
   After License
  Per installs SW Maintenance 1 yr           2677
   After License
  Media pack (English)                                      5829
 
5733-M60 DB2 Connect Enterprise
 Edition 3 yr
  Per users SW Maintenance 3 yr              2683
   After License
  Per installs SW Maintenance 3 yr           2686
   After License
  Media pack (English)                                      5849

Upon renewal, existing maintenance customers of 5648-D48 V7.2 processor entitlement, with maintenance (5733-MU2 and 5733-MU3) will be migrated to UDB ESE (5765-F94 and 5765-F95). Place an order for products and features from the table below to complete migration.

                                             OTC            Media
                                             Feature        Feature
Description                                  Number         Number
 
5765-F94 UDB ESE 1 yr
 Per processor SW Maintenance                0005
  1 yr renewal
 Media pack (English)                                       5869
 
5765-F95 UDB ESE 3 yr
 Per processor SW Maintenance                0005
  3 yr renewal
 Media pack (English)                                       5889

Upon renewal, existing maintenance customers of 5648-D48 V7.2 Host User Connection, with maintenance (5733-MU2 and 5733-MU3) will be migrated to DB2 Connect Ent Ed (5733-M59 and 5733-M60). Place an order for products and features from the table below to complete migration.

                                             OTC            Media
                                             Feature        Feature
Description                                  Number         Number
 
5733-M59 DB2 Conn Enterprise
 Edition 1 yr
  Per users SW Maintenance                   2674
   1 yr renewal
  Per installs SW Maintenance                2676
   1 yr renewal
  Media pack (English)                                      5829
 
5733-M60 DB2 Connect Enterprise
 Edition 3 yr
  Per users SW Maintenance                   2682
   3 yr renewal
  Per installs SW Maintenance                2685
   3 yr renewal
  Media pack (English)                                      5849

Upon renewal, existing maintenance customers of 5648-D50 V7.2 processor features, with maintenance (5733-M57 and 5733-M58) will be migrated to DB2 UDB ESE (5765-F94 and 5765-F95) processor and or data partitioning feature. Place an order for products and features from the table below to complete migration.

                                             OTC            Media
                                             Feature        Feature
Description                                  Number         Number
 
5765-F94 UDB ESE 1 yr
 Per processor SW Maintenance                0005
  1 yr renewal Database
  Partitioning Feature
 Per processor SW Maintenance                0002
  1 yr renewal
 Media pack (English)                                       5869
 
5765-F95 UDB ESE 3 yr
 Per processor SW Maintenance                0005
  3 yr renewal Database
  Partitioning Feature
 Per processor SW Maintenance                0002
  3 yr renewal
 Media pack (English)                                       5889

Upon renewal, existing maintenance customers of 5648-D50 V7.2 user features, with maintenance (5733-M57 and 5733-M58) will be migrated to DB2 Connect Enterprise Edition (5733-M59 and 5733-M60). Place an order for products and features from the table below to complete migration.

                                             OTC            Media
                                             Feature        Feature
Description                                  Number         Number
 
Per users SW Maintenance                     2674
 1 yr renewal
Per installs SW Maintenance                  2676
 1 yr renewal
Media pack (English)                                        5829
 
5733-M60 DB2 Connect Enterprise
 Edition 3 yr
  Per users SW Maintenance                   2682
   3 yr renewal
  Per installs SW Maintenance                2685
   3 yr renewal
  Media pack (English)                                      5849

Existing customers of 5648-D48 V7.2 Enterprise Edition and maintenance (5733-MU2 and 5733-MU3) are entitled to receive V8.1 UDB ESE at no charge. Order the applicable media features from the table below.

                                                            Media
                                                            Feature
Description                                                 Number
 
5733-MU2 DB2 Enterprise
 Edition 1 yr
  English Media Pack                                        5809
 
5733-MU3 DB2 Enterprise
 Edition 3 yr
  English Media Pack                                        5809

Existing customers of 5648-D50 V7.2 Enterprise Ext. Ed. and maintenance (5733-M57 and 5733-M58) are entitled to receive V8.1 UDB ESE at no charge. Order the applicable media features from the table below.

                                                            Media
                                                            Feature
Description                                                 Number
 
5733-M57 DB2 Enterprise Ext. Ed.
 English                                                    5859
 
5733-M58 DB2 Enterprise Ext. Ed. 3 yr
 English                                                    5879

DB2 Workgroup Server Edition V8.1 (Type/Model: 5765-F35): Customers who have purchased previous versions of DB2 Workgroup Edition (5648-D46) with current maintenance on 5733-MT9 or 5733-MU1 are entitled to receive DB2 Workgroup Server Edition V8.1 (5765-F35) at no charge. Customers with current maintenance on 5733-MT9 or 5733-MU1 for the Internet Processor, will be migrated to DB2 Workgroup Server Unlimited Edition (5765-F43) at no charge.

Customers with current maintenance on 5733-MT9 and 5733-MU1 will need to migrate to the appropriate maintenance PIDs upon renewal date. Eligible customers should add the applicable media feature number from the table below to their existing record.

                                                  Media/
Maintenance IASP PID                              Language
 
5733-MT9
 
English                                           5819
 
5733-MU1
 
English                                           5809

DB2 Workgroup Server Unlimited Edition V8.1 (Type/Model: 5765-F43): Customers who have purchased previous versions of DB2 Workgroup Unlimited Edition (5648-D46) with current maintenance on 5733-MT9 or 5733-MU1 are entitled to receive DB2 Workgroup Unlimited Server Edition V8.1 (5765-F43) at no charge.

Customers with current maintenance on 5733-MT9 and 5733-MU1 will need to migrate to the appropriate maintenance PIDs upon renewal date. Eligible customers should add the applicable media feature number from the table below to their existing record.

                                                  Media/
Maintenance IASP PID                              Language
 
5733-MT9
 
English                                           5819
 
5733-MU1
 
English                                           5809

 
Back to top
 
Terms and conditions

Agreement: IBM International Program License Agreement. Proofs of Entitlement are required for all authorized use. Part number products only, offered outside of Passport Advantage, where applicable, are license only and do not include Software Maintenance.

This software license includes Software Maintenance, previously referred to as Software Subscription and Technical Support.

The following agreements apply for maintenance and do not require customer signatures:

  • IBM Agreement for Acquisition of Support (Z125-6011)
  • Addendum for Support (Software Maintenance) for Select iSeries and pSeries™ Programs (Z125-6495)

License Information Form Number: License Information (LI) comes electronically only.

Limited warranty: Yes

Program services: V8.1 Program Services are available until March 31, 2005.

V7.2 Program Services have been extended until March 31, 2004.

Note: For BTO PIDs, only the service support is extended, not the actual maintenance.

Money-Back Guarantee: If for any reason you are dissatisfied with the Program, return it within 30 days from the invoice date, to the party (either IBM or its reseller) from whom you acquired it, for a refund. This applies only to your first acquisition of the Program.

Copy and Use on Home/Portable Computer: No

Volume Orders (IVO): No

Passport Advantage Applies: Yes, and through the Passport Advantage Web site at:

Usage Restriction: Yes

License Limitations

The following license limitations exist with the DB2 V8.1 products:

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

The following restrictions apply to the Workgroup Server Edition.

  • Use of this program is restricted to servers with up to four (4) processors per server.
  • DB2 Universal Database Workgroup Server Edition license does not permit creation of 64-bit instances on servers where the products are installed.
  • Connections made to this product through the intranet (connections from within your Enterprise) must be counted as DB2 Users.
  • You are not entitled to use the Connection Concentrator with this program.

The following restrictions apply to the Workgroup Server Unlimited Edition. Use of this program is restricted to servers with up to four processors per server. DB2 Universal Database Workgroup Server Edition license does not permit creation of 64-bit instances on servers where the products are installed. You are not entitled to use the Connection Concentrator with this program. WSUE must be licensed for all CPUs available in the server.

DB2 Universal Database Enterprise Server Edition ESE.

In order to create a multi-partitioned database using DB2 ESE, you must purchase the applicable number of entitlements for the DB2 UDB ESE separately chargeable database partitioning feature.

  • The entitlement to the DB2 Database Partitioning Feature, is licensed on per processor basis for every processor in the single database image across all servers where the database has been partitioned. This entitlement must be acquired before creating more than one partition within your database.
  • The DB2 Database Partitioning Feature 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.
  • Use of the DB2 Connect component is limited to five registered users per server. This product contains DB2 Connect component to provide connectivity, DB2 for z/OS for OS/390, DB2 Server for VSE and VM, and DB2 for iSeries database servers. If additional users need to connect to any of the above mentioned database servers, a separate DB2 Connect Program license must be acquired.

Licensing for DB2 UDB Enterprise Edition for Linux on S/390 and zSeries: Licensing for DB2 on Linux/390 is consistent with the corresponding workstation platform products as follows: DB2 Enterprise Edition per processor (equivalent to engine on the 390)

Licensing Terms and Conditions

DB2 Enterprise Edition is priced per engine to the Linux capacity of the box. Consistent with Workstation products, we will price to a subset of the engines on a box where we can limit EE's access to remaining engines in an enforced fashion.

Modes of executing Linux applications where we will price to a subset of engines:

  • Where customer has purchased additional processor capacity under the Integrated Facility for Linux (IFL). Linux workspace enabled under IFL is exclusively for Linux workload, and will not support any of the S/390 traditional operating systems.
  • Modes of executing Linux applications where we will charge for all engines:
    • Running Linux natively
    • Running Linux under VM
    • Running Linux within a S/390 logical partition (LPAR) without IFL for Linux

DB2 Personal Developer's Edition is licensed for installation and use by an individual developer on a single machine. You may only use the Program for the purposes of evaluating, demonstrating, testing, and developing application programs.

DB2 Universal Developer's Edition is licensed for installation and use by an individual user. To use the Program in a shared environment, a separate license must be purchased for each developer. You may only use the Program for the purposes of evaluating, demonstrating, testing, and developing application programs.

DB2 Net Search Extender is licensed for use with DB2 Universal Database Enterprise Server Edition V8.1, or DB2 Universal Database Workgroup Server Unlimited Edition V8.1. If the Program is acquired through DB2 Universal Personal Edition or DB2 Universal Workgroup Server Edition, then this Program is licensed for installation and use as follows: DB2 Universal Personal Edition — Use is limited to one user; DB2 Workgroup Server Edition — Use is limited to five users per server install.

DB2 Spatial Extender is licensed for use with DB2 Universal Database Enterprise Server Edition V8.1, or DB2 Universal Database Workgroup Server Unlimited Edition V8.1. If the Program is acquired through DB2 Universal Personal Edition or DB2 Universal Workgroup Server Edition, then this Program is licensed for installation and use as follows: DB2 Universal Personal Edition — Use is limited to one user; DB2 Workgroup Server Edition — Use is limited to five users per server install.

DB2 Data Links Manager is licensed for use only with DB2 Universal Database Enterprise Server Edition V8.1

DB2 Warehouse Manager and its components must be used with a licensed copy of DB2 Enterprise Server Edition V8.1.

  • Information Catalog Manager is provided to support your authorized use of the Program within your Enterprise. You are allowed to perform multiple installations of this component.
  • QMF for Windows: This Program license entitles you to access the DB2 server to which the product is licensed.
  • 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 Connector is per install per processor and customers are responsible for acquiring the correct option for the Connector they want to install and use.
  • You are entitled to install the IBM Query Patroller component, when (made) available, on the DB2 server to which this product is licensed.
  • The DB2 Warehouse Manager provides a restricted-use copy of DB2 UDB Enterprise Server Edition V8. Authorization to use this copy of DB2 UDB Enterprise Server Edition is to enable database management of DB2 for iSeries data warehouse control databases by the following workstation tools only:
    1. Data Warehouse Center
    2. Information Catalog

    For use of DB2 UDB Enterprise Server Edition other than the uses specifically described above, you must obtain a separate license for DB2 UDB Enterprise Server Edition from IBM.

Restrictions on the use of the JDBC drivers with mainframe and iSeries data sources: Included with the DB2 product you have purchased are JDBC drivers. These JDBC drivers may be used for connecting to a properly licensed DB2 UDB database on Linux, UNIX, or Windows server. These drivers are not licensed for use with DB2 Universal Database for z/OS and OS/390, DB2 Server for VSE & VM, and DB2 Universal Database for iSeries database need to purchase an appropriate DB2 Connect product.

DB2 Clients. You may make copies of these clients and documentation in support of your authorized use of the Program within your Enterprise.

The Warehouse Server component of DB2 Universal Database supports the operation of the Data Warehouse Center. If the Warehouse Server is installed on a server that is different from your intended database server, then a restricted license is installed on the same server as the warehouse server. You are entitled to use this restricted license DB2 server to manage one or more of the following types of data:

  • Warehouse control database
  • Scheduler and information catalog metadata in a DB2 tools catalog
  • Sample databases that are created by DB2 V8.1 products or components Any other use requires a full unrestricted license.

XML Extender and Image, Audio, and Video Extenders. You may install the DB2 Extenders on multiple machines, and make copies of the documentation in support of your authorized use of the Program, only when those machines are within your Enterprise. You may not distribute the DB2 Extenders outside of your Enterprise.

This Program includes portions of WebSphere MQ. You are authorized to install and use these components only in association with your licensed use of the DB2 UDB for queuing and messaging with DB2 and DB2 applications. For example, this license does not include inbound connections to WebSphere MQ from non-DB2 applications for queuing and messaging. You are authorized to install and use these components only with and on the same machine as the DB2 UDB.

High Availability/Failover Licensing 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, and refer to the Planning Information section.

If the Program is acquired under the terms of an IBM offering for limited platform support (such as, the Program is acquired for use on a single platform or less than all available platforms), then that Program is licensed only for installation and use on the specific platforms or operating systems as designated by the offering terms and conditions.

Components of DB2 technology are provided within several other products, such as WebSphere, under restricted use terms provided in the other product's licensing. This database is supplied for internal product administrative functions only. The intent is not to provide a general use database for customer storage of enterprise data, nor building of applications to store/retrieve/query data. Customers who require a general use database for the storage and access of their enterprise data, are required to upgrade to a full licensed DB2 product.

Third-party code is found in all products. For details on restrictions, refer to the unique license information provided with each product.

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

Usage Restriction

All products require the correct licensing terms. The database software provided on the Product media is provided solely for use with your licensed use of the product as described in the program unique license information that is provided to you electronically.

If the total number exceeds the quantity in your Proofs of Entitlement (PoEs) or exceeds your product authorizations acquired under Passport Advantage, you must notify IBM or its reseller as stated in the IBM International Program License Agreement (IPLA).

DB2 Universal Database Personal Edition is licensed for installation and use by an individual user at one workstation. Inbound connections to this product are licensed for administration use only.

DB2 Universal Database Workgroup Server Edition V8.1 is licensed for one server install and one concurrent or registered user entitlement is included.

DB2 Universal Database Workgroup Unlimited Server Edition V8.1: One processor entitlement is included.

DB2 Universal Database Enterprise Server Edition V8.1: One processor entitlement is included.

The following DB2 Programs include one processor entitlement:

  • DB2 Data Links Manager, V8.1.
  • DB2 Spatial Extender, V8.1
  • DB2 Net Search Extender, V8.1
  • DB2 Warehouse Manager, V8.1
  • DB2 Intelligent Miner Scoring, V8.1.

If the total number of server installs exceeds the quantity in your PoEs or each product authorization acquired under Passport Advantage, you must notify IBM or its reseller as stated in the IPLA.

One server install entitlement is included for DB2 Intelligent Miner Modeling, V8.1 and for DB2 Intelligent Miner Visualization, V8.1. If the total number of server installs exceeds the quantity in your PoEs or each product authorization acquired under Passport Advantage, you must notify IBM or its reseller as stated in the IPLA.

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.

Support Line: Yes

AIX/UNIX Upgrade Protection Applies: No

Entitled Upgrade for Current AIX/UNIX Upgrade Protection Licensees: No

AS/400=AE Software Subscription Applies: No

Variable Charges Apply: No

Educational Allowance Available: Yes, a 15% education allowance applies to qualified education institution customers.

Software Maintenance Applies: Yes

Software Maintenance, previously referred to as Subscription and Technical Support, is now included in the Passport Advantage Agreement. Installation and technical support for the products announced in this letter is provided by the Software Maintenance offering of the IBM International Passport Advantage Agreement. This fee service enhances customer productivity by providing voice and/or electronic access into the IBM support organizations.

IBM includes Software Maintenance with each Program acquired during the Coverage Period. Coverage Period means the period commencing on the date you acquire the Program up to the first or second Anniversary Date, depending on whether you acquired coverage for one or two anniversaries. The Coverage Period for Software Maintenance acquired in the two months preceding an Anniversary Date will be extended to the next applicable Anniversary Date.

While your Software Maintenance is in effect, IBM provides you assistance for your:

  1. Routine, short duration installation and usage (how-to) questions
  2. Code-related questions

IBM provides assistance via telephone and, if available, electronic access, only to your information systems (IS) technical support personnel during the normal business hours (published prime shift hours) of your IBM support center. This assistance is not available to your end users. IBM provides Severity 1 assistance 24 hours a day, every day of the year. For further details, consult your IBM Software Support Guide at:

Software Maintenance does not include assistance for:

  1. The design and development of applications.
  2. Your use of Programs in other than their specified operating environment.
  3. Failures caused by products for which IBM is not responsible under this Agreement.

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

All distributed software licenses include Software Maintenance (software subscription and technical support) for a period of 12 months from the date of acquisition providing a streamlined way to acquire IBM software and assure technical support coverage for all licenses. Extending coverage for a total of three years from date of acquisition may be elected. For additional information, refer to Changes to Distributed Software Products Model for Products Outside Passport Advantage Software Announcement 201-201 , dated July 10, 2001.

Complementary Products: IBM provides licensed copies of complementary products in our product boxes. The complementary products are not upgradeable through the originally ordered product. They are only upgradeable separately as individual products. If a fully licensed product is required, contact IBM or your reseller. In addition, complementary products do not entitle customers to receive service support.

AIX/UNIX Upgrade Protection Applies: No

Entitled Upgrade for Current AIX/UNIX Upgrade Protection Licensees: No

Variable Charges Apply: No

Educational Allowance Available: Yes, 15% education allowance applies to qualified education institution customers.
 
Back to top
 

Prices

The prices provided in this announcement are suggested retail prices for the U.S. only and are provided for your information only. Dealer prices may vary, and prices may also vary by country. Prices are subject to change without notice. For additional information and current prices, contact your local IBM representative.

Build to Plan (BTP)

Program Packages

                                                  Part
Description                                       Number         OTC
 
DB2 UDB Personal Edition V8.1
 
English                                           45P8152        $369
 
DB2 UDB Workgroup Server Edition V8.1
 
English                                           45P8155         999
 
DB2 Personal Developer's Edition V8.1
 
English                                           45P8276          50
 
DB2 Universal Developer's Edition V8.1
 
English                                           45P8268         999
 
DB2 Universal Developer's Edition V8.1
zSeries (S/390)
 
English                                           45P9364         999

Network or Electronic Delivery

                                                  Part
Description                                       Number         OTC
 
DB2 UDB Personal Edition V8.1
 
NET DEL
 
With 1 Use NET DEL English                        45P9258        $359
 
DB2 UDB Workgroup Server Edition V8.1
 
NET DEL
 
With 1 Use NET DEL English                        45P9274         969
 
DB2 Universal Developer's Edition V8.1
 
NET DEL
 
With 1 Use NET DEL English                        45P9336         959

Passport Advantage

For Passport Advantage and charges, contact your authorized Lotus® Business Partner. Additional information is also available on the Passport Advantage Web site at:

Build to Order (BTO)

Base Products

                                                  OTC
                                                  Feature
Description                                       Number         OTC
 
DB2 Universal Developer's Edition V8.1 (5765-F34)
 
Per Install with 1 Year                           0001        $ 1,125
 SW Maintenance
 
DB2 Warehouse Manager Edition V8.1 (5765-F42)
 
Per Install with 1 Year                           0001         12,313
 SW Maintenance
 
Connector for SAP V8.1
 
Per Install with 1 Year                           0003          2,346
 SW Maintenance
 
Connector for the Web V8.1
 
Per Install with 1 Year                           0002          2,346
 SW Maintenance
 
DB2 Data Links Manager V8.1 (5765-F31)
 
Per Processor with 1 Year                         0001          8,997
 SW Maintenance
 
DB2 Net Search Extender V8.1 (5765-F38)
 
Per Processor with 1 Year                         0001          5,864
 SW Maintenance
 
DB2 Spatial Extender V8.1 (5765-F40)
 
Per Processor with 1 Year                         0001          8,208
 SW Maintenance
 
                                                  OTC
                                                  Feature
Description                                       Number         OTC
 
DB2 Intelligent Miner
Modeling V8.1 (5765-F32)
 
Per Install with 1 Year                           0001        $49,752
 SW Maintenance
 
DB2 Intelligent Miner
Visualization V8.1 (5765-F33)
 
Per Install with 1 Year                           0001         16,595
 SW Maintenance
 
DB2 Intelligent Miner
Scoring V8.1 (5765-F36)
 
Per Processor with 1 Year                         0001         16,595
 SW Maintenance
 
DB2 UDB Enterprise Server
Edition V8.1 (5765-F41)
 
Per Processor with 1 Year                         0001         29,317
 SW Maintenance
 
Database Partitioning Feature
 Per Processor with 1 Year                        0002          8,795
 SW Maintenance
 
DB2 UDB Workgroup Server
Edition V8.1 (5765-F35)
 
Per Server Install with 1 Year                    0004          1,092
 SW Maintenance
 
Per Users with 1 Year                             0005            282
 SW Maintenance
 
DB2 UDB Workgroup Server
Unlimited Edition V8.1 (5765-F43)
 
Per Processor with 1 Year                         0001          8,795
 SW Maintenance

New Maintenance PIDs

                                                  OTC
                                                  Feature
Description                                       Number         OTC
 
DB2 Intelligent Miner Modeling V8.1
  1 yr (5765-F76)
 
Per Installs SW Maintenance                       0001        $     0
 Registration
Per Installs SW Maintenance                       0002         11,057
 1 Year Renewal
Per Installs SW Maintenance                       0003         33,169
 1 Year After License
 
DB2 Intelligent Miner Modeling V8.1
  3 yr (5765-F77)
 
Per Installs SW Maintenance                       0001         21,008
 3 Year Registration
Per Installs SW Maintenance                       0002         32,064
 3 Year Renewal
Per Installs SW Maintenance                       0003         54,177
 3 Year After License
 
                                                  OTC
                                                  Feature
Description                                       Number         OTC
 
DB2 Intelligent Miner Visualization V8.1
  1 yr (5765-F78)
 
Per Installs SW Maintenance                       0001              0
 Registration
Per Installs SW Maintenance                       0002          3,688
 1 Year Renewal
Per Installs SW Maintenance                       0003         11,063
 1 Year After License
 
DB2 Intelligent Miner Visualization V8.1
  3 yr (5765-F81)
 
Per Installs SW Maintenance                       0001          7,007
 3 Year Registration
Per Installs SW Maintenance                       0002         10,695
 3 Year Renewal
Per Installs SW Maintenance                       0003         18,070
 3 Year After License
 
DB2 Intelligent Miner Scoring V8.1
  1 yr (5765-F79)
 
Per Processor SW Maintenance                      0001              0
 Registration
Per Processor SW Maintenance                      0002          3,688
 1 Year Renewal
Per Processor SW Maintenance                      0003         11,063
 1 Year After License
 
DB2 Intelligent Miner Scoring V8.1
  3 yr (5765-F80)
 
Per Processor SW Maintenance                      0001          7,007
 3 Year Registration
Per Processor SW Maintenance                      0002         10,695
 3 Year Renewal
Per Processor SW Maintenance                      0003         18,070
 3 Year After License
 
DB2 Enterprise Server Edition V8.1
  1 yr (5765-F94)
 
Per Processor SW Maintenance                      0004              0
 1 Year Registration
Per Processor SW Maintenance                      0005          6,515
 1 Year Renewal
Per Processor SW Maintenance                      0006         19,545
 1 Year After License
 
Database Partitioning Feature
 
Per Processor SW Maintenance                      0001              0
 1 Year Registration
Per Processor SW Maintenance                      0002          1,954
 1 Year Renewal
Per Processor SW Maintenance                      0003          5,864
 1 Year After License
 
DB2 Enterprise Server Edition V8.1
  3 yr (5765-F95)
 
Per Processor SW Maintenance                      0004         12,379
 3 Year Registration
Per Processor SW Maintenance                      0005         18,894
 3 Year Renewal
Per Processor SW Maintenance                      0006         31,924
 3 Year After License
 
                                                  OTC
                                                  Feature
Description                                       Number         OTC
 
Database Partitioning Feature
 
Per Processor SW Maintenance                      0001         $3,713
 3 Year Registration
Per Processor SW Maintenance                      0002          5,667
 3 Year Renewal
Per Processor SW Maintenance                      0003          9,576
 3 Year After License
 
DB2 Workgroup Server Edition V8.1
  1 yr (5765-F98)
 
Per Users SW Maintenance                          0001              0
 Registration
Per Server Install SW                             0002              0
 Maintenance Registration
Per Users SW Maintenance                          0003             63
 1 Year Renewal
Per Users SW Maintenance                          0004            188
 1 Year After License
Per Server Install SW Maintenance                 0005            242
 1 Year Renewal
Per Server Install SW Maintenance                 0006            727
 1 Year After License
 
DB2 Workgroup Server Edition V8.1
  3 yr (5765-F99)
 
Per Users SW Maintenance                          0001            119
 3 Year Registration
Per Users SW Maintenance                          0002            181
 3 Year Renewal
Per Users SW Maintenance                          0003            306
 3 Year After License
Per Server Install SW Maintenance                 0004            461
 3 Year Registration
Per Server Install SW Maintenance                 0005            703
 3 Year Renewal
Per Server Install SW Maintenance                 0006          1,188
 3 Year After License
 
DB2 Workgroup Server Unlimited Edition V8.1
  3 yr (5765-F96)
 
Per Processor SW Maintenance                      0001              0
 1 Year Registration
Per Processor SW Maintenance                      0002          1,954
 1 Year Renewal
Per Processor SW Maintenance                      0003          5,864
 1 Year After License
 
DB2 Workgroup Server Unlimited Edition V8.1
  3 yr (5765-F97)
 
Per Processor SW Maintenance                      0001          3,713
 3 Year Registration
Per Processor SW Maintenance                      0002          5,667
 3 Year Renewal
Per Processor SW Maintenance                      0003          9,576
 3 Year After License

Customer Financing: IBM Global Financing offers attractive financing to credit-qualified commercial and government customers and Business Partners to assist them in acquiring IT solutions. Offerings, rates, terms, and availability can vary by country. Contact your local IBM Global Financing organization or visit the Web at:

Use the Select a Country menu, to find a contact in your location.
 
Back to top
 

Order now

 Use Priority/Reference Code: YE001
 
 Phone:     800-IBM-CALL
 Fax:       800-2IBM-FAX
 Internet:  ibm_direct@vnet.ibm.com
 Mail:      IBM Atlanta Sales Center
            Dept. YE001
            P.O. Box 2690
            Atlanta, GA  30301-2690

You can also contact your local IBM Business Partner or IBM representative. To identify them, call 800-IBM-4YOU.

Note: Shipments will begin after the planned availability date.

Trademarks

 
z/OS, IMS, Informix, QMF, Intelligent Miner, DB2 OLAP Server, iSeries, zSeries, DataPropagator, SP, Everyplace, and pSeries are trademarks of International Business Machines Corporation in the United States or other countries or both.
 
DB2, OS/390, DB2 Connect, Encina, DB2 Universal Database, DataJoiner, MQSeries, WebSphere, AIX, DB2 Extenders, S/390, Net.Data, NUMA-Q, Multiprise, SP2 and Visual Warehouse are registered trademarks of International Business Machines Corporation in the United States or other countries or both.
 
Intel and Pentium are registered trademarks 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.
 
Tivoli is a registered trademark of International Business Machines Corporation or Tivoli Systems Inc. in the United States or other countries or both.
 
Lotus is a registered trademark of Lotus Development Corporation and/or IBM Corporation.
 
Other company, product, and service names may be trademarks or service marks of others.

Back to top
 

 
Printable version