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.

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.

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

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.

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

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

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

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

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.

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.

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.

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.

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.

We are using IBM db2 to store large volume of sensitive user data which scale automatically when required, it allows multiple concurrent transactions with no data redundancy and maintains the isolation property.

IBM DB2 provides the low latency and high data availability, It provides automatic scaling and high security for the large volume of data. It is robust No matter how much amount of data is, IBM DB2 will never fail.

IBM Db2 is a bit expensive and not all the SQL standards available in the IBM Db2

Learning a fully functional database or DBMS may require an educational institution to buy licensed software to be installed in the laboratory. IBM DB2 Express-C is a free closed- source software that a student can use. Even a student could download and have the personal copy of the application as he learns database during the course.

IBM DB2 gives a start up point for a student to learn databases. All the features a DBMS have are provided by DB2. The product supports almost any front-end application that requires database. All the drivers are provided as you setup a connection to an application. IBM DB2 is not limited in learning SQL scripts. You may initiate also database back up and security, XML, stored procedures, and user-defined functions.

IBM DB2 is a high-secured database server. You may be lost in the installation process if you missed one of its steps. If you experience failed installation, uninstalling it may not fully do the trick. You need to delete folders or directories it has created during installation.

This tool is effectively and efficiently being used in some specific departments of our organization. Overall, it is a great tool that has been really beneficial for our company. I find the customer support of IBM Db2 the best product support team as whenever we have questions they just respond to them in the quickest way.

I have been using this product in our company for a long time as Database-as-a-Service on our cloud for different requirements such as storing and even manipulating data safely with timely availability. This product has been providing services that help in storing and running all the problems in order to evaluate the data. This tool allows us to modify the processing speed of our company’s data just to enhance the overall user experience. Moreover, I am a frequent user of this tool and having great experience of this tool.

I felt there is a storage capacity problem which sometimes makes it difficult to check the effectiveness of the entire database.

I learned how to cluster distributed databases, the use of IBM products, they are very powerful

It is very easy to install, use, it can be used for small and large projects, there is a lot of documentation about DB2, and the support they offer is very good, as long as you have a good license. I use it mainly for the execution of databases distributed in a banking project, its performance is very good

the bad thing that I see, is that you have to acquire a business license to use your maximum potential, apart from that there is also use IBM hardware, otherwise many conflicts are created

This can hold n number of records and easy to access it via online application and updated using the informatica

The application looks and query are bit complicated compared to SQL

Complessivamente un ottimo prodotto, ma per le nostre esigenze troppo impegnativo dal punto di vista dell’amministrazione del Db.

Utilizzato prevalentemente in modalità Jdbc attraverso transazioni sql il DB2 è un ottimo prodotto è scalabile e risponde a qualsiasi esigenza transazionale.

Per avere il meglio necessità di competenze di amministrazione che altri prodotti invece non richiedono.

I used it every day for years. I still use it from time to time as it is sunset.

It served its purpose in its time but I think that time is past. It worked well for our mainframe and from COBOL but has been replaced by bigger and better things.

The way the schemas are defined is confusing

Supported on multiplatform like AS400, Linux, Windows. A good choice if you work across these environments.

Having worked on over a dozen different databases, the thing I hate most is having to REORG my tables weekly so that my DB doesn't slow down.

Use it if you are using a Mainframe OS. The navigation is not too complex considering a minimalistic UI.

The query speed and result retrieval is a pain point. May be they can introduce an instant results UI page on the Mainframes.

Our card system is in ibm db2 database and super powerful and never the instance has presented problems.

Sometimes not all applications are compatible with this database.

Overall satisfied, used in couple of my projects, even with AS400.

Easy to integrate with any API with minimal configuration

Searching large amount of data might take time, indexing strategy could be better

I liked the raw power of the utility. I was able to run millions, sometimes billions of rows of data through and it handled it just fine. The included functions were very helpful in translating complex data structures

None really. It did everything I needed. Maybe the only complaint would be how complex it is, but that is more of a feature not a bug

IBM DB2 is an excellent database platform. We are able to use it as a database platform for large corporates. It is designed to store, analyze and retrieve the data efficiently, hence one of the commonly used database platform.

There is nothing which we do not like about this database platform. everything looks so good about it.

IBM DB2 is a very good database to use in small companies, is very robust and easy to mantain with good performance.

The community and support team is not very helpful, the updates take a lot of time so it's not up to date if you compare with other databases

Straight forward to use, fast, and clean interface

Stability and easy cloud interface, quick access to resources

For complex process like hot backup could be deal with limitations, some gap between the local interface and the cloud solution

IBM DB2 ensured the development of a scalable database solution to cater to the data processing and data cleansing requirements. The query processing performance was fast with minimal disruptions. Debugging was efficient with good community support. A number of drivers are available to connect to external applications.

Scalable database to store large scale organisation data Robust application Data security & reliability - ensure strict data compliance Easy to get started - getting started is simple with minimal expert intervention required Excellent community support - resolution of bugs, suggestions, ideas available

Analytics capabilities have to be improved

* IBM DB2 Cloud services are really good. * Error Handling feature is really impressive. * DB2 provides API support for many languages.

* Regular DB 2 fix packs cannot be applied. * Number of concurrent user connections is not limited.

What I like most about IBM DB2 is it can be managed from any job. Likewise, it saves data against loss, unauthorized access, or invalid entries.

What I like least about IBM DB2 is that it requires other applications that have been developed and those that are going to be implemented.