Db2

Db2

(142)
3.8 out of 5 stars

IBM® Db2® is the database that offers enterprise-wide solutions handling high-volume workloads. It is optimized to deliver industry-leading performance while lowering costs.

Work for Db2?

Learning about Db2?

We can help you find the solution that fits you best.

Db2 Reviews

Ask Db2 a Question
Write a Review
Filter Reviews
Filter Reviews
  • Ratings
  • Company Size
  • User Role
  • Industry
Ratings
Company Size
User Role
Industry
Showing 147 Db2 reviews
LinkedIn Connections
Db2 review by José H.
José H.
Validated Reviewer
Verified Current User
Review Source

"DBA ADMNISTRATOR IN DB2"

What do you like best?

I have worked in DB2 technology since 1996. I have made a lot of effort to understand what it can offer the user, its automatic applications, and its security, its integrity and the backup and recovery of its data. It is a robust and fully tested technology. Very reliable for any volume of data. Preferably the transactional ones. Excellent administrator of relational tables and its standard SQL. I recommend it.

What do you dislike?

In my personal experience, DB2 is very demanded by its utilities. Many commands and references of very nebulous errors. It requires a lot of computing power, it is still architecture for medium and large computing environments.

Recommendations to others considering the product

Yes. It is definitely excellent for handling transactional data and non-formal data, safe, reliable. recoverable, robust and updated to the demands of new trends in the modern development of applications and systems and for handling very large volumes of data.

What business problems are you solving with the product? What benefits have you realized?

I have worked to assist developers of large data analysis systems. Especially business intelligence solutions, designing datamarts and datawarehouse. And processing of statistical data of medium and great complexity. Very good relationship with third-party SAS software: mining and multivariate data analysis.

Sign in to G2 Crowd to see what your connections have to say about Db2
Db2 review by Administrator in Computer Software
Administrator in Computer Software
Validated Reviewer
Verified Current User
Review Source

"Time tested database which has fallen behind to the new competition."

What do you like best?

ANSCII compliance is high, Queries are similar to Oracle SQL, Since it is there from long time lot of help is available online. Available both on linux as well as windows. Mostly written in JAVA and C, C++. Less vulnerabilities is known. Support system is good. World wide agents are available. Queries are simple

What do you dislike?

DB2 has stiff competition, It has fallen way behind Microsoft SQL Server and Oracle. Updates are not rolling out from a long time. Lot of good features are being deprecated. Windows client is a nightmare. There was 'Control Center desktop client that has been removed. Very complicated installation. New hardware and networking advances are not being utilized.

Recommendations to others considering the product

It's comparatively less cost compared to Oracle / Microsoft Sql server. I don't thing IBM is doing lot of investment on DB2. If your applications are mission critical and you want future proofing it's better to go with Microsoft SQL Server. If your app is legacy and it's not too important to scale then you can go with DB2

What business problems are you solving with the product? What benefits have you realized?

Backend Data storage in Relational table format. It is good RDBMS suitable for traditional monolithic applications.

What Relational Databases solution do you use?

Thanks for letting us know!
Db2 review by Derek J.
Derek J.
Validated Reviewer
Review Source

"Great Database Platform (For the Most Part)"

What do you like best?

DB2 is relatively simple to maintain and performs very well. It provides a wealth of enterprise class features (mirroring, replication, clustering, etc), and I've found the built in troubleshooting/monitoring tools to be quite handy. IBM support for the product has been excellent as well.

What do you dislike?

Worst ODBC drivers I've ever used - and that says something. There are countless variations and packages, each with 32-bit, 64-bit, and multilanguage flavors. It's easiest if you use the GUI-based tools to create the System DSN (using the Windows ODBC interface has never once worked properly for us), but the GUI tools install a small DB instance wherever they're installed. I don't want that on my servers just to get an ODBC connection set up. The lightweight drivers only provide poorly documented CLI tools and store passwords in cleartext ini files.

Recommendations to others considering the product

There are free products that perform just as well and likely have better integration capabilities with 3rd party applications. However, DB2 was the right fit for us because it worked natively with our aging mainframe.

What business problems are you solving with the product? What benefits have you realized?

Our DB2 cluster mirrors our mainframe databases to act as a data repository for all our business-critical applications. Our mainframe is unable to handle the load from external queries, so the DB2 cluster acts as the read/write for all integrations.

Db2 review by Brian R.
Brian R.
Validated Reviewer
Verified Current User
Review Source

"IBM i DB2"

What do you like best?

The database is very easy to use and has great features. The software is completely integrated into the IBM i OS so much of the overhead and manual processed required by other databases is handled for you entirely behind the scenes to free you up for real business requirements and responsibilities.

What do you dislike?

Sometimes working with IBM can be an issue in relation to support or speed in which they can make adjustments to the product. On occasion issue or support calls can progress at a slow pace to resolution. Many people in the computer world consider the IBM i an old architecture so it has a somewhat tainted reputation in regards to getting new/younger people involved with the platform. .

Recommendations to others considering the product

The platform and software are tightly integrated and very easy to integrate and utilize. Based on this the platform requires a limited number of people to manage and the run your environment.

What business problems are you solving with the product? What benefits have you realized?

The majority of our primary business structure is supported by DB2 including our ERP and financial systems. We also have other products that may be used for BI presentations and they also interact with the DB2 database without any issues.

Db2 review by Aishwarya A.
Aishwarya A.
Validated Reviewer
Review Source

"Amazing database language by IBM"

What do you like best?

I really like the way it has a different syntax than the traditional RDMS SQL. For ex: In order to create an alias for a table name, you have to write a query separately with "create alias aliasname for table name" instead of a traditional table name alias name syntax.

What do you dislike?

It's difficult to put to use especially when you are building applications in a specific company IDE. What I mean to say is if you are working with Visual Studio, it's better to write queries in SQL Server Management Studio due to its ease of SQL Server storage on cloud and interaction.

Recommendations to others considering the product

Must go for it if you are using IBM tools and Team Management systems like Lotus Notes or Rational Team Concert.

What business problems are you solving with the product? What benefits have you realized?

I am an IBM certified DB2 Associate.

Db2 review by Administrator in Consumer Goods
Administrator in Consumer Goods
Validated Reviewer
Verified Current User
Review Source

"Stone age relic that is barely trying to look modern. (DB2 LUW)"

What do you like best?

It's being replaced at our shop gradually and will likely be pushed out the door. That's about it.

What do you dislike?

Wow! Where to start? The stone age interface at operating system level? The many kludges and signs of neglect? The lack of support in the community and the vendor? The horrid documentation by IBM? The ridiculous backup and restore procedures? I guess the biggest problem is that it's an IBM product. The vendor has a horrible track record with in-house and acquired software that's been Blue-washed.

Recommendations to others considering the product

Run away . Consider something else. IBM is not a vendor you would want on your site in any case.

What business problems are you solving with the product? What benefits have you realized?

This was originally sold to the business as a cheaper (and better) solution to the rising prices that Oracle was invoicing. It was cheap for a few years and then the prices for the product started increasing. One of the issues we've seen is that UPGRADES TO A NEW FULL VERSION LEAVE REMNANTS OF THE OLD VERSION AND IBM CONTINUES TO CHARGE FOR BOTH VERSIONS. We haven't found the mechanism to clean this up as yet due to the convoluted licensing.

Db2 review by Francisco T.
Francisco T.
Validated Reviewer
Review Source

"DB2 GOOD Database "

What do you like best?

Db2 have a good integration with Host and cobol programs, for store data generate with this programs is the best solution in the market.

The configuration of the clients at least for me was a little bit complicated, as far as i know it only have 3 party clients.

What do you dislike?

Db2 does not have the potential of other solutions, less functions implemented than other databases for data analysis i think there are better solutions than these one.

Recommendations to others considering the product

