Join the 1500 companies using G2 Track to manage SaaS spend, usage, contracts & compliance.
IBM Db2

IBM Db2

4.0
(414)
Optimized for quick response

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 IBM Db2?

Learning about IBM Db2?

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

IBM Db2 Reviews

Ask IBM Db2 a Question
Write a Review
Filter Reviews
Filter Reviews
  • Ratings
  • Company Size
  • User Role
  • For Category
  • Industry
Ratings
Company Size
User Role
For Category
Industry
Showing 414 IBM Db2 reviews
LinkedIn Connections
IBM Db2 review by Cesar A.
Cesar A.
Validated Reviewer
Verified Current User
Review Source
content

"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 to see what your connections have to say about IBM Db2
IBM Db2 review by Elizabeth G.
Elizabeth G.
Validated Reviewer
Verified Current User
Review Source
content

"Improve your backups and databases with IBM Db2 on cloud"

What do you like best?

This software comes with a high availability option, where you can help a database and you can scale and search for any type of information securely from the cloud, additionally you have the ability to separate the data from the cpu and the cloud, in which you can pay only the time or space you use, helps you take care of data encryption

What do you dislike?

These types of software are very necessary already in the day to day of any company, since now everything is based on the speed of technology to drown man hours and give faster response, for me there is nothing negative in it, even improves the security of your database

Recommendations to others considering the product

perform the test, so that they are convinced that it can be a great tool for your recommended company.

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

i'm going to perform the test to create a database and a backup where you can check the speed of work within the cloud, the security of the information there backed up, and how this can help the company, is a very interesting tool

What Relational Databases solution do you use?

Thanks for letting us know!
IBM Db2 review by Aris R.
Aris R.
Validated Reviewer
Review Source
content

"Facilities the Process of Data Security and Management "

What do you like best?

I like the effectiveness and quality of this software.

I doubt that product which can beat IBM Db2 in terms of data security and management.

Besides, this software is universal, and therefore, many firms and individuals use it often.

Lastly, the support from the IBM is immense and of high quality.

What do you dislike?

IBM products are all expensive.

This database software is not an exceptional.

I wish the vendor could understand that not all individuals or persons who have the finances required for a successful installation and running of this item..

This is the only issue that most of us have with this item.

Recommendations to others considering the product

Like many other IBM products, I find this one also very useful and effective.

Nonetheless, you need enough cash to have it.

It fully supports the process of database management and processing.

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

The software from IBM has so many features that makes it possible to conduct various roles.

For instance, the application acts as a Database Warehouse or storage.

Again, it assist in processing and managing big data in companies.

Lastly, it acts as a relational database.

IBM Db2 review by Atanu R.
Atanu R.
Validated Reviewer
Review Source
content

"One of the best database servers"

What do you like best?

I have mainly used DB2 along with IBM BPM as a product and application database for both non production and production environments. Running commands from Command Line Interface or IBM Data Studio is ease. Great performance with faster query returns. Vary much stable, occasionally goes down. Requires very low maintenance once deployed. Task scheduler is a great advantage. Can stored XML data to reduce development.

What do you dislike?

Administrating is bit difficult. Lack of proper documentation for all administration tasks. Requires costle hardwares and licensing cost is also high. Support from IBM takes lots of time even after raising PMRs.

IBM Data Studio is a heavy software, preferable to use other Database clients like DBVisualizer, Oracle SQL Developer etc.

Recommendations to others considering the product

DB2 is a good database in terms of transaction based workloads. It integrates well with other IBM softwares like IBM Websphere, IBM Datapower. But overall it's a stable and reliable database server.

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

Used as a default product database of IBM BPM and used as application database for IBM BPM applications for banking, finance, healthcare clients.

IBM Db2 review by José H.
José H.
Validated Reviewer
Verified Current User
Review Source
content

"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.

IBM Db2 review by Evaristo C.
Evaristo C.
Validated Reviewer
Review Source
content

"Amazing database"

What do you like best?

What i always declare about IBM products is the robust gets after it gets install, is a pretty fast and lite . Easy to install ,, integrates with differents opertaint system and finally you can have a free version with all the features . The data management was really agile , is impresive how work equal for 10 record to 1000 records.

What do you dislike?

