IBM United States
Software Announcement 200-089
April 18, 2000

IBM DB2 Universal Database Version 7.1 with DB2 Warehouse Manager, DB2 Net Search Extender, and DB2 OLAP Starter Kit Delivers Enhanced Function for All DB2 Users

 ENUS200-089.PDF (188KB)

(Corrected on August 4, 2000)

Deleted selected part numbers from Passport Advantage under DB2 Relational Connect section. Corrected part number in the License Information section.

(Corrected on May 11, 2000)

Added new Workgroup Unlimited Edition Version 7.1 Product Information throughout letter.

(Corrected on April 18, 2000)

Removed Unlimited Users Option Information.

At a Glance

DB2 Version 7.1 provides enhanced functions for all DB2 users, but it is specifically tailored to:

  • E-commerce — DB2 is the first and only database to combine the in-memory speed required for Internet search with handling complex text matching and with the scalability and availability of a relational database.
  • Customer Relationship Management (CRM) — DB2 meets the wide-ranging needs of CRM applications in a single infrastructure that gives you a choice of mobile client with zero end-user administration, scalable replication, leading Internet standards exploitation, and integrated analytical features.
  • Business Intelligence (BI) — DB2 offers a complete metadata-driven BI architecture with integrated best-of-class technologies to rapidly deploy business intelligence solutions that make a difference to the bottom line. DB2 facilitates solution integration by implementing the OMG CWMI standard.
  • Enterprise Resource Planning (ERP) and Supply Chain Management (SCM) — DB2 gives you leading performance and scalability from workstations through to mainframe platforms..

For ordering, contact:

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

Overview

For customers transforming their businesses to e-businesses, DB2® helps customers leverage their information by delivering the performance, scalability, reliability, and availability needed for the most demanding e-commerce, CRM, BI, and ERP applications. Unlike competitors, DB2 integrates these core strengths with differentiated features for the targeted applications in offerings that are easy to deploy, use, and manage, while giving you the lowest total cost of ownership.

Here are some highlights of this release:

Available — Always

DB2 is built for reliability and availability, so it's up when you are open for business. On the Internet, that means all the time.

Unparalleled Scalability

DB2 gives you the foundation for your business to manage the explosive growth of the Internet. DB2 supports millions of users and terabytes of data in leading e-business applications worldwide.

Easy Access to Your Business

DB2 empowers your mobile workers by putting enterprise information in the palms of their hands.

Leveraging Information

DB2 helps you extract, consolidate, integrate, summarize, analyze, and share information across your enterprise to identify new insights and opportunities.

Web Enablement

Built for the Web, DB2 supports all the key Internet standards. WebSphere™, a new XML Extender, and built-in Java™ support make it easy for you to deploy e-business applications. DB2 Net Search Extender allows extremely fast in-memory searches, including word or phrase, fuzzy, and wildcard searches.

Application Development

DB2 delivers the tools, including Java and Web tools, that you need to rapidly deploy applications on the Internet or anywhere.

Key Prerequisites

Refer to the Hardware Requirements and Software Requirements sections.

Planned Availability Date

June 16, 2000

September 22, 2000, for:

  • DB2 Enterprise Edition Version 7.1 for NUMA-Q®
  • DB2 Enterprise — Extended Edition Version 7.1 for NUMA-Q
  • DB2 Enterprise — Extended Edition Version 7.1 for HP-UX
  • DB2 Query Patroller Version 7.1 for HP-UX and NUMA-Q
  • DB2 Data Links Manager Version 7.1 for Solaris
  • DB2 Spatial Extender Version 7.1

Description

Leveraging Information

DB2 helps you extract, consolidate, integrate, summarize, analyze, and share information across your enterprise to identify new insights and opportunities. Here are the enhancements:

DB2 OLAP Starter Kit is included with each of the DB2 Universal Database® offerings with the exception of DB2 Satellite Edition. Its online analytical processing capabilities allows users to:

  • Easily define multidimensional applications
  • Link and populate those applications with warehouse data
  • Share the applications among a work group

Its easy-to-use interface to build and manage OLAP applications is based on the industry-leading Hyperion Essbase analytic engine. This DB2 OLAP Starter Kit is specially tailored for easy installation and use, and provides components of the DB2 OLAP Integration Server, an Administration Manager, and OLAP spreadsheet plug-ins for Excel and Lotus® 1-2-3®.

Relational OLAP: New SQL functions for moving aggregates, such as moving average and moving sum, are now available for analytical queries. They comply with the proposed OLAP Addendum to SQL-99.

Data Warehouse Center creates and manages data warehouses by easing the tasks of:

  • Registering and accessing data sources
  • Defining data extraction and transformation steps
  • Populating data warehouses
  • Automating and monitoring warehouse management processes
  • Managing and interchanging metadata

The new GUI is integrated with the DB2 Control Center and offers full replacement, incremental, and replication style data movement options for flexibility in maintaining the data warehouse.

DB2 Warehouse Manager is a separately priced feature that enhances the scalability, manageability, and accessibility of your DB2 warehouse. It features:

  • Better data scalability of the Data Warehouse Center with point-to-point data movement options for distributed systems.
  • Faster deployment via common, pre-built warehouse and statistical transformations.
  • Better user scalability by providing governing functions to manage query workloads.
  • Better manageability of the warehouse via resource and usage tracking.
  • Better end-user access by providing an information catalog to help end users find, understand, and access relevant information.
  • Enterprise reporting to develop and deliver reports to unlimited clients.

DB2 Warehouse Manager includes DB2 Query Patroller , the Information Catalog Manager , and QMF™ for Windows™ .

DB2 Query Patroller is now provided as an integral component of the DB2 Warehouse Manager . It gives you extensive query governing for workload management. Enhancements with this release are:

  • Client
    • Trap dynamic SQL queries regardless of the Query Interface.
    • Trap SQL queries exceeding specified threshold execution cost.
  • Server
    • Allow automatic restart following a database server failure.
    • Add support for user groups, which reduces administration costs.
    • Restart and quiesce Query Patroller agents on individual DB2 UDB EEE nodes.

The Information Catalog Manager , previously provided with Visual Warehouse®, is now an integral component of DB2 Warehouse Manager . It helps end users find, understand, and access available information by:

  • Populating the catalog through metadata interchange with the Data Warehouse Center and other analytical and reporting tools.
  • Allowing users to directly register shared information objects.
  • Providing navigation or searching across the objects to find relevant information.
  • Displaying the metadata about the object.
  • Launching the tools used to render the information for the end user.

QMF for Windows is included with the DB2 Warehouse Manager to provide a multipurpose query tool for business reporting, data sharing, server resource protection, robust application development and native connectivity to all of the DB2 workstation platforms. It allows users to:

  • Build queries and reports easily via its quick start interface.
  • Use the new Java-based query capability to launch queries from their favorite browser.
  • Easily integrate query results with desktop tools such as spreadsheets and personal databases.
  • Rapidly build data access and update applications.
  • Fully exploit DB2 performance, SQL syntax, and advanced database performance techniques such as static SQL.

Also, the Administrator component controls resource consumption by user group through detailed permissions by group, schedule, or both.

DB2 Spatial Extender , a separately priced feature, allows users to integrate spatial data into their business queries. It supports 13 spatial types to model real-world entities such as location of customers, boundary of parks, course of rivers, and path of cable lines. It conforms to the OpenGIS Consortium (OGC) and ISO standards for storing, indexing, and querying spatial data.

Web Ready

Built for the Web, DB2 supports all the key Internet standards. A Web server, the XML Extender, and built-in Java support make it easy for you to deploy e-business applications.

DB2 Net Search Extender is a feature that can be ordered separately to address the search requirements of e-commerce and Web self-service applications. It allows extremely fast, in-memory, full-text searches, including word or phrase, fuzzy, and wildcard searches. In addition, the following benefits can be realized:

  • Works seamlessly with text data contained in DB2.
  • Able to handle heavy text search demands of larger Web sites.
  • Designed to rapidly search and index data without locking database tables.
  • Stored procedure uses standardized SQL/MM search interface.
  • Excellent performance and scalability with regard to query load.

DB2 XML Extender is provided with each DB2 Universal Database server product. DB2 now allows you to store eXtensible Markup Language (XML) documents as a new column data type. You also have the ability to decompose and store XML in its component parts as columns in multiple tables. In either case, indices can be defined over the element or attribute of an XML document for fast retrieval. Furthermore, text search and section search can be enabled on the XML column or its decomposed part via DB2 Text Extender. You can also formulate an XML document from existing DB2 tables for data interchange in business-to-business environments. To facilitate business-to-consumer applications, Net.Data® and the XML Extender can be used to generate XML documents from DB2 and distribute to consumers via a browser.

Net.Data, a core Web enabling technology for DB2, is provided with each DB2 Universal Database offering. Enhancements with this release are:

  • Support for new DB2 XML data types provided by XML Extender.
  • Macro switch to XML or HTML output for built-in functions, default formatting of tables, and query results.
  • Generating XML documents from DB2 tables.
  • Attaching files to e-mail message and uploading browser files.

WebSphere: A complimentary copy of WebSphere Application Server, Standard Edition Version 3.02 is included in the DB2 server product package. It provides the Java servlet environment supported by the IBM Network Computing Framework for e-business, and tools like VisualAge® for Java. With the combination of WebSphere Application Server and Net.Data, and support for servlets, you can use new or existing Net.Data macros with other servlets created using e-business tools. For more information about WebSphere, visit the following Web site at:

Application Development

DB2 delivers the tools, including Java and Web tools, you need to rapidly deploy applications on the Internet or anywhere. Here are the enhancements in this release:

  • Declared temporary tables allowing applications that can create and use temporary tables for the duration of database connection.
  • Application save points, providing the developer the ability to group several SQL statements into executable block. If any statement in the block fails, only that statement is rolled back. At the end of the block, execution can continue or be rolled back to the save point.
  • Identity Columns providing assignment of sequential numbers to rows in a table, which are DBMS-generated with guaranteed uniqueness.
  • Simplified stored procedure development with the new and improved Stored Procedure Builder supporting SQL and Java stored procedures.
  • Ability to write UDF containing a single SQL statement, allowing Scalar function, row functions, and table functions.
  • Ability to define a column in a table where column values are pre-computed automatically using an expression. This can save time and money where expression evaluation can be very expensive if performed often, or where evaluation is expensive even if done occasionally (such as spatial calculations).
  • Ability to create an index on a generated column, as an alternative to either having them specified by a user on insert/update, which is error prone, or specified by triggers, which are complex to implement.
  • Building OLE-DB Applications under Windows with DB2 client support for OLE DB 2.0. This provides native, high-performance implementation and supports applications using ADO APIs. Integrated support for OLE stored procedures is also introduced.
  • Building Applications with MS Visual Studio
    • The Visual Basic and Visual C++ Stored Procedure Builder Add-In for building and deploying stored procedures written in Java or the new SQL Procedure language.
    • The Visual C++ Tools Add-In to launch DB2 tools such as the Control Center, or the Client Configuration Assistant.
    • The Visual C++ Project Add-in to automate the various tasks of developing embedded SQL applications in C++ for DB2, such as managing the pre-compilation step, generating new stored procedures in C++, generating C++ code to execute SQL statements and call existing stored procedures.
  • O-R language extensions to DB2 Universal Database.

Data Access Everywhere

DB2 empowers your mobile workers by putting enterprise information in the palms of their hands, and on multiple platforms.

This release of DB2 coincides with the beta program of DB2 Everyplace, a mobile database solution targeted at administration of DB2 Everyplace Clients on hand-held devices. DB2 Everyplace contains three components:

  • A small footprint database of about 100 K for PalmOS, WinCE, EPOC, and Neutrino devices.
  • A synchronization server to replicate data in both directions from devices directly to enterprise data sources such as DB2 on OS/390®, AS/400®, UNIX®, and Windows platforms.
  • An application development tool to build handheld applications with drag-and-drop ease.

Distributed Query: DB2 now provides distributed query capability across DB2 family databases, OLE DB data sources, and any data sources accessible via TABLE functions. This simplifies end-user access to distributed heterogeneous environments by making the backend data sources appear as a single database. This new distributed query capability incorporates the high-performance distributed query optimization techniques available with DB2 DataJoiner®.

DB2 Relational Connect, a separately priced feature, provides native read access to Oracle databases. This can be used with built-in heterogeneous query capabilities to formulate queries across DB2, Oracle, and OLE DB databases or with the Data Warehouse Center to accelerate access performance from Oracle sources for loading a DB2 data warehouse. DB2 Relational Connect makes Oracle access completely transparent to the calling application and supports the full SELECT API features of DB2. Differences between the DB2 capabilities and the Oracle function are masked from the application without any loss of function due to automatic compensation built into DB2.

DB2 Data Links Manager is a feature, ordered separately for DB2, which facilitates the access of distributed data with the security and ease-of-use of the DB2 user interface. The following enhancements are introduced:

  • Support for DCE Distributed File System (DFS)
  • Support for the Solaris Operating Environment
  • Support for archiving of linked files to Independent Solution Vendors' backup solutions
  • Support for replication using the DB2 Data Propagator product, allowing multi-site development for customers with multiple shops

Unparalleled Scalability

DB2 provides the foundation for your business to manage the explosive growth of the Internet. DB2 supports millions of users and terabytes of data in leading e-business applications worldwide.

Enterprise Integration is aided through the following enhancements:

  • Windows 2000 exploitation
    • Use Active Directory to locate databases and servers.
    • Support single sign-on using Kerberos.
    • Support Kerberos and Server/Encrypt security for mixed environments.
    • Support for NTLM userid length up to the maximum 20 characters.
    • Launch DB2 Control Center from the Computer Management Console.
    • Support for Windows 2000 Logical Raw partitions.

    Also, DB2 meets all the requirements for Windows 2000 Server Certification.

Performance and Capacity Enhancements made in this release are as follows:

  • Active log size limit raised to 32 GB, allowing longer-running transactions.
  • Support for multiple TCP/IP listeners gives you the ability to handle more concurrent TCP/IP connections.
  • Microsoft's SNA Server support for Two-Phase Commit. DB2 users with MS Back Office can involve Windows, OS/400®, and host database servers in multisite update transactions.
  • DB2 Connect® provides tightly coupled XA support by the concentrator. This gives you the ability to use a single worker agent to serve all applications working on a single, tightly coupled XA transaction.
  • Support for Java Transaction API (JTA) and JDBC 2.0 distributed transaction support, used by IBM Enterprise Java Server, which provides distributed programming environment based on the Enterprise Java Beans model.
  • Client-side Unicode support allowing an application interface that accepts Unicode characters.
  • Filtered log recovery giving the ability to skip recovery of specified tables, indexes, and table space during roll-forward processing and allows the database to be brought back online without waiting to fix problems with broken database objects.
  • Flushing logs during online backup is an option to close active log when online backup completes "db2 backup db testdb online flush log". This significantly reduces log management during online backups.
  • Enhancements to Automated Summary Tables (ASTs) allow "refresh immediate" replicated table, conversion between regular table and summary table, and provide the ability to refresh multiple tables concurrently.
  • Ability to rename a table space, which gives ease of movement of data from one table space to another.

Available Anytime

DB2 is built for reliability and availability, so it's up when you are open for business. On the Internet, that means all the time. To support this reliability and availability, DB2 provides the following enhancements:

Load Utility

  • Import and Load utility support new format extensions:
    • User-defined date and time formats
    • Zoned decimal format
    • Preservation of blanks in DEL format for char and varchar columns
  • New LOAD authority
    • Allows users to load tables without requiring them to have SYSADM or DBADM authorities
  • Remote load capability
    • File to be loaded can reside on the remote client instead of on the local database server

Year 2000

The service end date for these Year-2000-ready products is December 31, 2002.

Reference Information

Other related products that will be available in June are:

  • DB2 Connect Personal Edition Version 7.1 (5648-D40)
  • DB2 Connect Enterprise Edition Version 7.1 (5648-D42)
  • DB2 Connect Unlimited Edition Version 7.1 (5648-D42)
  • DB2 OLAP Server® Version 7.1 (5648-OLP)
  • DB2 Satellite Edition (closed beta program)
  • DB2 QMF for Windows Version 6.1 (5697-E35)
  • DB2 Everyplace Version 7.1 (beta program)

    For product information, refer to:

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

  • DB2 Server for VSE & VM Version 7.1 (beta program)

    For beta program participation, refer to:

    http://www-4.ibm.com/software/data/db2/vse-vm/

