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

    Eclipse

    Score8.3 out of 10
    N/AEclipse is a free and open source integrated development environment (IDE).N/A
    Pricing
    Db2Eclipse
    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
    Db2Eclipse
    Free Trial
    YesNo
    Free/Freemium Version
    YesNo
    Premium Consulting/Integration Services
    YesNo
    Entry-level Setup FeeOptionalNo setup fee
    Additional Details——
    More Pricing Information
    Community Pulse
    Db2Eclipse
    Considered Both Products
    IBM
    Chose Db2
    We are working for our product , where we were using different database but that database was not fast our work So we switch to IBM Db2 for better result.
    Incentivized
    Open Source
    No answer on this topic
    Key User Insights
    Would buy again
    96%
    Would buy again
    103 Answers
    94%
    Would buy again
    29 Answers
    Delivers good value for the price
    97%
    Delivers good value for the price
    95 Answers
    97%
    Delivers good value for the price
    29 Answers
    Happy with the feature set
    96%
    Happy with the feature set
    103 Answers
    94%
    Happy with the feature set
    29 Answers
    Lived up to sales and marketing promises
    96%
    Lived up to sales and marketing promises
    66 Answers
    95%
    Lived up to sales and marketing promises
    21 Answers
    Implementation went as expected
    99%
    Implementation went as expected
    89 Answers
    96%
    Implementation went as expected
    24 Answers
    Best Alternatives
    Db2Eclipse
    Small Businesses
    Amazon RDS
    Score8.1 out of 10
    No answers on this topic
    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
    Db2Eclipse
    Likelihood to Recommend
    9.1
    (114 ratings)
    9.9
    (74 ratings)
    Likelihood to Renew
    7.9
    (12 ratings)
    9.0
    (1 ratings)
    Usability
    8.5
    (9 ratings)
    8.0
    (3 ratings)
    Availability
    9.3
    (64 ratings)
    -
    (0 ratings)
    Performance
    9.1
    (12 ratings)
    -
    (0 ratings)
    Support Rating
    8.9
    (6 ratings)
    6.8
    (19 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
    Db2Eclipse
    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
    I think that if someone asked me for an IDE for Java programming, I would definitely recommend Eclipse as is one of the most complete solutions for this language out there. If the main programming language of that person is not Java, I don't think Eclipse would suit his needs[.]
    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
    • Eclipse organizes imports well and does a good job presenting different programming languages.
    • Eclipse auto formats source code allowing customization and increased readability.
    • Eclipse reports errors automatically to users rather than logging it to the console.
    • Eclipse has coding shortcuts and auto-correction features allowing faster software development.
    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
    • While the DB integration is broad (many connectors) it isn't particularly deep. So if you need to do serious DB work on (for example) SQL Server, it is sometimes necessary to go directly to the SQL Server Studio. But for general access and manipulation, it is ok.
    • The syntax formatting is sometimes painful to set up and doesn't always support things well. For example, it doesn't effectively support SCSS.
    • Using it for remote debugging in a VM works pretty well, but it is difficult to set up and there is no documentation I could find to really explain how to do it. When remote debugging, the editor does not necessarily integrate the remote context. So, for example, things like Pylint don't always find the libraries in the VM and display spurious errors.
    • The debugging console is not the default, and my choice is never remembered, so every time I restart my program, it's a dialog and several clicks to get it back. The debugging console has the same contextual problems with remote debugging that the editor does.
    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
    I love this product, what makes it one of the best tool out in the market is its ability to function with a wide range of languages. The online community support is superb, so you are never stuck on an issue. The customization is endless, you can keep adding plugins or jars for more functionalities as per your requirements. It's Free !!!
    Incentivized
    Read full review
    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 has everything that the developer needs to do the job. Few things that I have used in my day-to-day development 1. Console output. 2. Software flash functionality supporting multiple JTAG vendors like J-LINK. 3. Debugging capabilities like having a breakpoint, looking at the assembly, looking at the memory etc. this also applies to Embedded boards. 4. Plug-in like CMake, Doxygen and PlantUML are available.
    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
    I gave this rating because Eclipse is an open-source free IDE therefore no support system is available as far as I know. I have to go through other sources to solve my problem which is very tough and annoying. So if you are using Eclipse then you are on your own, as a student, it is not a big issue for me but for developers it is a need.
    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
    The installation, adaptability, and ease of usage for Eclipse are pretty high and simple compared to some of the other products. Also, the fact that it is almost a plug and play once the connections are established and once a new user gets the hang of the system comes pretty handy.
    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
    • This development environment offers the possibility of improving the productivity time of work teams by supporting the integration of large architectures.
    • It drives constant change and evolution in work teams thanks to its constant versioning.
    • It works well enough to develop continuous server client integrations, based on solid or any other programming principle.
    Incentivized
    Read full review
    ScreenShots

    Db2 Screenshots

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