TrustRadius
DB2 is a relational database software solution offered by IBM.https://media.trustradius.com/product-logos/Pl/TO/6MZVJJK89QMG.PNGIBMGreat Product, with a Terrible Name2018-12-26T14:23:21.883ZThis review will be for Db2, which is the distributed version, running on Linux/Unix/Windows. The fact that IBM has a separate product called Db2 (for z/os) is totally unfortunate and extremely confusing. We run Db2 off zLinux guests, which are virtualized off our mainframe. These databases support a variety of applications, the most important being that it handles each and every card swipe that is done by one of our members. This is thousands per minute, 24/7. We also use Db2 as a repository for a few applications, and as a gateway between the mainframe and our legacy Oracle databases. This portion is called Federation Server.,Simplicity. It's way easier to maintain and administer than its red counterpart.
Avoids the terrible GUI trap of its contemporary from the Seattle area. Command line access is wonderful.
HA/DR works well out of the box, and we also use block-level replication for DR, which is a huge benefit.
Stability. I hate to bring a curse on myself for saying this, but Db2 itself is extremely stable and we keep incredible up time.
Supports some of Oracle's SQL
Tight-knit community.
Support is fantastic.,IBM is really behind in delivering developer tools. They pride themselves on Data Studio, but it is just frustrating.
Marketing. Horrible to do a Google search and get returns for a COMPLETELY different product, for z/os. Why they share the same name is beyond me. Better marketing would also increase the user base and help the product mature.
Slower than the competition to roll out next-generation features.,8,Hard to calculate, given the bundled pricing. Virtualization from the mainframe IFLs saves us considerably.
Management tools like Data Server Manager are great and FREE. Other vendors charge big bucks for those.,5,9,10,Oracle Database, Oracle Database 12c, Microsoft SQL Server and MySQL,Oracle Database, Microsoft SQL Server, SQL Server Integration ServicesVerified UserA business must have DB2 as their DB to be always up and running.....2018-06-21T15:08:15.470ZWe use DB2 as a database for our enterprise customers as part of their SAP system landscape. One of our Diamond clients uses it for their critical landscape and we provide the implementation and support for the landscape. DB2 is best suited to enterprise businesses who want a low cost, low maintenance solution for improved transnational DB queries to fulfill the business requirement on a frequent basis.,It's best for use in a BW landscape for reporting purposes where you need fast data fetching. As compared to other traditional DBs, I feel DB2 is lightweight and less complicated.
Easy DB administration, and requires less administration.
Easy in version as well as FP upgrades.,Our DB is almost 4 TB in size. So we feel that to manage such a huge DB, DB2 should provide some more user friendly and easier GUI base administrative tool, looking at the current competition in market for their DBs.
There is definitely a bit more improvement required in data manipulation and query languages.
Stability for an HA kind of environment is one of the key areas for improvement.,9,Positive - Very good performance as compared to other traditional DBs.
Positive - Transaction and query search are made easy from a DB level with good performance, also runs on top scape on AIX servers.
Negative - There is always room for improvement, such as Webex queries and the GUI base tool. Also the available support documentation should be improved.,10,9,9,Microsoft SQL Server, Oracle Database and SAP Sybase IQ,SAP CRM, SAP HANA, SAP S/4HANA, AWS Lambda, Amazon S3 (Simple Storage Service)Pradeep BeleDB2 is great for BI2018-04-03T22:25:39.924ZDB2 is being used as the database software for our financial core software. We also use it to query data for business intelligence. This is used by the whole organization and will allow us to pull reports based on requests. The software is easy enough to use for anyone that has SQL experience and I feel like it is responsive and quick.,Business intelligence - Allows for querying of the data to create reports
Flexibility - It scales based on your need
Robust - Can connect with reporting software such Crystal Reports to build even prettier reports.,For those unfamiliar with SQL, it will be a sharp learning curve,8,Makes my executive team happy because we can get the data out of the DB
Has allowed us to pursue targeted marketing the because the data is there.,8,9,10Josh Rice, MBA, ACSPA database that guarantees the company for the future2018-03-26T22:56:55.886ZCertainly from the whole organization: the product is used by all the ICT departments, by the departments that develop the applications and by the departments that manage the systems. Business departments use data to create dashboards or reports using Cognos automatically. The fact that it is multiplatform allows us to decide from time to time at what level the database must reside.,Easy to use with SQL programming
High availability
An extreme certainty of the data,High consumption of mainframe processor
Use of the plan for data access too rigid
Use of very limiting DRDA gateways,10,high quality cpu consumption
delicate management of recovery through the log
necessity of constant maintenance through utilities,10,10,10,oracle, vsam and dl1,IBM CICS, IBM Tivoli OMEGAMON, WebSphere Application ServerVerified UserDB2 easy access2018-06-27T15:05:24.822ZWe are using DB2 in our IT department. It's used as a back-end tool and specifically, we highly leverage the DB2 client tool to connect to IBM IAccess to do data connections to feed other inventory tools.,DB2 provides a strong command line interface
Very resilient DB connection
Integrated very well with IBM product,Maybe they could have a simple UI interface similar to MSSQL management studio,8,Positive, as it provides simple and stable data access to multiple other systems.,9,9,9,Microsoft SQL Server,Microsoft SQL Server, Microsoft Azure,100,2,Data access
Data portability
Data Availability,Standard use,For us, the use case is pretty set.,8,No,Product Features,Do it in-house instead of relying to a greater extent on the consultant recommendation.Verified UserDB2 does what it needs to do2018-04-03T21:29:01.718ZIt is used as the database for our ERP system that is utilized by the entire company. It addresses our need for stability and performance from our main source of data.,It is stable
It runs well without active DBA management
It performs well when we need it to,Does not have the most sophisticated features
At its core it utilizes IMB "green screen" interface,9,We do not have downtime related to database issues,9,9,10,,Oracle JD Edwards EnterpriseOne, Microsoft Project, Microsoft Office 2016, ConnectWise Control (formerly ScreenConnect), OneNoteVerified UserDB2 Review. Short, hope that also helps...2017-10-11T15:15:14.288ZIt's used at the department level, but queries can be run by the whole organization.
Front end application databaseMixed OLTP-OLAP databaseLoan IQ Main database (where Loan IQ is the worlds leading software solution for loan servicing),Sturdy and fault tolerant
Fast
High parametrization,Client tools need to be improved.
Documentation needs to be improved,9,Best performance with high durability.,8,9,8,Microsoft SQL Server and MongoDB,Oracle Database, Microsoft SQL ServerJose YohnDB2 eats data for Lunch!2017-10-10T19:31:40.045ZWe use DB2 to run our entire SAP Landscape,Minimal administration needed compared to other enterprise database products in the market
Performance has been exceptional and improved with every version
The reliability of the DB2 engine is probably it's biggest asset,The Oracle compatibility feature stopped short of providing a listener type connection so applications could have been agnostic to what database it was running.,10,Using the SAP / DB2 licensing model, we saved over a million in licensing fees over the competitor.,10,10,10,Andrew JuarezDB2 LUW Purescale/DPF2017-10-10T18:18:59.762ZIt is used for reporting, analytics and also for critical clinical applications.,Reporting using DPF.
Purescale for scalable and highly available critical applications.
Cost effective solution compared to other vendors.,Optimizer - sometimes we need to force the right access plan.
Support staff needs to engage more effectively by using WebEx/phone instead of emails.
More compatible functions to ease migration from other platforms.,10,Positive returns by retired legacy EMRs,10,10,10,SAP Sybase IQ, Sybase Replication Server and SAP Adaptive Server EnterpriseVerified UserIBM DB2 - love it or leave it - It's binary2015-12-08T20:20:32.288ZWe currently use DB2 as one of our major database platforms across the organization in multiple different capacities. We have it in different environments, use it for testing of new software features, and use it to support legacy software. This software addresses the need to support legacy Java with the technology of a robust mainframe.,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.,3,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.,Microsoft SQL Server and MySQL,MySQL, Microsoft SQL Server, WebSphere DataPower Gateway, WebSphere Application Server, Microsoft IIS, Apache Web Server, F5 BIG-IP,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.,No,5J.R. BullingtonIBM-DB2 for an Enterprise - one of the robust RDBMS in the market2016-02-16T16:49:57.722ZDB2 is the primary relational database being used in our organization both on z/OS and linux platforms - it is used across the entire organization and is being used to store information on transactions in financial, customer, purchasing environments,Is platform specific to Z/OS, Linux, Unix and hence can be leveraged in a customized manner
Error handling is the most important feature with warnings
Very robust database performance in the SQL schema
Allows shared access to the database using LAN in remote branch offices,DB2 for Unix has definite room for improvement when compared to competition
GUI can be much better than what it is now
Data base engine can be faster,8,It is very robust and hence [provides] value for money
Also has a free version that is very robust for a smaller organization
Used a centralized DB2 database across the organization and hence saved infra investments,Oracle,Microsoft Access, CouchDB,2000,5,Primary data base for mission critical applications.
Runs on both Z/OS and linux platforms for us.,Can be scaled to a limited extent
Complex SQL error warning,Evaluating usage on Unix,8Shiv ShivakumarDB2 LUW PROS and CONS2017-04-14T15:39:56.024ZWe use db2 for all our in-house developed applications and for any vendor application. If it supports db2 it’s the first option we go with. We use it for OLTP, OLAP and also mixed workloads. We also implemented db2 pureScale for an HA solution which has 2 nodes on each data center.,Less administrative overhead
Easy upgrades
Easy maintenance,Support
Stability
Benchmarks
Product should work as it is advertised,9,As I recommended PureScale was disappointing
Stability is the key for success, after v8.2 none of the versions were stable enough
Positive thing is that db2 can recover from failure very well compared to other products out there,ORACLE, PostgreSQL and SAP Sybase IQ,Microsoft SQL Server, SAP Sybase IQ, Sybase Replication ServerVerified UserDB2 LUW Review2015-12-18T20:35:57.914ZWe use DB2 as one of the backend databases for both internal and customer facing applications at Dealertrack. It does not address a business problem as such, rather using DB2 provides a stable, fast and feature full database to store data. The DB2 database platform provides recoverability, uptime and good performance for the applications using it.,High level of query fulfillment. One of our applications uses the DB2 database to serve up about 16k to 20k queries per sec at peak, the majority of which execute in less than a few microseconds.
Stability. We use a PureScale based, 4 compute node implementation for DB2 and this allows for high uptime. If a node fails, the remaining nodes seamlessly take up the load.,Some of DB2 system management tasks can be a bit cumbersome.
Rather than adding new features, it would be much better to enhance and expand some of the existing features.,10,Mostly positive impact. The current company started out with using MySQL as their database engine, but once their customer base and the resulting volume of data grew, moving over to DB2 increased their capacity for throughput dramatically.,,MySQL, Microsoft SQL ServerVerified UserDB2 review2015-12-28T17:48:40.261ZWe have our webmethods middleware installed with the backend database as DB2. We have been using it for past 5 years or so. It is being used by our department. Our middleware helps in order processing, inventory checkup etc. I am not an admin for DB2 but a user.,It is owned by IBM. Getting support from IBM is very convenient.
It is robust.
Monitoring tools exist.,Issue resolution or debugging an issue is difficult.,6,Order processing was made easier.
Transaction search was made quite easy.,webMethods Trading Network, IBM MQ, TIBCO ActiveMatrix BusinessWorksVerified User
Unspecified
DB2
77 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow'>trScore algorithm: Learn more.</a>