Trademarks

 
WebSphere and QMF are trademarks of International Business Machines Corporation in the United States or other countries or both.
 
DB2, DB2 Universal Database, Visual Warehouse, Net.Data, VisualAge, OS/390, AS/400, DataJoiner, OS/400, DB2 Connect, and DB2 OLAP Server are registered trademarks of International Business Machines Corporation in the United States or other countries or both.
 
Windows is a trademark of Microsoft Corporation.
 
Java is a trademark of Sun Microsystems, Inc.
 
UNIX is a registered trademark in the United States and other countries exclusively through X/Open Company Limited.
 
Lotus and 1-2-3 are registered trademarks of Lotus Development Corporation.
 
NUMA-Q is a registered trademark of Sequent Computer Systems, Inc., a wholly owned subsidiary of IBM Corporation.
 
Other company, product, and service names may be trademarks or service marks of others.

Additional Information

Object Relational Features

Abstract or structured data types are type mechanisms for modeling and storing complex objects in a relational database. Structured types may have multiple fields embedded within them, for example, a geometric shape (a list of Cartesian coordinates), or an employee (name, address, gender, birth date, and employee number) can be modeled and stored in DB2 Universal Database®.

Structured Types: Structured type support has been extended to give you the ability to create tables with structured type columns. Additionally, structured types can be nested within a structured type. This means that the attributes of a structured type are no longer restricted to the base SQL types, they can now be of another structured type.

In Version 7, you can define functions with input parameters or parameters on the RETURNS clause that are structured types. You can also define methods for each structured data type, which permit the encapsulation of behavior with data. A method is defined very much like a function, but its use is strictly associated with structured types. It is essentially a routine with a structured type instance as its implicit first argument.

The Reorganize Table (REORG) and the db2look utilities can be used on tables with structured type columns.

Transform Functions: Transform functions enable the use of structured type columns with user written programs. Transform functions convert the complex structure within a structured data type into an ordered set of its base SQL types. They also convert the base attributes back to their structured types. These transforms are required to move structured types in and out of a database.

SQL-bodied Functions: An SQL-bodied function contains expressions or SELECT statements within its body, which is embedded into the calling SQL (similar to a macro). This allows the query compiler to optimize the whole SQL statement including the SQL-bodied function. Structured data types make use of SQL-bodied function for their transform functions and methods.

Typed Tables: You can now use referential integrity constraints and triggers with typed tables.

Education Support

The appropriate curriculum will be updated, as necessary, to include the enhancements described in this announcement.

Descriptions of all classroom and self-study courses are available by visiting the IBM Web site at:

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

Offering Information

Product information is available through Offering Information (OITOOL) at:

Publications

The following updated DB2 Universal Database publications will be available for separate order on June 16, 2000, for a fee. To order these publications separately, contact your IBM representative.

                                                  Order
Title                                             Number
 
Administration Guide:  Planning                   SC09-2946
Administration Guide:  Implementation             SC09-2944
Administration Guide:  Performance                SC09-2945
For all three Administration Guides above         SBOF-8934
Administrative API Reference                      SC09-2947
Application Building Guide                        SC09-2948
Application Development Guide                     SC09-2949
CLI Guide and Reference                           SC09-2950
Command Reference                                 SC09-2951
Data Movement Utilities Guide                     SC09-2955
DB2 Connect(R) User's Guide                       SC09-2954
DB2(R) Data Warehouse Center                      SC26-9993
 
  Administration Guide Version 7
DB2 Data Warehouse Center Application             SC26-9994
  Integration Guide Version 7
Getting Started with QMF(TM) for Windows(TM)      SC26-9582
Installing and Managing QMF for Windows           GC26-9583
DB2 Net Search Extender Administration            SC27-0818
  and Programming Version 7
DB2 OLAP Server(R) and Starter Kit                SC27-0702
  OLAP Setup and User's Guide Version 7
DB2 OLAP Server and Starter Kit                   SC27-0786
  OLAP Spreadsheet Add-In User's Guide
  for Excel Version 7
DB2 OLAP Server and Starter Kit                   SC27-0785
  OLAP Spreadsheet Add-In User's Guide
  for 1-2-3(R) Version 7
DB2 Query Patroller Administration Guide          SC09-2958
DB2 Query Patroller User's Guide                  SC09-2960
DB2 Spatial Extender User's Guide and             SC27-0701
  Reference Version 7
DB2 UDB Image, Audio, and Video                   SC26-9929
  Extenders Administration and
  Programming Version 7
DB2 UDB Text Extender Administration and          SC26-9930
  Programming Version 7
DB2 Warehouse Manager Information                 SC26-9995
  Catalog Manager Administration
  Guide Version 7
                                                  Order
Title                                             Number
 
DB2 Warehouse Manager Information                 SC26-9997
  Catalog Manager Programming Guide
  and Reference Version 7
DB2 Warehouse Manager Information                 SC26-9996
  Catalog Manager User's Guide
  Version 7
Getting Started with QMF for Windows              SC26-9582
Installation and Configuration                    GC09-2957
  Supplement
Installing and Managing QMF for                   GC26-9583
  Windows
Message Reference, Volume 1                       SC09-2978
Message Reference, Volume 2                       SC09-2979
For both Message Reference Volumes                SBOF-8932
OLAP Integration Server                           SC27-0787
  Administration Guide
OLAP Integration Server                           SC27-0784
  Metaoutline User's Guide
OLAP Integration Server Model                     SC27-0783
  User's Guide
Replication Guide and Reference                   SC26-9920
SQL Getting Started                               SC09-2973
SQL Reference, Volume 1                           SC09-2974
SQL Reference, Volume 2                           SC09-2975
For both SQL Reference volumes                    SBOF-8933
System Monitor Guide and Reference                SC09-2956
Troubleshooting Guide                             GC09-2850
What's New                                        SC09-2976
 
Installation Information
 
DB2 Connect Enterprise Edition for OS/2(R)        GC09-2953
  and Windows Quick Beginnings
DB2 Connect Enterprise Edition                    GC09-2952
  for UNIX(R) Quick Beginnings
DB2 Connect Personal Edition                      GC09-2967
  Quick Beginnings
DB2 Connect Personal Edition                      GC09-2962
  Quick Beginnings for Linux
DB2 Data Links Manager Quick Beginnings           GC09-2966
DB2 Enterprise -- Extended Edition                GC09-2964
  for UNIX Quick Beginnings
DB2 Enterprise -- Extended Edition                GC09-2963
  for Windows Quick Beginnings
DB2 for OS/2 Quick Beginnings                     GC09-2968
DB2 for UNIX Quick Beginnings                     GC09-2970
DB2 for Windows Quick Beginnings                  GC09-2971
DB2 Personal Edition Quick Beginnings             GC09-2969
DB2 Personal Edition                              GC09-2972
  Quick Beginnings for Linux
DB2 Query Patroller Installation Guide            GC09-2959
DB2 Warehouse Manager Installation Guide          GC26-9998

You can also order the books from the Publications Web page at:

To order manuals specific to the new DB2 Warehouse Manager product, the following publications are contained in SBOF-8935:

  • Query Patroller Administration Guide
  • Query Patroller User's Guide
  • Warehouse Manager Information Catalog Manager Administration Guide
  • Warehouse Manager Information Catalog Manager Programming Guide and Reference
  • Warehouse Manager Information Catalog Manager User's Guide

The other special order number SBOF-8931, provides all the DB2 documentation with the exclusion of those provided above under SBOF-8935.

Displayable Softcopy Publications: Publications for DB2 are included in softcopy form on the CD-ROM as part of the install image. To assist with the initial installation, each product's Quick Beginnings book is also provided in hardcopy within the product box.

To see which manuals are provided with DB2 products, refer to the Packaging section.

The displayable manuals can be viewed using an HTML browser installed on your system, or by using the Netscape Navigator browser provided.

There is also a separate publications CD-ROM where PDF versions of the library can be viewed or printed. These files can produce high-quality reproductions of the documentation on local laser printers.

Open Blueprint®

DB2 Universal Database products provide the relational database function described in IBM's Open Blueprint. They provide the:

  • Structured Query Language (SQL) industry-standard interface including the SQL Multimedia and Application Packages (SQL/MM) interface from the International Organization for Standardization (ISO)
  • SQL Call Level Interface (SQL CLI) industry standard from the ISO
  • Open Database Connectivity (ODBC) for Windows client systems interface from Microsoft™ Corporation

It supports the Distributed Relational Database Architecture™ (DRDA®) protocol from the Open Group to facilitate open, distributed, multivendor interoperability.

Open Enterprise: The products announced adhere to the following standards:

  • Object Management Group (OMG) Common Warehouse Metadata Interchange (CWMI)
  • ANS Database Language-SQL, X3.135-1992 (ANSI SQL92) (Entry Level)
  • ISO/IEC 9075: 1992 Database Language SQL (ISO SQL92)
  • Database Language SQL, Federal Information Processing Standards Publication 127-2 (FIPS PUB 127-2)
  • Microsoft Winsosheet and Microsoft Winsockets
  • OSF for DCE Standard 1.1
  • Open Group Technical Standard DRDA Version 2
  • X/Open XA CAE Specification
  • ODBC 2 Level 2 Compliant and ODBC 3.0 Level 1 Compliant plus Level 2 compliance in the following:
    • 202 — Dynamic parameters described using SQLDescribeParam
    • 203 — Support for input, output, and input/output parameters and result values of stored procedures
    • 205 — Advanced information on the data dictionary from SQLColumnPrivileges, SQLForeignKeys, and SQLTablePrivileges
    • 207 — Asynchronous execution of appropriate functions
    • 209 — SQL_ATTR_CONCURRENCY statement attribute can be set to at least one value other than SQL_CONCUR_READ_ONLY
    • 211 — Default isolation level can be changed; transactions can be executed with the "serialized" level of isolation

Technical Information

Hardware Requirements

The hardware requirement for the DB2 products is a central processing unit (CPU), with the processing capacity of an Intel 486 processor, or higher.

Memory Requirements: The following tables show applicable recommended minimum memory for installation prerequisite in megabytes (MB). The actual requirement depends on the applications the customer intends to run. The numbers below are for reference only.

UNIX              5 connections                           64
UNIX              50 connections                         208
UNIX              DB2 Administration Tools               128
Intel             5 connections                           64
Intel             50 connections                          80
Intel             DB2 Administration Tools               128

.-------------------+--------+---------+----------+----------.
|                   |        |         |          |Enterprise|
|                   |Personal|Workgroup|Enterprise| Extended |
|                   |Edition |Edition  |Edition   | Edition  |
|-------------------+--------+---------+----------+----------|
|UNIX Installation  |128*    |128*     |128*      |128*      |
|-------------------+--------+---------+----------+----------|
|Intel Installation |128*    |128*     |128*      |128*      |
|-------------------+--------+---------+----------+----------|
| Note:  * Includes GUI tools                                |
'------------------------------------------------------------'

DB2 Options

.--------------------+--------+-----------+---------+---------.
|                    | Data   |           | Net     |         |
|                    | Links  | Relational| Search  | Spatial |
|                    | Manager| Connect   | Extender| Extender|
|--------------------+--------+-----------+---------+---------|
|UNIX Installation   |  256   |  32       | 1024    |  32     |
|--------------------+--------+-----------+---------+---------|
|Intel Installation  |   64   |  32       | 512     |  32     |
|--------------------+--------+-----------+---------+---------|
| Note: Data Links Manager is not available on Windows 2000.  |
'-------------------------------------------------------------'

DB2 Warehouse Manager Components

.--------------+----------+------------+-----------+----------.
|              |          | Information| Query     |          |
|              | Query    | Catalog    | Management| Warehouse|
|              | Patroller| Manager    | Facility  | Agent    |
|--------------+----------+------------+-----------+----------|
|UNIX systems  | 128      | N/A        | N/A       | 64       |
|--------------+----------+------------+-----------+----------|
|Intel systems |  64      | 64         | 32        | 64       |
'--------------+----------+------------+-----------+----------'

DB2 Client Requirements

.------+----------+---------------+-------------+----------.
|      |          |               | Application | Query    |
|      | Run-Time | Administration| Development | Patroller|
|------+----------+---------------+-------------+----------|
|UNIX  |    16    |      32       |     16      |     32   |
|------+----------+---------------+-------------+----------|
|Intel |    16    |      32       |     16      |     32   |
'------+----------+---------------+-------------+----------'

DB2 Disk Space Requirements

The following tables show 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.

.--------------+------+-----+-------+----+---+-------+-----.
|              |NUMA-Q|HP-UX|Solaris|OS/2|AIX|NT/2000|Linux|
|--------------+------+-----+-------+----+---+-------+-----|
| Personal     |N/A   |N/A  |N/A    |150 |N/A|205    |150  |
|  Edition     |      |     |       |    |   |       |     |
|--------------+------+-----+-------+----+---+-------+-----|
| Enterprise   | 80   |282  |197    |155 |183|245(1) |130  |
|  Edition     |      |     |       |    |   |       |     |
|--------------+------+-----+-------+----+---+-------+-----|
| Ent. Ext.    | 80   |282  |197    |N/A |183|245(1) |N/A  |
|  Edition     |      |     |       |    |   |       |     |
|--------------+------+-----+-------+----+---+-------+-----|
| Workgroup    | 80   |282  |197    |150 |183|245(1) |130  |
|  Edition     |      |     |       |    |   |       |     |
|--------------+------+-----+-------+----+---+-------+-----|
| Notes                                                    |
|                                                          |
|   Add another 109 MB for documentation.  This is true for|
|     all platforms except NUMA-Q(R) and also to those     |
|     referenced by (1).                                   |
|   (1) Includes documentations, administration tools, and |
|     JRE.                                                 |
'----------------------------------------------------------'

DB2 Options

.-----------+-------+-----+-------+-----+-----+-------+-----.
|           |NUMA-Q |HP-UX|Solaris|OS/2 |AIX  |NT/2000|Linux|
|           |       |     |       |     | (R) |       |     |
|-----------+-------+-----+-------+-----+-----+-------+-----|
|Warehouse  | N/A   |N/A  |50(1)  |50(1)|50(1)|175(2) |N/A  |
| Manager   |       |     |       |     |     |       |     |
|-----------+-------+-----+-------+-----+-----+-------+-----|
|Relational | N/A   |N/A  |N/A    |N/A  |<5   | 10    |N/A  |
| Connect   |       |     |       |     |     |       |     |
|-----------+-------+-----+-------+-----+-----+-------+-----|
|Data Links | N/A   |N/A  |N/A    |N/A  |205  |205(3) |N/A  |
| Manager   |       |     |       |     |     |       |     |
|-----------+-------+-----+-------+-----+-----+-------+-----|
|Spatial    | N/A   |N/A  |N/A    |N/A  |600  |600    |N/A  |
| Extender  |       |     |       |     |     |       |     |
|-----------+-------+-----+-------+-----+-----+-------+-----|
|Net Search | N/A   |N/A  |30     |N/A  |30   | 30    |N/A  |
| Extender  |       |     |       |     |     |       |     |
|-----------+-------+-----+-------+-----+-----+-------+-----|
| Notes                                                     |
|                                                           |
|  Transformers require 12 MB on NT/2000, OS/2, AIX, and    |
|  Solaris.                                                 |
|                                                           |
|  (1) These numbers are for the warehouse agent only.      |
|  (2) Includes ICM tools, Administration, User, and agents.|
|  (3) Data Links Manager not available on Windows 2000.    |
|                                                           |
'-----------------------------------------------------------'

For DB2 Clients

