Want to see who topped the 2019 Best Software Awards?
Db2

Db2

3.9
(169 reviews)

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 190 Db2 reviews
LinkedIn Connections
Db2 review by Cesar A.
Cesar A.
Validated Reviewer
Verified Current User
Review Source

"Robust and fast database"

What do you like best?

In my experience in using DB2 I can say that this database manager has different facets that helps us to do an effective work of DBA since it is a robust and strong database manager since it has to speed up the response time of this query , recovery using accesses of only indexes. also has the correlated redicated, replicated tables. DB2 uses a combination of external security and internal access control to protect data. One of the outstanding features that can be said about DB2 is that it distributes and remembers the location of each track where the information is located. In the context of a long database, this partition system makes administration much easier to manage than a database of the same nonpartitioned measure.

What do you dislike?

in what I most dislike is its graphical interface that is totally command and with black screen and among other things that I can say in using this handler, It has to do with the applications that have been developed and those that are going to be implemented.

Recommendations to others considering the product

I recommend DB2 to other companies that handle large amounts of data and that have a robust infrastructure, since they will have results of their data management in real time and optimal platform stability.

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

You can perform DB2 administration from any job, DB2 saves your data against loss, unauthorized access, or invalid entries,DB2 provides a set of access data for the interfaces for different types of users and applications.

Sign in to G2 Crowd to see what your connections have to say about Db2
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.

What Relational Databases solution do you use?

Thanks for letting us know!
Db2 review by Alan I.
Alan I.
Validated Reviewer
Review Source

"The best Database but Really bad Advertisement"

What do you like best?

Fot me the best feature of this database , is how lite it is , like any IBM product is almost imposible to put it out of line after gets install so for me as a developer is not another problem to be worried , also is it a diferrent versions of it , Express , full etc , even a linux version , that a very high point in my list.

What do you dislike?

Not everything has to be perfect but my major dislike for this is how dificult it is to install it , is a problem that can take days to get it done , in my first experience wooth this was really dificult to install , and some incompatibiliys with windows servers that where a pretty big problem for me as a junior. Also is very expensive, so not many companies can affort this type of databases

Recommendations to others considering the product

If you can make it easy to install and keep up with the lastest servers and operating system you should be ready to have THE BEST database for 10 years without worrying about anything in its performance

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

Db2 is a really strong database , pretty easy to use and the documentation is a lot of them , most of it is from IBM but another programers make some manuals to help us to work with database also. We make it run over a 2008 servers and works like a charm , this is why we got it

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

"Depending on the version, it can be your best friend or worst enemy"

What do you like best?

DB2 is all about performance and control. We run it on an iSeries AS/400, version 5 revision 4. You get a lot of tools and a lot of in-depth access if you want it, as well as very good performance compared to most engines out there, mainly because, at least on the AS/400, the DB is part of the OS instead of being a ran program. Oh yeah, and the maintenance is amazing.

What do you dislike?

FETCH FIRST 1 ROWS ONLY - instead of LIMIT. 0/1 instead of TRUE/FALSE (again, I am speaking from a v5r4 view). Weird act-ups sometimes, like a SUM containing a division of DECIMAL will return an integer in a SELECT and a DECIMAL in an UPDATE. The constant need for CAST. A DECIMAL(4,2) multiplied by a DECIMAL(4,2) has to be CAST down to a DECIMAL(4,2) manually, each time. Else, overflow.

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

Managing stocks, users, clients, basically everything a medium-sized business needs.

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.

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
Business partner of the vendor or vendor's competitor, not included in G2 Crowd scores.

"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 User in Information Technology and Services
User in Information Technology and Services
Validated Reviewer
Review Source
Business partner of the vendor or vendor's competitor, not included in G2 Crowd scores.

"IBM db 2"

What do you like best?

IBM has been the best for providing services, IBM Db2 was the name introduced by IBM in 2017. The names DB2 and Db2 refer to database-server products developed by IBM. These products all support the relational model, but in recent years, some products have been extended to support object-relational features and non-relational structures like JSON and XML

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 considering the amount of materials and tutorials available in the internet for DB2. So Project teams should look for good RDBMS folks and train them for a new project in DB2 rather than just looking for pure DB2 DBAs which most of the times end-up in frustration. That way more DB2 DBAs will be available and at the same time existing employees and Full-time resources will be motivated to learn a demanding Database Technology.

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

On the Tools part, I contacted IBM Product team on what they are doing currently for new & existing customers on recommending the best Tools. They were very prompt to give me the details about the same and I was pretty much satisfied with their current strategy to address my concern. IBM currently has consolidated the focus on Administration, Management, Monitoring and Tuning onto a single platform called IBM Data Server Manager. This product combines the capabilities of Optim Performance Manager, Optim Configuration Manager and Optim Workload Tuner, and the basic administration included in Data Studio into a single more consumable offering with a much simplified up and running experience, guided workflows and drilldown to detailed views when required. There is a 0 cost DSM Base Edition useful as an entry

point and advanced offering capabilities in DSM Enterprise Edition.

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

"Standards compliant, Feature depraved."

What do you like best?

I like being able to query for table schemas.

What do you dislike?

Clunky dated interface. Slow load times when loading schemas in the DB manager. Not having full control to terminate queries I started. The documentation has little useful information or is confusing. If you are writing ad hoc queries

Recommendations to others considering the product

If you're about to embark into the world of DB2, I would suggest brushing up on ANSI SQL and do not expect any of the nice things you come to expect from platforms like MSSQL. The ability to use on the fly variable declarations when querying gave me some significant heart ache when I first started out. You end up learning ways around it, but in this day and age, I don't feel you should have to.

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

I mostly aggregate data for individual customers across our data warehouse. We display this aggregated data in our customer service applications

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

