IBM Db2 Reviews

Pros

IBM DB2 provides the low latency and high data availability, It provides automatic scaling and high security for the large volume of data. It is robust No matter how much amount of data is, IBM DB2 will never fail.

Cons

IBM Db2 is a bit expensive and not all the SQL standards available in the IBM Db2

Pros

The main project that made me involved in working with DB2 is a transactional concurrency benchmark that compares IBM DB2 to Oracle 10g RDBMS. The benchmark results demonstrated high scalability and availability properties in DB2 but the TPS measures showed a better performance of Oracle 10g on HP ML350 servers. DB2 supported better concurrency in bulk data-intensive SQL queries but lagged in computation-intensive tasks.

Cons

The programming language support is definitely something that needs improvement in addition to cloud integration and deployment tools. Many other commercial RDBMSes (such as Oracle) are leading ahead on this front. OS support, such as testing OS X platforms, can be also better provided in DB2l

Pros

It was one of the best when I used to work with it. Till Microsoft SQL Server, Oracle & SAP came along. There are many companies still using legacy database systems. What IBM builds, they build to last.

Cons

I miss DB2. It was one of the most solid products.

Pros

Db2 was used in our mainframe application. it accepts standard sql syntax. can handle large amount of data.

Cons

As data grows in production environment, it becomes slow. Thread hung and application performance degrades. Also it's costly.

Pros

DB2 HAS A SERIES OF TOOLS THAT ARE DIFFERENTIAL, BUT HIGHLIGHTING THE CAPACITY OF SELF-MANAGEMENT (PARAMETERIZATION) AND DATA COMPACTION. ARE STRONG POINTS TO CONSIDER.

Cons

The acquisition cost can be a hindrance in the acquisition negotiations.
Support is also a weakness for the cost, forcing the use of DB2 communities for troubleshooting.

Alternatives Considered

Reasons for Switching to IBM Db2

Pros

Db2 scales very well AFTER a certain point. Support is excellent, it's easy to get stood up once you have a feel for what you're doing.

Cons

Scaling: for instance it won't run on small machines too well. This becomes important if you're running a local copy for development or testing. There is a free Community Edition to play with, but can't take advantage of tons of ram or CPU, but good for POC.

Pros

Easy database Implementation easy administration can be managed from any station the level of specialization is much lower than any other database, robust and recovery by indexes, interconnects with other databases such as Sql Server and allows data sharing in Immediately, its level of robustness and integrity is unique.

Cons

Proprietary database, requires a lot of Hardware for its good performance and its costs are high.

Pros

I have been using this product in our company for a long time as Database-as-a-Service on our cloud for different requirements such as storing and even manipulating data safely with timely availability. This product has been providing services that help in storing and running all the problems in order to evaluate the data. This tool allows us to modify the processing speed of our company’s data just to enhance the overall user experience. Moreover, I am a frequent user of this tool and having great experience of this tool.

Cons

I felt there is a storage capacity problem which sometimes makes it difficult to check the effectiveness of the entire database.

Pros

IBM DB2 gives a start up point for a student to learn databases. All the features a DBMS have are provided by DB2. The product supports almost any front-end application that requires database. All the drivers are provided as you setup a connection to an application.

IBM DB2 is not limited in learning SQL scripts. You may initiate also database back up and security, XML, stored procedures, and user-defined functions.

Cons

IBM DB2 is a high-secured database server. You may be lost in the installation process if you missed one of its steps. If you experience failed installation, uninstalling it may not fully do the trick. You need to delete folders or directories it has created during installation.

Pros

It is very easy to install, use, it can be used for small and large projects, there is a lot of documentation about DB2, and the support they offer is very good, as long as you have a good license.
I use it mainly for the execution of databases distributed in a banking project, its performance is very good

Cons

the bad thing that I see, is that you have to acquire a business license to use your maximum potential, apart from that there is also use IBM hardware, otherwise many conflicts are created

Pros

