Db2

(107)
3.8 out of 5 stars

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

Work for Db2?

Learning about Db2?

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

Db2 Reviews

Ask Db2 a Question
Write a Review
Filter Reviews
Filter Reviews
  • Ratings
  • Company Size
  • User Role
  • User Industry
Ratings
Company Size
User Role
User Industry
Showing 112 Db2 reviews
LinkedIn Connections
Db2 review by <span>José H.</span>
José H.
Validated Reviewer
Verified Current User
Invitation from G2 Crowd
Reviewed On

DBA ADMNISTRATOR IN DB2

What do you like best?

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

What do you dislike?

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

Recommendations to others considering the product

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

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

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

Sign in to G2 Crowd to see what your connections have to say about Db2
Headshots
Db2 review by Administrator in Computer Software
Administrator in Computer Software
Validated Reviewer
Verified Current User
Invitation from G2 Crowd
Reviewed On

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

What do you like best?

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

What do you dislike?

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

Recommendations to others considering the product

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

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

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

What Relational Databases solution do you use?

Thanks for letting us know!
Db2 review by <span>Derek J.</span>
Derek J.
Validated Reviewer
Organic
Reviewed On

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 <span>Brian R.</span>
Brian R.
Validated Reviewer
Verified Current User
Invitation from G2 Crowd
Reviewed On

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 Administrator in Consumer Goods
Administrator in Consumer Goods
Validated Reviewer
Verified Current User
Organic
Reviewed On

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 <span>ALEXANDER J.</span>
ALEXANDER J.
Validated Reviewer
Verified Current User
Invitation from G2 Crowd
Reviewed On

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.

Learn more about Db2

Db2 Downloads

Kate avatar
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
(107)