DB2 Reviews

89 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow noopener'>trScore algorithm: Learn more.</a>
Score 8.1 out of 100

Do you work for this company? Learn how we help vendors

Overall Rating

Reviewer's Company Size

Last Updated

By Topic

Industry

Department

Experience

Job Type

Role

Filtered By:

Reviews (1-19 of 19)

Companies can't remove reviews or game the system. Here's why.
May 03, 2021
Shivani Pandey | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User
Review Source

Pros and Cons

  • Reliable and fast
  • Easy to deploy and administer
  • Scalable as per the requirement
  • Micro options can be placed in more user intuitive interface
  • Documentation can be improved to include more information about micro options available in different menus in the UI
Read Shivani Pandey's full review
May 24, 2021
Anonymous | TrustRadius Reviewer
Score 8 out of 10
Vetted Review
Verified User
Review Source

Pros and Cons

  • Handle multiple schemas and instances.
  • scalable and multi-user support.
  • Fast processing and avoid redundancy in data.
  • Tuned for data warehouse applications, both ETL and reporting.
  • reliable, secure and high availability.
  • Handles large volume of data with ease.
  • Licensing is bit expensive and support is paid.
  • Cannot create tables that can exceed blocksize of tablespace.
  • External applications required to create clusters.
Read this authenticated review
May 01, 2021
Anonymous | TrustRadius Reviewer
Score 6 out of 10
Vetted Review
Verified User
Review Source

Pros and Cons

  • Business Analytics - facilitates data query to generate reports.
  • Integration - can connect with other software.
  • Easy - easy to learn and implement if you know SQL.
  • Database can run faster.
Read this authenticated review
September 17, 2019
Roberto Etcheverry | TrustRadius Reviewer
Score 10 out of 10
Vetted Review
Verified User
Review Source

Pros and Cons

  • Extremely stable, DB2 for i on POWER Systems has superb uptimes.
  • Great HA/DR capabilities, integrated in the OS and provided by IBM and other vendors.
  • The toolboxes for managing the system via SQL are great.
  • SQL Index Advisor and other tools help you tune the system with automatic reporting.
  • Marketing. Sharing the DB2 name between LUW, z/OS and i (which is a product for another review) is a search engine nightmare.
Read Roberto Etcheverry's full review
June 21, 2018
Pradeep Bele | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User
Review Source

Pros and Cons

  • It's best for use in a BW landscape for reporting purposes where you need fast data fetching. As compared to other traditional DBs, I feel DB2 is lightweight and less complicated.
  • Easy DB administration, and requires less administration.
  • Easy in version as well as FP upgrades.
  • Our DB is almost 4 TB in size. So we feel that to manage such a huge DB, DB2 should provide some more user friendly and easier GUI base administrative tool, looking at the current competition in market for their DBs.
  • There is definitely a bit more improvement required in data manipulation and query languages.
  • Stability for an HA kind of environment is one of the key areas for improvement.
Read Pradeep Bele's full review
April 03, 2018
Josh Rice, MBA, ACSP | TrustRadius Reviewer
Score 8 out of 10
Vetted Review
Verified User
Review Source

Pros and Cons

  • Business intelligence - Allows for querying of the data to create reports
  • Flexibility - It scales based on your need
  • Robust - Can connect with reporting software such Crystal Reports to build even prettier reports.
  • For those unfamiliar with SQL, it will be a sharp learning curve
Read Josh Rice, MBA, ACSP's full review
October 10, 2017
Andrew Juarez | TrustRadius Reviewer
Score 10 out of 10
Vetted Review
Verified User
Review Source

Pros and Cons

  • Minimal administration needed compared to other enterprise database products in the market
  • Performance has been exceptional and improved with every version
  • The reliability of the DB2 engine is probably it's biggest asset
  • The Oracle compatibility feature stopped short of providing a listener type connection so applications could have been agnostic to what database it was running.
Read Andrew Juarez's full review
December 08, 2015
J.R. Bullington | TrustRadius Reviewer
Score 3 out of 10
Vetted Review
Verified User
Review Source

Pros and Cons

  • DB2 maintains itself very well. The Task Scheduler component of DB2 allows for statistics gathering and reorganization of indexes and tables without user interaction or without specific knowledge of cron or Windows Task Scheduler / Scheduled jobs.
  • Its use of ASYNC, NEARSYNC, and SYNC HADR (High Availability Disaster Recovery ) models gives you a range of options for maintaining a very high uptime ratio. Failover from PRIMARY to SECONDARY becomes very easy with just a single command or windowed mouse click.
  • Task Scheduler ( DB2 9.7 and earlier ) allows for jobs to be run within other jobs, and exit and error codes can define what other jobs are run. This allows for ease of maintenance without third party softwares.
  • Tablespace usage and automatic storage help keep your data segmented while at rest, making partitioning easier.
  • Ability to run commands via CLI (Command Line Interface) or via Control Center / Data Studio ( DB2 10.x+) makes administration a breeze.
  • You cannot run multiple secondary nodes or cluster without additional software purchases; in some cases third party tools. This drastically increases your overall capital investment. The only way to accomplish a true HADR scenario is to set up NEARSYNC in one datacenter and do logshipping to another datacenter. Downside: You have to wait for the final log ship to complete before your DB is back up.
  • Licensing is prohibitively expensive! If you are not grandfathered in, IBM licensing for a multi-datacenter, PRIMARY, SECONDARY, and Disaster Recovery (DR) setup can be in the multiple $100,000 range.
  • Data Studio is built on IBM's Rapid Application Development (RAD) tool, built on Eclipse. So the download is in the multi-GB range and it includes a ton of bloatware not needed for your standard database maintenance. Control Center is a simple, powerful tool at a quarter of the disk space.
  • Support for DB2 is very hard to come by without paid IBM support. Even then, opening PMRs does not solve problems as the response time for any PMR is always more than two (2) hours, even for enterprise-level paying customers. They always want the most inane log files that have nothing to do with DB2 or its operation, or they want core dumps during the issue. This becomes useless when the issue is "our database just crashed and you can't get those logs right now because I do not want to replicate the cause!"
  • DB2's SQL syntax, while ANSI in CRUD opertaions, is different than Oracle. PostgreSQL, MySQL, and even MS SQL. One must become accustomed to a different syntax for LIMITs, cursors, record counting, stored procedures, user-defined functions, and even table / index creation or altering.