.---------+------+-----+-------+----+---+-------+-----+-----.
|         |NUMA-Q|HP-UX|Solaris|OS/2|AIX|NT/2000|Linux|SGI  |
|---------+------+-----+-------+----+---+-------+-----+-----|
|Adminis- | N/A  | 90  |  96   | 95 |107| 125   | 77  |N/A  |
| tration |      |     |       |    |   |       |     |     |
| Client  |      |     |       |    |   |       |     |     |
|---------+------+-----+-------+----+---+-------+-----+-----|
|Run-Time |  30  | 35  |  39   | 30 | 39|  25   | 23  |70   |
| Clients |      |     |       |    |   |       |     |     |
|---------+------+-----+-------+----+---+-------+-----+-----|
|Applica- |  40  | 99  | 106   |125 |120| 325(2)| 86  |78(1)|
| tion    |      |     |       |    |   |       |     |     |
| Develop-|      |     |       |    |   |       |     |     |
| ment    |      |     |       |    |   |       |     |     |
|---------+------+-----+-------+----+---+-------+-----+-----|
| Notes                                                     |
|                                                           |
|  (1) No control center                                    |
|  (2) Includes JDK                                         |
'-----------------------------------------------------------'

OLAP Starter Kit requires 64 MB memory and 70 MB disk space, which includes server and sample applications and SQL interface.

Software Requirements

The offerings in this announcement have the following requirements for their operating systems:

  • AIX
    • Requires an AIX operating system Version 4.2.1, or later, for 32 bit with UNICODE support for the warehouse agents
  • HP-UX
    • Requires an HP-UX operating system Version 11, or later
    • Supports compiler for C++, Version A.03.13
  • NUMA-Q
    • Requires a NUMA-Q operating system Version 4.5.1, or later
  • Windows
    • Requires a Windows NT™ operating system Version 4 with SP5, or later
    • Requires a Windows 95 operating system Version 4.00.950, or later
    • Requires a Windows 98 operating system (no prerequisite requirement)
    • Requires a Windows 2000 operating system (no prerequisite requirement)
  • OS/2
    • Requires an OS/2 operating system Version 4, or later
  • Solaris
    • Requires a Solaris operating system Version 2.6, or later, for 32 bit with UNICODE support for the warehouse agents
  • Linux
    • Supports kernel level 2.2.12
    • Supports glibc level 2.1.2
    • Supports libstdc++ 2.9.0
    • Prerequisite pdksh and rpm
  • Silicon Graphics IRIX
    • Version 6.2, and later

Compatibility: DB2 Clients for Version 5.2 will continue to operate without modifications with DB2 Universal Database Version 7.1 products.

DB2 Version 7.1 products support connection to DB2 Version 6.1 Servers. DB2 Clients for Version 7.1 will operate without modifications with DB2 Universal Database Version 6.1 Server products.

Visual Warehouse®: Versions 3 and 5 cannot be used with the Data Warehouse Center or the Warehouse Manager. On Microsoft and OS/2 systems, Visual Warehouse products will be uninstalled when DB2 Version 7 products are installed.

Limitations

License Limitations: The following license limitations exist with the DB2 Version 7.1 products:

  • DB2 Workgroup Edition Version 7.1 is restricted to installation on a server with a maximum of four processors on Intel and Linux and a maximum of two processors on UNIX. However, for customers who purchase Workgroup Unlimited Edition, the maximum processors allowed will be up to eight processors for Intel and Linux and up to four processors for UNIX.
  • DB2 Universal Developer's Edition Version 7.1 is restricted to one developer only. No additional use authorizations are available to allow multiple developers on one installation. It is also restricted to the evaluation, demonstration, testing, and development of application programs.
  • DB2 Personal Developer's Edition Version 7.1, now provided at no charge, is not restricted for installations or users, but is restricted to the evaluation, demonstration, testing, and development of application programs.
  • DB2 Data Links Manager Version 7.1 must be used with a licensed copy of DB2 Enterprise Edition Version 7.1.
  • DB2 Warehouse Manager Version 7.1 and its components must be used with a licensed copy of DB2 Enterprise — Extended Edition Version 7.1 or DB2 Enterprise Edition Version 7.1.
  • DB2 Personal Edition Version 7.1 allows inbound connections only for administrative purposes. This means you can not utilize DB2 Personal Edition for interactive host database access.
  • A copy of DB2 Universal Database Enterprise Edition is provided within several other products, such as WebSphere™, under restricted use terms. This database is supplied for internal product (that is, WebSphere) administrative functions. There is the implicit storage requirements of the Enterprise Java™ Server container for Enterprise JavaBeans.

    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.

  • When the Warehouse Server component of the DB2 Universal Database Server is installed, a DB2 Universal Database for NT server of the same edition as the purchased license is also installed with a restricted use license. You are entitled to use this DB2 server on NT to manage one or more of the following types of data:
    • Warehouse Control database
    • Information Catalog database
    • Sample databases created by DB2 Version 7 products or components

    Any other use requires a full unrestricted license.

  • The ObjectREXX Interpreter Edition for Windows is distributed with DB2 for use with the DataJoiner® Replication Administration (DJRA) tool. You may use this component only in association with DJRA. For all other uses of ObjectREXX, you must purchase an ObjectREXX license.

Technical Limitations

  • Net.Data® does not support Windows 95/98, nor Version 7 SGI Client.
  • SQLJ will not be supported in any environment that enforces the 8.3 filename restriction such as OS/2 FAT systems.
  • Audio, Video, and Image (AVI) Extenders do not support the DB2 SGI client, Linux, nor NUMA-Q.
  • Text Extender does not support the DB2 SGI client, the Windows 95 and Windows 98 servers, Linux, nor NUMA-Q.
  • Stored procedure debugging is supported for DB2 servers on the Windows NT, Solaris, and AIX platforms only.
  • Change Password is not supported with NUMA-Q, Solaris, HP-UX, nor Linux.
  • DCE operates on all platforms supporting OSF Standard 1.1. These platforms are:
    • AIX
    • HP-UX
    • Solaris
    • OS/2
    • Windows NT/95
  • ADSM Version 3 clients supported on:
    • Win 95/NT
    • OS/2
    • AIX
    • HP-UX
    • Solaris
    • Linux
    • NUMA-Q
  • Connectivity restrictions:
    • DRDA support requires OS/400® Version 4 Release 2 for TCP/IP support to DB2/400.
    • Named Pipes is available only on Windows 95, Windows NT, Windows 98, and OS/2, which supports Named Pipes for local DOS and Windows-OS/2 applications.
    • Novell IPX/SPX is not supported from Windows 95/98 clients to servers on OS/2, HP-UX, Solaris, AIX, nor Linux.
    • DB2 Client support for IPX is not available on HP-UX Version 11.
  • HACMP ES and HACMP are supported by DB2 UDB Version 7.1.
  • DB2 DataPropagator™ (DB2 DProp) supports Linux Redhat Version 2.0.35 and Linux SuSE.
  • Replication is not supported for DB2 Extenders® for Text, Audio, Video and Image, or other extenders where additional control files associated with the extender's LOB column data are maintained outside of the database.
  • The following products require a licensed copy of DB2 EE or EEE:
    • DB2 Warehouse Manager (EE, EEE)
    • DB2 Relational Connect (EE, EEE)
    • DB2 Spatial Extender (EE, EEE)
    • DB2 Net Search Extender (EE)
    • DB2 Data Links Manager (EE)
  • The Data Warehouse Center (DWC) requires a Warehouse Server component. The Warehouse Server component is available only on Windows NT and 2000.
  • Distributed requests issued within a federated environment are limited to read-only operations.
  • Microsoft SNA Server and SNA Multisite Update (Two Phase Commit) Support:
    • Host and AS/400 applications cannot access DB2 UDB Servers using SNA two phase commit when Microsoft SNA Server is the SNA product in use. Any DB2 UDB publications indicating this is supported are incorrect. IBM Communications Server for Windows NT Version 5.02 or greater is required.
    • Please note, however, that UNIX or PC applications accessing host and AS/400 database servers using DB2 UDB Enterprise Edition for Windows Version 7, DB2 UDB Enterprise - Extended Edition for Windows Version 7, or DB2 Connect Enterprise Edtion for Windows Version 7 can utilize SNA two phase commit using Microsoft SNA Server Version 4 Service Pack 3 or greater.

Product Platform Matrix: Refer to the following table for platform support for:

  • DB2 Personal Edition (PE)
  • DB2 Workgroup Edition (WE)
  • DB2 Enterprise Edition (EE)
  • DB2 Enterprise — Extended Edition (EEE)
  • DB2 Connect Personal Edition (CPE)
  • DB2 Connect Enterprise Edition (CEE)
  • DB2 Personal Developer's Edition (PDE)
  • DB2 Universal Developer's Edition (UDE)
  • DB2 Data Links Manager (DLM)
  • DB2 Warehouse Manager (DWM)
  • Application Development Client (ADC)
  • DB2 Net Search Extender (DNS)
  • DB2 Spatial Extender (DSE)
  • Run-Time Client (RT)
  • Administration Client (AD)
  • DB2 Relational Connect (RC)
  • Online Analytical Processing (OLAP) Starter Kit
  • Data Warehouse Center (DWC)
  • DB2 Query Patroller (DQP)
  • Information Catalog Manager (ICM)
  • Query Management Facility (QMF)

.-----------+---+---+---+--+--+---+---+---+---.
|Platform   |PE |CPE|PDE|WE|EE|DLM|CEE|EEE|DWM|
|-----------+---+---+---+--+--+---+---+---+---|
|OS/2       | Y | Y | Y |Y |Y | N | Y | N | S |
|-----------+---+---+---+--+--+---+---+---|   |
|AIX        | N | N | N |Y |Y | Y | Y | Y | e |
|-----------+---+---+---+--+--+---+---+---|   |
|WIN 95     | Y | Y | Y |N |N | N | N | N | e |
|-----------+---+---+---+--+--+---+---+---|   |
|WIN NT     | Y | Y | Y |Y |Y | Y | Y | Y |   |
|-----------+---+---+---+--+--+---+---+---|   |
|WIN 98     | Y | Y | Y |N |N | N | N | N | B |
|-----------+---+---+---+--+--+---+---+---|   |
|WIN 2000   | Y | Y | Y |Y |Y | N | Y | Y | e |
|-----------+---+---+---+--+--+---+---+---|   |
|HP-UX      | N | N | N |Y |Y | N | Y | Y | l |
|-----------+---+---+---+--+--+---+---+---|   |
|Solaris    | N | N | N |Y |Y | Y | Y | Y | o |
|-----------+---+---+---+--+--+---+---+---|   |
|SGI IRIXV6 | N | N | N |N |N | N | N | N | w |
|-----------+---+---+---+--+--+---+---+---|   |
|NUMA-Q     | N | N | N |N |Y | N | Y | Y |   |
|-----------+---+---+---+--+--+---+---+---|   |
|Linux      | Y | Y | Y |Y |Y | N | Y | N |   |
'-----------+---+---+---+--+--+---+---+---+---'
 
.-----------+---+---+--+--+---+---+--+----+---.
|Platform   |UDE|ADC|AD|RT|DNS|DSE|RC|OLAP|DWC|
|-----------+---+---+--+--+---+---+--+----+---|
|OS/2       | Y | Y |Y |Y | N | N |N | N  | N |
|-----------+---+---+--+--+---+---+--+----+---|
|AIX        | Y | Y |Y |Y | Y | Y |Y | Y  | Y |
|-----------+---+---+--+--+---+---+--+----+---|
|WIN 95     | Y | Y |Y |Y | N | N |N | Y  | Y |
|-----------+---+---+--+--+---+---+--+----+---|
|WIN NT     | Y | Y |Y |Y | Y | Y |Y | Y  | Y |
|-----------+---+---+--+--+---+---+--+----+---|
|WIN 98     | Y | Y |Y |Y | N | N |N | Y  | Y |
|-----------+---+---+--+--+---+---+--+----+---|
|WIN 2000   | Y | Y |Y |Y | Y | Y |Y | Y  | Y |
|-----------+---+---+--+--+---+---+--+----+---|
|HP-UX      | Y | Y |Y |Y | N | N |N | N  | N |
|-----------+---+---+--+--+---+---+--+----+---|
|Solaris    | Y | Y |Y |Y | Y | N |N | Y  | Y |
|-----------+---+---+--+--+---+---+--+----+---|
|SGI IRIXV6 | Y | Y |N |Y | N | N |N | N  | N |
|-----------+---+---+--+--+---+---+--+----+---|
|NUMA-Q     | Y | Y |N |Y | N | N |N | N  | N |
|-----------+---+---+--+--+---+---+--+----+---|
|Linux      | Y | Y |Y |Y | N | N |N | N  | N |
'-----------+---+---+--+--+---+---+--+----+---'

Data Warehouse Manager Components

.-----------+-----+---+---+------+------------.
|Platform   | DQP |ICM|QMF|Agents|Transformers|
|-----------+-----+---+---+------+------------|
|OS/2       |  N  | N | N |  Y   |     Y      |
|-----------+-----+---+---+------+------------|
|AIX        |  Y  | N | N |  Y   |     Y      |
|-----------+-----+---+---+------+------------|
|WIN 95     |  N  | Y | Y |  N   |     N      |
|-----------+-----+---+---+------+------------|
|WIN NT     |  Y  | Y | Y |  Y   |     Y      |
|-----------+-----+---+---+------+------------|
|WIN 98     |  N  | Y | Y |  N   |     N      |
|-----------+-----+---+---+------+------------|
|WIN 2000   |  Y  | Y | Y |  Y   |     Y      |
|-----------+-----+---+---+------+------------|
|HP-UX      |  Y  | N | N |  N   |     N      |
|-----------+-----+---+---+------+------------|
|Solaris    |  Y  | N | N |  Y   |     Y      |
|-----------+-----+---+---+------+------------|
|Linux      |  N  | N | N |  N   |     N      |
|-----------+-----+---+---+------+------------|
|NUMA-Q     |  Y  | N | N |  N   |     N      |
'-----------+-----+---+---+------+------------'

Planning Information

Licensing Information: Customers are responsible for determining their license requirements with the DB2 product family. The DB2 license entitlements are by users, processors, and installations.

User Entitlement: There are two counting methods of counting users of the DB2 product and of determining the required user entitlements. Customers should plan on which of the two counting 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 counting methods are counting concurrent users and counting registered users.

The definition of concurrent and registered users is as follows:

  1. 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 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 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.

  2. 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 of DB2 Workgroup Edition are counted separately, 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.

DB2 Workgroup Edition licenses include entitlement for one concurrent or registered user. Connections from DB2 Satellite Edition and DB2 Personal Edition may not be counted as DB2 Users for the purposes of determining the licensing requirements for the server machine. DB2 Workgroup Unlimited Edition licenses include entitlement for unlimited users for one processor.

DB2 Enterprise Edition and DB2 Enterprise — Extended Edition do not restrict access to local DB2 server data through user counting, although customers are required to obtain user entitlements for host connectivity with these two products.

DB2 Satellite Edition and DB2 Personal Edition are licensed for installation and use by an individual user at one workstation. Remote connections to DB2 Satellite Edition and DB2 Personal Edition are allowed for Administration purposes only.

The DB2 Personal Developer's Edition and DB2 Universal Developer's Edition products are licensed for installation and use by an individual user only for the purpose of evaluating, demonstrating, testing, and developing application programs. Multiple user entitlements are not available for either of these programs, although DB2 Personal Developer's Edition is available at no charge.

Processor Entitlements: The following DB2 program packages include entitlements to install the program on a machine having one processor:

  • DB2 Enterprise Edition
  • DB2 Spatial Extender
  • DB2 Warehouse Manager
  • DB2 Net Search Extender
  • DB2 Data Links Manager
  • DB2 Enterprise — Extended Edition

Where the customer requires the DB2 server to be installed on a machine with a greater number of processors, the customer must obtain additional processor entitlements.

The DB2 Workgroup Edition product is entitled for installation of not more than four processors on Intel, Linux machines or not more than two processors on UNIX machines. However, for customers who purchase Workgroup Unlimited Edition, the maximum processors allowed will be up to eight processors for Intel and Linux and up to four processors for UNIX. Where the customer requires installation on a machine that has more than the maximum allowed processors, the customer must obtain a DB2 Enterprise Edition or DB2 Enterprise — Extended Edition product along with the needed number of additional processor entitlements.

