Overall Satisfaction with Db2
It is used widely company wise by different department and different applications, mostly it is lagacy system, created in house or vendors.
DB2 have very important company data, transnational and reporting.
DB2 have very important company data, transnational and reporting.
- DB2 has build in replication tools make online data replication/movement much easier and fast.
- DB2 HADR is reliable, keep Database up and running 99.99% of time, switch beween servers in seconds.
- DB2 Federation make the access to all kinds of Databases like in one.
- DB2 is stable on Linux/AIX even Windows.
- DB2 Locks is too strict, very little flexibility
- Like to more built-in function, procedure for Analysis/Reporting
- Love to see DB2 can go open source, so that it can get more developer involved
- DB2 is holding very important company data and critical application is running on DB2.
- Flexible License make the deploy to Developer desktop/VM very easy.
- For developer from other vendors, not easy to write efficient query.
Reliability
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
Using Db2
100 - Technology, developer, BI Reporter
10 - Most Senior and some Junior
Very stable, have core application run on it.
Try to adapt cloud native DB
- Old way of using snapshot to monitor db create unexpected latch after DB upgrade, causing slowness when traffic high.
- Have to develop new script
- Moving to Cloud
Evaluating Db2 and Competitors
- Scalability
Has good team to admin, IBM support is good vs other vendors
Db2 Implementation
- Implemented in-house
Change management was a small part of the implementation and was well-handled
- very smooth as we have active-active data center
Db2 Support
Pros | Cons |
---|---|
Quick Resolution Knowledgeable team Problems get solved Kept well informed Immediate help available Support understands my problem Support cares about my success | None |
No, we have experienced DBA
Yes - yes
Quite a few times
One time is we have some clob function fail on spanish chars, end up we need to re-create db in unicode instead of iso8809
One time is we have some clob function fail on spanish chars, end up we need to re-create db in unicode instead of iso8809
Using Db2
Pros | Cons |
---|---|
Like to use Relatively simple Easy to use Technical support not required Well integrated Consistent Feel confident using | None |
- from db2top to dsmtop to dmctop, all very convinient
- dmc is bit heavy, but give you history