IBM Db2 pureScale on RHEL
IBM Software | 12.1Linux/Unix, Red Hat Enterprise Linux 8.8 - 64-bit Amazon Machine Image (AMI)
Reviews from AWS Marketplace
0 AWS reviews
-
5 star0
-
4 star0
-
3 star0
-
2 star0
-
1 star0
External reviews
External reviews are not included in the AWS star rating for the product.
DB2 version 11+ and it's support
What do you like best about the product?
We are the user of IBM DB2 since very early v7. v8, now we are on v11+.
This product after v11+ is amazing ------
* for very large DB (which we are using) the exteded compressed columnar-tables partitioned DB env make the BLU acceleration so fast that our DW's ETL (also IBM product) & Reporting so fast
* the workloads for OLTP are high balanced/improved that make all combined jobs have an average higher performance
* the Nested Loop Join (NLJN) made SQL-Merge so fast that a parallel sort using much less memory. Amazing.
* installation and migration become much easier with altogether software delivery.
* the security even more amzing that extended native encryption from local key store upgraded to enterpise level (with using Key Manager, KMIP)
* overall tech support are making sense. Not bad.
We are preparing to upgrade to DB2 v12. So far, we are overally satisfy this product with using other IBM DB management tool like Datastage (ETL) etc.
This product after v11+ is amazing ------
* for very large DB (which we are using) the exteded compressed columnar-tables partitioned DB env make the BLU acceleration so fast that our DW's ETL (also IBM product) & Reporting so fast
* the workloads for OLTP are high balanced/improved that make all combined jobs have an average higher performance
* the Nested Loop Join (NLJN) made SQL-Merge so fast that a parallel sort using much less memory. Amazing.
* installation and migration become much easier with altogether software delivery.
* the security even more amzing that extended native encryption from local key store upgraded to enterpise level (with using Key Manager, KMIP)
* overall tech support are making sense. Not bad.
We are preparing to upgrade to DB2 v12. So far, we are overally satisfy this product with using other IBM DB management tool like Datastage (ETL) etc.
What do you dislike about the product?
Still some bugs found with v11.1 (which mostly fixed in v11.5), eg. IT35682; IT39085; IT34931 we experienced. But IBM-Support clearly explained that and provied alternatives.
We hope IBM can develop some kind of GUI All-in-One management (Web based) software/platform for DBA (especially) just like Oracle-Enterprise-Manager. Though there are some 3rd-party software on the market like DBI for DB2 Gui management, we hope IBM can 'invent' own software that could be includeded into the DB2 database software itself (for save on licensing)
We hope IBM can develop some kind of GUI All-in-One management (Web based) software/platform for DBA (especially) just like Oracle-Enterprise-Manager. Though there are some 3rd-party software on the market like DBI for DB2 Gui management, we hope IBM can 'invent' own software that could be includeded into the DB2 database software itself (for save on licensing)
What problems is the product solving and how is that benefiting you?
All our Database/Data management needs are based on DB2. We are benefited for all DB2 functions for all our daily data management needs
- Leave a Comment |
- Mark review as helpful
TOP RDBMS, Werk er nu ruim 20 jaar mee en heb hier geen spijt van
What do you like best about the product?
Snel, betrouwbaar, voordurend in beweging
What do you dislike about the product?
De documentatie is niet altijd goed te vinden. Maar dit is meer een IBM issue voor al zijn producten
What problems is the product solving and how is that benefiting you?
Het opslaan van data in een duidelijke structuur en de alsmaar snellere toegangspaden
Makes my life as DB engineer very productive
What do you like best about the product?
Amazing features, speed and performance; the constant steady updates and enhancements from IBM; security it provides; interoperability with other DB's.
What do you dislike about the product?
I can't think of much, perhaps more easy access to information on features and examples when researching on topics.
What problems is the product solving and how is that benefiting you?
Hospital/healthcare system
Scalable, stable and just a dream to work with.
What do you like best about the product?
It is built on rocks and does not fail..
What do you dislike about the product?
Would be nice to have some built in monitoring and history.
What problems is the product solving and how is that benefiting you?
MFAAS
Db2 IBM
What do you like best about the product?
High availability, ease of use, ease of implementation, ease of integration and very stable
Also it has a very experienced support team and high performnace with few resources.
Number de features corrrect and quite frequently used by clients
It is a great product
Also it has a very experienced support team and high performnace with few resources.
Number de features corrrect and quite frequently used by clients
It is a great product
What do you dislike about the product?
Some problems with double byte characters
What problems is the product solving and how is that benefiting you?
Preparation of reports, dashboards. facilitate the use of data mining tools
Db2 warehouse (The best)
What do you like best about the product?
Column treatment greatly increases performance.
The container option is very well thought out.
The container option is very well thought out.
What do you dislike about the product?
It seems that IBM is abandoning it
The license is excessively expensive compared to the competition
If you put an MPP environment it is very very expensive
The license is excessively expensive compared to the competition
If you put an MPP environment it is very very expensive
What problems is the product solving and how is that benefiting you?
Analytical processes that previously took a long time to process and now take much less time
DB2 v12 for z/os
What do you like best about the product?
DB sharing group which give high availability
What do you dislike about the product?
Nothing bad with IBM DB2 for z/OS to say
What problems is the product solving and how is that benefiting you?
High availability
Excellent software but very very cumbersome administration and native administration tools
What do you like best about the product?
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
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
What do you dislike about the product?
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.
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.
What problems is the product solving and how is that benefiting you?
DB2 stands out as highly dependable software, showcasing exceptional reliability and robustness. Its ability to efficiently handle substantial workloads, including multi-terabytes of data, is a testament to its prowess in managing data-intensive operations with ease.
IBM DB2
What do you like best about the product?
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.
What do you dislike about the product?
It is a little on the slow side when prcoessing large amounts of records.
What problems is the product solving and how is that benefiting you?
Secure platform that can be partioned for use for our clients who reside in different time zones.
IBM db2 review
What do you like best about the product?
It's a robust and reliable database with tools to optimize memory usage and speed.
What do you dislike about the product?
For huge plans, BIND can take a while.
When the plan is in operation, the BIND process cannot occur.
When the plan is in operation, the BIND process cannot occur.
What problems is the product solving and how is that benefiting you?
Developers that wish to build a database without a database administrator (DBA) can use it.
showing 21 - 30