Item: Db2
Rating: 8
Author: Verified User

Overall Satisfaction with Db2

Use Cases and Deployment Scope

Db2 is the database of choice for all our mainframe applications in our organization. Many mission critical applications are using Db2 database to manage their work. It is a very high performance database. There are excellent tools available to manage the database such as Platinum etc. You can use it us dbeaver or other windows based software client.

Pros and Cons

Pros

backup and restore of database very easily
Good database security for access
Easy to Administer

Cons

Not available as option in Azure Cloud.
plan rebound that is required after the database changes
hard to find good Db2 DBA

Return on Investment

IT allows us to manage all our Purchase orders with vendors
All our corporate integration for Logistics systems is managed via Db2

Scalability

We have massive workload running in our organization on Db2 Database with massive amount of data and delivery sub-second response time to very mission critical applications. Various Logistics systems integrate with Corporate systems using the Db2 database. Various Accounts payable systems and paying vendors uses Db2 system. It is used in US and also all international countries.

Reliability and Availability

I can't remember when was the last time when my Db2 system failed. Db2 is a very highly available database used by multiple user application with thousands of users running app against Db2 system. Very rarely requires any downtime. Very rarely requires a reboot and continues to function fine with high performance.

Alternatives Considered

Db2 is much more scalable and available then other Databases such as MariaDB, Ingres, Sysbase, Informix etc Oracle is good but comes close to Db2.
Db2 is multi platofrom and when it comes to mainframe there is no other choice then Db2 for the database. Tools available for Db2 are far better then tools available for other databases.

Key Insights

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

Other Software Used

IBM CICS, IBM Informix

Likelihood to Recommend

Applications that need highly secured database.
Applications that need massive scalability and very high volume for very fast performance. Applications like
Very good for low latency transactions
It is very highly reliable, scalable and with very high performance.
Database of choice for credit card companies/insurance companies and any kind of financial transactions.
IT is one of the most matured relational database

Backend database for the modern web based java/websphere app
connecting all of the distribution centers of the company to corporate merchandise/replenishment apps

Future Planned Uses

to have data from DB2 moved to bigdata cloud solutions such as BigQuery/SnowFlake schema for analytics reporting

Likelihood to Renew

db2 works well for our workload for many of our mission critical applications. We get good topline support for the product.

Comments

Please log in to join the conversation

Db2 Review

Software Version