suche 36x36

IBM Informix Advanced Workgroup Edition 12.10

The Informix Advanced Workgroup Edition was discontinued in spring 2019 with the introduction of Informix version 14.10 and is no longer available!

Overview
  • Decision making in seconds based on transaction data.
  • Informix Advanced Editions enables to build extremely fast data warehouse applications.
  • They combine transaction processing OLTP and in-memory warehouse analyses OLAP in one database system.
Scope and functions
  • Corresponds to the Informix Workgroup Edition and also includes the Informix Warehouse Accelerator (IWA) as a warehouse component.
  • For direct access to data warehouse applications, the Advanced Workgroup editions include IBM Cognos Business Intelligence licensing with 5 authorized users.
  • The edition is limited to 16 CPU cores and 16 GB memory for the Workgroup Edition and 1,600 PVU and 48 GB memory for the Warehouse Accelerator.
  • The Storage Optimization feature is not available.
Licensing
  • IBM Processor Value Units (PVU), licensing of processor cores, calculation depends on processor performance.
  • The Informix Advanced Editions are based on two installations: the OLTP Workgroup or Enterprise installation and the installation of the Informix Warehouse Accelerator for in-memory data processing.
    The PVUs of both installations must be calculated for licensing.lizenzinfo de blue 424x100

Informix 14.10 Editions - functions, features, limits
  Developer Edition Innovator-C Edition Express
Edition
Workgroup
Edition
Enterprise Edition Advanced Developer Advanced Enterprise
 
ifx developer blue 400x100 ifx innovator blue 400x100 ifx express blue 400x100 ifx workgroup blue 400x100 ifx enterprise blue 400x100 ifx advanced blue 400x100 ifx advanced blue 400x100
Valid for version
v14.10.xC1 |
| v14.10.xC2
v14.10.xC1 |
| v14.10.xC2
v14.10

V14.10 V14.10 V14.10 V14.10
Limits
             
CPU VP / Cores max 1 | 4 1 | 2 4 24 unlimited unlimited unlimited
Memory maximal 1 GB | 16 GB 2 GB | 8 GB 8 GB 32 GB unlimited unlimited unlimited
Storage maximal 8 GB 8 GB | 50 GB unlimited unlimited unlimited unlimited unlimited
Features
             
TimeSeries / Sensor-Data yes yes yes yes yes yes yes
NoSQL Support yes yes yes yes yes yes yes
Encryption at rest yes yes yes yes yes yes yes
Label based access control yes no yes yes yes yes yes
High Availability Cluster (H/A) yes no one Sec. two Sec. yes yes yes
Secondarys maximal unlimited no Sec. one Sec. two Sec. unlimited unlimited unlimited
Updatable Secondary yes no yes yes yes yes yes
The ability to execute SQL or NoSQL DML operations (read, write, update, delete) on a H/A cluster secondary node. Note: If SQL or NoSQL DML operations are executed on a secondary instance, the secondary instance must be fully licensed
Continuous Log Restore yes no yes yes yes yes yes
CLR secondary is provided by the ontape and ON-Bar backup utilities
Enterprise Replication (ER) unlimited no Cluster limited total 2 root nodes unlimited unlimited unlimited unlimited
Distributed SQL/NoSQL yes no no no yes yes yes
The ability for a SQL/NoSQL session connected to a database in one instance to execute a DML operation using data from another database in a different instance
Parallel operations yes no no no yes yes yes
Parallel operations refers to the ability to execute SQL operations in parallel and includes parallel index build, high-performance loader, and ON-Bar parallel backup, and restore
Table fragmentation yes no no no yes yes yes
Partitioning refers to the ability to fragment a table or index based on logical rules to improve data access and parallel processing
Storage optimization yes no no no yes yes yes
Data Warehouse (IWA) no no no no no yes yes
 

(All information is non-binding and only for information purposes - there is no claim to completeness. The scope and features of the products are determined by IBM's publications, IBM license terms, IBM announcement letters, product documentation and additional publications of the manufacturer.)


Informix EditionsInformix Editions
Informix Editions
DocumentationDocumentation
Documentation
IBM NewsletterIBM Newsletter
IBM Newsletter
Current BugsCurrent Bugs
Current Bugs
Bug ResearchBug Research
Bug Research
Bug FixlistsBug Fixlists
Bug Fixlists
Release NotesRelease Notes
Release Notes
Machine NotesMachine Notes
Machine Notes
Release NewsRelease News
Release News
Product LifecycleProduct Lifecycle
Lifecycle
Media DownloadMedia Download
Media Download