Bigdata

Now Reading

IBM DB2

Next
Prev

Review

IBM DB2

Overview

Synopsis

IBM Db2 is the database that offers enterprise-wide solutions handling high-volume workloads. It is optimized to deliver industry-leading performance while lowering costs.

Category

Virtual Machine Deployment SQL Data Model

Features

• In-memory technology (BLU Acceleration)
• Advanced management and development tools
• In-database analytics for faster decisions
• pureScale: Access data through multiple hosts for continuous availability
• Disaster recovery: Protects against data loss from partial and complete site failures by replicating data changes from a source database
• Storage optimization: Transparently compress data to decrease disk space and storage infrastructure requirements

License

Proprietary

Pricing

Subscription

Free Trial

Available

Users Size

Small (<50 employees), Medium (50 to 1000 Enterprise (>1001 employees)

Company

IBM DB2

What is best?

What are the benefits?

• Increase availability: Safeguard data, speed recovery, maximize application uptime and minimize the cost of downtime
• Optimize performance: Implement a best-practice methodology to identify, diagnose, solve and prevent performance bottlenecks
• Migration: Migrate data between cloud and on-premises systems
• Increase data quality and consistency through shared policies, models and methods

PAT Rating™

Editor Rating

Aggregated User Rating

Rate Here

Ease of use

7.6

8.2

Features & Functionality

7.6

9.6

Advanced Features

7.6

9.1

Integration

7.6

9.0

Performance

7.6

—

Customer Support

7.6

—

Implementation

—

Renew & Recommend

—

Bottom Line

IBM DB2 has industry leading performance for multi-workloads across distributed systems (Linux, Unix, and Windows) for on-premises and on cloud, offering unparalleled benefits for organizations.

7.6

Editor Rating

9.0

Aggregated User Rating

2 ratings

You have rated this

IBM Db2 is the database that offers enterprise-wide solutions handling high-volume workloads. It is optimized to deliver industry-leading performance while lowering costs. DB2 maintains itself very well. The Task Scheduler component of DB2 allows for statistics gathering and reorganization of indexes and tables without user interaction or without specific knowledge of cron or Windows Task Scheduler / Scheduled jobs. Its use of ASYNC, NEARSYNC, and SYNC HADR (High Availability Disaster Recovery) models gives you a range of options for maintaining a very high uptime ratio. Failover from PRIMARY to SECONDARY becomes very easy with just a single command or windowed mouse click. Tablespace usage and automatic storage help keep data segmented while at rest, making partitioning easier. Ability to run commands via CLI (Command Line Interface) or via Control Center / Data Studio (DB2 10.x+) makes administration a breeze. The Db2 Advanced Recovery Feature helps users meet the increasing expectations of partners and customers. The IBM Db2 Advanced Recovery Feature combines three Db2 tools for advanced database backup, recovery and data extraction. These tools help improve data availability, accelerate crucial admin tasks and mitigate the risk of downtime. IBM's RDBMS, Db2, offers a configuration called pureScale, which can operate on both x86 and Power systems. pureScale enables Db2 to operate as a shared storage cluster, interacting with the application as a single database system. Because Db2 pureScale is simply a configuration of Db2, existing users can adopt it without converting data or reorganizing the database in any way. Existing Db2 applications will run without alteration and require no changes in order to take advantage of the scalability of pureScale.

Filter reviews