Installation Entitlements: For DB2 Personal Edition, DB2 Satellite Edition, DB2 Workgroup Edition, and DB2 Workgroup Unlimited Edition, customers must purchase an installation entitlement for each server the products are installed on.

For DB2 Enterprise Edition, DB2 Enterprise — Extended Edition, DB2 Net Search Extender, DB2 Data Links Manager, DB2 Spatial Extender, and DB2 Warehouse Manager, customers must purchase processor entitlements for each processor available to the DB2 system or cluster. Separate installation entitlements are not required.

For each server DB2 Relational Connect is installed on, customers must purchase one license for each data source server connection.

Special Licensing Considerations

Licensing of Standby Servers: A DB2 Workgroup Edition or a DB2 Workgroup Unlimited Edition server, when configured with high-availability software solely for use as an idle standby for one or more active DB2 Workgroup Edition or DB2 Workgroup Unlimited Edition licenses, customers need only obtain a base processor entitlement for the DB2 Workgroup Edition or DB2 Workgroup Unlimited Edition standby machine. A DB2 Workgroup Edition or DB2 Workgroup Unlimited Edition license installed and used as an active server and configured as a backup for one or more other DB2 Workgroup Edition or DB2 Workgroup Unlimited Edition servers must be licensed for users for its primary applications. Should failover occur, processor, Internet, and user entitlements options from a failed DB2 Workgroup Edition or DB2 Workgroup Unlimited Edition machine are considered transferred to the backup machine. Customers must ensure with this transfer of entitlement, the backup machine is fully licensed.

When the failed machine recovers and resumes DB2 processing, these entitlements are returned to the recovered machine, and the backup machine entitlement returns to its original state.

When installing a DB2 Enterprise Edition server in a cluster environment, which is configured with high-availability software solely for use as an idle standby for one or more active DB2 Enterprise Edition licenses, customers need to obtain a one processor entitlement license for the DB2 Enterprise Edition standby machine. A DB2 Enterprise Edition license installed and used as an active server and configured as a backup for one or more other DB2 Enterprise Edition servers must be licensed for processors and host user connections for its primary applications. Should failover occur, processor and host user connection entitlements from a failed DB2 Enterprise Edition machine are considered transferred to the backup machine. Customers must ensure with this transfer of entitlement, the backup machine is fully licensed for processors and host user connections. When the failed machine recovers and resumes DB2 processing, these processor and host user connection entitlements are returned to the recovered machine, and the backup machine entitlement returns to its original state. DB2 Data Links Manager, an option of DB2 Enterprise Edition, must be treated similarly.

A DB2 Enterprise — Extended Edition server, which is configured with high-availability software solely for use as an idle standby for one or more active DB2 Enterprise — Extended Edition licenses, must be licensed for the available processors to that host standby machine. Processor Entitlements are not transferred from the failed server to the backup machine as they are with DB2 Enterprise Edition. Host User Connection entitlements are transferred. Should failover occur, user entitlements from a failed DB2 Enterprise — Extended Edition machine are considered transferred to the backup machine, and customers must ensure with this transfer of entitlement, the backup machine is fully licensed for host user connections. When the failed machine recovers and resumes DB2 processing, these host user connection entitlements are returned to the recovered machine, and the backup machine entitlement returns to its original state. DB2 Query Patroller, an option of DB2 Warehouse Manager, must be treated similarly.

Web Connections: Customers using DB2 Enterprise Edition and DB2 Enterprise — Extended Edition have unlimited Web access to local DB2 data. Host User Connection entitlements must be obtained if accessing non-local DB2 data.

For customers using DB2 Workgroup Edition, Web access is available by obtaining a separate entitlement for each processor available to the program installation. (For example, if installed on a two-processor server, you must obtain two External Web Access Entitlements.) Web access to DB2 Workgroup Edition servers from internal connections must be counted as DB2 Users of the product. You should note this licensing makes a distinction between Web connections made from within your enterprise (intranet connections, "inside the fire-wall") and those made from outside your enterprise (Internet connections, "outside the fire-wall"). Customers can purchase the Workgroup Unlimited Edition, and with it, access is available by obtaining all users connections to the database (inside and outside the fire-wall).

Complimentary Products: IBM provides licensed copies of complimentary products in our product boxes. Customers are responsible for independent product registration of these products, and obtaining any desired upgrades for these complimentary products. There is no guarantee for customers to receive any free upgrade or guaranteed level of code to the products.

Direct Customer Support: Installation and support for these products on all supported platforms is provided by IBM Global Services under the Personal System Support Family organization at 800-237-5511 for a fee. For information or prices related to a SupportLine Technical Support contact, call 800-426-4343. To speak to an IBM representative about personal systems software, call 800-IBM-4YOU (426-4968).

Informal DB2 support can be found at:

All support or advice provided through the above channel is provided on an as-is basis. There are several no-charge and fee support options available for DB2 Universal Database Version 7. For additional information, visit the support Web site at:

Packaging: DB2 continues to be shipped with all the required information for its operation. For detailed information on the product packages, refer to the information below.

Product Box Contents: The following shows the contents of the DB2 UDB product boxes. Each of the product boxes contains:

  • Publications — product specific — detailed below
  • Media
    • Product CD-ROMs — product specific — detailed below
    • Packaged products — product specific — detailed below
    • Netscape Communicator CD-ROM
    • PDF Publications CD-ROMs
  • Mechanicals, or general components provided with all the DB2 products:
    • International Program License Agreement (IPLA) booklet
    • IPLA pointer sheet
    • License Information (LI) booklet (with unique product information)
    • Proof of Entitlement (PoE)
    • International DB2 Users Group (IDUG) card
    • Service flyer
    • ESRI coupon
    • Education and Training card

The following shows the components specific to each product:

DB2 Enterprise — Extended Edition, Version 7.1

  • Publications:
    • IBM DB2 Universal Database Enterprise — Extended Edition for UNIX Quick Beginnings
    • IBM DB2 Universal Database Enterprise — Extended Edition for Windows Quick Beginnings
    • IBM DB2 Universal Database Administration Guide: Planning
    • IBM DB2 OLAP Setup and User's Guide
  • Media:
    • EEE AIX CD-ROM
    • EEE Windows NT CD-ROM
    • EEE Solaris CD-ROM
    • EEE HP-UX Version 11 CD-ROM
    • Administration Client CD-ROMs
    • Run-Time Client CD-ROMs
    • Net.Data CD-ROM
    • Netscape Communicator CD-ROM
    • DB2 Extenders CD-ROMs (Intel and UNIX)
    • DB2 XML Extender CD-ROM
    • PDF Pubs CD-ROM
    • DB2 OLAP Starter Kit CD-ROMs (Intel and UNIX)
    • Lotus® 1-2-3 CD-ROM
  • Mechanicals:
    • IPLA booklet
    • IPLA pointer sheet
    • PoE
    • EEE License Information booklet
    • IDUG card
    • Service flyer
    • QMF package1
    • WebSphere package
    • URL Information card
    • Box Contents card
1
QMF Try and Buy version

DB2 Enterprise — Extended Edition for NUMA-Q, Version 7.1

  • Publications:
    • IBM DB2 Universal Database Enterprise — Extended Edition for UNIX Quick Beginnings
    • IBM DB2 Universal Database Administration Guide: Planning
    • IBM DB2 OLAP Setup and User's Guide
  • Media:
    • EEE NUMA-Q CD-ROM
    • Administration Client CD-ROMs
    • Run-Time Client CD-ROMs
    • Net.Data CD-ROM
    • Netscape Communicator CD-ROM
    • PDF Pubs CD-ROMs
    • DB2 OLAP Starter Kit CD-ROMs (Intel and UNIX)
    • Lotus 1-2-3 CD-ROM
  • Mechanicals:
    • IPLA booklet
    • IPLA pointer sheet
    • PoE
    • EEE License Information booklet
    • IDUG card
    • Service flyer
    • QMF package1
    • WebSphere package
    • Box Contents card

DB2 Personal Edition, Version 7.1

  • Publications:
    • IBM DB2 Personal Edition Quick Beginnings
    • IBM DB2 Personal Edition for Linux Quick Beginnings
    • IBM DB2 Universal Database Administration Guide: Planning
    • IBM DB2 SQL Getting Started
    • IBM DB2 OLAP Setup and User's Guide
  • Media:
    • Personal Edition OS/2 CD-ROM
    • Personal Edition Windows CD-ROM
    • Personal Edition Linux CD-ROM
    • Netscape Communicator CD-ROM
    • DB2 Extenders CD-ROM (Intel)
    • DB2 XML Extender CD-ROM
    • PDF Pubs CD-ROM
    • DB2 OLAP Starter Kit CD-ROM (Intel)
    • Lotus 1-2-3 CD-ROM
  • Mechanicals:
    • IPLA booklet
    • IPLA pointer sheet
    • PoE
    • PE License Information booklet
    • IDUG card
    • Service flyer
    • URL Information card
    • Box Contents card
    • Customer Installation Support card

DB2 Workgroup Edition, Version 7.1

  • Publications:
    • IBM DB2 Universal Database for OS/2 Quick Beginnings
    • IBM DB2 Universal Database for Windows Quick Beginnings
    • IBM DB2 Universal Database for Unix Quick Beginnings
    • IBM DB2 Universal Database Administration Guide: Planning
    • IBM DB2 SQL Getting Started
    • IBM DB2 OLAP Setup and User's Guide
  • Media:
    • Workgroup Edition OS/2 CD-ROM
    • Workgroup Edition Windows CD-ROM
    • Workgroup Edition AIX CD-ROM
    • Workgroup Edition HP-UX Version 11 CD-ROM
    • Workgroup Edition Solaris CD-ROM
    • Workgroup Edition Linux CD-ROM
    • DB2 Extenders CD-ROMs (Intel and UNIX)
    • DB2 XML Extender CD-ROM
    • Administration Client CD-ROMs
    • Run-Time Client CD-ROMs
    • Net.Data CD-ROM
    • Netscape Communicator CD-ROM
    • PDF Pubs CD-ROM
    • DB2 OLAP Starter Kit CD-ROMs (Intel and UNIX)
    • Lotus 1-2-3 CD-ROM
  • Mechanicals:
    • IPLA booklet
    • IPLA pointer sheet
    • PoE
    • WE License Information booklet
    • IDUG card
    • Service flyer
    • QMF package1
    • WebSphere package
    • URL Information card
    • ESRI coupon
    • Box Contents card

DB2 Workgroup Unlimited Edition, Version 7.1

  • Publications:
    • IBM DB2 Universal Database for OS/2 Quick Beginnings
    • IBM DB2 Universal Database for Windows Quick Beginnings
    • IBM DB2 Universal Database for Unix Quick Beginnings
    • IBM DB2 Universal Database Administration Guide: Planning
    • IBM DB2 SQL Getting Started
    • IBM DB2 OLAP Setup and User's Guide
  • Media:
    • Workgroup Edition OS/2 CD-ROM
    • Workgroup Edition Windows CD-ROM
    • Workgroup Edition AIX CD-ROM
    • Workgroup Edition HP-UX Version 11 CD-ROM
    • Workgroup Edition Solaris CD-ROM
    • Workgroup Edition Linux CD-ROM
    • DB2 Extenders CD-ROMs (Intel and UNIX)
    • DB2 XML Extender CD-ROM
    • Administration Client CD-ROMs
    • Run-Time Client CD-ROMs
    • Net.Data CD-ROM
    • Netscape Communicator CD-ROM
    • PDF Pubs CD-ROM
    • DB2 OLAP Starter Kit CD-ROMs (Intel and UNIX)
    • Lotus 1-2-3 CD-ROM
  • Mechanicals:
    • IPLA booklet
    • IPLA pointer sheet
    • PoE
    • WUE License Information booklet
    • IDUG card
    • Service flyer
    • QMF package1
    • WebSphere package
    • URL Information card
    • ESRI coupon
    • Box Contents card

DB2 Enterprise Edition, Version 7.1

  • Publications:
    • IBM DB2 Universal Database for OS/2 Quick Beginnings
    • IBM DB2 Universal Database for Windows Quick Beginnings
    • IBM DB2 Universal Database for UNIX Quick Beginnings
    • IBM DB2 Universal Database Administration Guide: Planning
    • IBM DB2 SQL Getting Started
    • IBM DB2 OLAP Setup and User's Guide
  • Media:
    • Enterprise Edition OS/2 CD-ROM
    • Enterprise Edition Windows CD-ROM
    • Enterprise Edition AIX CD-ROM
    • Enterprise Edition HP-UX Version 11 CD-ROM
    • Enterprise Edition Solaris CD-ROM
    • Enterprise Edition Linux CD-ROM
    • DB2 Extenders CD-ROMs (Intel and UNIX)
    • DB2 XML Extender CD-ROM
    • Administration Client CD-ROMs
    • Run-Time Client CD-ROMs
    • Net.Data CD-ROM
    • Netscape Communicator CD-ROM
    • PDF Pubs CD-ROM
    • DB2 OLAP Starter Kit CD-ROMs (Intel and UNIX)
    • Lotus 1-2-3 CD-ROM
  • Mechanicals:
    • IPLA booklet
    • IPLA pointer sheet
    • PoE
    • EE License Information booklet
    • IDUG card
    • Service flyer
    • QMF package1
    • WebSphere package
    • ESRI coupon
    • URL Information card
    • Box Contents card

Note: The Information Catalog Manager component will also be available in Hebrew for Windows. Details of installation can be found in the Release Notes and in the Install Notes.

DB2 Enterprise Edition for NUMA-Q, Version 7.1

  • Publications:
    • IBM DB2 Universal Database for UNIX Quick Beginnings
    • IBM DB2 Universal Database Administration Guide: Planning
    • IBM DB2 OLAP Setup and User's Guide
  • Media:
    • Enterprise Edition NUMA-Q CD-ROM
    • Administration Client CD-ROMs
    • Run-Time Client CD-ROMs
    • Net.Data CD-ROM
    • Netscape Communicator CD-ROM
    • PDF Pubs CD-ROM
    • DB2 OLAP Starter Kit CD-ROM (UNIX)
    • Lotus 1-2-3 CD-ROM
  • Mechanicals:
    • IPLA booklet
    • IPLA pointer sheet
    • PoE
    • EE License Information booklet
    • IDUG card
    • Service flyer
    • QMF package1
    • WebSphere package
    • URL Information card
    • Box Contents card

DB2 Personal Developer's Edition, Version 7.1

  • Publications:
    • IBM DB2 Application Building Guide
    • IBM DB2 Universal Database Data Warehouse Center Application Integration Guide
  • Media:
    • Personal Edition OS/2 CD-ROM
    • Personal Edition Windows CD-ROM
    • Personal Edition Linux CD-ROM
    • Connect Personal Edition OS/2 CD-ROM
    • Connect Personal Edition Windows CD-ROM
    • Connect Personal Edition Linux CD-ROM
    • Application Development Client CDs
    • Netscape Communicator CD-ROM
    • DB2 Extenders CD-ROM (Intel)
    • DB2 XML Extender CD-ROM
    • PDF Pubs CD-ROM
    • DB2 OLAP Starter Kit CD-ROMs (Intel)
    • Lotus 1-2-3 CD-ROM
  • Mechanicals:
    • IPLA booklet
    • IPLA pointer sheet
    • PoE
    • PDE License Information booklet
    • VisualAge® for JAVA Entry Edition package2
    • IDUG card
    • Service flyer
    • URL Information card
    • Box Contents card
2
VisualAge for Java package comprised of VisualAge for Java Entry OS/2 and Windows CD-ROMs, tutorial (MINDQ) CD-ROM, Object Connection® Partners (Companion) CD-ROM, LI, and PoE shrinkwrapped/polybagged together.

