Overall Satisfaction with Db2
DB2 runs the bulk of our company processes including inventory, accounting, manufacturing, order management, CRM, business intelligence, and data warehousing. It is the main database for nearly everything and is considered the source of record for most transactions. We also use it as the database for loading and cleansing data before interfacing with any other databases.
- Index advising
- Complex queries
- Views
- Reliability
- Need easier way to make dynamic tables
- Need better data cleansing commands built into the language
- Need better way to see the impact of a field change across the database
- higher database performance
- reduced maintenance
- simplified database development
- solid upgrade path
DB2 works as good as any of these databases. It is cheaper to run than any of them. It is more solid and stable that SQL server or Netezza. It is very comparable to Oracle for reliabilty.
But for administration, Netezza is a little simpler because it has no indexes. Netezza is also purpose built for data warehousing. It isn't a good transactional database for manufacturing. But administration is far simpler in DB2 that in Oracle or SQL server.
But for administration, Netezza is a little simpler because it has no indexes. Netezza is also purpose built for data warehousing. It isn't a good transactional database for manufacturing. But administration is far simpler in DB2 that in Oracle or SQL server.
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