IBM Db2 | Database for Security and performance at its best
Updated November 09, 2024

IBM Db2 | Database for Security and performance at its best

Anonymous | TrustRadius Reviewer
Score 8 out of 10
Vetted Review
Verified User

Software Version

Db2 on-premise

Overall Satisfaction with Db2

We are using IBM Db2 as our relational database for Financial and Mainframe applications. The database is very robust and we rarely had any issues with scalability and performance. We are also using it as a cluster database also to have 24*7 availability. It supports API and other integration very well as we have various application which connects to Db2.

Pros

  • Performance
  • OLTP
  • scalability
  • availability

Cons

  • Integration with other systems can be better
  • GUI needs much improvement.
  • Its quite hard to find Db2 engineers, so IBM should focus on trainings.
  • Installation and upgrade process is bit complex.
  • It doesn't require many engineers to handle the Database, few expert engineers can handle it well.
  • Once it is installed, it's easy to maintain and thus it doesn't require system changes every now and then.
  • Higher security makes it less vulnerable. Thus have to spend less on the security.
For large businesses like us, scalability is one important factor. Db2 fits well for this purpose. As ours is a financial system, sometimes there is a demand to scale the database especially during month and year-end activities. With Db2, this scalability is much more convenient to achieve and it's always easy to meet the growing enterprise demand.
Banking and financial systems need 24/7 availability. With Db2's high availability feature, clustering is much easier. This also enables us to patch the system without any downtime, as sometimes it's not possible to afford downtime. Cluster nodes can be patched one by one, thus making the Database available all the time.
Db2 provides a combination of performance and scalability. Security wise, Db2 is always a first choice, especially for the systems where security can't be compromised. For mainframe systems, there is no other DB in the market that can perform better than Db2. If an organization is using other IBM products, then Db2 provides seemless integration with them.

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?

I wasn't involved with the selection/purchase process

Did implementation of Db2 go as expected?

Yes

Would you buy Db2 again?

Yes

Oracle Database, Amazon Relational Database Service (RDS), PostgreSQL, Microsoft SQL Server
It's best suited for systems that can't compromise on performance and security. That's why it's usually the first choice for banking and financial systems. It's very good at handling large-scale datasets. However, for small scale enterprises, using Db2 is not that feasible due to its licensing cost. Due to its complexity and lack of training resources, there are very less engineers in the market that have expertise on Db2.

Using Db2

500 - In our organization, DB2 is being used as a mainframe database for storing banking data. DB2 provides the highest security for banking data, which is further used by various data mining and analytics applications. We are also using it for OLTP-based applications because of its high volume transection capability. The data is being used by marketing team also to find the potential clients.
15 - We have a team of mainly DBAs who are supporting the database. Apart from this, we have a team for the OS (AIX) and storage. There is also a team of DB2 developers to cater various business requirement and enhancements. We also have few DB2 consultants to look after overall DB2 infrastructure.
DB2 has an edge over other databases because of its secure, reliable and scalable architecture. Db2 is always on top of providing up-to-date security features. The scalability is much simpler to implement and it is emerging day by day. The performance is in par with any other databases available in the market.
We are yet to move from our existing DB2 infrastructure to the cloud. We have the plans for Db2 cloud move in the coming months.
However, for a few of our AI applications, Db2 has played a vital role in providing state of art AI capabilities which has helped in boosting team performances.
  • Using Db2 AI capabilities for performance optimisation
  • Using Db2 for analytics purposes
  • For scaling as per the load requirement
Db2 AI ML feature has helped us in various ways including performance optimization by query tuning. The AI powered optimizer helps in minizing the query cost and providing the better execution plan.
Db2 AI has also helped in automating workload management tasks (WLM) in the management of work and monitoring it after the execution.
  • Expanding use cases of Db2 AI/ML capabilities
  • For real-time analytics applications.
  • Using it for warehouse applications

Comments

More Reviews of Db2

  1. Home
  2. Relational Databases
  3. Db2 Reviews
  4. User Review of Db2