DB2 Universal Developer's Edition, Version 7.1

  • Publications:
    • IBM DB2 Application Building Guide
    • IBM DB2 OLAP Setup and User's Guide
    • IBM DB2 Universal Database Data Warehouse Center Application Integration Guide
  • Media:
    • Enterprise Edition OS/2 CD-ROM
    • Enterprise Edition Windows CD-ROM
    • Enterprise Edition AIX CD-ROM
    • Enterprise Edition HP-UX Version 11 CD-ROM
    • Enterprise Edition Solaris CD-ROM
    • Enterprise Edition Linux CD-ROM
    • Enterprise Edition NUMA-Q CD-ROM
    • Workgroup Edition OS/2 CD-ROM
    • Workgroup Edition Windows CD-ROM
    • Workgroup Edition AIX CD-ROM
    • Workgroup Edition HP-UX Version 11 CD-ROM
    • Workgroup Edition Linux CD-ROM
    • Workgroup Edition Solaris CD-ROM
    • Connect Enterprise Edition OS/2 CD-ROM
    • Connect Enterprise Edition Windows CD-ROM
    • Connect Enterprise Edition AIX CD-ROM
    • Connect Enterprise Edition HP-UX Version 11 CD-ROM
    • Connect Enterprise Edition Solaris CD-ROM
    • Connect Enterprise Edition Linux CD-ROM
    • Connect Enterprise Edition NUMA-Q CD-ROM
    • Personal Edition OS/2 CD-ROM
    • Personal Edition Windows CD-ROM
    • Personal Edition Linux CD-ROM
    • Connect Personal Edition OS/2 CD-ROM
    • Connect Personal Edition Windows CD-ROM
    • Connect Personal Edition Linux CD-ROM
    • DB2 Extenders CD-ROMs (Intel and UNIX)
    • DB2 XML Extender CD-ROM
    • Satellite Edition CD-ROM
    • Administration Client CD-ROMs
    • Run-Time Client CD-ROMs
    • Application Development Client CD-ROMs
    • Net.Data CD-ROM
    • Net.Data NUMA-Q CD-ROM
    • Netscape Communicator CD-ROM
    • PDF Pubs CD-ROM
    • DB2 OLAP Starter Kit CD-ROMs (Intel and UNIX)
    • Lotus 1-2-3 CD-ROM
  • Mechanicals:
    • IPLA booklet
    • IPLA pointer sheet
    • PoE
    • UDE License Information booklet
    • VisualAge for JAVA Pro package3
    • IDUG card
    • Service flyer
    • QMF package1
    • WebSphere package4
    • ESRI coupon
    • URL Information card
    • Box Contents card
3
VisualAge for Java package comprised of VisualAge for Java Pro OS/2 and Windows CD-ROMs, tutorial (MINDQ) CD-ROM, Object Connection® Partners (Companion) CD-ROM, LI, and PoE shrinkwrapped/polybagged together.
4
WebSphere package consists of WebSphere Application Server Standard Edition CD-ROM, LI, and Getting Started publication.

DB2 Data Links Manager, Version 7.1

  • Publication:
    • IBM DB2 Data Links Manager Quick Beginnings
  • Media:
    • Data Links Manager AIX CD-ROM
    • Data Links Manager Windows CD-ROM
    • Data Links Manager Solaris CD-ROM
    • Netscape Communicator CD-ROM
    • PDF Pubs CD-ROM
  • Mechanicals:
    • IPLA booklet
    • IPLA pointer sheet
    • PoE
    • DLM License Information booklet
    • Service flyer
    • IDUG card
    • URL Information card

DB2 Warehouse Manager, Version 7.1

  • Publications:
    • IBM DB2 Data Warehouse Center Administration Guide
    • IBM DB2 Warehouse Manager Installation Guide
    • IBM DB2 Warehouse Manager Information Catalog Manager Center Administration Guide
    • IBM DB2 Query Patroller Installation Guide
  • Media:
    • Warehouse Manager OS/2 CD-ROM
    • Warehouse Manager Windows CD-ROM
    • Warehouse Manager AIX CD-ROM
    • Warehouse Manager Solaris CD-ROM
    • Query Patroller Windows CD-ROM
    • Query Patroller AIX CD-ROM
    • Query Patroller Solaris CD-ROM
    • Query Patroller HP-UX Version 11 CD-ROM
    • Query Patroller NUMA-Q CD-ROM
    • PDF Pubs CD-ROM
  • Mechanicals:
    • IPLA booklet
    • IPLA pointer sheet
    • PoE
    • WM License Information booklet
    • Service flyer
    • QMF package5
    • Box Contents card
5
QMF unrestricted version contains CD, Memo, Getting Started with QMF Windows publication and Installing and Managing QMF for Windows publication.

Note: The Information Catalog Manager component will also be available in Hebrew for Windows. Details of installation can be found in the Release Notes and in the Install Notes.

DB2 Spatial Extender, Version 7.1

  • Publication:
    • DB2 Spatial Extender User's Guide and Reference
  • Media:
    • DB2 Spatial Extender Intel CD-ROM
    • DB2 Spatial Extender UNIX CD-ROM
  • Mechanicals:
    • IPLA booklet
    • IPLA pointer sheet
    • PoE
    • Spatial Extender License Information booklet
    • Service flyer
    • URL Information card

DB2 Net Search Extender, Version 7.1

  • Publication:
    • DB2 Net Search Extender Administration and Programming
  • Media:
    • DB2 Net Search Extender CD-ROM
  • Mechanicals:
    • IPLA booklet
    • IPLA pointer sheet
    • PoE
    • Net Search Extender License Information booklet
    • Service flyer
    • URL Information card

DB2 Relational Connect, Version 7.1

  • Publications: None
  • Media:
    • Relational Connect CD-ROMs (Intel and UNIX)
    • PDF Pubs CD-ROM
  • Mechanicals:
    • IPLA booklet
    • IPLA pointer sheet
    • PoE
    • RC License Information booklet
    • Service flyer
    • IDUG card
    • URL Information card
    • Installation card
    • Box Contents card

These programs when downloaded from a Web site, contain the applicable IBM license agreement, and 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 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.

Professional and Technical Services (IBM Global Services)

The following IBM Global Services offerings support the installation or migration to DB2 UDB Version 7. They are available worldwide and are performed by the ITS Data Management Practices. Each services engagement includes on-site work by an IBM services specialist, basic skills instruction, and a record summarizing the work performed.

The benefits realized by using IBM Global Software Services:

  • Allow customer's staff to concentrate on business-critical activities
  • Allow customized solutions to be installed and configured quickly and cost-effectively
  • Allow customer's staff to pickup basic skills without the expense of formal education

IBM Installation Service for DB2 UDB Enterprise Edition: This service provides the planning and installation of the DB2 Universal Database Enterprise Edition on AIX, Solaris, Linux, and Windows NT environments.

  • Planning and Design
  • Installation, Configuration, and Customization
  • Initial Performance and Tuning

IBM Installation Service for DB2 UDB Enterprise — Extended Edition: This service provides the planning and installation of the DB2 Universal Database Enterprise — Extended Edition on AIX, Solaris, Linux, and Windows NT environments.

  • Planning and Design
  • Installation, Configuration, and Customization
  • Initial Performance and Tuning

BI — Technology Enablement — Data Mart: This service implements an integrated technical platform for a data mart solution based on the following best-of-breed technology components:

  • DB2 Warehouse Manager
  • DB2 OLAP Server and an analysis tool of choice:
    • Brio
    • Business Objects
    • QMF for Windows

An IBM BI services specialist will:

  • Define the BI environment
  • Install and customize software (DB2UDB, DB2 OLAP, and one of the analysis tools listed above)
  • Integrate Solution Components

Contact your IBM representative for the list of selected services available in your country, either as standard or customized offerings for the efficient installation, implementation, and integration of this product.

Ordering Information

The following are the charge structures of the Version 7.1 products. 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 Personal Edition               Installs
 
DB2 Workgroup Edition              Installs
                                   Users
                                   Internet Processors
 
DB2 Workgroup                      Installs
  Unlimited Edition                Users (Unlimited)
 
DB2 Enterprise Edition             Processors
                                   Host User Connections
 
DB2 Enterprise --                  Processors
  Extended Edition                 Host User Connections
 
DB2 Net Search Extender            Processors
DB2 Data Links Manager             Processors on Data
                                     Links Server
 
DB2 Spatial Extender               Processors
DB2 Warehouse Manager              Processors
DB2 Relational Connect             Other Data Source Server
DB2 Enterprise Edition             Processors
  for NUMA-Q                       Host User Connections
 
DB2 Enterprise --                  Processors
  Extended Edition                 Host User Connections
  for NUMA-Q

Metric Descriptions

  • Processors
    • Each CPU available to the installed software must have a separate entitlement.
  • Host User Connections
    • Each person, or user, making a connection to a host computer system must have a separate entitlement. When concentrating software is used through the Internet, the users of that concentration software must each be counted as users.
  • Installs
    • Each installation of the program must have a separate entitlement.
  • Internet Processors
    • Each processor available to the installed DB2 code, which is providing access to the Internet or intranet, must have separate entitlement.
  • Other Data Source Server
    • Each server that houses a portion of the accessed other data source must have a separate 'other data source' server entitlement.
  • Host Servers
    • A host server must be obtained for each independent server being connected to with DB2 Connect Unlimited Edition. If the server is part of a sysplex (connected OS/390® servers), only one host server entitlement is required. If multiple host servers, or multiple sysplexes are used, then each host server must be obtained for each host server (or sysplex).
  • MSUs
    • A MSU entitlement must be obtained for each MSU on the DB2 host system. When this option is used, the customer need not count users of the DB2 Connect product. Only one server install is required for each customer utilizing the MSU licensing.

DB2 Personal Edition

                                                  Part
Program Name                                      Number
 
Program Packages
 
DB2 Personal Edition Version 7.1                  41L2717
  U.S. English
 
Licenses without Media
 
1 Install License                                 41L2725
 
Upgrades with Media
 
DB2 Personal Edition Version 7.1                  41L2720
  Upgrade from DB2 Personal Edition
  Version 5 or 6, U.S. English
 
Upgrades without Media
 
DB2 Personal Edition Version 7.1                  41L2726
  Upgrade from DB2 Personal Edition
  Version 5 or 6, 1 Install License

DB2 Workgroup Edition

                                                  Part
Program Name                                      Number
 
Program Packages
 
DB2 Workgroup Edition Version 7.1                 41L2727
  English
 
Licenses without Media
 
DB2 Workgroup Edition Version 7.1
  1 Install License                               41L2980
  1 User License                                  41L2981
  1 Internet Processor License                    41L2982
 
Upgrades with Media
 
DB2 Workgroup Edition Version 7.1                 41L2729
  Upgrade from DB2 Workgroup Edition
  Version 5 or 6, English
 
DB2 Workgroup Edition Version 7.1                 11K7957
  Upgrade from DB2 Personal Edition
  Version 7.1, English
 
                                                  Part
Program Name                                      Number
 
Upgrades without Media
 
DB2 Workgroup Edition Version 7.1
  Upgrade from DB2 Workgroup Edition
  Version 5 or 6
    1 Install License                             41L2983
    1 User License                                41L2985
    1 Internet Processor License                  41L2986
 
DB2 Workgroup Edition Version 7.1                 41L2984
  Upgrade from DB2 Personal Edition
  Version 7.1, 1 Install License

DB2 Workgroup Unlimited Edition

                                                  Part
Program Name                                      Number
 
Program Packages
 
DB2 Workgroup Unlimited Edition                   13P0410
  Version 7.1 English
 
Licenses without Media
 
DB2 Workgroup Unlimited Edition
  Version 7.1
    1 Install License                             11K8158
    1 Unlimited Users                             11K8159
      Processor License
 
Upgrades with Media
 
DB2 Workgroup Unlimited Edition                   13P0412
  Version 7.1
  Upgrade from DB2 Workgroup Edition
  Version 7.1, English
 
DB2 Workgroup Unlimited Edition                   13P0413
  Version 7.1
  Upgrade from DB2 Personal Edition
  Version 7.1, English
 
Upgrades without Media
 
DB2 Workgroup Unlimited Edition
  Version 7.1
  Upgrade from DB2 Workgroup Edition
  Version 7.1
    1 Install License                             11K8160
    1 Unlimited Users                             11K8162
      Processor License
      from 1 Internet
      Processor License
 
DB2 Workgroup Unlimited Edition                   11K8161
  Version 7.1
  Upgrade from DB2 Personal Edition
  Version 7.1, 1 Install License

DB2 Enterprise Edition

                                                  Part
Program Name                                      Number
 
Program Packages
 
DB2 Enterprise Edition Version 7.1                11K7630
  English
 
Licenses without Media
 
1 Processor Entitlement                           11K6770
1 Host User Connection                            11K6771
 
Upgrades with Media
 
DB2 Enterprise Edition Version 7.1                11K6768
  Upgrade from DB2 Enterprise Edition
  Version 5 or 6, English
 
DB2 Enterprise Edition Version 7.1                11K8070
  Upgrade from DB2 Workgroup Edition
  Version 7.1, English
 
DB2 Enterprise Edition Version 7.1                11K7689
  Upgrade from DB2 Workgroup
  Unlimited Edition
  Version 7.1, English
 
DB2 Enterprise Edition (EE) Version 7.1 and
  DB2 Warehouse Manager (DWM) Version 7.1
  Upgrade from DB2 Visual Warehouse
  Version 3 or 5:
    1 EE Program Pack and 1 DWM Program Pack
    from 1 install of:

English

.-------------------------------.
|   Visual Warehouse            |
|-------+-------+-------+-------|
|Base   |Cognos |Bus Obj|Brio   |
|-------+-------+-------+-------|
|11K8115|11K8117|11K8119|11K8121|
'-------+-------+-------+-------'
 
.-------------------------------.
|   Visual Warehouse OLAP       |
|-------+-------+-------+-------|
|Base   |Cognos |Bus Obj| Brio  |
|-------+-------+-------+-------|
|11K8123|11K8125|11K8127|11K8129|
'-------+-------+-------+-------'

                                                  Part
Program Name                                      Number
 
Upgrades without Media
 
DB2 Enterprise Edition Version 7.1
  Upgrade from DB2 Enterprise Edition
  Version 6.1
    1 Processor Entitlement                       11K6772
    1 Host User Connection                        11K6773
 
DB2 Enterprise Edition Version 7.1
  Upgrade from DB2 Enterprise Edition
  Version 5
    1 Processor Entitlement                       11K6774
      from 1 install entitlement
    1 Processor Entitlement                       11K6775
      from 1 processor entitlement
    1 Host User Connection                        11K6776
      from 1 user
 
DB2 Enterprise Edition Version 7.1
  Upgrade from DB2 Workgroup Edition
  Version 7.1
    1 Processor Entitlement                       11K6777
      from 1 server install
    1 Processor Entitlement                       11K6778
      from 1 Internet processor
 
DB2 Enterprise Edition Version 7.1
  Upgrade from DB2 Workgroup
  Unlimited Edition Version 7.1
    1 Processor Entitlement                       11K7683
      from 1 Unlimited Users
      Processor
 
DB2 Enterprise Edition Version 7.1
  and DB2 Warehouse Manager 7.1
  Upgrade from DB2 Visual Warehouse
  Version 3 or 5:
    1 EE Processor Entitlement and
    1 DWM Processor Entitlement from:
 
English

.-------------------------------.
|   Visual Warehouse            |
|-------+-------+-------+-------|
|Base   |Cognos |Bus Obj|Brio   |
|-------+-------+-------+-------|
|11K8133|11K8134|11K8135|11K8136|
'-------+-------+-------+-------'
 
.-------------------------------.
|   Visual Warehouse OLAP       |
|-------+-------+-------+-------|
|Base   |Cognos |Bus Obj| Brio  |
|-------+-------+-------+-------|
|11K8137|11K8138|11K8139|11K8140|
'-------+-------+-------+-------'

Upgrades From Restricted Licenses

                                                  Part
Program Name                                      Number
 
Upgrades with Media
 
DB2 Enterprise Edition Version 7.1                11K8131
  Upgrade from restricted use
  DB2 Enterprise Edition
  Version 5, 6 or 7, English
 
Upgrades without Media
 
DB2 Enterprise Edition Version 7.1
  Upgrade from restricted license
  DB2 Enterprise Edition
  Version 5, 6 or 7
    1 Processor Entitlement                       11K8141
    1 Host User Connection                        11K8142

DB2 Enterprise — Extended Edition

                                                  Part
Program Name                                      Number
 
Program Packages
 
DB2 Enterprise -- Extended Edition                11K7641
  Version 7.1, English
 