Is the best database if you have host. It a very robust database. For the rest of applications like data analysis there are a way better solutions at the moment.

What business problems are you solving with the product? What benefits have you realized?

We are using db2 like our database for all the cobol programs, intregration with that is easier than other products

Db2 review by ALEXANDER J.
ALEXANDER J.
Validated Reviewer
Verified Current User
Review Source

"Excellent DBMS"

What do you like best?

Excellent database to handle high volume of data, recommended for datawarehouse.

What do you dislike?

DB2 for Zos is focused on mainframe equipment, making it difficult for the installation of alternative infrastructure to the data center in the case of having a contingency center.

Recommendations to others considering the product

Define the project very well if the DB2 database manager is required since it could be expensive to maintain the infrastructure depending on the installation and configuration.

What business problems are you solving with the product? What benefits have you realized?

The partitioning of 21 alternative centers was resolved through the DB2, the management of roles and permissions for the accesses to the objects with the implementation of Rc / secure.

Db2 review by Charlie K.
Charlie K.
Validated Reviewer
Verified Current User
Review Source

"IBM DB2 developer "

What do you like best?

Faster loading and retrieval of data .

Security of the data

Faster response time in the applications using DB2 as a backend.

Drivers for DB2 are very easy to install.

What do you dislike?

Hard to configure and installation is also painful for DB2.

DB2 is sometime not very much compatible with apaplication developed in Java.

Recommendations to others considering the product

DB2 can handle large amount of data .

Performancewise DB2 can be faster when it comes to database optimization.

What business problems are you solving with the product? What benefits have you realized?

Processing large amount of data and storage it massive amount of data .

Db2 review by Justin H.
Justin H.
Validated Reviewer
Review Source

"DB2 is the tried and true database. "

What do you like best?

When it is administered well, DB2 is lightening fast with even very very large tables and retrieval of your data is very easy from any programming language with the familiar and intuitive SAL language.

What do you dislike?

When it has not been architected and maintained well, data retrieval can be very difficult. It is really only as good as the DBAs make it.

Recommendations to others considering the product

Stick with one platform. I am working in a shop now where we have twobdatabase platforms. It's unnecessary and just makes things that much more difficult. Keep to one. If you switch, switch completely, not halfway.

What business problems are you solving with the product? What benefits have you realized?

We have some tables with extraordinary amounts of data that are also growing bigger allbthe time. DB2 gives us the abiliry to pull from that data pool with subsecond response times.

Db2 review by Hima S.
Hima S.
Validated Reviewer
Review Source

"Best for beginners and also experienced peeple"

What do you like best?

Easy to use and perfect database for a beginner for executing simple queries and task scheduler that allows jobs to run other jobs makes its easy. I have used DB2 in my last job and was easy to use and gives a range of options in organizing the tables

What do you dislike?

My company didnt have IBM paid purchased tools which were support gets difficult if we ever encountered any issues

Recommendations to others considering the product

Purchase the IBM tools and you will get the best support from IBM team for any minor to major issue

What business problems are you solving with the product? What benefits have you realized?

Store data and organizing huge database tables in different environments and we use it for testing of new software features and support my companys legacy software

Db2 review by Consultant
Consultant
Validated Reviewer
Review Source

"Not the best option"

What do you like best?

I like a lot the support that it has, all the users that have been using it and purpossing challenges and all variety of solutions that you can use. Overall of this i like his security and the backup recovery. It is esasy to learn it and in a few time you could be working with this.

What do you dislike?

I don't like that they are losing in the market vs Microsoft, but Microsoft is doing it very well. I think that IBM should get advance of them being updated using all the new technologies and get not stagnate.

Recommendations to others considering the product

If they don't update his software, they will lose the market vs Microsoft making almost impossible consider it like an option to work

What business problems are you solving with the product? What benefits have you realized?

I'm working for a University departament building an app, and it fits exactly what we need for this, but even more I'm receiving work to use SQL Server, so every time I use it less.

Db2 review by User
User
Validated Reviewer
Verified Current User
Review Source

"DB2 is one of the best relational database management system"

What do you like best?

Concurrency feature of DB2 is one of the best feature.

Locking features in DB2 is pretty cool and needed functionality.

DB2 is easy to use and fairly easy to implement.

Integration of DB2 with other IBM products like filenet etc works pretty well.

What do you dislike?

Maintenance cost of DB2 is expensive.

DB2 doesn't have web interface which can be easily queries to extract data.

Db2 doesn't support distributed systems.

DB2 lacks monitoring tools.

SQL used for DB2 does't have lot of functions.

Recommendations to others considering the product

Db2 is fairly easy to support day to day transactional data needs.

What business problems are you solving with the product? What benefits have you realized?

Day to day transactional data needs are fulfilled with DB2.

Big data is pretty manageable in DB2.

Using DB2 for the transactional data.

Db2 review by Alexander C.
Alexander C.
Validated Reviewer
Review Source

"Robust, estable and excellent ability to manage high volumes of data"

What do you like best?

It has an excellent ability to manage high volumes of data and is easy to use, the tool is friendly to the end customer

What do you dislike?

the installation is usually a bit tedious, it requires very implicit professional knowledge to be able to use the tool and requires a high level of hardware so that it can work effectively

Recommendations to others considering the product

It is a viable alternative to manage data for financial entities and large companies

What business problems are you solving with the product? What benefits have you realized?

It provides considerable robustness, additionally, it has the ability to handle high volumes of data, it is highly recommended to be implemented in systems of financial entities and large companies

Db2 review by User in Information Technology and Services
User in Information Technology and Services
Validated Reviewer
Review Source

"The best DB for Mainframe legacy system"

What do you like best?

Working with Db2 is very easy as it allows all the database features of Relational database management system. It is the database of legacy system which can be used with Cobol, AS4 etc. It is easy to learn for beginners and designed to store , analyze and retrieve the data efficiently.

What do you dislike?

There are lots of great as well as efficient monitoring tools in DB2, but nowhere it is mentioned which one is recommended by iBM. Its hard to find good Db 2 DBAs for a new project unlike oracle or SQL server DBAs.

What business problems are you solving with the product? What benefits have you realized?

It is easy to install and deploy with tons of redbooks and whitepapers available on internet. Db 2 is cheaper compared to oracle or other databases. The maintenance cost is cheap as well including hardware up-gradation is also very cost effective.

Db2 review by Consultant in Computer Software
Consultant in Computer Software
Validated Reviewer
Review Source

"Outdated database with terrible support"

What do you like best?

Frankly for enterprise database product it does what it is supposed. It has a reasonably functional database engine. Its stays consistent with standard SQL and is relatively stable.

Mainframe version of DB2 has been in the market for eternity,.

What do you dislike?

Very few upgrades over the years, usually upgrades are not backward compatible. Deployment usually results in large validation cycles and have resulted in rollbacks causing disruptions.

Performances is average, and doesn't leverage many of the advances in technologies.

Database Management tool set is primitive

Product Documentation is not at par with any of competitor.

Getting support from IBM is a nightmare.

Getting Right set of developers with experience in IBM DB2 is difficult

Recommendations to others considering the product

There are many better systems available in the market

What business problems are you solving with the product? What benefits have you realized?

Its an Enterprise DB with out bells and whistles. It was one of the better Database System decades ago. Currently organizations are trying to see how we can move away from it.

Db2 review by Alok M.
Alok M.
Validated Reviewer
Verified Current User
Review Source

"The database management system "

What do you like best?

The core engine of db2 is the best I have experienced .

The features I love :

1> BLU Acceleration

2> Index Jump scan

3> Adaptive Compression

What do you dislike?

I particularly looking for good GUI tool to ease of managing the db2 database farm .

For example : OEM for Oracle .

I am versed with SQL server , Teradata and Oracle too. Hence i can particularly compare the tolls available for each of the database engine .

With that knowledge I suggest IBM to invest more to develop GUI tools.

