TrustRadius Insights for Db2 are summaries of user sentiment data from TrustRadius reviews and, when necessary, third party data sources.
Pros
Ease of Use: Users consistently praise the database for its intuitive interface and straightforward administration processes, such as backup, restoration, and monitoring capabilities, enhancing operational efficiency. The simplicity of tasks like data management allows teams to focus on core business activities.
Security Features: Many reviewers have highlighted the database's robust security measures, including encryption, access controls, and auditing functionalities that ensure secure data handling and prevent unauthorized access. This level of security instills confidence in users regarding data protection.
Performance and Scalability: Users value the database's efficient handling of large data volumes, effective query optimization capabilities, and seamless integration with external services like ERPs, contributing to enhanced performance and scalability. These features enable businesses to adapt to changing needs while maintaining optimal performance levels.
Loading Reviews List....
Db2 Reviews
7 Reviews
Small Businesses (1-50 employees)
Search is temporarily unavailable. Filters are still applied.
Because Db2 is scalable, it can be used by both big and small businesses with different types of data requirements. To obtain data and test my applications using various data sets, I primarily utilize SQL scripts. The financial and demographic data that form the foundation of our system are ideal for the Db2 database. With all of our sensitive data, the system's security is ideal.
Pros
Reliability and Availability
It has Advanced Analytics
Security features are great
Cons
UI can be improved.
It has learning curve.
Less Integration options
Likelihood to Recommend
IBM prioritizes availability and dependability in Db2, which makes it a strong option for applications that are mission-critical. Our business clients required a highly accessible database system that could grow with them easily. Although there were other possibilities, IBM Db2 offered smooth query execution and multi-cloud capabilities. This solution proved to be steadfast due to its potent performance and IBM Db2's dependability.
I'm a fan of IBM technology, I'm currently studying systems analysis and development, as I'm studying data science I needed to look for a relational database based on SQL where I could store my data. At the moment I use DB2 for studies so I opted for the DB2 Community license, it is simple and free.
Pros
Storage optimization
Rapid database development
pureScale technology, which focuses the database on availability and scalability
Simplicity and security when performing migrations
Ease and flexibility in implementation
Cons
The relational model requires a rigid schema that does not necessarily fit with some types of modern development.
Proprietary database, requires a lot of Hardware for its good performance and its costs are high.
As data grows in production environment, it becomes slow.
Likelihood to Recommend
Db2 offers many advanced features to improve data and database management. Actionable compression can save storage space without sacrificing performance. Many query predicates can be evaluated without needing to decompress the data. Hybrid Transaction Analytics Processing, or HTAP, performance is accelerated by Db2 BLU single-statement, multi-data, or SIMD column storage, data skip and skip technology on LUW platforms, and the IBM Db2 Analytics Accelerator on z/OS. A DBA can build a temporal database using Db2 to allow system and business changes to be captured, maintained, and queried. This allows organizations to store past, present, and future time-related information, as well as use time-travel queries to visualize past and future data states. AI and machine learning (ML) capabilities, including augmented data explorer, offer natural language query capabilities, an ML query optimizer, and a hybrid data management platform to enable seamless sharing of structured data, unstructured and semi-structured. The choice of deployment model includes on-premises hosted cloud deployment or managed cloud deployment. Db2 on LUW platforms offers an Oracle SQL compatibility option. Db2 for z/OS enables organizations to run mixed workloads with exceptional scalability, high performance, and 24/7 availability.
In our organization, DB2 is being used as a database for our mobile app. We also use it for querying data for business analytics and marketing analytics insights. This is used in multiple departments in the organization. It allows us to generate reports for meeting with investors. It solves the issue of warehousing our customer data.
Pros
Business Analytics - facilitates data query to generate reports.
Integration - can connect with other software.
Easy - easy to learn and implement if you know SQL.
Cons
Database can run faster.
Likelihood to Recommend
DB2 is suitable for various uses. The big use case is an online database where users can make online queries and generate batch reports.
VU
Verified User
Analyst in Research & Development (1-10 employees)
I will be writing about DB2 for i. That is the name for the DB2 version that is tightly integrated with the IBM i operating system. Not to be confused with DB2 LUW (Linux Unix Windows) or DB2 for z/OS. That those three DB products share the name leads to confusion regarding syntaxis, capabilities, and interoperability.
Customers that use IBM i leverage all the features of the DB even when they don't realize it. Since the DB is part of the OS, everything lives there.
A tape drive? an object in a library. A customer record? an object in another library.
This DB engine has decades of code behind it but it still manages to keep up and innovate with new features at each release.
DB2 for i doesn't require as much administration as the other kind of databases since the system has some leeway to auto-tune itself. Even then, what IBM recommends is a Database Engineer and not a DBA, since they don't really administer the DB but work with the developers to ensure optimal performance out of the system.
Pros
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.
Cons
Marketing. Sharing the DB2 name between LUW, z/OS and i (which is a product for another review) is a search engine nightmare.
Likelihood to Recommend
DB2 for i is well suited for most backbone workloads, especially those that need very high availability. Some customers might use DB2 for i as the main DB serving data and microservices. Others might have entire application stacks running on WebSphere Application Server or even on PHP.
It is a robust, high-capacity database that can support high workloads for high-availability scenarios.
es una base de datos robusta de alta capacidad de poder soportar altas Cargas de trabajo para escenarios de alta disponibilidad.
Pros
robust
robustes
Likelihood to Recommend
I recommend it 100%
lo recomiendo 100%
This review was originally written in Spanish and has been translated into English using a third-party translation tool. While we strive for accuracy, some nuances or meanings may not be perfectly captured.
I mainly use Db2 for managing large volumes of employee data from multiple sources like ERP and payment software. Db2 is the best tool for integrating with BI tools like PowerBI and Excel and I use it daily for reporting, automations and querying.
Pros
easy integration with Db2
advanced security features like encryption and user roles, so I don’t worry much about data leaks
the Express version is great for small businesses and still works well with all tools
Cons
the design part of the view sometimes returns errors while the query works successfully
some tasks are complicated
sometimes I came across compilation errors
Likelihood to Recommend
It’s reliable, stable and handles huge datasets without breaking, even setting it up is straightforward, and you get help from support or the community easily.
It is a database that is used for storing information with real time analytics and low latency transactions. We use it in many of our projects to store data for better performance as compared to other SQL databases whenever the project requirements are leaned more towards using a SQL database as compared to NoSQL, the Db2 is out go to preference for it.
Pros
faster data fetching
safer transactions
better indexing
Cons
could be better in terms of scaling
less migration options
could include JSON related indexing like in Postgres
Likelihood to Recommend
It is well suited when the project requires a SQL database and a database with faster retrieval of data and safer transactions is needed, if the project leans a lot on JSON related fields and it is required for the data be dependant on JSON indexing, I'd say avoid it altogether.