Licenses without Media
 
1 Processor Entitlement                           11K8164
1 Host User Connection                            11K8165
 
Upgrades with Media
 
DB2 Enterprise -- Extended Edition                11K7633
  Version 7.1 Upgrade from
  DB2 Enterprise -- Extended
  Edition Version 5 or 6, English
 
DB2 Enterprise -- Extended Edition                11K7637
  Version 7.1 Upgrade from
  DB2 Enterprise Edition
  Version 7.1, English
 
Upgrades without Media
 
DB2 Enterprise -- Extended Edition
  Version 7.1 Upgrade from
  DB2 Enterprise -- Extended
  Edition Version 5 or 6
    1 Processor Entitlement                       11K8166
    1 Host User Connection                        11K8167
 
DB2 Enterprise -- Extended Edition
  Version 7.1 Upgrade from
  DB2 Enterprise Edition
  Version 7.1
    1 Processor Entitlement                       11K8168
    1 Host User Connection                        11K8169

DB2 Warehouse Manager

                                                  Part
Program Name                                      Number
 
Program Packages
 
DB2 Warehouse Manager Version 7.1                 11K8080
  English
 
Licenses without Media
 
DB2 Warehouse Manager Version 7.1                 11K8077
  1 Processor Entitlement
 
Upgrades with Media
 
DB2 Warehouse Manager Version 7.1                 11K8104
  Upgrade from DB2 Query Patroller
 
  Version 6.1, English
DB2 Warehouse Manager Version 7.1                 11K8087
  Upgrade from DB2 Visual Warehouse
  Version 3 or 5
    1 DWM Program Pack from 1 VW agent
    server install entitlement, English
 
Upgrades without Media
 
DB2 Warehouse Manager Version 7.1                 11K8078
  Upgrade from DB2 Query Patroller
  Version 6.1
    1 Processor Entitlement from
      1 Processor Entitlement
 
DB2 Warehouse Manager Version 7.1                 11K8079
  Upgrade from DB2 Visual Warehouse
  Version 3 or 5
    1 Processor Entitlement from
      1 agent server install or
      1 agent processor

DB2 Relational Connect

                                                  Part
Program Name                                      Number
 
DB2 Relational Connect Version 7.1                11K8111
  English
 
Licenses without Media
 
One Other Relational Data                         11K7646
  Source Entitlement for 1 server
 
Upgrades with Media
 
None
 
Upgrades without Media
 
DB2 Relational Connect Version 7.1                11K7647
  Upgrade from DB2 DataJoiner
  Version 2 -- 1 Other Data Source
  Entitlement for 1 server Upgrade
  from 1 Other Relational Data
  Source Entitlement for 1 server

DB2 Data Links Manager

                                                  Part
Program Name                                      Number
 
Program Packages
 
DB2 Data Links Version 7.1                        11K6762
  English
 
Licenses without Media
 
DB2 Data Links Manager Version 7.1                11K7628
  1 Processor Entitlement
  for 1 server
 
Upgrades with Media
 
DB2 Data Links Manager Version 7.1                11K6764
  Upgrade from DB2 Data Links
  Manager Version 5 or 6, English
 
Upgrades without Media
 
DB2 Data Links Manager Version 7.1                11K7629
  Upgrade from DB2 Data Links
  Manager Version 5 or 6
    1 Processor Entitlement
      on 1 server

DB2 Spatial Extender

                                                  Part
Program Name                                      Number
 
Program Packages
 
DB2 Spatial Extender Version 7.1                  11K6779
  English
 
Licenses without Media
 
1 Processor Entitlement                           11K7644
 
Upgrades with Media
 
DB2 Spatial Extender Version 7.1                  11K6781
  Upgrade from DB2 Spatial Extender
  Version 2.1.1 -- 1 Processor
  Entitlement from 1 Spatial Extender
  First Processor Entitlement, English
 
Upgrades without Media
 
DB2 Spatial Extender Version 7.1                  11K7645
  Upgrade from DB2 Spatial Extender
  Version 2.1.1
    1 Processor Entitlement

DB2 Net Search Extender

                                                  Part
Program Name                                      Number
 
Program Packages
 
DB2 Net Search Extender Version 7.1               11K8072
  English
 
Licenses without Media
 
1 Processor Entitlement                           11K7632

DB2 Enterprise Edition for NUMA-Q

                                                  Part
Program Name                                      Number
 
Program Packages
 
DB2 Enterprise Edition for NUMA-Q                 11K8374
  Version 7.1 English
 
Licenses without Media
 
1 Processor Entitlement                           11K8106
1 Host User Connection                            11K8107
 
Upgrades with Media
 
DB2 Enterprise Edition for NUMA-Q                 11K8375
  Version 7.1 Upgrade from
  DB2 Enterprise Edition
  for NUMA-Q Version 6.1, English
 
Upgrades without Media
 
DB2 Enterprise Edition Version 7.1
  Upgrade from DB2 Enterprise
  Edition Version 6.1
    1 Processor Entitlement                       11K8108
    1 Host User Connection                        11K8109

DB2 Enterprise — Extended Edition for NUMA-Q

                                                  Part
Program Name                                      Number
 
Program Packages
 
DB2 Enterprise -- Extended Edition                11K8100
  for NUMA-Q, English
 
Licenses without Media
 
1 Processor Entitlement                           11K8370
1 Host User Connection                            11K8371
 
Upgrades with Media
 
DB2 Enterprise -- Extended Edition                11K8101
  for NUMA-Q Version 7.1 Upgrade from
  DB2 Enterprise -- Extended Edition
  for NUMA-Q Version 6.1, English
DB2 Enterprise -- Extended Edition                11K8103
  for NUMA-Q Version 7.1 Upgrade from
  DB2 Enterprise Edition for NUMA-Q
  Version 7.1, English
 
Upgrades without Media
 
DB2 Enterprise -- Extended Edition
  for NUMA-Q Version 7.1 Upgrade from
  DB2 Enterprise -- Extended Edition
  for NUMA-Q Version 6.1
    1 Processor Entitlement                       11K8372
    1 Host User Connection                        11K8373
DB2 Enterprise -- Extended Edition
  for NUMA-Q Version 7.1 Upgrade from
  DB2 Enterprise Edition for NUMA-Q
  Version 7.1
    1 Processor Entitlement                       11K8144
    1 Host User Connection                        11K8145

DB2 Personal Developer's Edition

                                                  Part
Program Name                                      Number
 
Program Packages
 
DB2 Personal Developer's Edition                  11K8091
  Version 7.1 English
 
Licenses without Media
 
1 Developer License                               11K8076

DB2 Universal Developer's Edition

                                                  Part
Program Name                                      Number
 
Program Packages
 
DB2 Universal Developer's Edition                 11K7879
  Version 7.1, English
 
Licenses without Media
 
1 Developer License                               11K6499
 
Upgrades with Media
 
DB2 Universal Developer's Edition                 11K8068
  Version 7.1 Upgrade from
  DB2 Universal Developer's Edition
  Version 6.1, English
 
Upgrades without Media
 
DB2 Universal Developer's Edition                 11K7621
  Version 7.1 Upgrade from
  DB2 Universal Developer's
  Edition Version 6.1
    1 Developer License

Electronic Delivery

                                                  Part
Program Name                                      Number
 
DB2 Net Search Extender Version 7.1               00P7681

Passport Advantage

                                                  Part
Program Name                                      Number
 
DB2 Workgroup Unlimited Edition
 
VPO Instl 1 Processor for Unlimited Users         D46X7ML
VPO Instl/SW Sub 1 Processor for                  D46XJML
  Unlimited Users 1 Year
VPO Instl/SW Sub 1 Processor for                  D46ZIML
  Unlimited Users 2 Years
VPO SW Sub Rnwl 1 Processor for                   E16ZNML
  Unlimited Users
VPO SW Sub 1 Processor for                        D46ZUML
  Unlimited Users 1 Year
VPO SW Sub 1 Processor for                        D46ZWML
  Unlimited Users 2 Years
VPO Instl DB2 WUE 1 Server Install                D47EWML
VPO Instl/SW Sub DB2 WUE 1 Server                 D47EXML
  Install 1 Year
VPO Instl/SW Sub DB2 WUE 1 Server                 D47EYML
  Install 2 Years
VPO SW Sub Rnwl DB2 WUE 1 Server Install          E17F0ML
VPO SW Sub DB2 WUE 1 Server Install               D47F2ML
  1 Year
 
                                                  Part
Program Name                                      Number
 
VPO SW Sub DB2 WUE 1 Server Install               D47F7ML
  2 Years
 
CO Instl/SW Sub 1 Processor for Unlimited         D46ZXML
  Users 1 Anniv
CO Instl/SW Sub 1 Processor for Unlimited         D46ZYML
  Users 2 Anniv
CO SW Sub Rnwl 1 Processor for Unlimited          E1700ML
  Users
CO SW Sub 1 Processor for Unlimited               D4704ML
  Users 1 Anniv
CO SW Sub 1 Processor for Unlimited               D4707ML
  Users 2 Anniv
CO Instl/SW Sub DB2 WUE 1 Server                  D47FDML
  Install 1 Anniv
CO Instl/SW Sub DB2 WUE 1 Server                  D47FEML
  Install 2 Anniv
CO SW Sub Rnwl DB2 WUE 1 Server                   E17FFML
  Install
CO SW Sub DB2 WUE 1 Server Install                D47FGML
  1 Anniv
CO SW Sub DB2 WUE 1 Server Install                D47FHML
  2 Anniv
CO Supt DB2 WUE 1 Server Install                  E17K7ML
  1 Anniv
CO Instl/SW Sub/Supt DB2 WUE 1 Server             D47KQML
  Install 1 Anniv
CO Instl/SW Sub/Supt DB2 WUE 1 Server             D47KTML
  Install 2 Anniv
CO SW Sub/Supt DB2 WUE 1 Server Install           D47KUML
  1 Anniv
CO SW Sub/Supt Rnwl DB2 WUE 1 Server              E17L0ML
  Install
 
DB2 Workgroup Edition External Web
Access processor to DB2 EE processor:
 
VPO Trade-up Instl/SW Sub fr DB2                  D47S1ML
  Workgroup Ed. Web Acc.
  to DB2 EE 1 Proc 1 Year
CO Trade-up Instl/SW Sub fr DB2                   D47S2ML
  Workgroup Ed. Web Acc.
  to DB2 EE 1 Proc 1st Anniv
CO Trade-up Instl/SW Sub/Supt fr                  D47S3ML
  DB2 Workgroup Ed.
  Web Acc. to DB2 EE
  1 Proc 1st Anniv
 
DB2 Workgroup Unlimited Edition
Processor to DB2 EE processor:
 
VPO Trade-up Instl/SW Sub fr DB2                  D47S4ML
  Workgroup Unlim. Ed.
  to DB2 EE 1 Proc 1 Year
CO Trade-up Instl/SW Sub fr DB2                   D47S5ML
  Workgroup Unlim. Ed.
  to DB2 EE 1 Proc 1st Anniv
CO Trade-up Instl/SW Sub/Supt fr                  D47S6ML
  DB2 Workgroup Unlim. Ed.
  to DB2 EE 1 Proc 1st Anniv
 
DB2 Enterprise Edition for NUMA-Q
Processor to DB2 Enterprise - Extended
Edition for NUMA-Q:
 
VPO Trade-up Instl/SW Sub fr                      D47S7ML
  DB2 Ent Ed. NUMAQ to DB2 EEE
  NUMAQ 1 Proc 1 Year
CO Trade-up Instl/SW Sub fr DB2 Ent Ed.           D47S8ML
  NUMAQ to DB2 EEE NUMAQ
  1 Proc 1st Anniv
CO Trade-up Instl/SW Sub/Supt fr DB2              D47S9ML
  Ent Ed. NUMAQ to DB2 EEE NUMAQ
  1 Proc 1st Anniv
 
DB2 Warehouse Manager
 
VPO Instl Processor Entitlement                   D468NML
VPO Instl/SW Sub Processor Entitlement            D468PML
  1 Year
VPO Instl/SW Sub Processor Entitlement            D4690ML
  2 Years
VPO SW Sub Rnwl Processor Entitlement             E1693ML
VPO SW Sub Processor Entitlement 1 Year           D4691ML
VPO SW Sub Processor Entitlement 2 Years          D4692ML
CO Instl/SW Sub Processor Entitlement             D4694ML
  1 Anniv
CO Instl/SW Sub Processor Entitlement             D4695ML
  2 Anniv
CO SW Sub Rnwl Processor Entitlement              E169BML
CO SW Sub Processor Entitlement 1 Anniv           D4696ML
CO SW Sub Processor Entitlement 2 Anniv           D4697ML
CO Supt Processor Entitlement 2 Anniv             NO SKU
                                                  NEEDED
CO Supt Processor Entitlement 1 Anniv             E169CML
CO Instl/SW Sub/Supt Processor                    D4698ML
  Entitlement 1 Anniv
CO Instl/SW Sub/Supt Processor                    D4699ML
  Entitlement 2 Anniv
CO SW Sub/Supt Processor Entitlement              D469AML
  1 Anniv
CO SW Sub/Supt Rnwl Processor Entitlement         E169FML
 
DB2 Relational Connect
 
VPO Instl Relational Data Src                     D46QNML
VPO Instl/SW Sub Relational Data Src              D46QTML
  1 Year
VPO Instl/SW Sub Relational Data Src              D46QUML
  2 Years
VPO SW Sub Rnwl Relational Data Src               E16QVML
VPO SW Sub Relational Data Src 1 Year             D46QWML
VPO SW Sub Relational Data Src 2 Years            D46QXML
CO Instl/SW Sub Relational Data Src               D46QYML
  1 Anniv
CO Instl/SW Sub Relational Data Src               D46QZML
  2 Anniv
CO SW Sub Rnwl Relational Data Src                E16R1ML
CO SW Sub Relational Data Src 1 Anniv             D46R4ML
CO SW Sub Relational Data Src 2 Anniv             D46R5ML
CO Supt Relational Data Src 2 Anniv               NO SKU
                                                  NEEDED
 
                                                  Part
Program Name                                      Number
 
CO Supt Relational Data Src 1 Anniv               E16R8ML
CO Instl/SW Sub/Supt Relational Data              D46RAML
  Src 1 Anniv
CO Instl/SW Sub/Supt Relational Data              D46RFML
  Src 2 Anniv
CO SW Sub/Supt Relational Data Src                D46RGML
  1 Anniv
CO SW Sub/Supt Rnwl Relational Data Src           E16RHML
 
DB2 Spatial Extender
 
VPO Instl Processor                               D46N9ML
VPO Instl/SW Sub Processor 1 Year                 D46NUML
VPO Instl/SW Sub Processor 2 Years                D46NWML
VPO SW Sub Rnwl Processor                         E1743ML
VPO SW Sub Processor 1 Year                       D473YML
VPO SW Sub Processor 2 Years                      D473ZML
CO Instl/SW Sub Processor 1 Anniv                 D476KML
CO Instl/SW Sub Processor 2 Anniv                 D47EDML
CO SW Sub Rnwl Processor                          E17EVML
CO SW Sub Processor 1 Anniv                       D47EEML
CO SW Sub Processor 2 Anniv                       D47EGML
CO Supt Processor 2 Anniv                         NO SKU
                                                  NEEDED
CO Supt Processor 1 Anniv                         E17XIML
CO Instl/SW Sub/Supt Processor 1 Anniv            D47YPML
CO Instl/SW Sub/Supt Processor 2 Anniv            D47YQML
CO SW Sub/Supt Processor 1 Anniv                  D47YSML
CO SW Sub/Supt Rnwl Processor                     E17XKML
 
DB2 Net Search Extender
 
VPO Instl Processor                               D46AKML
VPO Instl/SW Sub Processor 1 Year                 D46ALML
VPO Instl/SW Sub Processor 2 Years                D46EWML
VPO SW Sub Rnwl Processor                         E16EXML
VPO SW Sub Processor 1 Year                       D46F1ML
VPO SW Sub Processor 2 Years                      D46F2ML
CO Instl/SW Sub Processor 1 Anniv                 D46F3ML
CO Instl/SW Sub Processor 2 Anniv                 D46F4ML
CO SW Sub Rnwl Processor                          E16F6ML
CO SW Sub Processor 1 Anniv                       D46F8ML
CO SW Sub Processor 2 Anniv                       D46F9ML
CO Supt Processor 2 Anniv                         NO SKU
                                                  NEEDED