Recommendations to others considering the product

I would highly recommend other to evaluate DB2 before making a decision for a new application database.

What business problems are you solving with the product? What benefits have you realized?

My client hosts many of the mission critical application databases on db2 servers

Db2 review by Prashansa K.
Prashansa K.
Validated Reviewer
Verified Current User
Review Source

"DB2 Application developer"

What do you like best?

Performance while retrieving the data .

Security of the data .

Compatible with complex data models.

What do you dislike?

Granting permissions .

Settingup up roles for the security.

Administation of require specialized skills.

Not compatible with the Cloud applications.

Recommendations to others considering the product

If data need to be stored secure then DB2 is the best option.

What business problems are you solving with the product? What benefits have you realized?

Storing normalized data in the data model.

Retrieval of the data using the batch programs realtime.

Db2 review by Miguel A.
Miguel A.
Validated Reviewer
Review Source

"Experiencia laboral"

What do you like best?

Me gusta lo facil qué es de implementar y acoplar a otras tecnologias.

What do you dislike?

Lo lento y pesado qué es, ademas de su falta de una herramienta qué lo administre de forma eficaz y no basado en eclipse

Recommendations to others considering the product

En mi empresa se esta realizando la migracion a Oracle, asique no lo recomendaria porque no es una tecnologia actual

What business problems are you solving with the product? What benefits have you realized?

Todo el sistema de bases de datos montado en la administracion publica es de db2, tiene beneficial Como su fiabilidad en cuanto a caidas del sistema

Db2 review by Consultant
Consultant
Validated Reviewer
Review Source

"DB2 since 1992"

What do you like best?

DB2 posee monitor gráfico el cual posibilita observar el tiempo de ejecución de una sentencia SQL y corregir detalles para aumentar el rendimiento.

Permite gestionar tanto datos relacionales convencionales como datos XML, sin necesidad de que tengan que ser transformados, esta capacidad es única en el mercado.

What do you dislike?

Lentitud crear y ejecutar consultas.

Utiliza mucho la memoria RAM para las instalaciones y utilización de software.

DB2 posee un elevado costo económico en licencias personales.

Recommendations to others considering the product

Es sin duda una de las mejores databases

What business problems are you solving with the product? What benefits have you realized?

Permite agilizar el tiempo de respuestas de una consulta

Recuperación utilizando accesos de sólo índices.

Predicados correlacionados.

Posee tablas de resumen, tablas replicadas, uniones hash y utiliza una combinación de seguridad externa y control interno de acceso a proteger datos.

Db2 review by Awwad A.
Awwad A.
Validated Reviewer
Review Source

"the magic of database management"

What do you like best?

as it is internationally known, IBM always woks to provide what it might be in need for future and definitely IBM is speed up.

What do you dislike?

the tool is not easy to learn at all, but practice are the key.

Recommendations to others considering the product

i can recomneded to other unless i see they are in need to tool to use for their business solution. but if they are in situation to analysis a data, the DB2 is the tool.

What business problems are you solving with the product? What benefits have you realized?

first having the data and storing them and analyze them in the way the situation needs to, which this is great tool and save time.

Db2 review by User
User
Validated Reviewer
Review Source

"IBM DB2 'was' good"

What do you like best?

IBM DB2 is a fast database manager that allows multi-platform integration. It has a massive scalability, as well as a continuous availability in case any issue arise. Trust is what it offers.

What do you dislike?

It is becoming an outdated technology, as most of the IBM techs.

Recommendations to others considering the product

Fast and scalable, but there may be better options in the market.

What business problems are you solving with the product? What benefits have you realized?

I am working with an AS400, which has DB2 integrated. The problems solved are the integration with multiple external services through a well documented API.

Db2 review by Joe P.
Joe P.
Validated Reviewer
Verified Current User
Review Source

"IBM i Developer"

What do you like best?

Easy to learn, use and develop in delivering business applications.

What do you dislike?

Lack of marketing by IBM to promote the power systems.

Recommendations to others considering the product

Best platform to run DB2 in on IBM power running i5/OS (AS/400) operating system.

What business problems are you solving with the product? What benefits have you realized?

We build custom licensing and permitting applications using free-form RPG running on an IBM i power server. Rock-solid security 2nd to none.

Db2 review by David W.
David W.
Validated Reviewer
Review Source

"Still the best for large scale data"

What do you like best?

Best at handling large databases that have thousands of transactions per day; very stable and reliable; allows for large user base.

What do you dislike?

would like to see it easier to switch between character sets (such as EBCDIC to Unicode); additional query building tools would be nice to have

Recommendations to others considering the product

Still the best performance for large scale data; have not seen other products that even come close

What business problems are you solving with the product? What benefits have you realized?

Storage of large volumes of data; access of large volumes of data at fast speeds; very high availablility; supports large number of users accessing data

Db2 review by Josh R.
Josh R.
Validated Reviewer
Verified Current User
Review Source

"Solid Database program"

What do you like best?

It is easy to use and it makes sense when querying the data

What do you dislike?

Nothing really that I can think of. It is responsive and works

Recommendations to others considering the product

Go for it, a good Database program

What business problems are you solving with the product? What benefits have you realized?

We use it for our core software and when pulling reports from it, it is responsive and

Db2 review by Alex T.
Alex T.
Validated Reviewer
Verified Current User
Review Source

"DB2 on the mainframe"

What do you like best?

I like the stability of the platform and the familiarity.

What do you dislike?

The query tools provided with the software have not improved over time.

What business problems are you solving with the product? What benefits have you realized?

This is the database that is used by our payroll software. We have benefitted from the stability and processing throughput that the platform provides.

Db2 review by Nitin M.
Nitin M.
Validated Reviewer
Review Source

"I would prefer it least among all databases"

What do you like best?

Easy to install and deploy with tonns of red books and white paper available on net. It is cheaper as compared to Oracle.

What do you dislike?

It's hard to find good DB2 DBA's quickly. There are lot of great as well as less efficient monitoring tools in DB2 but no where it is mentioned which one is recommended by IBM

What business problems are you solving with the product? What benefits have you realized?

We have created a DB2 datamart for claims inventory instead of Oracle datamart which is quicker.

Db2 review by Sandeep N.
Sandeep N.
Validated Reviewer
Review Source

"Very comparable to SQL Server but not the best "

What do you like best?

In my opinion Oracle is the best. It supports the most programming languages and has the best features. Db2 is the next best thing. It’s useful across all ibm host environments. Companies with an ibm mainframe often use db2.

What do you dislike?

It does t have map reductio pin or immediate consistency like sql and oracle do.

What business problems are you solving with the product? What benefits have you realized?

Don’t have any problems other than small integration issues which would persist on all databases

Db2 review by User in Insurance
User in Insurance
Validated Reviewer
Verified Current User
Review Source

"DB2 Driver"

What do you like best?

Allowed me to create a DB2 connections so I could connect SAS directly to the DB2 server and extract data to analyse instead of pulling the data from alternate sources and importing to SAS.

What do you dislike?

It took a while to figure out how to set up the connection and get it working. Especially using a work computer requiring local admin to get it working.

Recommendations to others considering the product

Someone with technical experience and technical problem solving is required to figure out how to use the program. Instructions were spotty and were lacking in some places and slight version differences.

What business problems are you solving with the product? What benefits have you realized?

Allowed a stream lined solution to my data analysis needs by allowing DB2 connections directly in my SAS program.

Db2 review by Ember C.
Ember C.
Validated Reviewer
Verified Current User
Review Source
Business partner of the vendor or vendor's competitor, not included in G2 Crowd scores.

"DB2 - the stable and scalable choice"

What do you like best?

DB2 works logically no matter which edition you choose. Express-c and express work the same as the more expensive editions, and it is not hard for an expert to figure out which edition works well in a given situation.

