IBM Db2 Warehouse vs IBM Db2 Warehouse on Cloud comparison

Cancel
You must select at least 2 products to compare!
IBM Logo
973 views|521 comparisons
71% willing to recommend
IBM Logo
327 views|295 comparisons
83% willing to recommend
Comparison Buyer's Guide
Executive Summary

We performed a comparison between IBM Db2 Warehouse and IBM Db2 Warehouse on Cloud based on real PeerSpot user reviews.

Find out what your peers are saying about Snowflake Computing, Oracle, Teradata and others in Data Warehouse.
To learn more, read our detailed Data Warehouse Report (Updated: April 2024).
768,857 professionals have used our research since 2012.
Featured Review
Quotes From Members
We asked business professionals to review the solutions they use.
Here are some excerpts of what they said:
Pros
"Some of the best features are stored procedures, parallelism, and different indexing strategies.""The standout feature of IBM Db2 Warehouse, which is particularly valuable for large enterprises, is its ability to handle big data.""I think it scales really well and as long as you take enough time to learn a little bit about it, it works really well.""The analytics engine is not bad at forecasting predictions.""Provides good security and reliability.""It can be mounted on the cloud, which is a huge plus. If the client, for example, starts small with on-premise deployment and then it rapidly needs to grow, we can transfer this to the cloud easily."

More IBM Db2 Warehouse Pros →

"The performance is okay as long as the volume of queries is not too high.""The way that it scales will help a lot of customers that are stuck with Netezza boxes that can't grow any larger.​""It will be MPP, so performance should improve."

More IBM Db2 Warehouse on Cloud Pros →

Cons
"In terms of improvement, IBM Db2 Warehouse should be more scalable.""The biggest problems we have is when the backup solution is failing or slow and we run out of log space, which has happened probably a couple of times in the last four years.""Lacks sufficient documentation and particularly in Spanish.""IBM Db2 Warehouse needs to improve its interface.""The biggest challenge anyone could have with Db2 Warehouse is their references or online resources and documentation. They are very, very, very limited on the web.""There should be more material available for training and training should be free.""The areas of the solution that is needing the most improvement are separating compute from storage, elasticity, which means scaling up and then retracting."

More IBM Db2 Warehouse Cons →

"Tech support for dashDB is awful. We usually have tickets open for three to four weeks.""Right now, we are implementing on ESX VMware 6.0. Support for this platform is poor. Also, one of the backup/recovery options is broken and IBM is not addressing the issue.""Ultimately, the product itself has challenges and we are not currently satisfied with the support, either.""Containers get corrupted very easily. Restoring them using GPFS can result in a lot of issues."

More IBM Db2 Warehouse on Cloud Cons →

Pricing and Cost Advice
  • "In a traditional on-prem database, in a data warehouse, the solution is probably on the expensive side."
  • More IBM Db2 Warehouse Pricing and Cost Advice →

  • "If your going to go with warehouse DB/dashDB, use the cloud or Sailfish version."
  • More IBM Db2 Warehouse on Cloud Pricing and Cost Advice →

    report
    Use our free recommendation engine to learn which Data Warehouse solutions are best for your needs.
    768,857 professionals have used our research since 2012.
    Questions from the Community
    Top Answer:The standout feature of IBM Db2 Warehouse, which is particularly valuable for large enterprises, is its ability to handle big data.
    Top Answer:Db2 is a very expensive database. In comparison to Oracle, for example, where the cost depends on the size of the implementation. For an enterprise database, the cost is mid-range.
    Top Answer:IBM Db2 Warehouse needs to improve its interface.
    Top Answer:Organizations of all sizes, especially those who are in need of powerful and elastic cloud data warehouse solutions that can help administrators maximize the efficiency of their data-based operations… more »
    Ranking
    14th
    out of 34 in Data Warehouse
    Views
    973
    Comparisons
    521
    Reviews
    3
    Average Words per Review
    363
    Rating
    7.3
    15th
    Views
    327
    Comparisons
    295
    Reviews
    0
    Average Words per Review
    0
    Rating
    N/A
    Comparisons
    Also Known As
    InfoSphere Warehouse, IBM InfoSphere Warehouse
    IBM dashDB
    Learn More
    IBM
    Video Not Available
    Overview
    InfoSphere Warehouse is a suite of products that combines the strength of DB2 with a data warehousing infrastructure from IBM. You can use InfoSphere Warehouse to build a complete data warehousing solution that includes a highly scalable relational database, data access capabilities, and front-end analysis tools.

    IBM dashDB family offers private and public cloud database solutions for transactional and analytic workloads, with IBM fully managed or client managed options with a Common SQL engine across all deployment options.

    Sample Customers
    Alameda County Social Services Agency, Sui Southern Gas Company Limited
    Copenhagen Business School, BPM Northwest, GameStop
    Top Industries
    VISITORS READING REVIEWS
    Educational Organization52%
    Financial Services Firm9%
    Computer Software Company7%
    Insurance Company4%
    VISITORS READING REVIEWS
    Financial Services Firm16%
    Manufacturing Company10%
    University10%
    Computer Software Company9%
    Company Size
    REVIEWERS
    Small Business44%
    Midsize Enterprise11%
    Large Enterprise44%
    VISITORS READING REVIEWS
    Small Business9%
    Midsize Enterprise54%
    Large Enterprise37%
    VISITORS READING REVIEWS
    Small Business14%
    Midsize Enterprise10%
    Large Enterprise76%
    Buyer's Guide
    Data Warehouse
    April 2024
    Find out what your peers are saying about Snowflake Computing, Oracle, Teradata and others in Data Warehouse. Updated: April 2024.
    768,857 professionals have used our research since 2012.

    IBM Db2 Warehouse is ranked 14th in Data Warehouse with 8 reviews while IBM Db2 Warehouse on Cloud is ranked 15th in Cloud Data Warehouse. IBM Db2 Warehouse is rated 7.6, while IBM Db2 Warehouse on Cloud is rated 7.6. The top reviewer of IBM Db2 Warehouse writes "Useful for ETL process and has good documentation ". On the other hand, the top reviewer of IBM Db2 Warehouse on Cloud writes "The "prefetch" feature anticipates needed data and keeps it available. BLU acceleration determines what data is unqualified for analysis and skips it". IBM Db2 Warehouse is most compared with Oracle Exadata, Snowflake, Amazon Redshift, Apache Hadoop and BigQuery, whereas IBM Db2 Warehouse on Cloud is most compared with Amazon Redshift, IBM Netezza Performance Server, Microsoft Azure Synapse Analytics and Snowflake.

    See our list of best Data Warehouse vendors and best Cloud Data Warehouse vendors.

    We monitor all Data Warehouse reviews to prevent fraudulent reviews and keep review quality high. We do not post reviews by company employees or direct competitors. We validate each review for authenticity via cross-reference with LinkedIn, and personal follow-up with the reviewer when necessary.