CO Supt Processor 1 Anniv                         E16FDML
CO Instl/SW Sub/Supt Processor 1 Anniv            D46FGML
CO Instl/SW Sub/Supt Processor 2 Anniv            D46FHML
CO SW Sub/Supt Processor 1 Anniv                  D46FMML
CO SW Sub/Supt Rnwl Processor                     E16FQML

Media and Documentation Packages

                                                  Part
Program Name                                      Number
 
DB2 Personal Edition Version 7.1
 
English Media Pack                                BB67YNA
Japanese Media Pack                               BB67YJA
Korean Media Pack                                 BB67YKO
Simplified Chinese Media Pack                     BB67YSC
Traditional Chinese Media Pack                    BB67YTC
English Documentation Pack                        BB67ZNA
French Documentation Pack                         BB67ZFR
German Documentation Pack                         BB67ZDE
Spanish Documentation Pack                        BB67ZES
Italian Documentation Pack                        BB67ZIT
Brazilian Portuguese Documentation Pack           BB67ZBP
Danish Documentation Pack                         BB67ZDA
 
                                                  Part
Program Name                                      Number
 
Finnish Documentation Pack                        BB67ZFI
Norwegian Documentation Pack                      BB67ZNO
Swedish Documentation Pack                        BB67ZSV
Japanese Documentation Pack                       BB67ZJA
Korean Documentation Pack                         BB67ZKO
Simplified Chinese Documentation Pack             BB67ZSC
Traditional Chinese Documentation Pack            BB67ZTC
 
DB2 Workgroup Edition Version 7.1
 
English Media Pack                                BB6EXML
Japanese Media Pack                               BB6EXJA
Korean Media Pack                                 BB6EXKO
Simplified Chinese Media Pack                     BB6EXSC
Traditional Chinese Media Pack                    BB6EXTC
English Documentation Pack                        BB6EZNA
French Documentation Pack                         BB6EZFR
German Documentation Pack                         BB6EZDE
Brazilian Portuguese Documentation Pack           BB6EZBP
Danish Documentation Pack                         BB6EZDA
Finnish Documentation Pack                        BB6EZFI
Norwegian Documentation Pack                      BB6EZNO
Swedish Documentation Pack                        BB6EZSV
Japanese Documentation Pack                       BB6EZJA
Korean Documentation Pack                         BB6EZKO
Simplified Chinese Documentation Pack             BB6EZSC
Traditional Chinese Documentation Pack            BB6EZTC
 
DB2 Workgroup Unlimited Edition Version 7.1
 
 
English Media Pack                                BB7R0NA
Japanese Media Pack                               BB7R0JA
Korean Media Pack                                 BB7R0KO
Simplified Chinese Media Pack                     BB7R0SC
Traditional Chinese Media Pack                    BB7R0TC
English Documentation Pack                        BB7R1NA
French Documentation Pack                         BB7R1FR
German Documentation Pack                         BB7R1DE
Brazilian Portuguese Documentation Pack           BB7R1BP
Danish Documentation Pack                         BB7R1DA
Finnish Documentation Pack                        BB7R1FI
Norwegian Documentation Pack                      BB7R1NO
Swedish Documentation Pack                        BB7R1SV
Japanese Documentation Pack                       BB7R1JA
Korean Documentation Pack                         BB7R1KO
Simplified Chinese Documentation Pack             BB7R1SC
Traditional Chinese Documentation Pack            BB7R1TC
 
DB2 Enterprise Edition Version 7.1
 
Multi (non-AP) Media Pack                         BB68KML
Japanese Media Pack                               BB68KJA
Korean Media Pack                                 BB68KKO
Simplified Chinese Media Pack                     BB68KSC
Traditional Chinese Media Pack                    BB68KTC
English Documentation Pack                        BB68LNA
French Documentation Pack                         BB68LFR
German Documentation Pack                         BB68LDE
Brazilian Portuguese Documentation Pack           BB68LBP
Danish Documentation Pack                         BB68LDA
Finnish Documentation Pack                        BB68LFI
Norwegian Documentation Pack                      BB68LNO
Swedish Documentation Pack                        BB68LSV
Japanese Documentation Pack                       BB68LJA
Korean Documentation Pack                         BB68LKO
Simplified Chinese Documentation Pack             BB68LSC
Traditional Chinese Documentation Pack            BB68LTC
 
                                                  Part
Program Name                                      Number
 
DB2 Enterprise -- Extended Edition Version 7.1
 
Multi (non-AP) Media Pack                         BB7DTML
Japanese Media Pack                               BB7DTJA
Korean Media Pack                                 BB7DTKO
Simplified Chinese Media Pack                     BB7DTSC
Traditional Chinese Media Pack                    BB7DTTC
English Documentation Pack                        BB7EPNA
French Documentation Pack                         BB7EPFR
German Documentation Pack                         BB7EPDE
Brazilian Portuguese Documentation Pack           BB7EPBP
Japanese Documentation Pack                       BB7EPJA
Korean Documentation Pack                         BB7EPKO
Simplified Chinese Documentation Pack             BB7EPSC
Traditional Chinese Documentation Pack            BB7EPTC
 
DB2 Data Links Manager
 
Multi (non-AP) Media Pack                         BB6GQML
Japanese Media Pack                               BB6GQJA
Korean Media Pack                                 BB6GQKO
Simplified Chinese Media Pack                     BB6GQSC
 
Traditional Chinese Media Pack                    BB6GQTC
English Documentation Pack                        BB6GRNA
French Documentation Pack                         BB6GRFR
German Documentation Pack                         BB6GRDE
Spanish Documentation Pack                        BB6GRES
Brazilian Portuguese Documentation Pack           BB6GRBP
Japanese Documentation Pack                       BB6GRJA
Korean Documentation Pack                         BB6GRKO
Simplified Chinese Documentation Pack             BB6GRSC
Traditional Chinese Documentation Pack            BB6GRTC
 
DB2 Warehouse Manager
 
Multi (non-AP) Media Pack                         BB6GZML
Japanese Media Pack                               BB6GZJA
Korean Media Pack                                 BB6GZKO
Simplified Chinese Media Pack                     BB6GZSC
Traditional Chinese Media Pack                    BB6GZTC
English Documentation Pack                        BB6HDNA
French Documentation Pack                         BB6HDFR
German Documentation Pack                         BB6HDDE
Spanish Documentation Pack                        BB6HDES
Italian Documentation Pack                        BB6HDIT
Brazilian Portuguese Documentation Pack           BB6HDBP
Danish Documentation Pack                         BB6HDDA
Finnish Documentation Pack                        BB6HDFI
Norwegian Documentation Pack                      BB6HDNO
Swedish Documentation Pack                        BB6HDSV
Japanese Documentation Pack                       BB6HDJA
Korean Documentation Pack                         BB6HDKO
Simplified Chinese Documentation Pack             BB6HDSC
Traditional Chinese Documentation Pack            BB6HDTC
 
DB2 Relational Connect
 
Multi (non-AP) Media Pack                         BB6T0ML
Japanese Media Pack                               BB6T0JA
Korean Media Pack                                 BB6T0KO
Simplified Chinese Media Pack                     BB6T0SC
Traditional Chinese Media Pack                    BB6T0TC
 
                                                  Part
Program Name                                      Number
 
DB2 Spatial Extender
 
Multi (non-AP) Media Pack                         BB6KSML
Japanese Media Pack                               BB6KSJA
Korean Media Pack                                 BB6KSKO
Simplified Chinese Media Pack                     BB6KSSC
Traditional Chinese Media Pack                    BB6KSTC
English Documentation Pack                        BB6KTNA
French Documentation Pack                         BB6KTFR
German Documentation Pack                         BB6KTDE
Spanish Documentation Pack                        BB6KTES
Brazilian Portuguese Documentation Pack           BB6KTBP
Danish Documentation Pack                         BB6KTDA
Finnish Documentation Pack                        BB6KTFI
Norwegian Documentation Pack                      BB6KTNO
Swedish Documentation Pack                        BB6KTSV
Japanese Documentation Pack                       BB6KTJA
Korean Documentation Pack                         BB6KTKO
Simplified Chinese Documentation Pack             BB6KTSC
Traditional Chinese Documentation Pack            BB6KTTC
 
DB2 Net Search Extender
 
 
Multi (non-AP) Media Pack                         BB74TML
Japanese Media Pack                               BB74TJA
Korean Media Pack                                 BB74TKO
Simplified Chinese Media Pack                     BB74TSC
Traditional Chinese Media Pack                    BB74TTC
English Documentation Pack                        BB759NA
German Documentation Pack                         BB759DE
Spanish Documentation Pack                        BB759ES
Japanese Documentation Pack                       BB759JA
Korean Documentation Pack                         BB759KO
Simplified Chinese Documentation Pack             BB759SC
Traditional Chinese Documentation Pack            BB759TC
 
DB2 Personal Developer's Edition, Version 7.1
 
Multi (non-AP) Media Pack                         BB6J9ML
Japanese Media Pack                               BB6J9JA
Korean Media Pack                                 BB6J9KO
Simplified Chinese Media Pack                     BB6J9SC
Traditional Chinese Media Pack                    BB6J9TC
English Documentation Pack                        BB6JANA
French Documentation Pack                         BB6JAFR
German Documentation Pack                         BB6JADE
Spanish Documentation Pack                        BB6JAES
Japanese Documentation Pack                       BB6JAJA
Korean Documentation Pack                         BB6JAKO
Simplified Chinese Documentation Pack             BB6JASC
Traditional Chinese Documentation Pack            BB6JATC
 
DB2 Universal Developer's Edition, Version 7.1
 
Multi (non-AP) Media Pack                         BB6GLML
Japanese Media Pack                               BB6GLJA
Korean Media Pack                                 BB6GLKO
Simplified Chinese Media Pack                     BB6GLSC
Traditional Chinese Media Pack                    BB6GLTC
English Documentation Pack                        BB6GNNA
French Documentation Pack                         BB6GNFR
German Documentation Pack                         BB6GNDE
Spanish Documentation Pack                        BB6GNES
Japanese Documentation Pack                       BB6GNJA
Korean Documentation Pack                         BB6GNKO
Simplified Chinese Documentation Pack             BB6GNSC
Traditional Chinese Documentation Pack            BB6GNTC
 
                                                  Part
Program Name                                      Number
 
DB2 Enterprise Edition for NUMA-Q Version 7.1
 
Multi (non-AP) Media Pack                         BB6GUML
Japanese Media Pack                               BB6GUJA
English Documentation Pack                        BB6HENA
French Documentation Pack                         BB6HEFR
German Documentation Pack                         BB6HEDE
Spanish Documentation Pack                        BB6HEES
Japanese Documentation Pack                       BB6HEJA
 
DB2 Enterprise -Extended Edition for NUMA-Q Version 7.1
 
Multi (non-AP) Media Pack                         BB6SBML
Japanese Media Pack                               BB6SBJA
English Documentation Pack                        BB6SINA
French Documentation Pack                         BB6SIFR
German Documentation Pack                         BB6SIDE
 
Spanish Documentation Pack                        BB6SIES
Japanese Documentation Pack                       BB6SIJA

Terms and Conditions

Licensing: IBM IPLA. PoEs are required for all authorized use.

License Information Form Number: The part numbers for the LI booklets are shown below:

DB2 Personal Edition                              CT615ML
DB2 Workgroup Edition                             CT619ML
DB2 Workgroup Unlimited Edition                   CT70QML
DB2 Enterprise Edition                            CT617ML
DB2 Enterprise -- Extended Edition                CT61GML
DB2 Data Links Manager                            CT61LML
DB2 Warehouse Manager                             CT63CML
DB2 Net Search Extender                           CT63EML
DB2 Spatial Extender                              CT63DML
DB2 Relational Connect                            CT63BML
DB2 Personal Developer's Edition                  CT61FML
DB2 Universal Developer's Edition                 CT61EML

Note: There will be only one LI booklet for all languages.

Limited Warranty: Yes

Program Services: Available until December 31, 2002

Money-Back Guarantee: Two-month, money-back guarantee

Copy and Use on Home/Portable Computer: No

Volume Orders (IVO): No

Passport Advantage Applies: Yes

Passport Advantage Subscription Applies: Yes

Upgrades: Customers can acquire upgrades up to the currently authorized level of use of the qualifying programs.

Usage Restriction: For DB2 Satellite Edition, you must acquire one license for each installation. If the total number of users or workstation installations exceeds the number of licenses, you must notify IBM or its reseller as stated in the IPLA.

For DB2 Personal Edition, you must acquire one license for each installation. If the total number of users or workstation installations exceeds the number of licenses, you must notify IBM or its reseller as stated in the IPLA.

For DB2 Universal Developer's Edition, you must acquire one license for each developer. If the total number of developers exceeds the number of licenses, you must notify IBM or its reseller as stated in the IPLA. The Developer's Editions are licensed for installation and use by an individual developer only for the purpose of evaluating, demonstrating, testing, and developing application programs.

Charges for DB2 Workgroup Edition Version are based on the number of users, and on the number of processors providing Internet access. For any Web access on a particular installation, a separate Internet Processor Entitlement must be obtained for each processor available to DB2 Workgroup Edition Version. As with users described in the Planning Information section, the total number of users and the total number of processors providing Internet access cannot exceed the number authorized by the applicable PoE. If the total number exceeds the quantity in the PoE, you must notify IBM or its reseller as stated in the IPLA.

DB2 Workgroup Edition Version is entitled for installation on machines that have up to four processors on Intel and Linux and up to two processors on UNIX. Customers can purchase Workgroup Unlimited Edition. They are entitled to install on machines that have up to eight processors for Intel and Linux and up to four processors for UNIX.

Charges for installations of DB2 Enterprise Edition, DB2 Enterprise — Extended Edition, DB2 Enterprise Edition Version 7.1 for NUMA-Q, and DB2 Enterprise — Extended Edition Version 7.1 for NUMA-Q are based on the number of processors available, and on the host user connections required. The total number of processors used, and the total host user connections, cannot exceed the quantity in the applicable PoE. If the total number exceeds the quantity in the PoE, you must notify IBM or its reseller as stated in the IPLA. An entitlement is available to allow unlimited users and Web access.

Charges for the DB2 Data Links Manager Version 7.1, DB2 Net Search Extender Version 7.1, and DB2 Spatial Extender Version 7.1 optional feature are based on the number of processors on which it is used. The total number of processors used cannot exceed the quantity in the applicable PoE. If the total number exceeds the quantity in the applicable PoE, you must notify IBM or its reseller as stated in the IPLA.

Charges for the DB2 Warehouse Manager Version 7.1 are based on the number of processors on which it is used in the target database. The total number of processors used cannot exceed the quantity in the applicable PoE. If the total number exceeds the quantity in the applicable PoE, you must notify IBM or its reseller as stated in the IPLA.

Charges for installations of DB2 Relational Connect are based on the number of data source server connections required. The total number of data source server connections cannot exceed the quantity in the applicable PoE. If the total number exceeds the quantity in the PoE, you must notify IBM or its reseller as stated in the IPLA.

Support Line: Yes

AIX/UNIX Upgrade Protection Applies: No

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

AS/400® Software Subscription Applies: No

Variable Charges Apply: No

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.

DB2 Personal Edition Version 7.1

                                        Part
Program Name                            Number         OTC(6)
 
Program Packages
 
DB2 Personal Edition Version 7.1        41L2717      $  369
  U.S. English
 
Licenses without Media
 
1 Install License                       41L2725         359
 
License Upgrades with Media
 
DB2 Personal Edition Version 7.1        41L2720         185
  Upgrade from DB2 Personal Edition
  Version 5 or 6, U.S. English
 
License Upgrades without Media
 
DB2 Personal Edition Version 7.1        41L2726         179
  Upgrade from DB2 Personal Edition
  Version 5 or 6, 1 Install License
6
One-time charge