The user community around DB2 is both robust and friendly. Consultants readily share their expertise and mentor more junior DBAs. Blogs, developerWorks, and forums all provide places to share content and ask questions.

IBM shares the details of how features are implemented and the logic behind new features. A wealth of information is available about each new release.

DB2 is stable on a variety of platforms. Implementing maintenance, recovery strategies, and high availability strategies is straight-forward and the options are well-documented.

DB2 product documentation is robust, and once you understand the structure, not hard to use.

DB2 DBAs are not as expensive as some other RDBMS DBAs.

What do you dislike?

Coming up with something that I dislike about DB2 is difficult. May of the things I might dislike are worse with other providers in my experience. Interacting with IBM support is frustrating for an experienced DB2 DBA, but not as bad for a newer DBA.

What business problems are you solving with the product? What benefits have you realized?

I have helped clients use DB2 in a vast array of environments - from the free DB2 Express-C all the way up to all the bells and whistles in Advanced Enterprise Edition. At all levels, DB2 is full-featured and any options that require separate licensing are easy to identify.

I particularly like DB2's High Availability solutions - particularly HADR is easy to use and work with. The cost of implementing it is low, and it doesn't require extensive expertise to set up and support.

I also have enjoyed working with BLU - setting up very high-speed analytics for small data warehouses is simple with BLU and the results are excellent.

Db2 review by Kristen L.
Kristen L.
Validated Reviewer
Review Source

"Look no further if you are conerned about maintenance costs"

What do you like best?

IBM DB2 is easy to install and is cheaper compared to its competitors such as Oracle. Hardware upgrade is also cheaper.

What do you dislike?

Very difficult to find professional experts for IBM DB2. Efficiency monitoring could be made better.

Recommendations to others considering the product

Give personal recommendations to customers regarding the best management tools to use with DB2.

What business problems are you solving with the product? What benefits have you realized?

Once a DB2 environment is set-up and ready to use, it's very cheap to manage with minimal licensing & support cost.

Db2 review by Asha S.
Asha S.
Validated Reviewer
Verified Current User
Review Source

"Best Database Management Software Bundle"

What do you like best?

It's highly reliable, scalable and provide for the best reliability that business currently need. Normalization capabilities are built in with makes it much easier to get the task on hand completed without having to spent time on normalizing data or fields.

What do you dislike?

It would be nice to have it enabled with multiple web tools to make it easier to manage.

Recommendations to others considering the product

Its simple, easy to use and powerful database management software package that has all the required tools right out of the box.

What business problems are you solving with the product? What benefits have you realized?

It provides for configuring storage while improving efficiency and performance

Db2 review by Consultant in Information Technology and Services
Consultant in Information Technology and Services
Validated Reviewer
Review Source

"DB2 the DataBase"

What do you like best?

DB2 Database is the best for enterprise wise with optimised performance as well as low cost.

What do you dislike?

Till now what I found most is the DB2 Database Administrators are very less as compare to other DBs, besides I can say the support and the quality is very good of DB2 DB.

Recommendations to others considering the product

The excellent DB for compression to manage the huge DB size with in-memory feature with easy to install, configure, use with low cost and low administration , I highly recommend one to use DB in the landscape

What business problems are you solving with the product? What benefits have you realized?

Enterprise wise best suit to business with low cost, low maintenance with improved transnational db queries to fulfil the business requirement on frequent basis.

Db2 review by Andrea M.
Andrea M.
Validated Reviewer
Review Source

"The most used in integration from Java to Mainframe"

What do you like best?

I like the stability of the database and the performance

What do you dislike?

I dislike the db2 control centre program that it's used to manipulate it.

Recommendations to others considering the product

You can use it on local, instead of Oracle that it's very loud, but Oracle is more simple in using and you can easily create stored procedures.

What business problems are you solving with the product? What benefits have you realized?

I worked with DB2 on a mainframe system like a point of exchange from java to mainframe cobol system

Db2 review by Administrator in Construction
Administrator in Construction
Validated Reviewer
Verified Current User
Review Source

"Db2 webquery"

What do you like best?

I like how it looks and feels. It also has a direct relationship with our as400

What do you dislike?

A little difficult to get working correctly. We had to contract out to get the reports we need created

Recommendations to others considering the product

Make sure you either have a good relationship with your IBM vendor or hire a database guy

What business problems are you solving with the product? What benefits have you realized?

It provides us with business reporting.

Db2 review by Administrator in Machinery
Administrator in Machinery
Validated Reviewer
Verified Current User
Review Source

"Solid Speed - Various Software Accessible"

What do you like best?

AS400 and Windows Server 2012 Interegration

Standard Layouts cross platforms

Standard SQL access

What do you dislike?

Learning cirve is a bit long if you are unfamiliar with databases

Recommendations to others considering the product

Remwmber that some of the standard SQL statements are alightly different.

Works well with ASP.net however if you utilize remember the naming conventions from AS400 differ from standard DB2.

What business problems are you solving with the product? What benefits have you realized?

IntrNet data warehousing

Cross platfoem access amont several country locations

Db2 review by Consultant in Computer Software
Consultant in Computer Software
Validated Reviewer
Review Source

"DB2 Review "

What do you like best?

DB2 is a very performant database system. I've used it on mainframes mostly which has it's own set of idiosyncrasies compared to a normal server version. It stores data quickly and uses a very standard set of SQL unlike Oracle who has tried to get everyone on their version SQL forever.

What do you dislike?

It's old, which in a lot of cases makes it preferred, especially in DB's, you want all of the bugs worked out. In this case though, it's behind the times on a lot of newer features. It's only for enterprise customers, there is no way to work it into a small budget company's app. There is no auto sequence for id's, you have to query some sequence table and put it in the id column, you could use a trigger I guess but it could easily be done for you like oracle or others.

Recommendations to others considering the product

Build a set of utilities in your app to handle commonly used tasks, it will speed up further development.

What business problems are you solving with the product? What benefits have you realized?

Used to store data on a mainframe for a bunch of internal app. Very big metal operation.

Db2 review by User in Automotive
User in Automotive
Validated Reviewer
Review Source

"Multii Platform Support"

What do you like best?

DB2's key feature is that it can run on multiple platforms which is great in an environment overflowing with AIX, HP-UX, and Linux platforms. The fact it comes bundled with an OS saves the admin a lot of setup time since performance is already optimized. Self tuning memory management is like autopilot for our DBA to allocate memory in the right places, tuning our small db for the best performance.

What do you dislike?

When partitioning a table space, difficulty arises in updating indexes. You must delete a row and insert it with new values. Key values must be known and defined ahead of time as once they are committed, you can not roll them back. DB2's language is not as robust as Oracle.

Recommendations to others considering the product

Somewhat outdated, Oracle SQL Server is the new corporate standard.

What business problems are you solving with the product? What benefits have you realized?

Invoicing details overseas. Great for loading on a low resource machine and tailoring processes to run overnight.

Db2 review by User in Consumer Electronics
User in Consumer Electronics
Validated Reviewer
Review Source

"DB2 Review"

What do you like best?

Really strong DB engine and most probably one of the big 3... stable version running on Linux family can put some comfort in the organization using it.

What do you dislike?

Windows versions or if you pretend to get away of the major standard implementations and best practices you can still do it but not recommended to avoid a lot of scripting...

Recommendations to others considering the product

Define clearly evaluation criteria when choosing a strategic DB engine.

What business problems are you solving with the product? What benefits have you realized?

Not necessarily problems were resolved but the stability and performance were pretty good and what expected. From previous old version until now IBM has done a very good job!

Db2 review by Abby B.
Abby B.
Validated Reviewer
Review Source

"From a user of DB2"

What do you like best?

The DBA's at my organization have just recently begun to implement data solutions for lower environments (Dev, QA) using IBM Optim. It seems to be working well for us so far.

What do you dislike?