"Reliable data management with well established provider"

What do you like best?

DB2 offers a lot of performance options that can be tweaked from SAS (Most of my use of DB2 is done through a SAS to DB2 connector).

DB2 BLU is also a great improvement on a somewhat older technology. It really brought the DB2 system up to par with newer versions of competitors.

What do you dislike?

Some of the db2 sql syntax is not really intuitive. Make sure to have documentation available or an access to google for web searches.

Recommendations to others considering the product

Ensure that you have a very good local knowledge if you want to go with IBM world support as it generally means support from India. No real problem or other consideration other than that.

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

Enterprise data warehouse. DB2 has been here for a very long time (20+ years). Having support for most production environment being under the responsibility of IBM, it is more convenient this way.

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

"DB2 un gestor potente"

What do you like best?

Lo que más me gusta de Db2 es su facilidad para agilizar el tiempo de respuestas de una consulta,

muy necesario a la hora de crear nuevas bases de datos y gestión de elementos y de consultar elementos.

Es muy segura y la hora de integrarlo en tu empresa puede ser una opción muy factible desde el punto de

vista de su estabilidad ya que es un gestor de bases de datos muy fiable con un soporte excepcional..

Y la facilidad de importar datos hace que sea una herramienta muy recomendada para guardar datos y gestionarlos en tu empresa.

What do you dislike?

Lo malo de Db2 es que sólo será útil para manejar relativamente pocos datos, utiliza mucho la memoria RAM para las instalaciones y utilización de software.Y su principal problema puede ser el costo, posee un costo elevado para adquirir licencias en muchos equipos. También mencionar que el lenguaje de SQL es algo menos robusto que en otros gestores de datos lo que complica algo su manejo.

Recommendations to others considering the product

Si eres una empresa grande a nivel internacional con gran poder adquisitivo el inconveniente del coto elevado para este gestor de bases de datos no supondrá un impedimiento por que es de total recomendación para la gestión de archivos xml dentro de tu empresa junto con otros tipos de archivo.

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

Gestión de datos de clientes internacionales y nacionales, problemas de Big Data y gestión de almacenamiento a nivel general. Las consultas generalmente suelen durar poco tiempo y es algo útil para la gestión a gran escala de los datos almacenados.

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 Sej K.
Sej K.
Validated Reviewer
Review Source

"Operational Database"

What do you like best?

It's very robust to handle real-time transactions. We have hosted some critical systems like Point of Sale on DB2 and it does its job very well without causing much maintenance to DBA

What do you dislike?

Licensing has been one of the pain with DB2. Also, scalability has been other concerns and thus we have been looking into some NoSQL databases for our future applications

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

DB2 is very good at processing real-time transactions and thus it has been at the heart of our websites and all POS Systems. Another important application with DB2 has been in our pharmacies to have our data secured & protected to meet all related compliance

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
Business partner of the vendor or vendor's competitor, not included in G2 Crowd scores.

"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 Sushmita D.
Sushmita D.
Validated Reviewer
Review Source

"IBM DB2 review"

What do you like best?

IBM DB2 was easy to use. The syntax was quite similar to oracle sql so easy to pick up if you have oracle sql knowledge

What do you dislike?

i ran into many installation issues. Sometimes when i launch the tool, it would display error "couldn't launch setup.exe". After trouble shooting and reading online forums, i was asked to go into a specific folder in the installation folders and delete a file.

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

I felt like oracle is better as per infrastructure supporting an application is concerned

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

"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
Business partner of the vendor or vendor's competitor, not included in G2 Crowd scores.

"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
Business partner of the vendor or vendor's competitor, not included in G2 Crowd scores.

"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 Steve S.
Steve S.
Validated Reviewer
Review Source

"DB2 4 U"

What do you like best?

It has been a solid product for decades on multiple platforms. I've used it on AS400 iSeries windows with hybrid and stand alone implementations.

What do you dislike?

One thing that has always bothered me is the documentation. I always had better success using third party books.

Recommendations to others considering the product

Big blue is still big blue.

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

Using a DB2 SQL engine sitting on top of an AS400 file system I was able to support a document printing application.

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
User
Validated Reviewer
Review Source

"Secure RDBMS. Good Support community. "

What do you like best?

Querying is fast for large chunks of data. Legacy systems without referential integrity are fast when compared to opensource DBs like Sybase.

Updates and Security Patches are released in a controlled manner and it is easy to plan around it.

Java Method Support is good to use. DB2 IBM support is good. Any issues will be addressed quickly.

What do you dislike?

Nothing that I can think of . Really cant say any difference between DB2 and the other DBs in the market like Oracle and MySQL.

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

Data which have to be stored for legal requirements for 30+ years are saved using DB2.

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

"An intuitive database language"

What do you like best?

Its syntax is different from the traditional SSMS or MySQL and hence it makes it unique to work with. Works faster with IBM Software tools.

What do you dislike?

If you are someone who has always worked on SQL Server, it would be a little typical to catch on.

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

We carried out trainings on db2 to work with a project. I am a db2 certified associate.

Db2 review by User in Financial Services
User in Financial Services
Validated Reviewer
Review Source

"IBM's robust DBaaS & Cloud support"

What do you like best?

Extremely easy to setup, manage migration and focused

Strong task scheduler that helps to collect statistical data

Tablespace usage and automatic storage help keep your data segmented while at rest. This maks partitioning easier

Ability to run commands by CLI makes administration easy

What do you dislike?

Db2 has very few region options and this impacts your performance and compliance requirements

License is expensive

You cannot run multiple secondary nodes or cluster without additional software purchases; in some cases third party tools

Recommendations to others considering the product

Robust database as service that was be extended through the cloud

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

Easy of database administration and strong / robust fail over requirement.

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.

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
3.9
(169 reviews)