Read J.R. Bullington's full review
February 16, 2016
Shiv Shivakumar | TrustRadius Reviewer
Score 8 out of 10
Vetted Review
Verified User
Review Source

Pros and Cons

  • Is platform specific to Z/OS, Linux, Unix and hence can be leveraged in a customized manner
  • Error handling is the most important feature with warnings
  • Very robust database performance in the SQL schema
  • Allows shared access to the database using LAN in remote branch offices
  • DB2 for Unix has definite room for improvement when compared to competition
  • GUI can be much better than what it is now
  • Data base engine can be faster
Read Shiv Shivakumar's full review
December 26, 2018
Anonymous | TrustRadius Reviewer
Score 8 out of 10
Vetted Review
Verified User
Review Source

Pros and Cons

  • Simplicity. It's way easier to maintain and administer than its red counterpart.
  • Avoids the terrible GUI trap of its contemporary from the Seattle area. Command line access is wonderful.
  • HA/DR works well out of the box, and we also use block-level replication for DR, which is a huge benefit.
  • Stability. I hate to bring a curse on myself for saying this, but Db2 itself is extremely stable and we keep incredible up time.
  • Supports some of Oracle's SQL
  • Tight-knit community.
  • Support is fantastic.
  • IBM is really behind in delivering developer tools. They pride themselves on Data Studio, but it is just frustrating.
  • Marketing. Horrible to do a Google search and get returns for a COMPLETELY different product, for z/os. Why they share the same name is beyond me. Better marketing would also increase the user base and help the product mature.
  • Slower than the competition to roll out next-generation features.
Read this authenticated review
March 26, 2018
Anonymous | TrustRadius Reviewer
Score 10 out of 10
Vetted Review
Verified User
Review Source

Pros and Cons

  • Easy to use with SQL programming
  • High availability
  • An extreme certainty of the data
  • High consumption of mainframe processor
  • Use of the plan for data access too rigid
  • Use of very limiting DRDA gateways
Read this authenticated review
June 27, 2018
Anonymous | TrustRadius Reviewer
Score 8 out of 10
Vetted Review
Verified User
Review Source

Pros and Cons

  • DB2 provides a strong command line interface
  • Very resilient DB connection
  • Integrated very well with IBM product
  • Maybe they could have a simple UI interface similar to MSSQL management studio
Read this authenticated review
April 03, 2018
Anonymous | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User
Review Source

Pros and Cons

  • It is stable
  • It runs well without active DBA management
  • It performs well when we need it to
  • Does not have the most sophisticated features
  • At its core it utilizes IMB "green screen" interface
Read this authenticated review
October 10, 2017
Anonymous | TrustRadius Reviewer
Score 10 out of 10
Vetted Review
Verified User
Review Source

Pros and Cons

  • Reporting using DPF.
  • Purescale for scalable and highly available critical applications.
  • Cost effective solution compared to other vendors.
  • Optimizer - sometimes we need to force the right access plan.
  • Support staff needs to engage more effectively by using WebEx/phone instead of emails.
  • More compatible functions to ease migration from other platforms.
Read this authenticated review
April 14, 2017
Anonymous | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User
Review Source

Pros and Cons

  • Less administrative overhead
  • Easy upgrades
  • Easy maintenance
  • Support
  • Stability
  • Benchmarks
  • Product should work as it is advertised
Read this authenticated review
December 18, 2015
Anonymous | TrustRadius Reviewer
Score 10 out of 10
Vetted Review
Verified User
Review Source

Pros and Cons

  • High level of query fulfillment. One of our applications uses the DB2 database to serve up about 16k to 20k queries per sec at peak, the majority of which execute in less than a few microseconds.
  • Stability. We use a PureScale based, 4 compute node implementation for DB2 and this allows for high uptime. If a node fails, the remaining nodes seamlessly take up the load.
  • Some of DB2 system management tasks can be a bit cumbersome.
  • Rather than adding new features, it would be much better to enhance and expand some of the existing features.
Read this authenticated review
December 28, 2015
Anonymous | TrustRadius Reviewer
Score 6 out of 10
Vetted Review
Verified User
Review Source

Pros and Cons

  • It is owned by IBM. Getting support from IBM is very convenient.
  • It is robust.
  • Monitoring tools exist.
  • Issue resolution or debugging an issue is difficult.
Read this authenticated review

What is DB2?

DB2 is a relational database software solution offered by IBM.

DB2 Integrations

DB2 Technical Details

Operating Systems: Unspecified
Mobile Application:No

Frequently Asked Questions

What is DB2?

DB2 is a relational database software solution offered by IBM.

What is DB2's best feature?

Reviewers rate Availability highest, with a score of 10.

Who uses DB2?

The most common users of DB2 are from Enterprises and the Information Technology & Services industry.