DB2 Workgroup Edition Version 7.1

                                        Part
Program Name                            Number         OTC
 
Program Packages
 
DB2 Workgroup Edition Version 7.1       41L2727       $  999
  English
 
Licenses without Media
 
DB2 Workgroup Edition Version 7.1
  1 Install License                     41L2980          969
  1 User License                        41L2981          249
  1 Internet Processor License          41L2982        3,000
 
License Upgrades with Media
 
DB2 Workgroup Edition Version 7.1       41L2729          499
  Upgrade from DB2 Workgroup Edition
  Version 5 or 6, English
DB2 Workgroup Edition Version 7.1       11K7957          629
  Upgrade from DB2 Personal Edition
  Version 7.1, English
 
License Upgrades without Media
 
DB2 Workgroup Edition Version 7.1
  Upgrade from DB2 Workgroup Edition
  Version 5 or 6
    1 Install License                   41L2983          485
    1 User License                      41L2985          125
    1 Internet Processor License        41L2986        1,500
 
DB2 Workgroup Edition Version 7.1       41L2984          609
  Upgrade from DB2 Personal Edition
  Version 7.1, 1 Install License

DB2 Workgroup Unlimited Edition

                                        Part
Program Name                            Number         OTC
 
Program Packages
 
DB2 Workgroup Unlimited Edition         13P0410      $12,600
  Version 7.1 English
 
Licenses without Media
 
DB2 Workgroup Unlimited Edition
  Version 7.1
    1 Install License                   11K8158       12,500
    1 Unlimited Users                   11K8159       12,500
      Processor License
 
Upgrades with Media
 
DB2 Workgroup Unlimited Edition         13P0412       11,600
  Version 7.1
  Upgrade from DB2 Workgroup
  Edition Version 7.1, English
 
DB2 Workgroup Unlimited Edition         13P0413       12,230
  Version 7.1
  Upgrade from DB2 Personal
  Edition Version 7.1, English
 
Upgrades without Media
 
DB2 Workgroup Unlimited Edition
  Version 7.1
  Upgrade from DB2 Workgroup
  Edition Version 7.1
    1 Install License                   11K8160       11,500
    1 Unlimited Users                   11K8162        9,500
      Processor License
      from 1 Internet
      Processor License
 
DB2 Workgroup Unlimited Edition         11K8161       12,130
  Version 7.1
  Upgrade from DB2 Personal
  Edition Version 7.1,
  1 Install License

DB2 Enterprise Edition Version 7.1

                                        Part
Program Name                            Number         OTC
 
Program Packages
 
DB2 Enterprise Edition Version 7.1      11K7630      $17,600
  English
 
Licenses without Media
 
1 Processor Entitlement                 11K6770       17,500
1 Host User Connection                  11K6771          249
 
                                        Part
Program Name                            Number         OTC
 
License Upgrades with Media
 
DB2 Enterprise Edition Version 7.1      11K6768      $ 8,800
  Upgrade from DB2 Enterprise
  Edition Version 5 or 6, English
DB2 Enterprise Edition Version 7.1      11K8070       16,600
  Upgrade from DB2 Workgroup
  Edition Version 7.1, English
 
DB2 Enterprise Edition Version 7.1      11K7689        5,000
  Upgrade from DB2 Workgroup
  Unlimited Edition
  Version 7.1, English
 
DB2 Enterprise Edition (EE) Version 7.1
  and DB2 Warehouse Manager (DWM)
  Version 7.1 Upgrade from DB2 Visual
  Warehouse Version 3 or 5:
    1 EE Program Pack and 1 DWM
    Program Pack from 1 install of:
 
English
 
Visual Warehouse
 
Base                                    11K8115      $13,100
Cognos                                  11K8117       13,100
Bus Obj                                 11K8119       13,100
Brio                                    11K8121       13,100
 
Visual Warehouse OLAP
 
Base                                    11K8123      $13,100
Cognos                                  11K8125       13,100
Bus Obj                                 11K8127       13,100
Brio                                    11K8129       13,100

                                        Part
Program Name                            Number         OTC
 
License Upgrades without Media
 
DB2 Enterprise Edition Version 7.1
  Upgrade from DB2 Enterprise
  Edition Version 6.1
    1 Processor Entitlement             11K6772      $ 8,750
    1 Host User Connection              11K6773          125
 
DB2 Enterprise Edition Version 7.1
  Upgrade from DB2 Enterprise
  Edition Version 5
    1 Processor Entitlement             11K6774        8,750
      from 1 install entitlement
    1 Processor Entitlement             11K6775        8,750
      from 1 Processor Entitlement
    1 Host User Connection              11K6776          125
      from 1 user
 
DB2 Enterprise Edition Version 7.1
  Upgrade from DB2 Workgroup
  Edition Version 7.1
    1 Processor Entitlement             11K6777       16,500
      from 1 server install
    1 Processor Entitlement             11K6778       14,500
      from 1 Internet processor
 
                                        Part
Program Name                            Number         OTC
 
DB2 Enterprise Edition Version 7.1
  Upgrade from DB2 Workgroup
  Unlimited Edition Version 7.1
    1 Processor Entitlement             11K7683        5,000
      from 1 Unlimited
      Users Processor
 
DB2 Enterprise Edition Version 7.1
  and DB2 Warehouse Manager 7.1
  Upgrade from DB2 Visual Warehouse
  Version 3 or 5:
    1 EE Processor Entitlement and
      1 DWM Processor Entitlement from:
 
English
 
Visual Warehouse
 
Base                                    11K8133      $13,000
Cognos                                  11K8134       13,000
Bus Obj                                 11K8135       13,000
Brio                                    11K8136       13,000
 
Visual Warehouse OLAP
 
Base                                    11K8137      $13,000
Cognos                                  11K8138       13,000
Bus Obj                                 11K8139       13,000
Brio                                    11K8140       13,000

License Upgrades From Restricted Licenses

                                        Part
Program Name                            Number         OTC
 
License Upgrades with Media
 
DB2 Enterprise Edition Version 7.1      11K8131      $14,100
  Upgrade from restricted use
  DB2 Enterprise Edition
  Version 5, 6 or 7, English
 
License Upgrades without Media
 
DB2 Enterprise Edition Version 7.1
  Upgrade from restricted license
  DB2 Enterprise Edition
  Version 5, 6 or 7
    1 Processor Entitlement             11K8141       14,000
    1 Host User Connection              11K8142          199

DB2 Enterprise — Extended Edition Version 7.1

                                        Part
Program Name                            Number         OTC
 
Program Packages
 
DB2 Enterprise -- Extended Edition      11K7641      $22,600
  Version 7.1, English
 
Licenses without Media
 
1 Processor Entitlement                 11K8164       22,500
1 Host User Connection                  11K8165          249
 
                                        Part
Program Name                            Number         OTC
 
License Upgrades with Media
 
DB2 Enterprise -- Extended Edition      11K7633       11,300
  Version 7.1 Upgrade from
  DB2 Enterprise -- Extended
  Edition Version 5 or 6, English
 
DB2 Enterprise -- Extended Edition      11K7637        5,000
  Version 7.1 Upgrade from
  DB2 Enterprise Edition
  Version 7.1, English
 
License Upgrades without Media
 
DB2 Enterprise -- Extended Edition
  Version 7.1 Upgrade from
  DB2 Enterprise -- Extended
  Edition Version 5 or 6
    1 Processor Entitlement             11K8166      $11,250
    1 Host User Connection              11K8167          125
 
DB2 Enterprise -- Extended Edition
  Version 7.1 Upgrade from
  DB2 Enterprise Edition
  Version 7.1
    1 Processor Entitlement             11K8168        5,000
    1 Host User Connection              11K8169          125

DB2 Warehouse Manager Version 7.1

                                        Part
Program Name                            Number         OTC
 
Program Packages
 
DB2 Warehouse Manager Version 7.1       11K8080       $8,600
  English
 
Licenses without Media
 
DB2 Warehouse Manager Version 7.1
  1 Processor Entitlement               11K8077       $8,500
 
License Upgrades with Media
 
DB2 Warehouse Manager Version 7.1       11K8104        4,300
  Upgrade from DB2 Query Patroller
  Version 6.1, English
DB2 Warehouse Manager Version 7.1
  Upgrade from DB2 Visual Warehouse
  Version 3 or 5
    1 DWM Program Pack from 1 VW        11K8087        4,300
    agent server install
    entitlement, English
 
License Upgrades without Media
 
DB2 Warehouse Manager Version 7.1       11K8078        4,250
  Upgrade from DB2 Query Patroller
  Version 6.1
    1 Processor Entitlement from
      1 Processor Entitlement
 
DB2 Warehouse Manager Version 7.1       11K8079        4,250
  Upgrade from DB2 Visual Warehouse
  Version 3 or 5
    1 Processor Entitlement from
      1 agent server install or
      1 agent processor

DB2 Relational Connect Version 7.1

                                        Part
Program Name                            Number         OTC
 
DB2 Relational Connect Version 7.1      11K8111       $3,780
  English
 
Licenses without Media
 
One Other Relational Data               11K7646        3,750
  Source Entitlement for 1 server
 
License Upgrades with Media
 
None
 
                                        Part
Program Name                            Number         OTC
 
License Upgrades without Media
 
DB2 Relational Connect Version 7.1      11K7647       $1,875
  Upgrade from DB2 DataJoiner
  Version 2 -- 1 Other Data Source
  Entitlement for 1 server Upgrade
  from 1 Other Relational Data
  Source Entitlement for 1 server

DB2 Data Links Manager Version 7.1

                                        Part
Program Name                            Number         OTC
 
Program Packages
 
DB2 Data Links Version 7.1              11K6762       $8,050
  English
 
Licenses without Media
 
DB2 Data Links Manager Version 7.1      11K7628        8,000
  1 Processor Entitlement
  for 1 server
 
License Upgrades with Media
 
DB2 Data Links Manager Version 7.1      11K6764        4,025
  Upgrade from DB2 Data Links
  Manager Version 5 or 6, English
 
License Upgrades without Media
 
DB2 Data Links Manager Version 7.1      11K7629        4,000
  Upgrade from DB2 Data Links
  Manager Version 5 or 6
    1 Processor Entitlement
      on 1 server

DB2 Spatial Extender Version 7.1

                                        Part
Program Name                            Number         OTC
 
Program Packages
 
DB2 Spatial Extender Version 7.1        11K6779       $7,050
  English
 
Licenses without Media
 
1 Processor Entitlement                 11K7644        7,000
 
                                        Part
Program Name                            Number         OTC
 
License Upgrades with Media
 
DB2 Spatial Extender Version 7.1        11K6781        3,525
  Upgrade from DB2 Spatial Extender
  Version 2.1.1 -- 1 Processor
  Entitlement from 1 Spatial Extender
  First Processor Entitlement,
  English
 
License Upgrades without Media
 
DB2 Spatial Extender Version 7.1        11K7645       $3,500
  Upgrade from DB2 Spatial Extender
  Version 2.1.1
    1 Processor Entitlement

DB2 Net Search Extender Version 7.1

                                        Part
Program Name                            Number         OTC
 
Program Packages
 
DB2 Net Search Extender Version 7.1     11K8072       $5,050
  English
 
Licenses without Media
 
1 Processor Entitlement                 11K7632        5,000

DB2 Enterprise Edition for NUMA-Q Version 7.1

                                        Part
Program Name                            Number         OTC
 
Program Packages
 
DB2 Enterprise Edition for NUMA-Q       11K8374      $17,600
  Version 7.1, English
 
Licenses without Media
 
1 Processor Entitlement                 11K8106       17,500
1 Host User Connection                  11K8107          249
 
License Upgrades with Media
 
DB2 Enterprise Edition for NUMA-Q       11K8375        8,800
  Version 7.1 Upgrade from
  DB2 Enterprise Edition
  for NUMA-Q Version 6.1, English
 
License Upgrades without Media
 
DB2 Enterprise Edition Version 7.1
  Upgrade from DB2 Enterprise
  Edition Version 6.1
    1 Processor Entitlement             11K8108        8,750
    1 Host User Connection              11K8109          125

DB2 Enterprise — Extended Edition for NUMA-Q Version 7.1

                                        Part
Program Name                            Number         OTC
 
Program Packages
 
DB2 Enterprise -- Extended Edition      11K8100      $22,600
  for NUMA-Q, English
 
Licenses without Media
 
1 Processor Entitlement                 11K8370       22,500
1 Host User Connection                  11K8371          249
 
License Upgrades with Media
 
DB2 Enterprise -- Extended Edition      11K8101      $11,300
  for NUMA-Q Version 7.1 Upgrade
  from DB2 Enterprise -- Extended
  Edition for NUMA-Q Version 6.1,
  English
DB2 Enterprise -- Extended Edition      11K8103        5,000
  for NUMA-Q Version 7.1 Upgrade
  from DB2 Enterprise Edition for
  NUMA-Q Version 7.1, English
 
License Upgrades without Media
 
DB2 Enterprise -- Extended Edition
  for NUMA-Q Version 7.1 Upgrade
  from DB2 Enterprise -- Extended
  Edition for NUMA-Q Version 6.1
    1 Processor Entitlement             11K8372       11,250
    1 Host User Connection              11K8373          125
DB2 Enterprise -- Extended Edition
  for NUMA-Q Version 7.1 Upgrade
  from DB2 Enterprise Edition for
  NUMA-Q Version 7.1
    1 Processor Entitlement             11K8144        5,000
    1 Host User Connection              11K8145          125

DB2 Personal Developer's Edition Version 7.1

                                        Part
Program Name                            Number         OTC
 
Program Packages
 
DB2 Personal Developer's Edition        11K8091       $   39
  Version 7.1, English
 
Licenses without Media
 
1 Developer License                     11K8076           NC
NC
= No Charge

DB2 Universal Developer's Edition Version 7.1

                                        Part
Program Name                            Number         OTC
 
Program Packages
 
DB2 Universal Developer's Edition       11K7879       $  999
  Version 7.1, English
 
Licenses without Media
 
1 Developer License                     11K6499          959
 
License Upgrades with Media
 
DB2 Universal Developer's Edition       11K8068          499
  Version 7.1 Upgrade from
  DB2 Universal Developer's Edition
  Version 6.1, English
 
License Upgrades without Media
 
DB2 Universal Developer's Edition       11K7621          479
  Version 7.1 Upgrade from
  DB2 Universal Developer's
  Edition Version 6.1
    1 Developer License

Passport Advantage

Note: For Passport Advantage and charges, contact your IBM Lotus representative or authorized IBM Lotus Business Partner. Additional information is also available on the Passport Advantage URL:

Customer Financing: IBM Global Financing offers attractive financing to credit-qualified commercial and government customers and Business Partners in more than 40 countries around the world. IBM Global Financing is provided by the IBM Credit Corporation in the United States. Offerings, rates, terms, and availability may vary by country. Contact your local IBM Global Financing organization. Country organizations are listed on the Web at:

Order Now

 Use Priority/Reference Code: YE001
 
 Phone:     800-IBM-CALL
 Fax:       800-2IBM-FAX
 Internet:  ibm_direct@us.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

 
QMF, IBMLink, Distributed Relational Database Architecture, WebSphere, and DataPropagator are trademarks of International Business Machines Corporation in the United States or other countries or both.
 
DB2 Universal Database, DB2, DB2 Connect, DB2 OLAP Server, OS/2, Open Blueprint, DRDA, AIX, Visual Warehouse, DataJoiner, Net.Data, OS/400, DB2 Extenders, VisualAge, Object Connection, OS/390, and AS/400 are registered trademarks of International Business Machines Corporation in the United States or other countries or both.
 
Windows, Microsoft, and Windows NT are trademarks of Microsoft Corporation.
 
Java is a trademark of Sun Microsystems, Inc.
 
UNIX is a registered trademark in the United States and other countries exclusively through X/Open Company Limited.
 
Notes is a trademark of Lotus Development Corporation.
 
1-2-3 and Lotus are registered trademarks of Lotus Development Corporation.
 
NUMA-Q is a registered trademark of Sequent Computer Systems, Inc., a wholly owned subsidiary of IBM Corporation.
 
Other company, product, and service names may be trademarks or service marks of others.