TrustRadius: an HG Insights company

Save this comparison

Save this comparison

Add Product

Recommended Comparisons

    Overview
    ProductRatingMost Used ByProduct SummaryStarting Price

    Db2

    Score8.6 out of 10
    N/ADB2 is a family of relational database software solutions offered by IBM. It includes standard Db2 and Db2 Warehouse editions, either deployable on-cloud, or on-premise.

    $0

    Prometheus

    Score8 out of 10
    N/APrometheus is a service monitoring and time series database, which is open source.N/A
    Pricing
    Db2Prometheus
    Editions & Modules
    Db2 on Cloud Lite
    $0
    Db2 on Cloud Standard
    $99
    per month
    Db2 Warehouse on Cloud Flex One
    $898
    per month
    Db2 on Cloud Enterprise
    $946
    per month
    Db2 Warehouse on Cloud Flex for AWS
    2,957
    per month
    Db2 Warehouse on Cloud Flex
    $3,451
    per month
    Db2 Warehouse on Cloud Flex Performance
    13,651
    per month
    Db2 Warehouse on Cloud Flex Performance for AWS
    13,651
    per month
    Db2 Standard Edition
    Contact Sales
    Db2 Advanced Edition
    Contact Sales
    No answers on this topic
    Offerings
    Pricing Offerings
    Db2Prometheus
    Free Trial
    YesNo
    Free/Freemium Version
    YesNo
    Premium Consulting/Integration Services
    YesNo
    Entry-level Setup FeeOptionalNo setup fee
    Additional Details——
    More Pricing Information
    Best Alternatives
    Db2Prometheus
    Small Businesses
    Amazon RDS
    Score8.1 out of 10
    InfluxDB
    Score9 out of 10
    Medium-sized Companies
    SingleStore
    Score8.2 out of 10
    No answers on this topic
    Enterprises
    SAP IQ
    Score5.4 out of 10
    No answers on this topic
    All AlternativesView all alternativesView all alternatives
    User Ratings
    Db2Prometheus
    Likelihood to Recommend
    9.1
    (114 ratings)
    7.8
    (35 ratings)
    Likelihood to Renew
    7.9
    (12 ratings)
    -
    (0 ratings)
    Usability
    8.5
    (9 ratings)
    7.1
    (3 ratings)
    Availability
    9.3
    (64 ratings)
    -
    (0 ratings)
    Performance
    9.1
    (12 ratings)
    -
    (0 ratings)
    Support Rating
    8.9
    (6 ratings)
    5.0
    (1 ratings)
    In-Person Training
    8.2
    (1 ratings)
    -
    (0 ratings)
    Implementation Rating
    5.6
    (3 ratings)
    -
    (0 ratings)
    Configurability
    9.1
    (2 ratings)
    -
    (0 ratings)
    Data Sharing and Collaboration
    8.0
    (1 ratings)
    -
    (0 ratings)
    Data Sources
    9.0
    (1 ratings)
    -
    (0 ratings)
    Ease of integration
    7.8
    (4 ratings)
    -
    (0 ratings)
    Product Scalability
    8.3
    (66 ratings)
    -
    (0 ratings)
    Vendor post-sale
    9.0
    (2 ratings)
    -
    (0 ratings)
    Vendor pre-sale
    9.0
    (2 ratings)
    -
    (0 ratings)
    User Testimonials
    Db2Prometheus
    Likelihood to Recommend
    IBM
    I have primarily used it as the basis for a SIS - but I have migrated more than a few systems from there database systems to DB2 (Filemaker, MySQL, etc.). DB2 does have a better structural approach, as opposed to Filemaker, which allows for more data consistency, but this can also lead to an inflexibility that can sometimes be counterintuitive when attempting to compensate for the flexibility of the work environment as Schools tend to have an all in one approach.
    Incentivized
    Read full review
    Open Source
    This program works from the roots of the problem and creates a professional matrix for each of its users. This will give them more skills and resources to carry out tasks and reduce the difficulties of operating each of the processes of my work, as well as being An ally for the manipulation and operability of all your master data; Prometheus is very easy to recommend since it is a program that fulfills its mission.
    Incentivized
    Read full review
    Pros
    IBM
    • While we query a large set of data, the results are generally available within a minute or so.
    • Always reliable - I have never experienced an application going down.
    • It is easy to write queries and find tables and columns.
    • We can log in smoothly without any headaches.
    Incentivized
    Read full review
    Open Source
    • Looking at metrics such as the aggregate number of HTTP requests served.
    • Understanding how our services are performing in aggregate.
    • Easy to deploy within a variety of architectures/environments.
    • Open source so new features are added regularly and bugs are fixed in a timely manner.
    • Free so there are no licensing restrictions.
    • Endorsed by the Cloud Native Computing Foundation.
    Incentivized
    Read full review
    Cons
    IBM
    • Learning curve for DB resources - Improvements to UI or native command line built-ins can help with increasing efficiencies for DB resources
    • Better resource utilization monitoring and recommendations
    • Continue to adopt support for modern frameworks and languages making it easier for organizations to see making Db2 the easy first choice
    Incentivized
    Read full review
    Open Source
    • Customer Service: since this is an open-source tool, customer service is not that great. Generally, you get all answers to your problems in online forums, but in case you got stuck, nobody will assist you in a channelised manner. You will have to find the way out on your own, and it may become frustrating at times.
    • More metrics for dashboards shall be added per the application being monitored. Standards metrics will work in most cases but may not in specific applications. Therefore, customised metrics shall be created for some of the industry-standard niche applications.
    Incentivized
    Read full review
    Likelihood to Renew
    IBM
    The DB2 database is a solid option for our school. We have been on this journey now for 3-4 years so we are still adapting to what it can do. We will renew our use of DB2 because we don’t see. Major need to change. Also, changing a main database in a school environment is a major project, so we’ll avoid that if possible.
    Incentivized
    Read full review
    Open Source
    No answers on this topic
    Usability
    IBM
    You have to be well versed in using the technology, not only from a GUI interface but from a command line interface to successfully use this software to its fullest.
    Incentivized
    Read full review
    Open Source
    It is usable and one can learn if few people in the team are already using it. It can be difficult to understand at the beginning because of non intuitive UI and syntax of the rules. So, I've gone for 7 points as there is some room for improvement in user interface and rules syntax.
    Incentivized
    Read full review
    Reliability and Availability
    IBM
    I have never had DB2 go down unexpectedly. It just works solidly every day. When I look at the logs, sometimes DB2 has figured out there was a need to build an index. Instead of waiting for me to do it, the database automatically created the index for me. At my current company, we have had zero issues for the past 8 years. We have upgrade the server 3 times and upgraded the OS each time and the only thing we saw was that DB2 got better and faster. It is simply amazing.
    Incentivized
    Read full review
    Open Source
    No answers on this topic
    Performance
    IBM
    The performances are exceptional if you take care to maintain the database. It is a very powerful tool and at the same time very easy to use. In our installation, we expect a DB machine on the mainframe with access to the database through ODBC connectors directly from branch servers, with fabulous end users experience.
    Incentivized
    Read full review
    Open Source
    No answers on this topic
    Support Rating
    IBM
    Easily the best product support team. :) Whenever we have questions, they have answered those in a timely manner and we like how they go above and beyond to help.
    Incentivized
    Read full review
    Open Source
    Never had to reach out to them.
    Incentivized
    Read full review
    In-Person Training
    IBM
    the material was very clear and all subjects have been handled
    Incentivized
    Read full review
    Open Source
    No answers on this topic
    Implementation Rating
    IBM
    db2 work well with the application, also the replication tool can keep it up
    Read full review
    Open Source
    No answers on this topic
    Alternatives Considered
    IBM
    DB2 was more scalable and easily configurable than other products we evaluated and short listed in terms of functionality and pricing. IBM also had a good demo on premise and provided us a sandbox experience to test out and play with the product and DB2 at that time came out better than other similar products.
    Incentivized
    Read full review
    Open Source
    Highly customized pricing plans to choose from. Lower pricing for the same features compared to competitors. Easy to reach the support team, which provided detailed documentation and helped set up the Prometheus. Monitoring metrics gets very easy after the integration with Grafana. It also has a sophisticated alert setting mechanism to ensure we don't miss anything critical.
    Incentivized
    Read full review
    Scalability
    IBM
    By
    using DB2 only to support my IzPCA activities, my knowledge here
    is somewhat limited.

    Anyway,
    from what I was able to understand, DB2 is extremely scallable.

    Maybe the information below could serve as an example of scalability.
    Customer have an huge mainframe environment, 13x z15 CECs, around
    80 LPARs, and maybe more than 50 Sysplexes (I am not totally sure about this
    last figure...)

    Today
    we have 7 IzPCA
    databases, each one in a distinct Syplex.

    Plans
    are underway to have, at the end, an small LPAR, with only one DB2 sub-system,
    and with only one database, then transmit the data from a lot of other LPARs,
    and then process all the data in this only one database.



    The
    IzPCA collect process (read the data received, manipulate it, and insert rows
    in the tables) today is a huge process, demanding many elapsed
    hours, and lots of CPU.

    Almost
    100% of the tables are PBR type, insert jobs run in parallel, but in 4 of the 7
    database, it is a really a huge and long process.



    Combining
    the INSERTs loads from the 7 databases in only one will be impossible.......,,,,



    But,
    IzPCA recently introduced a new feature, called "Continuous
    Collector"
    .
    By
    using that feature, small amounts of data will be transmited to the central
    LPAR at every 5 minutes (or even less), processed immediately,in
    a short period of time, and with small use of CPU,
    instead of one or two transmissions by day, of very large amounts of data and
    the corresponding collect jobs occurring only once or twice a day, with long
    elapsed times, and huge comsumption of CPU



    I
    suspect the total CPU seconds consumed will be more or less the same in
    both cases, but in the new method it will occur in small bursts
    many times a day!!
    Incentivized
    Read full review
    Open Source
    No answers on this topic
    Return on Investment
    IBM
    • Negative: Difficult and manual deployment
    • Negative: Missing assistants from common monitoring metrics
    • Positive: Stability
    • Positive: Performance
    • Positive: Resiliency and high availability (HADR)
    • Positive: Data Replication (Q-Rep)
    • Positive: Interaction with storage subsystems for backups (TSM, SVC)
    • Positive: Gigantic monitoring features in the form of table functions
    Incentivized
    Read full review
    Open Source
    • We are still working on the ROI
    • The ROI mentioned during the purchase has not been achieved, however this could be due to lack of data from our side. 2 years of implementation is too early to calculate and confirm the ROI.
    Incentivized
    Read full review
    ScreenShots

    Db2 Screenshots

    Screenshot of Db2 - Data sharingScreenshot of Db2 - Machine LearningScreenshot of Db2 - Real time insights