Overview
What is Db2?
DB2 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.
IBM Db2: Performance Powerhouse.
Db2 an Efficient DB Scale and Management Platform!
Love Having and Working on Db2 for z/OS
Highly Available and Scalable Relational Database
Db2 Review
IBM Db2: A Powerful and Reliable DB Management Solution
For a long time, IBM DB2 has proven reliable.
Db2 is good for you....
Db2 for for manage enterprise data
Reliable database platform with good support.
Db2 - a solid offering for data
We then …
DB2 review.
Db2 for enterprise scaling.
Driving API Excellence: Exploring the Dynamic Capabilities of IBM Db2 in Empowering Scalable and Resilient Backend Databases
Awards
Products that are considered exceptional by their customers based on a variety of criteria win TrustRadius awards. Learn more about the types of TrustRadius awards to make the best purchase decision. More about TrustRadius Awards
Reviewer Pros & Cons
Pricing
Db2 on Cloud Lite
$0
Db2 on Cloud Standard
$99
Db2 Warehouse on Cloud Flex One
$898
Entry-level set up fee?
- Setup fee optional
Offerings
- Free Trial
- Free/Freemium Version
- Premium Consulting/Integration Services
Product Details
- About
- Integrations
- Competitors
- Tech Details
- FAQs
What is Db2?
IBM Db2 empowers developers, DBAs, and enterprise architects to run low-latency transactions and real-time analytics equipped for the most demanding workloads.
From microservices to AI workloads, Db2 is a hybrid database providing availability, built-in refined security, scalability, and intelligent automation for systems.
Availability
Mission critical environments require continuous availability and tolerance for failure. Db2 availability enables users to run workloads without interruption.
Built-in security
Db2 protects data with in-motion and at-rest encryption, auditing, data masking, row and column access controls, and role-based access.
Scalability
Db2 grows with users, scaling up and out as workloads evolve and performance needs change.
Automation
Built-in container operators automate time-consuming database tasks, while keeping the business running. Users can build apps while using Db2's advanced workload management automation and ML-optimized query engine.
Db2 Integrations
Db2 Competitors
Db2 Technical Details
Deployment Types | On-premise, Software as a Service (SaaS), Cloud, or Web-Based |
---|---|
Operating Systems | Windows, Linux, UNIX |
Mobile Application | No |
Frequently Asked Questions
Comparisons
Compare with
Reviews and Ratings
(207)Attribute Ratings
- 8Likelihood to Renew12 ratings
- 8.7Availability51 ratings
- 9.1Performance11 ratings
- 8.7Usability7 ratings
- 6Support Rating6 ratings
- 8.2In-Person Training1 rating
- 9Implementation Rating2 ratings
- 9.1Configurability1 rating
- 8.7Product Scalability51 ratings
- 8.2Ease of integration1 rating
- 8.2Vendor pre-sale1 rating
- 8.2Vendor post-sale1 rating
- 9Data Sources1 rating
- 8Data Sharing and Collaboration1 rating
Reviews
(1-5 of 5)Db2 is good for you....
- manageability
- monitoring
- easiness of use/administration
- TSA and integration of other products
- makes follow up easier and we can act faster in case of problems discovered
- flexibility
- db2 in the cloud
- Integration with Other Systems
- Ease of Use
- Implemented in-house
- none
- In-Person Training
- installation
- database generation
- integration
- none discovered
- IBM data replication
- none
- to have a supported version
- none
Reliable database platform with good support.
- Reporting and analytics.
- Data storage.
- Data retrieval.
- Search speed needs to be improved; it's quite slow.
- Overall, this product has nifty features that work seamlessly with top-of-the-line technology.
- Storing blobs.
- Low license administration cost.
- It offers an integrated and secure data storage service.
- This service is very easy to manage and costs are low, it also offers advanced security.
Marketing
HR
DBMS
Data Modeling
- Scalability
- Reliability and Availability
- Cloud Transformation
- Data visualisation
- AI/ML for trend analysis
- Greater integration with our 3rd party partners
- Scalability
- Integration with Other Systems
- Ease of Use
- Enterprise Data Warehousing.
- Create efficient machine learning models.
- Unified and controlled data layer access.
- Support can be tricky
- Performance is slow
- Cant connect to many systems
DB2 is Good
- DB2 has build in replication tools make online data replication/movement much easier and fast.
- DB2 HADR is reliable, keep Database up and running 99.99% of time, switch beween servers in seconds.
- DB2 Federation make the access to all kinds of Databases like in one.
- DB2 is stable on Linux/AIX even Windows.
- DB2 Locks is too strict, very little flexibility
- Like to more built-in function, procedure for Analysis/Reporting
- Love to see DB2 can go open source, so that it can get more developer involved
- DB2 is holding very important company data and critical application is running on DB2.
- Flexible License make the deploy to Developer desktop/VM very easy.
- For developer from other vendors, not easy to write efficient query.
- Old way of using snapshot to monitor db create unexpected latch after DB upgrade, causing slowness when traffic high.
- Have to develop new script
- Moving to Cloud
- Scalability
- Implemented in-house
- very smooth as we have active-active data center
One time is we have some clob function fail on spanish chars, end up we need to re-create db in unicode instead of iso8809
- from db2top to dsmtop to dmctop, all very convinient
- dmc is bit heavy, but give you history
- NA
Optimize your Database Applications with DB2.
- Unparalleled availability 5 9's.
- Optimization of application data utilizing machine learning and AI.
- Provides simplistic step by step tablespace generation.
- Learning curve. It takes time to learn Db2; I'll be quite frank: no one can come in without any knowledge and start working with it.
- Database tuning at times can be time consuming and cumbersome.
- Training can be very convoluted for someone with little experience, can be very daunting.
- Initial Cost.
- Maintenance Renewal Costs.
- Costs are based on the number of virtual processing cores. It can be expensive based on the number of cores utilized in the environment.
- Oracle Cloud Platform and Oracle Cloud Infrastructure Identity Access Management (OCI IAM)
- Performing technical maintenance in general
- Programming
- Cloud usage is really nice as you can scale out as needed, elastic
- Initial learning and becoming familiar with DB/2 can be very complex it takes a while to learn it
- Programmers have difficulty at times with maintaining tablespaces, house cleaning for lack of a better term
- Tablespaces if not programmed correctly can result in jobs running for days so you need to understand how to code with DB/2
IBM DB2 - love it or leave it - It's binary
- DB2 maintains itself very well. The Task Scheduler component of DB2 allows for statistics gathering and reorganization of indexes and tables without user interaction or without specific knowledge of cron or Windows Task Scheduler / Scheduled jobs.
- Its use of ASYNC, NEARSYNC, and SYNC HADR (High Availability Disaster Recovery ) models gives you a range of options for maintaining a very high uptime ratio. Failover from PRIMARY to SECONDARY becomes very easy with just a single command or windowed mouse click.
- Task Scheduler ( DB2 9.7 and earlier ) allows for jobs to be run within other jobs, and exit and error codes can define what other jobs are run. This allows for ease of maintenance without third party softwares.
- Tablespace usage and automatic storage help keep your data segmented while at rest, making partitioning easier.
- Ability to run commands via CLI (Command Line Interface) or via Control Center / Data Studio ( DB2 10.x+) makes administration a breeze.
- You cannot run multiple secondary nodes or cluster without additional software purchases; in some cases third party tools. This drastically increases your overall capital investment. The only way to accomplish a true HADR scenario is to set up NEARSYNC in one datacenter and do logshipping to another datacenter. Downside: You have to wait for the final log ship to complete before your DB is back up.
- Licensing is prohibitively expensive! If you are not grandfathered in, IBM licensing for a multi-datacenter, PRIMARY, SECONDARY, and Disaster Recovery (DR) setup can be in the multiple $100,000 range.
- Data Studio is built on IBM's Rapid Application Development (RAD) tool, built on Eclipse. So the download is in the multi-GB range and it includes a ton of bloatware not needed for your standard database maintenance. Control Center is a simple, powerful tool at a quarter of the disk space.
- Support for DB2 is very hard to come by without paid IBM support. Even then, opening PMRs does not solve problems as the response time for any PMR is always more than two (2) hours, even for enterprise-level paying customers. They always want the most inane log files that have nothing to do with DB2 or its operation, or they want core dumps during the issue. This becomes useless when the issue is "our database just crashed and you can't get those logs right now because I do not want to replicate the cause!"
- DB2's SQL syntax, while ANSI in CRUD opertaions, is different than Oracle. PostgreSQL, MySQL, and even MS SQL. One must become accustomed to a different syntax for LIMITs, cursors, record counting, stored procedures, user-defined functions, and even table / index creation or altering.
If you are running websites or web services with it, then maybe it's time to investigate a newer, easier to use technology.
- We inherited DB2 as a standard database platform when our company was founded, so we have been stuck with it. There are only negative impacts on the use of DB2.
- We cannot find qualified candidates to help support it. You will occasionally receive a résumé of someone with DB2 experience, but they have either never run it in Linux or without a GUI, never run it via command line, or has only a very basic understanding of DB2 administration.
- Licensing always continues to increase year-over-year.
- ANSI SQL.
- Control Center
- Task Scheduler
- DB2 Registry values when initially working with a database.
- DB2 Command Line Interface when using a DB2INSTANCE
- Moving a database or instance from one server to another is particularly challenging, especially when using multiple partitions and tablespaces.