1. Home
  2. Relational Databases
  3. Db2 Reviews
  4. User Review of Db2
DB2 is Good
Updated February 07, 2024

DB2 is Good

richard shen | TrustRadius Reviewer
Score 10 out of 10
Vetted Review
Verified User

Overall Satisfaction with Db2

It is used widely company wise by different department and different applications, mostly it is lagacy system, created in house or vendors.
DB2 have very important company data, transnational and reporting.
  • DB2 has build in replication tools make online data replication/movement much easier and fast.
  • DB2 HADR is reliable, keep Database up and running 99.99% of time, switch beween servers in seconds.
  • DB2 Federation make the access to all kinds of Databases like in one.
  • DB2 is stable on Linux/AIX even Windows.
  • DB2 Locks is too strict, very little flexibility
  • Like to more built-in function, procedure for Analysis/Reporting
  • Love to see DB2 can go open source, so that it can get more developer involved
  • DB2 is holding very important company data and critical application is running on DB2.
  • Flexible License make the deploy to Developer desktop/VM very easy.
  • For developer from other vendors, not easy to write efficient query.
We have deployed DB2 in different environment, mostly of the system has 20 years of history. As of scalability, we can do vertically so far.
availability is the advantage of DB2 HADR. When unplanned outage happens, HADR will switch on the standby into primary using TSA until both server has issue at the same time. When application has errors, db itself will reflect the same.
Reliability

Do you think Db2 delivers good value for the price?

Yes

Are you happy with Db2's feature set?

Yes

Did Db2 live up to sales and marketing promises?

Yes

Did implementation of Db2 go as expected?

Yes

Would you buy Db2 again?

Yes

It is good to in traditional transaction DB world. Not easy to scale out horizontally, but vertically.

Using Db2

100 - Technology, developer, BI Reporter
10 - Most Senior and some Junior
Very stable, have core application run on it.
Try to adapt cloud native DB
  • Old way of using snapshot to monitor db create unexpected latch after DB upgrade, causing slowness when traffic high.
  • Have to develop new script
  • Moving to Cloud
Moving to Cloud

Evaluating Db2 and Competitors

  • Scalability
Has good team to admin, IBM support is good vs other vendors

Db2 Implementation

db2 work well with the application, also the replication tool can keep it up
  • Implemented in-house
Change management was a small part of the implementation and was well-handled
  • very smooth as we have active-active data center

Db2 Support

ProsCons
Quick Resolution
Knowledgeable team
Problems get solved
Kept well informed
Immediate help available
Support understands my problem
Support cares about my success
None
Most support ppl have good knowledge
No, we have experienced DBA
Yes - yes
Quite a few times
One time is we have some clob function fail on spanish chars, end up we need to re-create db in unicode instead of iso8809

Using Db2

Have been using for long time
ProsCons
Like to use
Relatively simple
Easy to use
Technical support not required
Well integrated
Consistent
Feel confident using
None
  • from db2top to dsmtop to dmctop, all very convinient
  • dmc is bit heavy, but give you history