We have ongoing scaling issues and performance issues that are difficult to track down. Like most organizations, we feel stuck with our relational database solution of DB2 beacause of the effort to switch to a different database platform would be tremendous.

The user tools (query editor, basic maintenance) provided with DB2 don't seem to be as good as something like SQL Server. It's also extremely difficult to find 3rd party tools and utilities that work with DB2.

Recommendations to others considering the product

Make sure someone in your organization has extensive experience with DB2.

What business problems are you solving with the product? What benefits have you realized?

DB2 is used for nearly all of our organization's relational database needs. The DBA's maintain hundreds of DB2 databases. My group maintains many applications build on top of and interacting with DB2 databases.

Db2 review by Consultant in Non-Profit Organization Management
Consultant in Non-Profit Organization Management
Validated Reviewer
Review Source

"Love DB2"

What do you like best?

It is low maintenance and great for our SAP landscape.

What do you dislike?

Not many programmers around that can understand that the language.

What business problems are you solving with the product? What benefits have you realized?

It's best for use in a BW landscape for reporting purposes where you need fast data fetching. As compared to other traditional DBs, I feel DB2 is lightweight and less complicated.

Db2 review by Sanketh D.
Sanketh D.
Validated Reviewer
Verified Current User
Review Source

"Amazing Experience"

What do you like best?

When I have installed DB2 server, It has very easy to understand and very much comfortable to use, Overall it is an amazing experience which made me to learn everything much faster.

What do you dislike?

The thing is that, Db2 is hard to say dislike. It is liked by all and yes, it is easy to use without any difficulty. Overall, no dislikes.

Recommendations to others considering the product

Everything is comfortable in this, so I recommend all to learn this.

What business problems are you solving with the product? What benefits have you realized?

I used the very basic features of DB2 as it is a part of my assignment.

Db2 review by John S.
John S.
Validated Reviewer
Review Source

"Not the best option "

What do you like best?

I can't find anything I enjoy about this rdbms.

What do you dislike?

There is alot I dislike; slow, missing alot of functionality which makes it impossible to do dev work, very outdated.

Recommendations to others considering the product

Stay away.

What business problems are you solving with the product? What benefits have you realized?

Usually can't solved complex business problems with db2. Something that takes me a few lines to write in mssql takes hundreds in db2.

Db2 review by Dustin W.
Dustin W.
Validated Reviewer
Review Source
Business partner of the vendor or vendor's competitor, not included in G2 Crowd scores.

"Sensible choice for use in an all IBM solution and BLU Acceleration is worth a POC effort."

What do you like best?

The strong integration between the IBM product stack and DB2 is probably DB2's best feature. However, there needs to be a distinction between the various types of DB2 that run on i Series, z/OS, and other general Linux/Windows platforms. Knowing what platform DB2 will be running on doesn't make or break DB2 as a good RBDMS, but it does determine what features are available to the developer/DBA using the RDBMS. For example, IBM released BLU Acceleration for DB2, but it not available for DB2 running on i Series.

What do you dislike?

I find the user interface known as Data Studio to be inferior to the development and management studios offered as part of other RDBMS software (SQL Developer for Oracle and Management Studio for SQL Server).

Recommendations to others considering the product

If you are a DB2 shop, then there are no worries. However, switching to DB2 is not an easy task and I recommend making sure upgrading your current RDBMS to see if it can meet your needs.

What business problems are you solving with the product? What benefits have you realized?

I have used DB2 with BLU Acceleration as the background database software supporting a large business intelligence implementation. This implementation had DB2 running on RHEL and hosting the business intelligence application database and the data warehouse.

Db2 review by Josh E.
Josh E.
Validated Reviewer
Review Source

"Rock solid Database"

What do you like best?

pureScale and SQL arrays as far as the newer features of DB2 go. That and how long it's been apart of the IT community and the endless resources available to you for whatever issue comes your way. Better performance, HADR support, cloud support. IBM has done an excellent job in keeping up with the times and then some.

What do you dislike?

This the closest I could come to a "dislike". But the semi-steep learning curve, at least for younger professionals. But once you bypass that hurdle, you're in good hands.

Recommendations to others considering the product

I would recommend DB2 based on it's performance, community, and the company behind it continually improving it, to stay in the game.

What business problems are you solving with the product? What benefits have you realized?

When a project was moving to a much larger infrastructure, it was moved from SQL Server to DB2. The utilities at hand with DB2 didn't restrict us to one OS or writing one-off utils in order to make the migration. And the community around DB2 is top notich.

Db2 review by Kapil J.
Kapil J.
Validated Reviewer
Review Source

"Nice tool"

What do you like best?

DB2 is great and it work nice. I like it better than sql database. Great tool actually and very very easy to learn . if you know any database then this also very easy

What do you dislike?

the inbuilt functions are not that great. There is a lot to improve.

What business problems are you solving with the product? What benefits have you realized?

easy to use tool.

Db2 review by Andrew K.
Andrew K.
Validated Reviewer
Review Source

"Better options"

What do you like best?

The SQL is similar to other SQL languages

What do you dislike?

It's old, has too much boilerplate, isn't as easy as it should be.

Recommendations to others considering the product

Just go to SQL server or MySQL or some type of no SQL database

What business problems are you solving with the product? What benefits have you realized?

We have been able to keep the same databases from the 1900s

Db2 review by Internal Consultant in Food & Beverages
Internal Consultant in Food & Beverages
Validated Reviewer
Review Source

"Ibm Db2"

What do you like best?

run on all available platforms, rather than just Windows-based platforms optimizes performance by making adjustments on the fly to the database memory and buffer pools with no requirement for human intervention

What do you dislike?

It's hard to find good DB2 DBAs quickly for a new project unlike Oracle or SQL-Server DBAs. Up-skilling Oracle DBAs to DB2 is easy

What business problems are you solving with the product? What benefits have you realized?

I have worked almost my entire career as a DB2 LUW Architect & DBA and leading small and big teams of DBAs and DB2 specialists

Db2 review by User in Computer Software
User in Computer Software
Validated Reviewer
Review Source

"Used Db2 for querying the database tables for my work"

What do you like best?

Using DB2 is very easy and quick to learn, if you know the sql commands then its straigh froward here as it follows the same syntax.

What do you dislike?

Till the point of time i used i did not find anything that i dislike

Recommendations to others considering the product

this is a great tool for all your DB requirements

What business problems are you solving with the product? What benefits have you realized?

Used DB2 to search complex database tables for the testing i do, helps me to search for the required data by writing the queries, its very fast and easy to use

Db2 review by Arun S.
Arun S.
Validated Reviewer
Review Source

"Optimized DB tool specific for IBM Products"

What do you like best?

Liked the Sharding concept in this tool as it effectively optimize the bigger applications.

What do you dislike?

Comaparing the usabilty with other competitor DB tools this lacks as its not widely used . And also the in memory is not upto the mark compare to other DB tools

What business problems are you solving with the product? What benefits have you realized?

Ecommerce Application like WCS Sterling etc

Db2 review by Feng C.
Feng C.
Validated Reviewer
Verified Current User
Review Source

"Great product"

What do you like best?

I have been using for for almost 20 years. Started on the mainframe then moved to UNIX. I really like Performance and Stability of this product.

We used to had very serious power issue and a lot of boxes crashed, a couple Oracle server could not come up and there was no issue with db2 crash recovery.

What do you dislike?

I would like db2 on Unix to include something like cold start option and include a native utility to analyze log files.

What business problems are you solving with the product? What benefits have you realized?

We use db2 for OLTP for most tier 1 system. We also use it for data warehouse application.

Db2 review by Administrator in Financial Services
Administrator in Financial Services
Validated Reviewer
Verified Current User
Review Source

"Solid product"

What do you like best?

The stability provided by this IBM product cannot be matched, which is evidenced by how long the product has been in use.

What do you dislike?

The pack of innovation within the app is a definate point of frustration.