not much about the dislikes but there are a few :

1.- If you want to buy the full version is really expensive

2.- For installing in diferentes Opertatin system other than windows is a pretty hard problem to solve

3.- In the internet is not a lot of information to solve every day issues.

Recommendations to others considering the product

Is a really good database and has a lot of feature to work really nice , but you have to considerer 2 major aspects of it :

1.- If you want the free version you limited for some feature and max storage of 2g, instead of that the paid version is almost perfect but is super expensive.

2.- Beware for want system you are using it , in windows is pretty easy but linux is a pretty big headake

3.- also beware that is not a lot of information in the internet to help and only have the IBM data that sometime is not as acurate as should be.

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

well in my case we were running an ibm aplication that only works on DB2 so more than solving an issue was see how it works and i can say is a pretty good tool to work with.

IBM Db2 review by Pankaj R.
Pankaj R.
Validated Reviewer
Review Source
content

"Perfect for Legacy code handling"

What do you like best?

I utilize Access databases frequently,

ignoring 'weird looks' given to me by IT professionals who consider anything

less than Oracle not a true database, but some sort of a 'toy'. However, DB2

fits the bill perfectly in some cases. Back in 1996, I had to resolve a problem

very quickly, by creating a 'tool' to keep track of problems encounters by

buyers from the procurement department in ordering certain parts, like parts

for old designs and currently unavailable due to obsolescence, or parts having

an unacceptable long lead time. The need was for a relatively simple and small

database, allowing recording of such problems, recording of the progress made

by the Component Engineering department in finding a solution and the recording

of the solution itself, when one was found. I selected IBM DB2 as a

platform, since it appeared relatively simple compared to more powerful

databases, and my proficiency in other members of the Office suite making the

learning curve shorter. And it worked very well. The implementation took only

three weeks and the results were very much appreciated by its users. I believe

this database it is still in use.

What do you dislike?

It cannot accommodate as many records or as many concurrent users an Oracle or similar database can.

It is not as reliable as a database of 'industrial strength' is.

It does not work fast, particularly when when large amount of code was used for its design or when a relatively many users attempt to utilize it simultaneously.

Recommendations to others considering the product

Make the DDL creation of Stored Procedures explicit.

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

IBM DB2 is very suitable whenever the objective of the project is a database where:

1. The timeframe of the project must be short and the start of the project must be immediate.

2. Specialised personnel from IT department is not available, due to their own prioritization scheme.

3. The designer tasked with the design, implementation and deployment of the database, is a technically-oriented person in general, but having no previous knowledge of Access in particular.

4. The size of the envisaged database is relatively small, both in the number of records to be stored in it, as well in the number of concurrent users.

IBM Db2 review by Alan I.
Alan I.
Validated Reviewer
Review Source
content

"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

IBM Db2 review by Anjali P.
Anjali P.
Validated Reviewer
Review Source
content

"The Ultimate hybrid SQL engine."

What do you like best?

IBM DB2 big SQL engine for Hadoop makes quering the enterprise data from across the organization easier.

With this, we can quickly access data stored in hadoop, run federated queries across a variety of data sources.

Even when different applications having different SQL dialects, Big SQL will understand them and data engineers can make use of this highly!

Big SQL can solve the machine learning problems more easily.

What do you dislike?

Compared to any other SQL engine, i would definitely go with IBM DB2 big SQL and do not find any significant cons as such.

Recommendations to others considering the product

This SQL engine is definitely worth a try due to its benefits as mentioned earlier. Big SQL can solve the machine learning problems more easily, so organizations and data engineers can benefit out of it.

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

Querying the enterprise data in Hadoop is easily managed by this.

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

"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.

IBM Db2 review by Manjushri S.
Manjushri S.
Validated Reviewer
Review Source
content
Business partner of the vendor or vendor's competitor, not included in G2 scores.

"Database on the cloud"

What do you like best?

The IBM DB2 database is of the cool new technologies through which one can easily create a database on the cloud without having to worry about any operating system and does not have any limitation. It is easily scalable and also does not require any major set up.

What do you dislike?

Well I have used both the Amazon RedShift and the IBM DB2 instance and just feel that implementation wise it is a little tougher to implement when compared to AWS. However it also is a robust platform supporting major day to day operations.

