invispix 10x10

DB2 10.5 product lines and editions

Tabular comparison of DB2 10.5 editions

  • Requirements
  • Features
  • Restrictions

 


 

  DB2 Advanced Enterprise Server Edition DB2 Enterprise Server Edition DB2 Advanced Workgroup Server Edition DB2 Workgroup Server Edition DB2 Express-C Edition DB2 Devel- oper Edition
License models available PVU
AU min. 25 User
PVU
AU min. 25 User
PVU
AU min. 25 User
PVU
LUV
AU min. 5 User
free of charge
AU
max. socket count unlimited unlimited max. 4 sockets on terabyte metric. max. 4 sockets no restrictions listed no restrictions listed
max. cores count unlimited unlimited 16 16 2 unlimited
max. memory unlimited unlimited 128GB only on AUSI and PVU metric 128GB 16GB unlimited
max. storage unlimited unlimited 15 TerraByte User-Data per Database 15 TerraByte User-Data per Database 15 TerraByte User-Data per Database unlimited
Advanced Recovery Feature option option option option option option
Performance Management Offering allowed is included option is included option no is included
Blue Acceleration available is included no is included no no is included
pureScale available included free of charge ->is only available on AIX pSeries and x86 servers

Please read information on supported hardware here.

limited to a idle-standby in a pureScale cluster.

included free of charge ->is only available on AIX pSeries and x86 servers

Please read information on supported hardware here.

limited to a idle-standby in a pureScale cluster.

no included free of charge ->is only available on AIX pSeries and x86 servers

Please read information on supported hardware here.

Data Partitioning available is included no is included no no is included
Compression (row, adaptive, index) available is included no is included no no is included
Federation Capabilities (more as DB2 and Informix) available is included no is included no no is included
Materialized Querys available is included is included is included no no is included
Workload Management available is included option is included option no is included
MQ Replication available is included no is included no no is included
CDC Replication available is included no is included no no is included

features in the license not included

DB2 Advanced Enterprise Server Edition

  • If licensing under the Terabyte metric: pureScale clustering technology
  • Accessing federated data in DB2 for i or DB2 for z data servers outside of the SQL Warehousing Tool unless Licensee has separately acquired sufficient entitlement to IBM DB2 Connect
  • SQL Replication with non-DB2 LUW databases ("DB2 LUW databases" includes databases hosted on IBM DB2 on Cloud)
  • Q Replication functionality except to replicate data between the Program and no more than two DB2 for LUW or IBM DB2 on Cloud data servers
  • Change Data Capture functionality, except for the following: (1) unidirectional replication without data transformations between a single DB2 for LUW source and no more than two DB2 for LUW or IBM DB2 on Cloud databases of the same version for the purpose of high availability / disaster recovery; (2) for supporting shadow table functionality within a single DB2 for LUW instance to replicate from row-organized tables into column-organized tables
  • Tips for the DB2 Advanced Enterprise Server Edition

    High Availability/Failover Configuration:

    • Hot Standby: secondarys must be fully licensed according to the same metric as the Primary has been licensed. (Read on Standby is on)
    • Idle Standby: Secondary must be licensed with 100 PVU or 25 AU
    • Cold Standby: Secondary free

    The advanced enterprise server is licensable under the TerraByte metric. Then it is usable but only for data warehousing purposes. The following conditions apply:

    • Licensee must obtain Terabyte entitlements for this Program sufficient to cover the Terabytes of user data, as reported by the Program. The number of required entitlements must be calculated separately for each database.
    • Licensee may only use the Program for a data warehouse and run a data warehouse workload. A data warehouse is a subject-oriented, integrated, time-variant collection of data that integrates data from multiple data sources for historical ad hoc data reporting and querying. A data warehouse workload is a workload that typically scans thousands or millions of rows in a single query in order to support the analysis of data in a data warehouse.
    • Licensee must have user data from a single database spread across two or more active data partitions or at least 75% of the user data residing in column-organized tables with a majority of the workload accessing the column-organized tables.

    The following licenses are also included:

    • IBM Cognos Analytics User - 5 Authorized User
    • IBM Cognos Analytics Administrator - 1 Authorized User
    • IBM InfoSphere Data Architect - 10 Authorized User
    • IBM DB2 Connect components - Use Limitations: Use by Principal Program

DB2 Enterprise Server Edition

  • DB2 Database Partitioning Feature
  • pureScale clustering technology may be used with the Program only in cluster configurations with a maximum of two pureScale members. If the cluster configuration is configured with two pureScale members, at least one pureScale member must act as an Idle/Warm Standby server (as defined below).
  • Row Compression
  • Adaptive Compression
  • Intelligent Mining
  • Workload Management
  • Unstructured Text Analysis
  • Accessing federated data in DB2 for i or DB2 for z data servers
  • Accessing federated data in non-IBM data servers
  • SQL Replication with non-DB2 LUW databases ("DB2 LUW databases" includes databases hosted on IBM DB2 on Cloud)
  • Q Replication
  • Change Data Capture (CDC)
  • DB2 Connect components
  • column-organized tables
  • Index compression
  • Tips for the DB2 Enterprise Server Edition

    High Availability/Failover Configuration:

    • Hot Standby: secondarys must be fully licensed according to the same metric as the Primary has been licensed. (Read on Standby is on)
    • Idle Standby: Secondary must be licensed with 100 PVU or 25 AU
    • Cold Standby: Secondary free