What business problems are you solving with the product? What benefits have you realized?

Database management has been made significantly more effienct due to our use of DB2

Db2 review by Jim C.
Jim C.
Validated Reviewer
Review Source

"DB2 is a truly great relational Database management package "

What do you like best?

DB2 is not only robust but is able to handle large volumes of data typically found in large corporations. My experience with DB2 is mainly on the IBM Mainframe and it has always met or exceeded expectations when it came to ease of use, functionality, processing power and educational material provided on the internet

What do you dislike?

There isn't much a dislike other than they should consider having easier catalog viewing access than having to know all of the system tables.

Recommendations to others considering the product

Many redbooks and other materials to read to gain further knowledge of the product

What business problems are you solving with the product? What benefits have you realized?

I have been part of large scale conversions of other data bases to DB2 to take advantage of processing power, size and overall scalability. Each company realized immediate benefits as IBM has built their hardware to work with DB2 since they own both

Db2 review by Administrator
Administrator
Validated Reviewer
Review Source

"IBM always trustworthy and a stable DB experience "

What do you like best?

IBM's quality has stayed with them since they beginning. Not always the most beautiful looking GUI's or platform, its functionality is unrivaled.

What do you dislike?

Ease of causing errors or shutting down systems due to incorrect key strokes. But this is what builds a strong IT technician, making sure not overlook important details.

Recommendations to others considering the product

Its costly if your switching over or implementing, but IBM products are always a benefit.

What business problems are you solving with the product? What benefits have you realized?

Having a Database that can run small to large firms. Solidity and trsutworthiness.

Db2 review by Shaifali G.
Shaifali G.
Validated Reviewer
Review Source

"DB2"

What do you like best?

Its improved performance to fetch data and availability for newer data call handling. The single table view that it provides and on demand supply of stored procedures.

What do you dislike?

DB2 automation tool does not works simply which was promising simplied automation. It does not directly unloads from flash memory which takes time for copy to copy sequential process.

Its longer recovery time.

Recommendations to others considering the product

Use this tool for frequent large webapplication requiring robust data base setup.

What business problems are you solving with the product? What benefits have you realized?

Saving data for WebApplications handling large number of tables and thier communication.

Db2 review by Executive Sponsor in Banking
Executive Sponsor in Banking
Validated Reviewer
Review Source

"it is a very stable easy to use product"

What do you like best?

it comes bundled with the machine without a additional cost. it supports multiple applications, creating multiple data bases. it can handle large volumes of data without much performane degradation

What do you dislike?

There are times it gives object locks during some operation though mode we use should not create object locks. There are times we need expert knowledge to solve performance issues

Recommendations to others considering the product

it is a very good product

What business problems are you solving with the product? What benefits have you realized?

we use for providing banking services. we are running banking system smoothly supporting 10 million customers

Db2 review by User
User
Validated Reviewer
Review Source

"Extremely reliable and fast"

What do you like best?

I like how reliable and quick our DB2 tables are. We use WinSQL to display and manage our DB2 tables and they are nothing short of fantastic.

What do you dislike?

I do not dislike anything about our DB2 tables.

Recommendations to others considering the product

Nothing to worry about -- DB2 tables are the best you can get.

What business problems are you solving with the product? What benefits have you realized?

We are solving the issue of enterprise scaling. Our DB2 tables allow us to have a massive scale for data, which is critically important for my global company.

Db2 review by Consultant in Information Technology and Services
Consultant in Information Technology and Services
Validated Reviewer
Review Source

"DB2 for java applications with websphere"

What do you like best?

The stability offered is good. It is extensible and interacts well with the other related IBM software.

There asre some things like paging and table spaces which are non intutive and can be improved.

What do you dislike?

not much information/articles available on errors on the IBM website.The most improvement can be done in adding all SQL codes and SQL errors and adding detailed steps on how to fix the errors

Recommendations to others considering the product

there might be issues with connection pooling when used in combination with websphere

What business problems are you solving with the product? What benefits have you realized?

It works for us where the user base for the applications is not massive. Providing the much needed extensiblity and flexibility

Db2 review by Jay P.
Jay P.
Validated Reviewer
Review Source

"Best database for economic usage"

What do you like best?

I loved the database version which is light version and easy to use

What do you dislike?

Pretty ugly when it comes to using the database language

What business problems are you solving with the product? What benefits have you realized?

We used the whole database over tables and made the whole architecture over IBM db2

Db2 review by Administrator
Administrator
Validated Reviewer
Review Source

"Good database supported by multiple operating systems"

What do you like best?

It is a strong database that doesn't fail a lot. SQL queries and standard sql tools

What do you dislike?

I didn't try all the options it has but I like what I tried

Recommendations to others considering the product

It is a Strong database and depending on the Operating system, you will have a strong system where you can store all your important data.

What business problems are you solving with the product? What benefits have you realized?

Our core data was stored in DB2 and we hadn't problems by the time we used it

Db2 review by Kenya M.
Kenya M.
Validated Reviewer
Review Source

"Meh"

What do you like best?

Db2 database is painful to use but it works

What do you dislike?

The interface, the not so user friendly tools available to customize clients

Recommendations to others considering the product

Please make sure you have the right client

What business problems are you solving with the product? What benefits have you realized?

Our entire system is db2

Db2 review by User in Information Technology and Services
User in Information Technology and Services
Validated Reviewer
Review Source

"Versatile database"

What do you like best?

Db2 comes from IBM Mainframes background which is a well known industry name and considering the fact that it's been around for decades, there is absolutely no question on its credibility. I have used DB2 on Z OS as well as Windows and it works without any issue on both platforms.

What do you dislike?

Really there is not much you do not like on Db2.

What business problems are you solving with the product? What benefits have you realized?

It is a relational database and does what it is supposed to do.

Db2 review by Aravind I.
Aravind I.
Validated Reviewer
Review Source

"db2 luw database "

What do you like best?

the product is easy to administer, the patching and upgrades are easy and simple. Backup and recovery solution is great

What do you dislike?

not aggressive as oracle in implementing new features

What business problems are you solving with the product? What benefits have you realized?

we use db2 dpf for or analytics

Db2 review by Consultant in Information Technology and Services
Consultant in Information Technology and Services
Validated Reviewer
Verified Current User
Review Source

"DB2 developer "

What do you like best?

It’s fast and can handle large amount of data .

What do you dislike?

Not a lot of functions available in DB2 to manipulate the data.

What business problems are you solving with the product? What benefits have you realized?

Pulling data from different sources if easy and store large amount of data .

Db2 review by Visalakshi A.
Visalakshi A.
Validated Reviewer
Review Source

"Best product "

What do you like best?

It is easy to learn and use the product

What do you dislike?

I do not see any major disadvantage to dislike the product

Recommendations to others considering the product

Good product

What business problems are you solving with the product? What benefits have you realized?

I am using to store data and create reports out of it

Db2 review by Sandy L.
Sandy L.
Validated Reviewer
Verified Current User
Review Source

"Corporate Director of IT"

What do you like best?

I like the OS behind the database. It is very easy to use.

What do you dislike?

Inflexible database. You cannot add or remove fields without recompiling programs.

Recommendations to others considering the product

There is not a lot of ERP Apparel software out there for this database.

What business problems are you solving with the product? What benefits have you realized?

Business, apparel applications. In house knowledge of the database.

Db2 review by Thilagar T.
Thilagar T.
Validated Reviewer
Review Source

"Awesome"

What do you like best?

The biggest of them is 64-bit addressing that offers virtual storage constraint relief.

Powerful Structure Query Language

Multiple Platform Support

Memory Management

What do you dislike?

Only one table can be defined in a partitioned table space. This is not necessarily a disadvantage because most DBAs follow a one-table-per-table-space rule

Recommendations to others considering the product

Its Good! Go for it

What business problems are you solving with the product? What benefits have you realized?

