IBM DB2 Reviews

Filter by:Reset all filters
industry
Filter Unavailable
Company Size
Filter Unavailable
Job Level
Filter Unavailable
rating
Filter Unavailable
SecAnalyst3477
Real User
Security Analyst at a insurance company with 1,001-5,000 employees
Jul 26 2017

What is most valuable?

Ease of use and robust automated security administration and reporting are features any mainframe shop needs and should... more»

How has it helped my organization?

When new DB2 resources are introduced into the environment, the Vanguard Administrator product allows us to quickly... more»

What needs improvement?

It is worth noting that the RACF security product is used to safeguard the DB2 environment on the mainframe. This... more»

What's my experience with pricing, setup cost, and licensing??

I am not directly involved with pricing and licensing, but I know that despite the associated cost of the software... more»

Which other solutions did I evaluate??

We have not used any external security managers other than RACF to safeguard the mainframe DB2 environment. At one... more»

What other advice do I have??

If your computing budget allows you to get automated security and audit products for your mainframe environment and the... more»
Andrés Gómez Casanova
Real User
DB2 DBA at a financial services firm with 10,001+ employees
Jul 31 2017

What is most valuable?

* PureScale * Blu acceleration * XML and JSON datatypes * Autonomous computing (storage, memory, and maintenance) * HADR * NoSQL (RDF and MongoDB).

How has it helped my organization?

Due to the stability, the applications can have a very long uptime, even with modifications in the application. I have never needed to install a... more»

What needs improvement?

Monitoring. There are very few applications that really monitor DB2. Marketing. IBMers from other IBM brands, do not rely on DB2.

Which other solutions did I evaluate??

I have used a little bit of Oracle, SQL Server, PostgresSQL, and MySQL. They are good platforms, but they are not as easy to work with as DB2 is.

What other advice do I have??

If you are creating a small budget project, DB2 could be your first option. You have almost no limits with the Community-C edition (the free... more»
Find out what your peers are saying about IBM, Oracle, Microsoft and others in Relational Databases.
291,675 professionals have used our research since 2012.
Wombat McPlattypuss
Real User
VMware & Storage Design Lead at a university with 1,001-5,000 employees
Jul 17 2017

What is most valuable?

The simplicity of installation/setup and the ability to run without requiring constant maintenance. For applications, we have Oracle and... more»

How has it helped my organization?

Not one that is relevant, it is used purely in a “systems infrastructure” setting rather than as a “business application system”.

What needs improvement?

In my limited use case, the only major thing would be improved reporting capability.

Which other solutions did I evaluate??

No, I selected DB2 based on previous experience with Oracle and after a brief look at MS SQL.

What other advice do I have??

Define their use cases as exactly as they can, then look at what DB fits them. I have seen the app/database team deploy Oracle/MS-SQL when... more»
Ankur Katiyar
Consultant
Project Manager at a tech services company with 10,001+ employees
Jul 11 2017

What is most valuable?

We use it to provide for back-end DB for many proprietary applications. The most valuable features are reliability,... more»

How has it helped my organization?

We have moved a lot of our applications off zOS to distributed platforms and IBM UDB DB2 has been extremely critical in... more»

What needs improvement?

I would definitely like to see a better interface to interact with the database. Performance monitoring tools which... more»

What's my experience with pricing, setup cost, and licensing??

I love the way the product is licensed on zOS and zLinux/Azure licensing is very confusing and not cost-effective.

Which other solutions did I evaluate??

We used XDB (Micro Focus RDBMS equivalent to DB2) which used to have scalability and reliability issues in our... more»

What other advice do I have??

For folks looking to re-host applications that are using zOS DB2, our advice is to strictly go with IBM UDB DB2. Do not... more»
Abdel Moneim Emad
Real User
Enterprise Solutions Architect at Intercom Enterprises
Nov 29 2017

What is most valuable?

A) The command set is almost the same in Windows and AIX operating systems, which greatly minimize the administration... more»

How has it helped my organization?

