IBM-DB2 for an Enterprise - one of the robust RDBMS in the market
February 16, 2016

IBM-DB2 for an Enterprise - one of the robust RDBMS in the market

Shiv Shivakumar | TrustRadius Reviewer
Score 8 out of 10
Vetted Review
Verified User
Review Source

Overall Satisfaction with DB2

DB2 is the primary relational database being used in our organization both on z/OS and linux platforms - it is used across the entire organization and is being used to store information on transactions in financial, customer, purchasing environments
  • Is platform specific to Z/OS, Linux, Unix and hence can be leveraged in a customized manner
  • Error handling is the most important feature with warnings
  • Very robust database performance in the SQL schema
  • Allows shared access to the database using LAN in remote branch offices
  • DB2 for Unix has definite room for improvement when compared to competition
  • GUI can be much better than what it is now
  • Data base engine can be faster
  • It is very robust and hence [provides] value for money
  • Also has a free version that is very robust for a smaller organization
  • Used a centralized DB2 database across the organization and hence saved infra investments
  • Oracle
DB2 is much more robust than Oracle or mySQL when used in the Z/OS or Linux platform as it has the best error detection/warning system and also is very fast when accessed over the LAN in remote branch locations. It is scalable to a limited extent though as is the case in all relational database management systems. It is a high availability data base that can support mission critical applications in an enterprise and has had a proven track record over the last 30 years.
DB2 is very robust on both Z/OS and Linux platforms while it has room for improvement on Unix and Windows platforms. It is very robust and the best feature is the error warning system using SQL - whether it is a simple SQL or complex SQL. It can be used in remote locations over LAN and hence a centralized database would be sufficient.

Using DB2

2000 - All mission critical applications in the organization that include: order management, vendor management, purchasing and financial transactions, logistics, and fulfillment.
5 - Regular database management skils with knowledge of SQL, as DB2 is a relational database management system.
  • Primary data base for mission critical applications.
  • Runs on both Z/OS and linux platforms for us.
  • Can be scaled to a limited extent
  • Complex SQL error warning
  • Evaluating usage on Unix
Because it is robust and can be used across the enterprise for RDBMS.