Choosing the right storage options for XML data

Configuring the storage options correctly is important for maximizing the performance

of a DB2 database. In this section, we discuss the type of table space for the database, the

page size for the XML data stored in the database and the method of storing the XML

data in the database

Db2 review by Consultant
Consultant
Validated Reviewer
Verified Current User
Review Source

"Stable and fast"

What do you like best?

Administration and speed of queries far exceeds expectations

What do you dislike?

Ability to export query results is a bit cumbersome.

What business problems are you solving with the product? What benefits have you realized?

Backend database for enterprise system.benefits involve reliable data management and stability

Db2 review by User in Banking
User in Banking
Validated Reviewer
Review Source

"Good db"

What do you like best?

I like the speed and the functionality of it. We use db2 on both the mainframe and server environment. We have a data warehousing appliance that runs db2.

What do you dislike?

I dont dislike anything about this product. It is easy to learn and try transition from a different flavor of sql.

What business problems are you solving with the product? What benefits have you realized?

Data warehousing, we also use db2 to store money transactions because it is so fast.

Db2 review by Rohan S.
Rohan S.
Validated Reviewer
Review Source

"Great tool. "

What do you like best?

fast number crunching machine . the ease of use and robustness

What do you dislike?

the customizations that most companies do make upgrades near impossible .

What business problems are you solving with the product? What benefits have you realized?

everything from indexing to querying to lobbying

Db2 review by Administrator in Government Administration
Administrator in Government Administration
Validated Reviewer
Review Source

"DB2 on z/OS for SAP "

What do you like best?

We have over 75 SAP systems running on DB2 for z/OS. DB2 never crashes, the IBM tools for maintenance are acceptable, and scalability and availability are unmatched.

What do you dislike?

My main dislike is there is not 3270 GUI emulator. You have to know how to navigate on a mainframe to support DB2 for z/OS, and that skill is hard to find these days.

Recommendations to others considering the product

Just give it a try...specifically versus Oracle.

What business problems are you solving with the product? What benefits have you realized?

We need a database to run out ERP system. We already had onsite expertise and DB2 met all the requirements. The biggest benefits ante availability and scalability.

Db2 review by Proby P.
Proby P.
Validated Reviewer
Review Source

"Fast database and great compatibility and integration "

What do you like best?

Fast database and great compatibility and integration. Backup and recovery features are good too

What do you dislike?

Used for specific types of DBs, Oracle and SQL still the flagship products and main competitors

Recommendations to others considering the product

Use the product daily and research use cases for it.

What business problems are you solving with the product? What benefits have you realized?

Analytics, CRM, SCM

Db2 review by Matthew B.
Matthew B.
Validated Reviewer
Review Source

"Robust and easy to use"

What do you like best?

The ability to link tables via SQL and join tables

What do you dislike?

I don't like anything yet at the time of writing this review.

What business problems are you solving with the product? What benefits have you realized?

Link to various internal apps

Db2 review by User in Computer Software
User in Computer Software
Validated Reviewer
Review Source

"Best database till date. By IBM"

What do you like best?

It has different sysntax than other database .

But it has faster loader data.

Best sequrity data.easy to install drivers.

We can handle large anout of data for our Wearhouse.

What do you dislike?

Sometimes it is hard to configure the situation.

Lack in community support,missing distribute system support and monitoring tools

Recommendations to others considering the product

Yes

What business problems are you solving with the product? What benefits have you realized?

Daily transaction ,handling multiple transaction in single go,the optimization is best.

Db2 review by Internal Consultant in Information Technology and Services
Internal Consultant in Information Technology and Services
Validated Reviewer
Review Source

"Yes! My favourite DB!"

What do you like best?

Oh man, I got bored of mysql and this was a brand new light to our lifes.

This made our work way easier with our data bases. The graphs are gold.

What do you dislike?

Xml over Json.. ew

What else can i say, would be much easier to implement that

Recommendations to others considering the product

Keep it up guys, get the json!

What business problems are you solving with the product? What benefits have you realized?

Banking and websites, but mostly banking.

Db2 review by Jane S.
Jane S.
Validated Reviewer
Review Source

"Reliable"

What do you like best?

enterprise solution - large business, large complex data, IBM hs a solution for it all

What do you dislike?

slow to make dramatic changes and inovation

What business problems are you solving with the product? What benefits have you realized?

websites / ai/ social media integration/ personaliation

Db2 review by Amit P.
Amit P.
Validated Reviewer
Review Source

"DB2 Database Distributed platform"

What do you like best?

Very stable database. Reliable database. Works well.

What do you dislike?

Little bit heavy. No light weight desktop version for development version.

What business problems are you solving with the product? What benefits have you realized?

Used for business application development and data storage.

Db2 review by User in Sports
User in Sports
Validated Reviewer
Review Source

"Not bad!"

What do you like best?

For making queries I enjoyed it. It is able to build off different types for searches and storing data.

What do you dislike?

There isn't much for me to complain about in all honesty.

Recommendations to others considering the product

Improvise with what you are using this for. I knew someone who did something like this for ethnography

What business problems are you solving with the product? What benefits have you realized?

Data searching. Building the database is easier and optimal for finding words or items when searching.

Db2 review by Consultant in Information Technology and Services
Consultant in Information Technology and Services
Validated Reviewer
Review Source

"DB2 is a crap"

What do you like best?

I do not like anything in DB2. But why we use is because it integrates well with other IBM products like FileNet and also IBM bundles it.

What do you dislike?

It’s not flexible and also very limited tools are available running queries or accessing programmatically

Recommendations to others considering the product

Do not consider this unless you don’t have any other option

What business problems are you solving with the product? What benefits have you realized?

It is for storing metadata of our content management software.

Db2 review by Arti G.
Arti G.
Validated Reviewer
Review Source

"Broad use"

What do you like best?

The multiple areas of our division we are able to cover

What do you dislike?

I don’t think there is anything I dislike

What business problems are you solving with the product? What benefits have you realized?

Day to day

Db2 review by Sudhir J.
Sudhir J.
Validated Reviewer
Review Source

"Software developer"

What do you like best?

Very robust and great for transaction processing.

What do you dislike?

Need more functions for BI and data warehousing.

What business problems are you solving with the product? What benefits have you realized?

Filing Customs documents for clients, billing, and reporting

Db2 review by keith G.
keith G.
Validated Reviewer
Review Source

"Stable Database"

What do you like best?

I've worked with this software for thirty years.

What do you dislike?

The DB2 software great for inventory and financial applications..

Recommendations to others considering the product

Very favorable

What business problems are you solving with the product? What benefits have you realized?

Inventories and financial

Db2 review by Vikram S.
Vikram S.
Validated Reviewer
Review Source

"Maintenance "

What do you like best?

Security and reliability are the features that I like the most

What do you dislike?

Configuration takes time and some times complex

What business problems are you solving with the product? What benefits have you realized?

Multi threading and security

Db2 review by User
User
Validated Reviewer
Review Source

"Its good basically IBM db is very good for transaction use case...we have been using it for long tim"

What do you like best?

It is a robust and fully tested technology. Very reliable for any volume of data. Preferably the transactional ones.

What do you dislike?

Not good for big data.. Many commands and references of very nebulous errors. It requires a lot of computing power...

What business problems are you solving with the product? What benefits have you realized?

Transactions are very well handled by db2 ...all our transactions are handled by db2 DB

Db2 review by Mark A. M.
Mark A. M.
Validated Reviewer
Review Source

"Strong and Stable"

What do you like best?

Reliable and stable. High level of uptime.

What do you dislike?

Slower and fewer advanced features than Oracle.

Recommendations to others considering the product

None

What business problems are you solving with the product? What benefits have you realized?

Over 10 years of reliable data storage.

Db2 review by User in Information Technology and Services
User in Information Technology and Services
Validated Reviewer
Verified Current User
Review Source

