Db2

Excellent product, very manageable across multiple platforms, paramount in recovery and backups. It has an automated system with great features that allow data to be stored easily. We have this software that is the best base for the data for a load of a quantity of data. With this relational database tool, we obtain excellent service in the company with excellent achievements. It has a quality technical service that makes what seems complicated easy.

It has a fairly stable database server that is compatible with other tools, making this software the best on the market in terms of data systematization and control; it is fully manageable with multiple platforms making everything easier. With this nice feature tool, everything in the organization works better than before; but on the other hand there is the search problem, because the platform becomes slow at times.

The company has been using it for many years and I have been using it for just over 2 years. I feel the ease in obtaining the data. The solution can fit scenarios where there is quite a high workload and a low response time. Queries and transactions occur in milliseconds. Other backup/restore, replication and other features are fundamental and work exceptionally well. IBM is one of the most reliable companies and has been in the market for years in this segment and has helped us with support whenever we need it.

Its best suited where users want to create and predict with high-performance machine learning models inside data warehouse. The best feature is it can be integrated with the IBM AI: Watson for features and functionality. In helps the users perform real-time analytics and generate an instant report. However, prefetching and modelling of the data needs to be done at users end or in the different Db2 which can then be integrated again back here.

We needed to take backup of DB which is on remote location which is standby but currently HADR doesnt support backup of standby so Db2 was not well suited there and we ended up using storage level backup.

DB2 is well suited for most of IBM applications and is easily configurable. It's easy to setup and link applications to. Troubleshooting is easy as there are tools provided out of the box to diagnose and research day to day issues. DB2 has a simple design and somewhat lacks advanced functionality when compared to other mainstream databases.

If the application is based on data warehousing then Db2 would be the best choice to opt for as over more than a decade of my working with Db2 I have found it extremely robust in DW's. It has also performed exceptionally well in case of OLTP databases.

The product is very stable and can be used with large databases and complex queries. In addition, opening of ticket / request for support is easy.

I haven't really come across a scenario for RDBMS where Db2 is not very well suited. But then, I design and implement large scale, highly standardized, enterprise-ready estates with the goal of cost-effectively operating thousands of databases. I.e. my scope is rather on the infrastructure side than on functional details of Db2.

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 having to unpack the data.Performance of Hybrid Transaction Analytics Processing, or HTAP, is accelerated by Db2 BLU column storage with single instruction, multiple data, or SIMD, data skipping and skipping 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 information related to past, present and future time, as well as use time travel queries to visualize past and future data states.AI and machine learning (ML) capabilities, including the 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, not structured 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 24x7 availability.

If you are processing hundreds of thousands of transactions per second, and want each and every one to be consistent, then Db2 is your bag.

Db2 is great for any scenario where data is collected. One drawback is that the IBM machines it runs on are not very portable. When we needed to take our data to have on-site at a conference, we ported the data to an MS-SQL database running on a laptop.

It is good to in traditional transaction DB world. Not easy to scale out horizontally, but vertically.

Suited exceptionally well for Enterprise, not as much for the individual just needing a database. Not exactly beginner friendly but, I believe that is just tied to how complex a database really is, so I don't see it as a positive or negative. There are free tools for use with Db2, including IBM Data Studio. It's adequate, but not as intuitively put together as MsSS, nor most other 'consumer friendly' databases out there.

We were using DB2 to help reorganize our company's data to make it easier to retrieve and recover at a moment's notice in case of equipment change and/or data glitch. It helps me manage databases accurately. It benefits both end users and programmers since it helps you to work easier.

Db2 is VERY well suited for high volume, large scale production OLTP environments. Also, with the DPF feature, it can handle the largest warehouse databases as well.

DB2 has decades of history as a reliable and robust relational database. It may lack some of the latest features available on Oracle or SQL Server, but it is still a great tool to store huge amounts of relational data and be able to access it in a simple and efficient way.

IBM offers a good variety of database choices like DB2, MongoDB, Redis, etc. If you want some database to use quickly but don't want to spend time on setting things up from scratch and don't want to spend efforts on daily operations, IBM Cloud Databases would be a good choice.

In our experience, some database service offers more than one URL, so our application needs to handle the failover.

It is well suited for data ingestion and especially when we need third-party support. Also extensively use it in integration and deployment stuff.

IBM Db2 provides [the best] solutions for cloud database management with zero [downtime]. It provides auto-scaling based on requirements, for example for [a] specific period of time, [the] number of users could increase, and decrease, [At] that time we can set auto-scaling without affecting database availability. IBM Db2 on Cloud provides [a] console, where we can execute queries on the go. Though it is secure, still It is not suited for those who [have] security reasons like if they don't want to transfer data outside their organization, because your data will be in cloud.

It is very easy to install and get started quickly and the ability to store data in a different location and access it in another location makes it very convenient for our users. Great platform with back-ups and recovery features and the high security for our data is assured when storing on this platform.

Db2 on cloud is a very good way to introduce ourselves into the database environment located in the cloud, since it provides a great level of versatility, flexibility and security, which can translate into a better performance of the productivity of our systems and therefore from our department.

Db2 on Cloud should not be taken lightly as it has a medium level of complexity when installing and configuring its implementation

It is a great product. It can be used by new as well as experienced developers to create a database instance without any assistance from DBA. We are using it with our IoT based ERP system. It can also be used by Analysts who want to build databases from scratch in no time.