DB2 Advanced Workgroup Server Edition

  • Accessing federated data in DB2 for i or DB2 for z data servers
  • If licensing under the Terabyte metric: pureScale clustering technology
  • SQL Replication with non-DB2 LUW databases ("DB2 LUW databases" includes databases hosted on IBM DB2 on Cloud)
  • Q Replication functionality except to replicate data between the Program and no more than two other DB2 for LUW data servers
  • Change Data Capture functionality, except for the following: (1) unidirectional replication without data transformations between a single DB2 for LUW source and no more than two DB2 for LUW or IBM DB2 on Cloud databases of the same version for the purpose of high availability / disaster recovery; (2) for supporting shadow table functionality within a single DB2 for LUW instance to replicate from row-organized tables into column-organized tables
  • Tips for the DB2 Advanced Workgroup Server Edition

    The advanced enterprise server is licensable under the TerraByte metric. Then it is usable but only for data warehousing purposes. The following conditions apply:

    • Licensee must obtain Terabyte entitlements for this Program sufficient to cover the Terabytes of user data, as reported by the Program. The number of required entitlements must be calculated separately for each database.
    • Licensee may only use the Program for a data warehouse and run a data warehouse workload. A data warehouse is a subject-oriented, integrated, time-variant collection of data that integrates data from multiple data sources for historical ad hoc data reporting and querying. A data warehouse workload is a workload that typically scans thousands or millions of rows in a single query in order to support the analysis of data in a data warehouse.
    • Licensee must have user data from a single database spread across two or more active data partitions or at least 75% of the user data residing in column-organized tables with a majority of the workload accessing the column-organized tables.

    The following licenses are also included:

    • IBM Cognos Analytics User - 5 Authorized User
    • IBM Cognos Analytics Administrator - 1 Authorized User
    • IBM InfoSphere Data Architect - 10 Authorized User
    • IBM DB2 Connect components - Use Limitations: Use by Principal Program

DB2 Workgroup Server Edition

  • Database Partitioning Feature
  • Materialized Query Tables
  • Workload Management
  • Intelligent Mining
  • Adaptive Compression
  • Row Compression
  • Index compression
  • column-organized tables
  • Unstructured Text Analysis
  • Accessing federated data in DB2 for i or DB2 for z data servers
  • Accessing federated data in non-IBM data servers
  • SQL Replication with non-DB2 LUW databases ("DB2 LUW databases" includes databases hosted on IBM DB2 on Cloud)
  • Change Data Capture (CDC) and Q Replication
  • DB2 Connect components
  • Tips for the DB2 Workgroup Server Edition

    High Availability/Failover Configuration:

    • Hot Standby: secondarys must be fully licensed according to the same metric as the Primary has been licensed. (Read on Standby is on)
    • Idle Standby: Secondary must be licensed with 100 PVU or 1 LUS or 5 AU
    • Cold Standby: Secondary free

    When licensing by LUS in virtual environments, the sum of the sockets used of all instances don't exceed fourth.

    The use of DB2 pureScale Feature is restricted to a total of 16 processor cores and 128 GB of memory across all servers in the cluster.

DB2 Express-C Edition

  • IBM DB2 pureScale clustering technology
  • column-organized tables
  • Row Compression
  • Database Partitioning
  • Adaptive Compression
  • Index compression
  • Row & Column Access Control
  • Label Based Access Control
  • Advanced Copy Service
  • High Availability Disaster Recovery
  • Online Reorg
  • Materialized Query Tables
  • Multi-Dimensional Clustering
  • Query Parallelism
  • Connection Concentrator
  • Table Partitioning
  • Access Plan Reuse
  • Scan Sharing
  • Workload Management
  • Multi-temperature Storage
  • Intelligent Mining
  • Unstructured Text Analysis
  • Accessing federated data except in DB2 for Linux, UNIX and Windows (LUW) and Informix data servers
  • SQL Replication
  • Q Replication
  • Change Data Capture (CDC)
  • Use of any component of the Program in a clustered database environment, including (without limitation) any use of the Program on a group of servers connected together to create a single database image.

DB2 Developer Edition

  • nothing

Productgroup DB2:
(Here you can find more information about the DB2 product group)

  • IBM DB2 Advanced Enterprise Server Edition
  • IBM DB2 Enterprise Server Edition
  • IBM DB2 Workgroup Server Edition
  • IBM DB2 Express Edition
  • IBM DB2 Express-C Edition
  • DB2 Content Manager
  • DB2 Alphablox
  • DB2 Connect
  • DB2 Content Manager
  • DB2 Document Manager
  • DB2 Data Entity
  • DB2 Data Warehouse
  • DB2 Everyplace
  • DB2 KnowledgeX
  • DB2 Query
  • DB2 Records Manager
  • DB2 Tools 
  • DB2 UDB

     

invispix 10x10

CURSOR Service Distribution - Navigationnavigator 400x400

Scope
Topics
Details
DB2 Announcemnts
x
DB2 Editionen
x
DB2 Kalkulator
x
DB2 Lizenztexte
x
ASL/OEM Lizenzierung
x
ASL für Ihr Produkt
x