"software engineer"

What do you like best?

Robust in features, seamless integration. Fairly easy to learn to use.

What do you dislike?

Can be buggy at times and there is a learning curve coming from other, similar products.

What business problems are you solving with the product? What benefits have you realized?

Solved overall database management problems. Were disordered before but now dbs are organized and much more manageable.

Db2 review by Anton M.
Anton M.
Validated Reviewer
Review Source

"High-end database"

What do you like best?

We had to cover IBM db2 as we were making a platform independent content management system for our high end customers. I had no problem porting the sql server and oracle database data and store procedures to db2. And I have heard v11 is really big on big data now.

What do you dislike?

I think it lacked a bit on user interface usability at the time.

What business problems are you solving with the product? What benefits have you realized?

This would be one of the systems to consider when needing a high performance database.

Db2 review by Jake P.
Jake P.
Validated Reviewer
Review Source

"Strong database"

What do you like best?

I like the ease of using the index adviser to tune your queries, using database specific functions like TRIM(), INT(), DIGITS, and others.

What do you dislike?

No Pivots, Fixed width fields (Even when declared as varchar), NULL characters (Due to EBCDIC encoding), EBCDIC encoding, ALL available editors, even their studio although better, still uses fixed width lines for text.

Recommendations to others considering the product

just know your requirements there are some things db2 does great other things not so much.

What business problems are you solving with the product? What benefits have you realized?

Building enterprise applications through web interfaces.

Db2 review by Pragya B.
Pragya B.
Validated Reviewer
Review Source

"IBM DB2 "

What do you like best?

Data accessibility of different tables is great

What do you dislike?

It’s an outdated software, writing codes was cumbersome

What business problems are you solving with the product? What benefits have you realized?

Developing new software requirements

Db2 review by Mark B.
Mark B.
Validated Reviewer
Review Source
Business partner of the vendor or vendor's competitor, not included in G2 Crowd scores.

"A DB2 Review"

What do you like best?

I like the fact that DB2 is a dependable, "well-seasoned" database management system from IBM.

I know that if ever I need additional DB2 information that the IBM Support representatives are ready with answers.

What do you dislike?

I think that the initial DB2 setup and definition process is a bit more involved than I would prefer.

What business problems are you solving with the product? What benefits have you realized?

Our mainframe financial application suite of products runs very well with IBM DB2, the application performance is fast and the overall system is extremely reliable.

Db2 review by Murali Manohar Sai C.
Murali Manohar Sai C.
Validated Reviewer
Review Source

"Simple Authentic RDMS which offers nothing less than Oracle "

What do you like best?

It's easy to learn nice and simple English terminology compared to any other rdbms, Dont need worry about architecture and stuff when u jump in as a new bie, all products features are offered free to test for 90 days, monitoring to adjusting as per requirements are taken care by db2 engine

What do you dislike?

I don't any such with db2 database management system

Recommendations to others considering the product

I recommend to try the product for a ease of use from setup to maintenence

What business problems are you solving with the product? What benefits have you realized?

Warehousing, Analytics, OLTP

Db2 review by Administrator in Financial Services
Administrator in Financial Services
Validated Reviewer
Verified Current User
Review Source

"may be biased but do love it"

What do you like best?

easy to use on all aspects.

but I may be biased as db2 has been the major rice maker for me for more than 10 years.

What do you dislike?

I would say, it may be better to reformat the db2diag.log. Current format is not easy to look through, though this can be resolved with a little scripting work, but it's not so user friendly per my experience on both IBM and user side.

What business problems are you solving with the product? What benefits have you realized?

db2 is my rice maker...

Db2 review by Executive Sponsor in Food & Beverages
Executive Sponsor in Food & Beverages
Validated Reviewer
Review Source

"Solid database "

What do you like best?

Being on an IBM AS400 server means you can sleep well at night and not have to worry about the server crashing.

What do you dislike?

Not very flexible table structure. Hard to find any more talent.

Recommendations to others considering the product

This system requires little maintenance and patching.

What business problems are you solving with the product? What benefits have you realized?

Our enterprise system runs on DB2, all the transactions we process flow through this server.

Db2 review by Administrator
Administrator
Validated Reviewer
Review Source

"db2 database"

What do you like best?

performance

works as designed, robust and supports online transaction processing and analytical processing.

What do you dislike?

nothing. like the product.

would be good for supporting on all platforms like intel based, other than Linux

Need columanr support to go with industryu demands

Recommendations to others considering the product

make it columnar database too - very good for analytics

What business problems are you solving with the product? What benefits have you realized?

many analytics

Db2 review by User
User
Validated Reviewer
Review Source

"Nice database"

What do you like best?

Easy connection to the database, great scalability and performance

What do you dislike?

At first glance not so easy, but then you get used to it

Recommendations to others considering the product

It's usually easy to spot the errors

What business problems are you solving with the product? What benefits have you realized?

The database we use at work is db2.Fast connection, good input for any errors you might have

Db2 review by User in Information Technology and Services
User in Information Technology and Services
Validated Reviewer
Review Source

"Very Old DB tool"

What do you like best?

Nothing much, pretty much old tool and complex for new user

What do you dislike?

not simpler as compare to other DB available in the market. Need more infrastructure to support

Recommendations to others considering the product

There are better DB application available in the market than this product

What business problems are you solving with the product? What benefits have you realized?

no benefits, Infact we are moving out from DB2

Db2 review by Internal Consultant in Banking
Internal Consultant in Banking
Validated Reviewer
Review Source

"DB2 data modeler, designer and developer"

What do you like best?

Stability and speed of DB2 is remarkable. There are decent number of DB2 personnel in the market so scaling a team is easy.

What do you dislike?

Cost. DB2 is the second costliest RDBMS after Oracle. New DBs are way cheaper.

Recommendations to others considering the product

Evaluate Oracle and nosql solutions too

What business problems are you solving with the product? What benefits have you realized?

Good Response times for operational data

Db2 review by User in Automotive
User in Automotive
Validated Reviewer
Review Source

"Fast Processing Easy To Use"

What do you like best?

DB2 is easy to use and fast in processing

What do you dislike?

New technologies like HP vertica or any other column-based databases are faster.

Recommendations to others considering the product

Try to get column based storage tech incorporated too, or may introduce a new product offering

What business problems are you solving with the product? What benefits have you realized?

Fetching data for preprocessing purposes

Db2 review by Nikhil P.
Nikhil P.
Validated Reviewer
Verified Current User
Review Source
Business partner of the vendor or vendor's competitor, not included in G2 Crowd scores.

"Multiple reporting and backend implementations using DB2"

What do you like best?

- Very user friendly SQL commands

- High performance benefits when architecting a highly relational DB

- Cheaper than Oracle at similar scales

What do you dislike?

- Still does not match the depth and breadth of Oracle's High-Availability capability

Recommendations to others considering the product

Conduct a POC and look at the strengths against Oracle for the specific business scenario you want to use it for

What business problems are you solving with the product? What benefits have you realized?

High -Availability for online reservations application and near-realtime operational reporting

Db2 review by Consultant in Consumer Goods
Consultant in Consumer Goods
Validated Reviewer
Review Source

"DB2 the legacy legacy"

What do you like best?

Calls to database have not changed much in years

What do you dislike?

Dated - does not have tools to support web and monitoring tools

Recommendations to others considering the product

Consider another product with gui, Windows, and support tools

What business problems are you solving with the product? What benefits have you realized?

Calculation of payments using historical data. COBOL is easy to read.

Learn more about Db2

Db2 Videos

Kate from G2 Crowd

Learning about Db2?

I can help.
* We monitor all Db2 reviews to prevent fraudulent reviews and keep review quality high. We do not post reviews by company employees or direct competitors. Validated reviews require the user to submit a screenshot of the product containing their user ID, in order to verify a user is an actual user of the product.
Db2
(142)