Recommendations to others considering the product

If you are wanting to set up a database for your project then there this can be one of simplest approaches that the company can take.

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

Any business who want to set up a database, can now quickly connect to IBM DB2 and not have to worry about hiring DBA for managing the access, everything is internally managed by IBM so it really easy for any developer to get a hang of it.

IBM Db2 review by Manish S.
Manish S.
Validated Reviewer
Review Source
content

"DBaas"

What do you like best?

If I have to be honest, using IBM Db2 Hosted doesn't make any sense. It is not bad, it a relational DBMS and helps in scalability due to it being hosted on the cloud. However, as it is by IBM thus integrating it with other frameworks and services is not as easy as configuring Amazon's DynamoDb for the same effort. Else it just does the work, slightly more efforts.

What do you dislike?

As mentioned above, it is not very seamless when it comes to integration with other services and frameworks. This makes the overall procedure a pain!

Recommendations to others considering the product

If you can then go for Dynamo or MS SQL based DB.

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

Building an application using IBM Db2 Hosted as a service. We had to use it due to the client mainframe and IBM Db2 integration requirements. Else would any day go for DynamoDB

IBM Db2 review by Administrator in Computer Software
Administrator in Computer Software
Validated Reviewer
Verified Current User
Review Source
content

"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.

IBM Db2 review by Derek J.
Derek J.
Validated Reviewer
Review Source
content

"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.

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

"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.

IBM Db2 review by User
User
Validated Reviewer
Review Source
content

"Best Db i have ever seen"

What do you like best?

One of the best DB ever seen, it is really nice to use & user-friendly & compatible. Very useful to execute & performance wise too fast. every fast processing & it's available in any kind of operating system. For running stored procedures & creating any kind of scripts it's user-friendly & GUI we can connect with any kind of tool we are having in and compatible with any kind of application. The main thing we are using IBM Database is for our logs storage & application related data.

What do you dislike?

Nothing to say anything wrong about the product, it's really a nice product which we have seen. The main thing is its user-friendly & compatible with any kind of application to connect.

Recommendations to others considering the product

One of the best Db which will fulfill your daily issues in your applications for storing the data & solving the issues.

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

We are using this for our application logging purpose & storing application data during retrieving.

IBM Db2 review by Aishwarya A.
Aishwarya A.
Validated Reviewer
Review Source
content
Business partner of the vendor or vendor's competitor, not included in G2 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.

IBM Db2 review by Administrator
Administrator
Validated Reviewer
Verified Current User
Review Source
content

"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.

IBM Db2 review by User
User
Validated Reviewer
Review Source
content

"Db2 is a complete database management system?"

What do you like best?

If it is, it is a fabulous data base manager, easy to manipulate indexing and apart modification and elimination. In my case I have tried commercial databases of other companies and it is very cumbersome to support I must ask by phone to solve a damaged data in the case of the manager db2 ibm was a separate success that is a compilation of several types of C, C ++, Assembly language, Java and that makes it easier to migrate between systems my experience was with a billing system

What do you dislike?

I really do not have any kind of dislike on the contrary the db2 system has an application called db2admin that makes life easier to migrate from system to another

Recommendations to others considering the product

It is excellent I recommend 10000% it is worth more than any database manager system

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

In a company that invoiced the support of the migration of an old and obsolete system to a newer system and the database of the old system is made in c ++ so the new system was made in db2 and it was very easy the migration . At one time there was a duplication of the data but with the application db2 admin I delete the duplicate is excellent

I send you the image that makes it possible to migrate from one platform to another without so much trouble I want you to db2

IBM Db2 review by Phani Krishna G.
Phani Krishna G.
Validated Reviewer
Verified Current User
Review Source
content

"DB2 Speed and Support"

What do you like best?

DB2 processing capacity and level of support from IBM is very good. Performance s one good that DB2 provides good challenge to other DBMS systems.

What do you dislike?

Feature wise this needs more from what customer expectation to present data processing requirements.

Recommendations to others considering the product

Reliability and more enhanced features to cloud capabilities with respect to security. more over there should me business requirements teams that align to customer and their data centric. All this requires more understanding between product development and support teams.

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

Large volume of data. speed, performance.

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

