DB2 Express Edition

An entry-level budget friendly database system, designed for small and medium businesses

IBM® DB2® Express Edition is an entry level database system designed for transaction processing and handling complex query workloads. It provides enterprise-scale capabilities and is optimized to utilize up to 8 processor cores and 8 GB of memory. The software is available in a range of licensing models.

DB2 Express Edition offers these features and benefits:

Bi-temporal data management using the time travel query feature.
Always on Transactions using High Availability and Disaster Recovery (HADR) to minimize data loss.
Enhanced security through Row and column and Label based access control features.
Flexible application development and management, including an integrated tools environment,and SQL compatibility features to help you develop, manage, migrate and standardize diverse data assets.
Future proof versatility with NoSQL Graph Store and IBM Mobile database synchronization and support.

Bi-temporal data management

Provides the infrastructure for time-aware analytics to run time-specific queries. This helps reduce the operational complexity of collecting and analyzing time-based data.
Allows data to be queried as currently exists at any points in the past, or as it will be at some point in the future.

Always on Transactions

Helps ensure that critical databases remain available around the clock. HADR allows rapid failover from a primary or standby server and requires little time to set up.
Allows multiple HADR standby databases.
Multiple standby setup helps to protect your data while keeping it highly available, with a single technology.
Supports replication at the schema level. This means that any newly created table is set up for replication.

Enhanced security

Includes label-based access control to help you secure data access and control security risks.
Offers row and column access control to help you regulate data access at the row level or column level, or both. This feature can be used to complement the table privileges model.

Flexible application development and management

Includes IBM Data Studio, which provides an integrated, modular environment for database development and administration of IBM DB2 for Linux, UNIX and Windows.
Enables you to create and manage heterogeneous database environments to help increase productivity.
Includes a SQL compatibility feature to help simplify and reduce the risk of database migration. For applications running on comparable Oracle databases, requires few or no code changes to run on DB2.

Future proof versatility

Includes IBM Mobile Database, a relational database that runs on your mobile device, to help you manage data on mobile and embedded devices.
Together with IBM solidDB and its advanced replication and universal cache capabilities, you can synchronize data between mobile devices and IBM databases.
Using NoSQL Graph Store, provides an optimized way to store and work with graph triples inside DB2.
Allows you to store graph triples with the added benefits of ACID compliance, data compression, parallel execution, load balancing, backup and recovery and advanced security.

DB2 Express Edition resources

Data sheet: IBM DB2 10.5 with BLU Acceleration 970KB

Read about this high-performance, scalable database management system designed to meet the needs of small and medium businesses.

Brochure: Keep your business up and running with IBM DB2 1MB

Learn more about meeting online transaction processing demands in the big data era, with DB2 10.5