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.
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.
Db2 is easy to use and has just about every feature you can imagine in a relational database management system. You can use it on the mainframe, as well as on Linux, Unix, and Windows systems, and even the iSeries platform. Review collected by and hosted on G2.com.
Not much to dislike. Perhaps IBM could do a better job of marketing it. Review collected by and hosted on G2.com.
fluidly adapting to our changing needs and integrating with multiple platforms languages and workloads. IBM Db2 is supported across Linux, Unix, and Windows operating systems. Review collected by and hosted on G2.com.
version upgrade requires an outage
Lack of modern client an tool to connect
No free trial
Costing is too high
DB2 web console is not too stable
Improve documentation Review collected by and hosted on G2.com.
The ease of organizing & managing data. But it has been a long while I have worked on DB2. But I like using the SQL commands. Review collected by and hosted on G2.com.
I remember there were a few issues but can't remember as it's been a while since I worked on DB2. Review collected by and hosted on G2.com.