Our software products have to be PCI-DSS compliant, so encryption of customers' credit card numbers is a must-have... more»

What needs improvement?

Backing up databases from Windows and restoring them on AIX and vise-versa. Support for migrating DB2 v9.7 to 11 in a... more»

What's my experience with pricing, setup cost, and licensing??

Use DB2 Express for your development environment, but consider using Workgroup Server Edition if you need to federate... more»

Which other solutions did I evaluate??

I used Oracle DB and am still using it with some of my customers, but Oracle administration is a nightmare compared to... more»

What other advice do I have??

I recommend it to medium-to-large enterprise applications
Robert Venyige
Consultant
Engineer at a tech services company
Jul 09 2017

What is most valuable?

We use DB2 HADR to replicate data on LAN to another site. It is easy to takeover to the other site. There is easy integration with TSM.

How has it helped my organization?

We replicate TSM servers' databases to the other sites with the HADR feature. We use HADR takeover to switch the TSM service to the other site.

What needs improvement?

* Automatic upgrade process

What's my experience with pricing, setup cost, and licensing??

It depends on the customers. Often, DB2 is more expensive than Oracle on the same environment. There are those with more experience with Oracle,... more»

What other advice do I have??

Use InfoCenter, then DeveloperWorks, and the TechNotes. :) Do this in order to get experience.
Chao Kang Chen
Real User
DBA with Oracle Database, IBM DB2 and Cloudera Hadoop project at a financial services firm with 5,001-10,000 employees
Jul 13 2017

What is most valuable?

A4: Automatic storage. Disk space management is one of the biggest pain points for a DBA. Even Oracle 11g R2 cannot do better than IBM DB2 when... more»

How has it helped my organization?

The old system, however, the performance and stability couldn't meet our requirements. After migrating to DB2, it's much better.

What needs improvement?

Absolutely -- centralized management tools with UI interface, like Oracle EM .

What's my experience with pricing, setup cost, and licensing??

Calculating the license fee is always very complicated and only the IBM sales can get the final answer. It's not a transparent way.

Which other solutions did I evaluate??

See my answer to the 'Stability' question.
Don Denoncourt
Real User
Lead Code Wisperer at a tech vendor
Jul 13 2017

What is most valuable?

Scalability, the IBM i Logical views, journaling.

How has it helped my organization?

DB2 was always there, so I can't answer that. Know that I've used MySQL, PostgreSQL, and SQL Server extensively as... more»

What needs improvement?

Not sure.

What's my experience with pricing, setup cost, and licensing??

If you want horizontal scaling and reliability, DB2 for i is absolutely the way to go.

Which other solutions did I evaluate??

I did not use a different solution prior to IBM DB2.

What other advice do I have??

If you don't know IBM i OS, just use it for DB2 for i, and scalability, reliability, and security. Then consider using... more»
See 3 More IBM DB2 Reviews

Articles

User Assessments By Topic About IBM DB2

Find out what your peers are saying about IBM, Oracle, Microsoft and others in Relational Databases.
291,675 professionals have used our research since 2012.

IBM DB2 Questions

IBM DB2 Projects By Members

IBM DB2 Consultants

What is IBM DB2?

DB2 Enterprise for Linux, UNIX, and Windows is the ideal data server for the most demanding workloads. New XML support is designed to help firms minimize the time and effort it takes to persist and use their XML data reducing development costs and improving business agility.
Also known as
DB2
IBM DB2 customers
Knorr-Bremse, Mizuho Bank Ltd., Australian Government Department of Defence, SCHWENK Zement, Friedhelm Loh Group, YAZAKI Europe Limited, Ekornes ASA, Baldor Electric, VSN Systemen BV, Lion Brewery (Ceylon) PLC, PLANSEE Group, TE Connectivity, Hansgrohe SE, Openmatics, University of Toronto
BUYER'S GUIDE
Not sure which Relational Databases solution is right for you?

Download our free Relational Databases Report and find out what your peers are saying about IBM, Oracle, Microsoft, and more!

Sign Up with Email