It's ease of use, administration, security, resilience, performance, stability, scalability, availability. Review collected by and hosted on G2.com.
It's not used enough! It's well-respected, but could do with more press! Review collected by and hosted on G2.com.
This is great for storing and organizing our client's data and gives the company the flexbility to use both files and tables as we cotinue to modernize our software platform. I use Run SQL scripts the most for accessing data so I can test my programs with different data sets. The DB2 database is perfect for the finanical and demographic data that is the backbone of our system. The system is very scure which is perfect for all the senistive data we have. Review collected by and hosted on G2.com.
It is a little on the slow side when prcoessing large amounts of records. Review collected by and hosted on G2.com.
As a long-time user of IBM Db2, using it for 15 years now, I've found several standout features that make it a reliable choice for our database needs. The stability of Db2 is impressive; it handles our high-transaction environment with ease. Scalability is a strong suit, allowing us to grow seamlessly alongside our expanding data requirements. Security features are robust, meeting our standards for protecting sensitive data.
The compatibility with various platforms makes integration smooth, and the support for advanced analytics and AI integration has been beneficial for deriving meaningful insights. The availability of comprehensive documentation and a supportive community ensures we can troubleshoot effectively and stay updated.
What stands out most is the flexibility in supporting both SQL and NoSQL models, giving us the freedom to adapt to different use cases. Overall, our experience with IBM Db2 has been positive, thanks to its reliability, scalability, security features, and continuous support and innovation Review collected by and hosted on G2.com.
My experience with IBM Db2 over the years has been marked by a notable gap in user-friendly tools, especially when compared to SQL Server Management Studio (SSMS). The absence of an equivalent tool has been a source of frustration, particularly in areas such as auditing, query tuning, and monitoring. The auditing feature feels outdated, requiring considerable manual effort. Query tuning lacks the streamlined approach found in SSMS, and the absence of a tool akin to SSMS's activity monitor means delving into scripts for essential reports.
In a landscape where many databases showcase activities through elegant GUI screens, the reliance on scripts for reports feels antiquated. Unlike SSMS, where obtaining an explain plan is a single click away, DB2 demands a more complex process involving plan generation, interpretation, and decision-making. Additionally, the use of Java for GUIs presents a performance challenge, with slow loading times.
This experience highlights a perceived stagnation in tool development for DB2, necessitating heavy dependence on the expertise of a DBA rather than leveraging tools for simplified day-to-day activities. While DB2 offers robust features, the user interface and toolset development seem to lag behind, making routine tasks more labor-intensive than they need to be. Review collected by and hosted on G2.com.
Extremely reliable DBMS with quality support.
It works with great encryption and decryption features.
Easy scalability.
Great connection between Cobol and db2
Queries and transactions in milliseconds. Review collected by and hosted on G2.com.
Some query syntaxes are different, but in a short time, it's easy to learn.
Licensing can be an issue due to the high value of the premium version. Review collected by and hosted on G2.com.
I am the certified database DB2 application developer. I am working in DB2 database at production side daily .
I am stunned with the vloume of data it handles and works seemslessly with webservices with different systems in real time basis.
As datastudio comes handy, there is no downfall at all now for DB2. Earlier you need to know mainframe a bit to access, but now its not the case Review collected by and hosted on G2.com.
none, I do not think of any. It now still embeds XML in a column. Its going strong. Review collected by and hosted on G2.com.