"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

IBM Db2 review by Archana K.
Archana K.
Validated Reviewer
Review Source
content

"Review of IBM Db2"

What do you like best?

well-designed, fully managed SQL Database-as-a-Service (DBaaS) solution with Db2 and Oracle PL/SQL compatibility.

Data migration processes and the user interface (UI) are clean, intuitive, and easy to operate for users of a variety of skill levels.

The product is perfect for developers who want to create a database without the assistance of a database administrator (DBA).

It's also great for business analysts who want to custom build a database in no time flat.

What do you dislike?

sometimes the connections are not established the way it needs to be established. - rare occurrence but still not something nice to have.

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

business analysts who want to custom build a database in no time flat - No dependency on availability of DBAs. simple and scalable approach

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

"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.

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

"The database was launched in hours and performed brilliantly."

What do you like best?

Ease of deployment and associated support.IBM provided excellent support from pre-sale, to implementation to support. Direct communication with product development group was very helpful. Overall, IBM products have good amount of maturity mixed with a set of leading-edge enhancements. Products come with optional components that can be turned on or used without impacting existing user experiences making deployment and adoption easier.

What do you dislike?

Although the workload we migrated came from another IBM product, we still had to reoptimize queries on this product causing time and spend.

Recommendations to others considering the product

Usually, popularity wins over product real capabilities and customers need to filter the noise and the bias about Oracle as a default Enterprise scale DB, which is true but there are equally great products out there. Due diligence is the key

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

It helps me to upgrade my system secure and latest updated to the Market Requirements.

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

"Quick and easy Implementation in lesser cost "

What do you like best?

It was a lovely experience to work with the IBM Db2 team providing ultimate level of philosophy around delivering quality and performance in a cost-effective manner.The product 'just works' and the IBM team couldn't be any more helpful. Very reliable product.Security is very high and security is been considered seriously which can't be compromised with not affecting the performance at all.

What do you dislike?

The fact that IBM does not push the benefits of Db2 vs. Oracle and HANA, as the database of choice for SAP. Needs to be adopt and adapt modern interfaces in a agile manner. Integration with IDAA needs to be made more transparent.

Recommendations to others considering the product

