IBM Db2

In My professional life I have used DB2 on the AS / 400 and e_Series platform for more than 15 years

Commentaires : Implementing in record time allowing operating different system projects in the companies where I worked, you can be quiet because the data of the companies are based on a robust database eliminated the level of distress, allows access to your level of user user security to the system users allowing them to elaborate the data of the database in an excel sheet for example.

Avantages :

Easy database Implementation easy administration can be managed from any station the level of specialization is much lower than any other database, robust and recovery by indexes, interconnects with other databases such as Sql Server and allows data sharing in Immediately, its level of robustness and integrity is unique.

Inconvénients :

Proprietary database, requires a lot of Hardware for its good performance and its costs are high.

IBM DB2: A high availability Relational Database

Avantages :

The main project that made me involved in working with DB2 is a transactional concurrency benchmark that compares IBM DB2 to Oracle 10g RDBMS. The benchmark results demonstrated high scalability and availability properties in DB2 but the TPS measures showed a better performance of Oracle 10g on HP ML350 servers. DB2 supported better concurrency in bulk data-intensive SQL queries but lagged in computation-intensive tasks.

Inconvénients :

The programming language support is definitely something that needs improvement in addition to cloud integration and deployment tools. Many other commercial RDBMSes (such as Oracle) are leading ahead on this front. OS support, such as testing OS X platforms, can be also better provided in DB2l

IBM D2

Commentaires : I would recommend use of DB2 in modern tech advancements. Light weight DB like MySQL, postgres are much better.

Avantages :

Db2 was used in our mainframe application. it accepts standard sql syntax. can handle large amount of data.

Inconvénients :

As data grows in production environment, it becomes slow. Thread hung and application performance degrades. Also it's costly.

29/5000 Extremely stable and safe

Commentaires : Over 10 years using DB2 I can affirm that it is a very secure bank, with updates that bring new features, high compaction power and geographic contingency features gave us the security to work with SAP.

Avantages :

DB2 HAS A SERIES OF TOOLS THAT ARE DIFFERENTIAL, BUT HIGHLIGHTING THE CAPACITY OF SELF-MANAGEMENT (PARAMETERIZATION) AND DATA COMPACTION. ARE STRONG POINTS TO CONSIDER.

Inconvénients :

The acquisition cost can be a hindrance in the acquisition negotiations. Support is also a weakness for the cost, forcing the use of DB2 communities for troubleshooting.

Heavy and expensive, but good at what it does

Avantages :

Db2 scales very well AFTER a certain point. Support is excellent, it's easy to get stood up once you have a feel for what you're doing.

Inconvénients :

Scaling: for instance it won't run on small machines too well. This becomes important if you're running a local copy for development or testing. There is a free Community Edition to play with, but can't take advantage of tons of ram or CPU, but good for POC.