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.
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