Allocate extra resources than the load expected (keep buffer to expedite the implementation. Support from IBM Db2 team is awesome as compared to other vendors like Oracle and SAP. Better publicize the benefits of running SAP on Db2. Push IBM for more modern interfaces. Technlogy is very solid and reliable

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

Cost effectiveness by replacing SAP. Complete Adoption of maturing technologies with manageable risk. Data Warehouse and Data Management solution for Analytics.

IBM Db2 review by Obumneme O.
Obumneme O.
Validated Reviewer
Review Source
content

"db2 is a great database manager"

What do you like best?

I Like DB2 because it is very easy to install, use, it can also be used for small and large projects, there is a lot of documentation about DB2, and the support they offer is very good, as long as you have a good license.

I used for one of my clients for the execution of databases distributed in small-scale banking project, its performance is very good

What do you dislike?

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

Recommendations to others considering the product

Db2 is a great database manager.

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

I was able to use IBM DB2 to execute databases distributed in a small-scale banking project.

IBM Db2 review by Sandip G.
Sandip G.
Validated Reviewer
Review Source
content

"IBM Db Warehouse is likely good"

What do you like best?

Task scheduler allows easy maintainence,

CLI support,

Platform Independent support,

Safe data segmentation

Fast , reliable and easy deployment with advance features,

Easy statistics gathering and reorganization of indexes and tables without user interaction

What do you dislike?

Licensing is expensive and UI interface is difficult

Lots to learn and needs high technical support

Huge download size with tons of bloatware

CRUD Operation is diffrent from PostGreSql, MySQL,MSSQ,

Cannot run multiple secondary nodes or cluster without additional software purchases

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

Using it as the database software for our financial core software.

We also use it to query data for business intelligence. This is used by the whole organization and will allow us to pull reports based on requests.

IBM Db2 review by Industry Analyst / Tech Writer in Information Technology and Services
Industry Analyst / Tech Writer in Information Technology and Services
Validated Reviewer
Review Source
content
Business partner of the vendor or vendor's competitor, not included in G2 scores.

"Db2 Warehouse on Cloud Review"

What do you like best?

You can size dashDB to your current needs and expand its capability later on as the needed. I like the way dashDB allow for connecting to the cloud that my network engineer to set things up quickly. IBM dashDB's ability to store and provide fast access to data both on-premise and in the cloud makes it a real winner for me.

What do you dislike?

IBM dashDB could be clearer about the technology used to deliver the particular tier of the service you buy. IBM dashDB can be cost prohibitive for folks needing to push a lot of data from on-premise into the cloud on a regular basis.IBM dashDB is really like three data technologies in one and the sales teams at IBM sometimes can't explain why the MPP tier is better for certain uses over the db2 BLU based tier.

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

The IBM DB2 database is of the cool new technologies through which one can easily create a database on the cloud without having to worry about any operating system and does not have any limitation. It is easily scalable and also does not require any major set up.

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

IBM Db2 review by User in Outsourcing/Offshoring
User in Outsourcing/Offshoring
Validated Reviewer
Review Source
content

"Best cloud based SQL Database i have worked so far"

What do you like best?

You can size dashDB to your current needs and expand its capability later on as the needed.

dashDB allow easy connectivity to the cloud so that my network engineer can set make the required setup in very less time.

IBM dashDB's ability to store and provide fast access to data proves it a race winner for me.

In-database Netezza analytics, providing the immediate answers users need from their data.

What do you dislike?

IBM dashDB could be clearer about the technology used to deliver the particular tier of the service you buy.

The cost of using it.

The setup is not that user friendly.

Recommendations to others considering the product

In my opinion it is the most reliable solution in the cloud for analytics when it comes to a real business environment.Go for it.

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

It provided us Security and performance as it uses.

We ainly use it for Data Analytics where we manipulate data and export it for brainstorming and marketing decisions based on the rules.

IBM Db2 review by User in Financial Services
User in Financial Services
Validated Reviewer
Review Source
content
Business partner of the vendor or vendor's competitor, not included in G2 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

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

"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.

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

"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.

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

"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 .

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

"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.

IBM Db2 review by Administrator
Administrator
Validated Reviewer
Review Source
content

"Excellent, stable product for ECM"

What do you like best?

We use DB2 for our IBM Content Manager Enterprise Edition environment. We went through the tuning process and the product practically runs itself. We tuned the environment when we hooked up CMIS but generally do not need to adjust anything. We also implemented PowerShell-based maintenance scripts which are able to use DB2 features to dynamically calculate which tables need to be run through the maintenance process for things like runstats and reorgs. This has greatly lowered our maintenance window over the static scripts we used to employ.

What do you dislike?

It can be rather daunting to figure out solutions for things like database replication due to production name changes and rebranding.

Recommendations to others considering the product

This product is far easier to install, configure and maintain than other products like Oracle.

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

We use DB2 for our IBM Content Manager Enterprise Edition and IBM Content Manager OnDemand systms.

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

"Best Database I have ever seen"

What do you like best?

More user friendly, easy compatibility with any kind of operating system , easy to connect with any kind of applications, more efficient and lite weight application for any stored procedures and select, update or delete queries. Our most of the applications are using db2 to write our application logs instead generating a log file. In this way we can maintain our file system with unwanted log files generated. Also we can retrieve years of application data without any issues. Nice product everyone should use in there applications.

What do you dislike?

Nothing to say anything wrong about this. Nice product from IBM for database and I recommend this to be used for all database related stuff.

Recommendations to others considering the product

I personal recommend to use this database in organizations.

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

All application logs and every logging mechanism we are inserting inton DB, using it for future purpose.

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

"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

IBM Db2 review by Consultant
Consultant
Validated Reviewer
Review Source
content

"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.

IBM Db2 review by Sej K.
Sej K.
Validated Reviewer
Review Source
content

"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

IBM Db2 review by Avi R.
Avi R.
Validated Reviewer
Review Source
content

"For analysis of data related to different section of the organization IBM Db2 is recommended."

What do you like best?

1. Consistent with SQL or relational database and good for transforming unstructured data sources to structured data source for analysis.

2. Very fast to process the large amount of query.

3. Good for organization that needs tracking of data between their various department inside.

What do you dislike?

1. Updates are not frequent.

2. Other competitor are also in market that are providing better services.

3. some time faced issue while contacting IBM

Recommendations to others considering the product

I would recommend large organization to go for it but for smaller one they should research it first.

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

Processing a large amount of data and it;s analysis is achieved by Db2 and it's fast performance is satisfactory

IBM Db2 review by daniel z.
daniel z.
Validated Reviewer
Review Source
content

"an easy warehouse db"

What do you like best?

i liked the easyness to perform tasks like create tables, update columns, and make users and changing their privileges , once you get a hold of how to use the web interphase

What do you dislike?

i think it could have a build in visual help to learn to perform the tasks, they are actually easy, but it could be bulletproof for dummyes

Recommendations to others considering the product

its very easy to learn for people with basic expertise as a dba

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

well it solves the infrastructure problem, you are free of searching for hardware, servers and tune up, its benefits are that is fast and reliable anywhere

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

"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.

IBM Db2 review by Max V.
Max V.
Validated Reviewer
Verified Current User
Review Source
content

"DB2 is the Best Database for Business Workload"

What do you like best?

DB2 is absolutely amazing database with built-in advanced features for fast information process as well as robust and granular security.

What do you dislike?

I haven't met any limitations that would prevent me from solving a problem.

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

DB2 is used by our ERP, Data Warehouse and shipping software as well as a number of custom developed applications.

IBM Db2 review by User
User
Validated Reviewer
Review Source
content

"db2 is very good structure and data handler"

What do you like best?

In the certification that made on the basis of data what more was mentioned the advantages of db2 with respect to the rest in the market and how easy and accessible it is

What do you dislike?

Once I had a problem in the migration of a database when I did some internships at the hotel marriott and it is because the db2 duplicated the data but it was repaired with the db2 admin system

Recommendations to others considering the product

excellent I recommend it before starting in the world of databases begin with db2 good strategy

and it's a universal database

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

Once I had a problem in the migration of a database when I did some internships at the hotel marriott and it is because the db2 duplicated the data but it was repaired with the db2 admin system

IBM Db2 review by User
User
Validated Reviewer
Review Source
content

"is the integration of different languages ​​to give life to a database manager system"

What do you like best?

It is very easy to modify the edition and the creation of tables and databases when setting up a system. The process of migration between platforms is also simple and easy, so it deserves a 10.

is based on several languages ​​such as c, c ++ java

What do you dislike?

I do not dislike anything as long as you do not delete the database trolling tool. Everything is fine as it makes it easier.

Recommendations to others considering the product

that you use it with confidence that when you migrate the system you will keep your database

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

if once it was a system that took the inventory made in c and then we updated it object-oriented and it was easy to migrate from c to java. is a system of inventory of ford cars that arrive by lots

IBM Db2 review by Dmitry S.
Dmitry S.
Validated Reviewer
Review Source
content

"HA"

What do you like best?

I like high availability and scalability features, which allow me to separate the data while getting secure DB solution and paying only for the time and disk space I use. I also like creation DB withing taking care about underlying OS.

What do you dislike?

I can only compare with AWS and GCP. I feel the solution is not so mature from user interface, so there is some opportunities for improvements. Howerever, becides that I still thik the solution is really good and can cover all my business cases.

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

I reaaly got no-DBA solution.

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

"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

IBM Db2 review by Naresh Kumar D.
Naresh Kumar D.
Validated Reviewer
Review Source
content
Business partner of the vendor or vendor's competitor, not included in G2 scores.

"IBM DB2 Private Cloud Warhouse"

What do you like best?

The best thing about this IBM DB2 is that it supports docker which is very useful for deploying pre-configured applications.

What do you dislike?

The license cost is very expensive.

Its difficult to get support for this software and leaving with very few option for the support. i.e. we need to get support from IBM.

Recommendations to others considering the product

Its a good product but have to admit that its bit expensive.

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

It generates structured data format for unstructured data which is one of the good features. It also does auto indexing which is useful for processing the query at an faster rate.

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

"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.

Learn more about IBM Db2

IBM Db2 Videos

Kate from G2

Learning about IBM Db2?

I can help.
* We monitor all IBM 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.
IBM Db2
4.0
(414)