Includes the functionality and tools needed for large, complex enterprise environments, and is ideal for both transactional and data warehouse workloads. Is available on a PVU, per Authorized User Single Install (AUSI), or per Terabyte charge metric. Under the AUSI charge metric, you must acquire a minimum of 25 AUSI licenses per 100 PVUs. Under the per Terabyte charge metric, you must 1) Use the database 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; 2) 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 BLU Acceleration column-organized tables with a majority of the workload accessing the BLU Acceleration column-organized tables; 3) Not use DB2 for Linux, UNIX, and Windows built-in high availability disaster recovery (HADR) or pureScale capabilities.

Is designed to meet the data server needs of midsize to large-size businesses and is ideal for transactional and mixed workloads. It can be deployed on Linux, UNIX, or Windows servers of any size, from one processor to hundreds of processors, and on both physical and virtual servers. The edition includes IBM Data Studio, Label Based Access Control, Row and Column Access Control, Multi-Temperature Data Management, Time Travel Query, Table Partitioning, High Availability Disaster Recovery, Online Reorganization, Materialized Query Tables (MQTs), Multidimensional Clustering (MDC), Query Parallelism, Scan Sharing, Connection Concentrator, pureXML, backup compression, and Tivoli System Automation for Multiplatforms for use with high availability. The product also includes DB2 Homogeneous Federation and Homogeneous SQL Replication allowing federated data access and replication between DB2 for Linux, UNIX and Windows servers as well as web services federation. Includes the capabilities needed for medium-sized business environments, and is ideal for both transactional and data warehouse workloads. The edition includes largely the same functionality and tools as DB2 Advanced Enterprise Server Edition. The main difference is that DB2 Advanced Workgroup Server Edition has processor core, socket, memory, and terabyte restrictions described below.

In addition, DB2 Advanced Workgroup Server Edition supports federation only with DB2 for Linux, UNIX and Windows and Informix data sources. Is available on a PVU, per Authorized User Single Install (AUSI), or per Terabyte charge metric. Under the AUSI charge metric, you must acquire a minimum of 25 AUSI licenses per 100 PVUs. Driver Ic Plus Ip100 Fast Ethernet Adapter Pci on this page.