I mostly work on Java applications working on WebSphere and the integration of DB2 with both the software is quite easy and effective. We have never faced an trouble with this. It is also supported for Mainframe programs which gives the additional benifits that we can do batch processing in Mainframe. Review collected by and hosted on G2.com.

Some query syntaxes are a bit different than other competitors so migrating them to DB2 requires code changes and requires testing of all the queries. This is a time-consuming task. Review collected by and hosted on G2.com.

Several Options available that looks good that makes the user to use the product with full potential. Users can easily do their work in lesser amount of time....... Review collected by and hosted on G2.com.

Query runs very slow sometimes and users face difficulty in navigating to the screens. Try to make it user friendly so that the common users can use it to the full potential. Review collected by and hosted on G2.com.

easy to install and configure the connection Review collected by and hosted on G2.com.

need to restart the system after installation Review collected by and hosted on G2.com.

DB2 is used in data warehousing solutions for ETL purpose to store, analyze and retrieve the data efficiently. It can also be used for semi- structured data i.e, XML and is extremely fats as compared to other traditional databases. Review collected by and hosted on G2.com.

It is scalable but version control, expanding hardware capacity is quite painful, required outage etc. Review collected by and hosted on G2.com.

the most helpful thing about this database is the excellent performance and advanced database operations can be performed easily. I used this database for smooth transaction processing of the customer's data and found it reliable. Review collected by and hosted on G2.com.

There are few of the disadvantages of this database are as below.

It doesn't have modern connectivity which sometimes creates problems.

The worst thing is, outage requires every version upgrade and performing some other activities too. Review collected by and hosted on G2.com.

Security and performance is good comparing to others Review collected by and hosted on G2.com.

Cost is very high compared to other competitors of RDBMS Review collected by and hosted on G2.com.

It just works for me, I will consider it where we have a very huge amount of data, Found that with the time the latency to fetch things drop down fast when the properties are correctly configured as per the app behavior. Review collected by and hosted on G2.com.

Of course, the amount I will pay for the premium services is on the higher side. Review collected by and hosted on G2.com.

Enterprise level security with highly granular access control levels can be acheived using db2. It's fast and reliable and can Scale to really large data. Excellent query optimizer is powering db2. Review collected by and hosted on G2.com.

One of the main disadvantages is high licensing cost. Along with that we noticed that db2 webconsole is not stable and crashes often. Debugging with db2 logs can be improved a lot as they are not verbose enough. There is a lot of scope in improvement of documentation. Review collected by and hosted on G2.com.

Accesibility,Accessibility, and simplification. Gets multiple things queries at the same time and also the search is faster as it allow user to skip the query and get the result quickly by performing search on multiple columns at the same time across the tables. Review collected by and hosted on G2.com.

Nothing as such..I am using this product from quite a few time now and it looks almost perfect to me which makes my life easier. Review collected by and hosted on G2.com.

Easy and user friendly. Secure and productive. Review collected by and hosted on G2.com.

Not supported in modern technology and environment. Review collected by and hosted on G2.com.