whichdb
vs

IBM Db2 vs Actian Ingres

IBM Db2: IBM's enterprise RDBMS for Linux, UNIX, Windows and z/OS, with BLU columnar and pureScale clustering. Actian Ingres: One of the original relational databases, still sold by Actian for long-lived enterprise systems.

key differences

  • IBM Db2 is built for larger datasets (≤ 1 PB) than Actian Ingres (≤ 10 TB).
  • Horizontal scaling is addon in IBM Db2 and none in Actian Ingres.
  • Only IBM Db2 has full-text search, vector search, geospatial, json, materialized views.

choose ibm-db2 for

  • +Mainframe core banking and insurance policy systems
  • +SAP and other packaged apps on IBM infrastructure
  • +Operational data warehouses with BLU columnar tables
  • +Continuous-availability OLTP with pureScale

best at · OLTP, OLAP, Warehouse

choose ingres for

  • +Maintaining legacy Ingres/OpenROAD business applications
  • +Government and public-sector systems built on Ingres
  • +Lift-and-shift of on-prem Ingres to containers or cloud VMs

best at · OLTP, OLAP, HTAP

IBM Db2IBM's enterprise RDBMS for Linux, UNIX, Windows and z/OS, with BLU columnar and pureScale clustering.
Actian IngresOne of the original relational databases, still sold by Actian for long-lived enterprise systems.
overview
Primary model
Relational
Relational
Also supports
Columnar / OLAP, Document, Spatial, Vector, XML
Columnar / OLAP
Type
Database engine
Database engine
Status
Active
Active
Developer
IBM
Actian (HCLSoftware)
First release
1983
1974
Latest version
12.1.5 (LUW) (Jun 2026)
12.1.0 (patch 34124) (Oct 23, 2026)
License
ProprietaryProprietary commercial license
ProprietaryActian commercial license
Free tier
✓
—
popularity
WhichDB Score
45.5
16.8
Rank
#38
#197
GitHub stars
–
–
Stack Overflow questions
12.9K
154
scale & guarantees
Comfortable data size
Large (≤ 1 PB)
Medium (≤ 10 TB)
Horizontal scaling
Addon
None
Multi-region
Read replicas
Read replicas
ACID
Full
Full
Consistency
Strong
Strong
Schema
Strict
Strict
Architecture
Client server, Primary replica, Shared storage, Distributed
Client server, Single node, Primary replica
deployment
Self-hosted
✓
✓
Vendor-managed cloud
✓
✓
Serverless
—
—
Embedded
—
—
Edge
—
—
Clouds
IBM Cloud, AWS
AWS, Azure, Google Cloud
capabilities
Transactions
✓
✓
Joins
✓
✓
Secondary indexes
✓
✓
Full-text search
✓
—
Vector search
✓
—
Geospatial
✓
—
JSON
✓
—
Change data capture
✓
✓
Triggers
✓
✓
Stored procedures
✓
✓
Materialized views
✓
—
TTL / expiry
—
—
Pub/Sub
—
—
Columnar storage
✓
✓
In-memory
✓
—
Durable persistence
✓
✓
Compression
✓
✓
Encryption at rest
✓
✓
Role-based access
✓
✓
Time travel
✓
—
Branching
—
—
Online schema changes
✓
—
Streaming ingest
—
—
Offline sync
—
—
Runs in WebAssembly
—
—
interfaces
Query languages
SQL, SQL PL
SQL, QUEL
Client languages
Java, C, C#, Python, JavaScript, Go, PHP, Ruby
C, Java, C#, Python, PHP
Best for
OLTP, OLAP, Warehouse, HTAP
OLTP, OLAP, HTAP
Add more to this comparisonNot sure either fits? Try smart match

IBM Db2 vs Actian Ingres: FAQ

What is the difference between IBM Db2 and Actian Ingres?

IBM Db2: IBM's enterprise RDBMS for Linux, UNIX, Windows and z/OS, with BLU columnar and pureScale clustering. Actian Ingres: One of the original relational databases, still sold by Actian for long-lived enterprise systems. IBM Db2 is built for larger datasets (≤ 1 PB) than Actian Ingres (≤ 10 TB). Horizontal scaling is addon in IBM Db2 and none in Actian Ingres. Only IBM Db2 has full-text search, vector search, geospatial, json, materialized views.

When should I choose IBM Db2 over Actian Ingres?

Choose IBM Db2 for mainframe core banking and insurance policy systems; SAP and other packaged apps on IBM infrastructure; and operational data warehouses with BLU columnar tables. Choose Actian Ingres for maintaining legacy Ingres/OpenROAD business applications; government and public-sector systems built on Ingres; and lift-and-shift of on-prem Ingres to containers or cloud VMs.

Is IBM Db2 or Actian Ingres more popular?

IBM Db2 ranks #38 on the WhichDB Score (45.5/100) and Actian Ingres ranks #197 (16.8/100). Popularity is not fit: check the requirements that matter for your project.

Are IBM Db2 and Actian Ingres open source?

No. IBM Db2 is proprietary, closed-source software. No. Actian Ingres is proprietary, closed-source software. License: Actian commercial license.