- ACID compliant like any good RDBMS (Oracle, MSSQL, SAP HANA)
- Runs well and scales well on IBM's Power-based platform, and commodity x86 hardware running Linux/Windows
- Various editions to suit customer needs and requirements. For example the Developer Edition is fully featured and is completely free for developers to use, or all the way to Enterprise Edition for state-of-the-art functionality (In-Memory based Columnar Tables thru its BLU functionality, High-Availability, Disaster Recovery etc. to prevent Single-Points-of-Failure). Rivals the existing enterprise RDBMS's

Cons

- Even though there is a GUI for point-and-click administration (IBM Data Studio), to really flex the database's features and functionality command-line tools are required (like Oracle :-)

Pros

Use it if you are using a Mainframe OS.
The navigation is not too complex considering a minimalistic UI.

Cons

The query speed and result retrieval is a pain point. May be they can introduce an instant results UI page on the Mainframes.

Pros

In my employed role we use DB2 for warehousing, marts and as simple data stores. It is an integral part of back and metadata for Cognos and DataStage. It was simple to install and by default comes as self managed.
We also deploy this for hosting customer data and integration with net backup, ha solutions and job scheduling is industry standard.

Cons

Vendor can be a little hard to work with on issues, getting the required information can be a drawn out process when trying to fix a live issue. This has improved over the years and support is more flexible in investigating while reports are generated. Functionality is competitive, but bleeding edge features (NoSql) can lag behind others.

Pros

It served its purpose in its time but I think that time is past. It worked well for our mainframe and from COBOL but has been replaced by bigger and better things.

Cons

The way the schemas are defined is confusing

Pros

Installation is very easy and when installed it's ease of use, very convenient. It's also very easy to connect to other tools like DBVisualizer which gives another way of viewing the tables and info.

Cons

They need to improve the help online to find some commands, and the explanation on the commands as well.

Pros

1) DB2 is very cheap, easy to install. We don't have to worry about license costs as they wouldn't be more than that in Oracle.
2) It can run on any OS like windows, Linux, Mac.
3) We can use DB2 along with XML data also.
4) The retrieving of data from the db2 database is very fast which is actually a very good feature.
5) Can store large files in the database in an easy way.
6) We can store the data in different locations across the data and the data can be accessed from different locations in a faster way.
7) Index feature is available in DB2 to identify a unique table out of thousands of tables in DB2 database.

Cons

I didn't find any flaws using this software.

Pros

As of now ibm db2 database is the best provided by IBM technology which have best costumer support and best recovery system where need not to wait long time best resolving any issue are given as fast and can and easy to handle and use

Cons

there no least in IBMdb2 which has the best over all experience ever has has the best user experience till now

Pros

1) DB2 has extensive functionality, has a lot of built-in features. robust database software
2) easy to use, and MPP systems which make the system to process data parallel.
3) DB2 SQL is anscii standard so migration to/from other databases would be easy.

Cons

1) expensive compared to other solutions available in market.
2) Few of the DB2 specific syntaxes are non convertable when we move to other databases.

Pros

This database engine is robust, with many tools and features.
Easily upgraded.
Minimal maintenance needed after it is up and running.
Able to use either the command line interface or GUI to access and manipulate databases.

Cons

Documentation needs to be more extensive, as you have to pay for customer support.
Takes quite a bit of getting use to, as syntax varies greatly from other DBMSs.

Pros

This can hold n number of records and easy to access it via online application and updated using the informatica

Cons

The application looks and query are bit complicated compared to SQL

Pros

DB2 is very versatile, and can be used to drive the processing in your software.

Cons

Too many abends using the product, and too hard to diagnose.

Pros

Our card system is in ibm db2 database and super powerful and never the instance has presented problems.

Cons

Sometimes not all applications are compatible with this database.

Pros

Easy to integrate with any API with minimal configuration

Cons

Searching large amount of data might take time, indexing strategy could be better

Pros

Supported on multiplatform like AS400, Linux, Windows. A good choice if you work across these environments.

Cons

Having worked on over a dozen different databases, the thing I hate most is having to REORG my tables weekly so that my DB doesn't slow down.

Pros

DB2 is solid as a rock. I'm using it from several years and with last release 11.1 it's been also easiest to be set up from newbie admin. DB2 is the classical server you will setup and you fill find again after years.

Cons

It's not economic and needs some education to be used in production environment.