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

    IFS Applications

    Score7.6 out of 10
    N/AIFS Applications is presented by the vendor as an agile application suite that offers enterprise resource planning (ERP), enterprise asset management (EAM) and enterprise project management, handling 4 core processes: Service & Asset Management Full Enterprise Asset Management (EAM), Maintenance Repair and Overhaul (MRO) and Field Service Management (FSM) Manufacturing Enterprise Resource Planning (ERP) with support for process manufacturing, discrete manufacturing…N/A
    Pricing
    Db2IFS Applications
    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
    Db2IFS Applications
    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
    Db2IFS Applications
    Considered Both Products
    IBM
    Chose Db2
    we have felt Db2 with enhance capability stands better than oracle offering and cost benefit is also there with features like better security and better integration with analytical engines and provision for XML, JSON, text and spatial data formats for different kinds of …
    Incentivized
    IFS
    No answer on this topic
    Key User Insights
    Would buy again
    96%
    Would buy again
    103 Answers
    No answers on this topic
    Delivers good value for the price
    97%
    Delivers good value for the price
    95 Answers
    No answers on this topic
    Happy with the feature set
    96%
    Happy with the feature set
    103 Answers
    No answers on this topic
    Lived up to sales and marketing promises
    96%
    Lived up to sales and marketing promises
    66 Answers
    No answers on this topic
    Implementation went as expected
    99%
    Implementation went as expected
    89 Answers
    No answers on this topic
    Features
    Db2IFS Applications
    Payroll Management
    Comparison of Payroll Management features of Db2 and IFS Applications
    Feature
    Db2
    -
    Ratings
    IFS Applications
    4.7
    3 Ratings
    46% below category average
    Pay calculation00 Ratings8.03 Ratings
    Benefit plan administration00 Ratings7.43 Ratings
    Direct deposit files00 Ratings6.43 Ratings
    Customization
    Comparison of Customization features of Db2 and IFS Applications
    Feature
    Db2
    -
    Ratings
    IFS Applications
    8.7
    5 Ratings
    14% above category average
    API for custom integration00 Ratings8.75 Ratings
    Plug-ins00 Ratings8.75 Ratings
    Security
    Comparison of Security features of Db2 and IFS Applications
    Feature
    Db2
    -
    Ratings
    IFS Applications
    9.9
    5 Ratings
    16% above category average
    Single sign-on capability00 Ratings10.05 Ratings
    Role-based user permissions00 Ratings9.85 Ratings
    Reporting & Analytics
    Comparison of Reporting & Analytics features of Db2 and IFS Applications
    Feature
    Db2
    -
    Ratings
    IFS Applications
    8.8
    5 Ratings
    15% above category average
    Dashboards00 Ratings8.55 Ratings
    Standard reports00 Ratings8.35 Ratings
    Custom reports00 Ratings9.55 Ratings
    General Ledger and Configurable Accounting
    Comparison of General Ledger and Configurable Accounting features of Db2 and IFS Applications
    Feature
    Db2
    -
    Ratings
    IFS Applications
    7.5
    5 Ratings
    3% below category average
    Accounts payable00 Ratings9.55 Ratings
    Accounts receivable00 Ratings9.55 Ratings
    Global Financial Support00 Ratings9.04 Ratings
    Primary and Secondary Ledgers00 Ratings9.34 Ratings
    Journals and Reconciliations00 Ratings9.04 Ratings
    Configurable Accounting00 Ratings8.84 Ratings
    Standardized Processes00 Ratings9.04 Ratings
    Inventory Management
    Comparison of Inventory Management features of Db2 and IFS Applications
    Feature
    Db2
    -
    Ratings
    IFS Applications
    9.1
    5 Ratings
    13% above category average
    Inventory tracking00 Ratings9.35 Ratings
    Automatic reordering00 Ratings9.55 Ratings
    Location management00 Ratings9.55 Ratings
    Order Management
    Comparison of Order Management features of Db2 and IFS Applications
    Feature
    Db2
    -
    Ratings
    IFS Applications
    6.3
    5 Ratings
    23% below category average
    Pricing00 Ratings9.05 Ratings
    Order entry00 Ratings8.25 Ratings
    Credit card processing00 Ratings8.74 Ratings
    Cost of goods sold00 Ratings8.35 Ratings
    Order Orchestration00 Ratings7.84 Ratings
    Subledger and Financial Process
    Comparison of Subledger and Financial Process features of Db2 and IFS Applications
    Feature
    Db2
    -
    Ratings
    IFS Applications
    3.9
    4 Ratings
    64% below category average
    Billing Management00 Ratings8.34 Ratings
    Cash and Asset Management00 Ratings8.84 Ratings
    Travel & Expense Management00 Ratings8.84 Ratings
    Budgetary Control & Encumbrance Accounting00 Ratings7.84 Ratings
    Period Close00 Ratings9.34 Ratings
    Project Financial Management
    Comparison of Project Financial Management features of Db2 and IFS Applications
    Feature
    Db2
    -
    Ratings
    IFS Applications
    2.7
    1 Ratings
    95% below category average
    Budgeting and Forecasting00 Ratings3.01 Ratings
    Project Costing00 Ratings6.01 Ratings
    Cost Capture00 Ratings5.01 Ratings
    Capital Project Management00 Ratings2.01 Ratings
    Customer Contract Compliance00 Ratings2.01 Ratings
    Project Revenue Recognition00 Ratings2.01 Ratings
    Project Execution Management
    Comparison of Project Execution Management features of Db2 and IFS Applications
    Feature
    Db2
    -
    Ratings
    IFS Applications
    3.5
    4 Ratings
    67% below category average
    Project Planning and Scheduling00 Ratings9.54 Ratings
    Task Insight for Project Managers00 Ratings8.54 Ratings
    Project Mobile Functionality00 Ratings7.54 Ratings
    Definable Resource Pools00 Ratings8.54 Ratings
    Grants Management
    Comparison of Grants Management features of Db2 and IFS Applications
    Feature
    Db2
    -
    Ratings
    IFS Applications
    9.3
    2 Ratings
    23% above category average
    Award Lifecycle Management00 Ratings9.32 Ratings
    Procurement
    Comparison of Procurement features of Db2 and IFS Applications
    Feature
    Db2
    -
    Ratings
    IFS Applications
    3.5
    4 Ratings
    68% below category average
    Bids Analyzed and Compared00 Ratings9.33 Ratings
    Contract Authoring00 Ratings8.33 Ratings
    Contract Repository00 Ratings8.33 Ratings
    Requisitions-to-Purchase Orders Integrated00 Ratings9.24 Ratings
    Supplier Management00 Ratings9.24 Ratings
    Risk Management
    Comparison of Risk Management features of Db2 and IFS Applications
    Feature
    Db2
    -
    Ratings
    IFS Applications
    5.0
    4 Ratings
    30% below category average
    Risk Repository00 Ratings8.54 Ratings
    Control Management00 Ratings8.74 Ratings
    Control Efficiency Assessments00 Ratings8.54 Ratings
    Issue Detection00 Ratings7.54 Ratings
    Remediation and Certification00 Ratings8.04 Ratings
    Logistics
    Comparison of Logistics features of Db2 and IFS Applications
    Feature
    Db2
    -
    Ratings
    IFS Applications
    7.8
    4 Ratings
    11% above category average
    Transportation Planning and Optimization00 Ratings8.32 Ratings
    Transportation Execution Management00 Ratings9.02 Ratings
    Trade and Customs Management00 Ratings8.02 Ratings
    Fulfillment Management00 Ratings7.73 Ratings
    Warehouse Workforce Management00 Ratings8.54 Ratings
    Manufacturing
    Comparison of Manufacturing features of Db2 and IFS Applications
    Feature
    Db2
    -
    Ratings
    IFS Applications
    6.8
    4 Ratings
    10% below category average
    Production Process Design00 Ratings9.33 Ratings
    Production Management00 Ratings9.04 Ratings
    Configuration Management00 Ratings8.84 Ratings
    Work Execution00 Ratings9.34 Ratings
    Manufacturing Costs00 Ratings9.54 Ratings
    Supply Chain
    Comparison of Supply Chain features of Db2 and IFS Applications
    Feature
    Db2
    -
    Ratings
    IFS Applications
    9.1
    4 Ratings
    21% above category average
    Forecasting00 Ratings8.84 Ratings
    Inventory Planning00 Ratings9.54 Ratings
    Performance Monitoring00 Ratings9.03 Ratings
    Product Lifecycle Management
    Comparison of Product Lifecycle Management features of Db2 and IFS Applications
    Feature
    Db2
    -
    Ratings
    IFS Applications
    4.8
    4 Ratings
    42% below category average
    Proposal Management00 Ratings8.33 Ratings
    Product Master Data Management00 Ratings8.83 Ratings
    Best Alternatives
    Db2IFS Applications
    Small Businesses
    Amazon RDS
    Score8.1 out of 10
    Zoho One
    Score9.2 out of 10
    Medium-sized Companies
    SingleStore
    Score8.2 out of 10
    Zoho One
    Score9.2 out of 10
    Enterprises
    SAP IQ
    Score5.4 out of 10
    Microsoft Dynamics AX (discontinued)
    Score4.8 out of 10
    All AlternativesView all alternativesView all alternatives
    User Ratings
    Db2IFS Applications
    Likelihood to Recommend
    9.1
    (114 ratings)
    8.5
    (5 ratings)
    Likelihood to Renew
    7.9
    (12 ratings)
    -
    (0 ratings)
    Usability
    8.5
    (9 ratings)
    8.5
    (4 ratings)
    Availability
    9.3
    (64 ratings)
    -
    (0 ratings)
    Performance
    9.1
    (12 ratings)
    -
    (0 ratings)
    Support Rating
    8.9
    (6 ratings)
    1.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
    Db2IFS Applications
    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
    IFS
    Order to cash processes and scenario are implemented natively in IFS. An HR module exists for career management also (objectives, comportments, training, mobility) but may be improved in terms of workflow validation (e.g. training to validate by a manager) or reporting.
    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
    IFS
    • It supports the web version in most later versions.
    • It provides various mobile versions of the applications as mobile apps to cater various areas.
    • IFS Applications allows easy configurations of the application without going for costly customization.
    • It covers almost every areas of an industrial company so any other third party applications are minimum.
    • It allows safer and easier built-in options for integrations capabilities.
    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
    IFS
    • Handling massive volumes of data can be improved.
    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
    IFS
    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
    IFS
    The system is very difficult to use, overly complex, and difficult to learn. It also has limitations that are hard to overcome.
    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
    IFS
    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
    IFS
    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
    IFS
    We have been unable to get answers to our questions, solutions to our problems, and they don't seem interested in working in the construction industry.
    Read full review
    In-Person Training
    IBM
    the material was very clear and all subjects have been handled
    Incentivized
    Read full review
    IFS
    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
    IFS
    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
    IFS
    IFS Applications is based on Agile Technology which allows organizations to reconfigure user interface as per user requirements and make it user-friendly. Other applications are lagging on many fronts like User Interface, Online help document availability, Implementation methodology, and post-implementation expenses.
    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
    IFS
    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
    IFS
    • Reporting is now centralized and managed. Previously, reports were outside the information systems and there was a risk of incoherence.
    • Accounting controls are now in place on the overall processes, including production, which helped the company to reduce closing periods or to produce more easily official mandatory accounting files yearly.
    • Interfaces between the CRM forecast tool and IFS helped to keep the tools in sync, and to decrease the processing times prior to production launch.
    Incentivized
    Read full review
    ScreenShots

    Db2 Screenshots

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

    IFS Applications Screenshots

    Product screenshotProduct screenshotProduct screenshotProduct screenshotProduct screenshot