Ease of use and robust automated security administration and reporting are features any mainframe shop needs and should have. The cost of investing in such products will usually offset the expense associated with the DB2 environment and the efforts to protect those data resources associated with it.
Security Analyst at a insurance company with 1,001-5,000 employees
The most valuable features automated security administration and reporting
Pros and Cons
- "Ease of use and robust automated security administration and reporting are features any mainframe shop needs and should have."
What is most valuable?
How has it helped my organization?
When new DB2 resources are introduced into the environment, the Vanguard Administrator product allows us to quickly build the required RACF security rules and access lists. There are features in the Administrator product that automate the tedious security administration efforts. The Vanguard Advisor product provides a mechanism for monitoring the RACF/DB2 environment, identifying and reviewing security violations that occur, etc. As stated earlier, we also use Vanguard Integrity Professional’s “Security Center” product for RACF DB2 administration. The Security Center has a direct GUI interface to RACF. As such, it does not require the RACF administrator to use TSO to define or change RACF security profiles associated with DB2.
What needs improvement?
It is worth noting that the RACF security product is used to safeguard the DB2 environment on the mainframe. This allows us to maintain all security rules for resources on the mainframe using the RACF security product. Some shops I have worked in do not use external security managers like RACF, Top Secret or ACF2 to protect the DB2 environment. I have seen instances where installations with DB2 use native internal security.
If an installation does not use an external security manager product like RACF, Top Secret or ACF2, then native internal DB2 security would have to be used to safeguard DB2 resources. This results in the DBA's being responsible for security profiles that protect DB2 resources. It's better to let the DBAs do the job they do best; that is, define the resources and then let the security team protect them accordingly, with their input of course.
For how long have I used the solution?
We have used this solution for approximately 10 years.
Buyer's Guide
IBM Db2 Database
May 2026
Learn what your peers think about IBM Db2 Database. Get advice and tips from experienced pros sharing their opinions. Updated: May 2026.
893,244 professionals have used our research since 2012.
What do I think about the stability of the solution?
There were no stability issues.
What do I think about the scalability of the solution?
There were no real scalability issues. Features in the Vanguard RACF security products allow the installation to determine security policy for DB2 resources and build the security rules as needed.
How are customer service and support?
I think the Support Team at Vanguard Integrity Professionals is great. I have never had a problem with Support getting back to me in a timely manner with the information I need to resolve issues.
Which solution did I use previously and why did I switch?
We have not used any external security managers other than RACF to safeguard the mainframe DB2 environment. At one point I was involved in looking at IBM’s zSecure product as an alternative RACF security and audit tool.
How was the initial setup?
The initial setup of the automated security products like Administrator and or Advisor is straightforward. I highly recommend a Systems Programmer install the products to maximize the software investment a company makes.
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 prudent and practical use of these products will be cost-effective. Mainframe software, after all, is expensive and you by strategically planning a security implementation up front will be beneficial in getting desired audit and security results.
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 applications that run on it, you are fortunate. It is then your responsibility to maximize the software investment to insure all resources on the mainframe platform are adequately protected.
Truth be told, companies using mainframes spend a lot of money on not just hardware, but the software (DB2/RACF/etc.), that runs on it. It goes without saying that any mainframe installation with DB2 and RACF needs reliable security products to administer the environment provide security and audit reporting and streamline efforts to safeguard the environment.
From personal experience, I submit that software that enhances and automates security administration efforts for the mainframe and it isn’t cheap either. It’s important for a mainframe organization to maximize the financial investment in such tools.
In addition, an installation running DB2 and RACF needs to make an important decision. That is, who will be responsible for securing the environment. If RACF or another external security manager is not used than internal DB2 security will need to be employed for safeguarding resources. It’s important to have a security process in place to:
- Determine what DB2 resources need protection and identify who the users or groups are that need access, and the type of access (inquiry, update, etc.).
- Audit settings: What type of violations are being monitored and what is the process for reporting them.
- Security reporting: Periodic re-certification of security rules and access lists, etc. Things (access requirements) change over time.
- Change control: Security updates which need to be applied in the event of employee hiring, transfers and terminations. Managing a mainframe environment is difficult enough without having to also worry about security clutter.
Incidentally, this is only a partial list of things to consider when securing a DB2 environment. For example, this write-up doesn’t even address backup, recovery, and/or restoration issues (process/procedures).
In the many years I have been administering RACF and other security, I have come to conclude that there perfect security does not exist for any application or specific resource. A practitioner I once observed at a security conference summed it up by saying, "Computer security is a journey that never ends..." Ever changing new technological developments and access requirements mean you have to adapt accordingly from a security perspective.
Disclosure: My company does not have a business relationship with this vendor other than being a customer.
Mainframe Application Analyst / Developer at a insurance company with 10,001+ employees
All parts of storage mediums, including VSAM and sequential files to make the system work.
Pros and Cons
- "Data structure -- easy access batch or interface."
- "Applications are used within the boundaries of their functionality and/or business purposes. While there are different situations that may occur either on a daily basis or once in a while, solutions are limited to the scope of their usage."
What is most valuable?
Data structure -- easy access batch or interface.
How has it helped my organization?
All parts of storage mediums, including VSAM and sequential files to make the system work.
What needs improvement?
Applications are used within the boundaries of their functionality and/or business purposes.
While there are different situations that may occur either on a daily basis or once in a while, solutions are limited to the scope of their usage. So it's very difficult to determine if any improvements are needed or suggested.
This would be a situation basis and an attempt to use the product
outside of the business scope.
For how long have I used the solution?
Since the early 1970s (IBM DB2 V2).
What do I think about the stability of the solution?
Very rarely.
What do I think about the scalability of the solution?
Very rarely.
How are customer service and technical support?
Excellent, if this question is referencing our DBAs.
Which solution did I use previously and why did I switch?
N/A.
How was the initial setup?
Not involved.
What's my experience with pricing, setup cost, and licensing?
Not involved.
Disclosure: My company does not have a business relationship with this vendor other than being a customer.
Buyer's Guide
IBM Db2 Database
May 2026
Learn what your peers think about IBM Db2 Database. Get advice and tips from experienced pros sharing their opinions. Updated: May 2026.
893,244 professionals have used our research since 2012.
VMware & Storage Design Lead at a university with 1,001-5,000 employees
Before installing DB2, make sure full planning is done regarding scalability and performance requirements
Pros and Cons
- "It was very simple to get up and running."
- "In my limited use case, the only major thing would be improved reporting capability."
What is most valuable?
The simplicity of installation/setup and the ability to run without requiring constant maintenance.
For applications, we have Oracle and Microsoft SQL deployed for application systems, but I prefer DB2 for my “systems” usage primarily due to its limited requirement for administration.
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.
What was my experience with deployment of the solution?
The first time was in 1989/1990.
Recently, from 2007 to the present day.
What do I think about the stability of the solution?
No, I had a DB2 instance running on an old IBM x3650 with Windows 2003, which ran continuously for eight years.
It was a performance data repository for our storage and fabric switches, with an average insert activity of several 1,000 per minute (had automatic record pruning setup).
What do I think about the scalability of the solution?
No, but we never had it greater than 100TiB.
How are customer service and technical support?
Can’t rate it as we never had to use it.
Which solution did I use previously and why did I switch?
No, I selected DB2 based on previous experience with Oracle and after a brief look at MS SQL.
How was the initial setup?
It was very simple to get up and running. The documentation is very good and the user forums, including IBM wikis, make it very easy to find out most things we did to it as far as setup/tuning are concerned.
Which other solutions did I evaluate?
As we already use Oracle and MS SQL for applications, I looked at the latest version of Oracle (at the time v9) to examine any differences pertinent to the last time I had looked at it.
MS SQL: I only briefly looked at it. IMHO, it was no match for DB2 or Oracle, as far as what I consider “Enterprise Databases” to be.
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 something really simple like MySQL would have been a better option.
Also, before installing DB2 make sure full planning is done regarding scalability and performance requirements.
Definitely, use the planning worksheets and search the DB2 wiki’s and user forums to ensure the setup is optimal from the start, especially as far as layout is concerned.
I have found in the x86 world that products seem to be installed with very little pre-installation planning. With my mainframe background, you don’t install anything until you have examined all available documentation, so you are aware of all the key decision points in the install/setup/layout.
Disclosure: My company does not have a business relationship with this vendor other than being a customer.
Lead Code Wisperer at a tech vendor
If you want horizontal scaling and reliability, DB2 for i is absolutely the way to go.
Pros and Cons
- "If you want horizontal scaling and reliability, DB2 for i is absolutely the way to go."
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 well, and always missed DB2 for i.
What needs improvement?
Not sure.
For how long have I used the solution?
Since before it was called DB2, back on the System/38, so twenty years or so.
What do I think about the stability of the solution?
Hah! You kidding. DB2 for i? No. Never.
What do I think about the scalability of the solution?
Hah! You kidding. DB2 for i? No. Never. Would you like a description of the IBM i Single-level Store. Add a new drive and you are good to go.
How are customer service and technical support?
Good to excellent. It can get expensive but third party is very good.
Which solution did I use previously and why did I switch?
I did not use a different solution prior to IBM DB2.
How was the initial setup?
It was integrated with the IBM i OS.
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?
No, I did not evaluate other options before choosing this product.
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 partitions for Linux for your business logic.
Disclosure: My company does not have a business relationship with this vendor other than being a customer.
DBA with Oracle Database, IBM DB2 and Cloudera Hadoop project at a financial services firm with 5,001-10,000 employees
On our old system...the performance and stability couldn't meet our requirements. After migrating to DB2, it's much better.
Pros and Cons
- "After migrating to DB2, the performance and stability of our Wealth Management system is much better than it was on Microsoft SQL Server."
- "As an unbreakable system, it's a very bad design."
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 it comes to this feature.
How has it helped my organization?
The old system (Wealth Management) was on Microsoft SQL Server platform, 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 .
For how long have I used the solution?
Three years.
What do I think about the stability of the solution?
Yes. We even encountered DB2 bug on the Version 9.7.0.9 and it's the reason why we upgraded to Version 9.7.0.11 .
What do I think about the scalability of the solution?
Yes. Many tables or indexes can't be scaled up without reorg step. As an unbreakable system, it's a very bad design.
How are customer service and technical support?
8 out of 10. IBM Lab is quite strong. The site technical support is good, too.
Which solution did I use previously and why did I switch?
See my answer to the 'Stability' question.
How was the initial setup?
It's quite complex. It cannot be done without reference.
What about the implementation team?
The reference documents and education resources in the market might not offer as much as Oracle Database or Microsoft SQL Server.
It's still much more than open source databases such as PostgreSQL, but much less than Oracle and Microsoft.
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?
Yes. Oracle Database.
Disclosure: My company does not have a business relationship with this vendor other than being a customer.
Project Manager at a tech services company with 10,001+ employees
We use it to provide for back-end DB for many proprietary applications.
Pros and Cons
- "We have moved a lot of our applications off zOS to distributed platforms and IBM UDB DB2 has been extremely critical in our solution to provide for a scale-able, cost-effective and reliable DBMS solution on distributed platform."
- "Right now, the setup for AWS/Azure licensing is very confusing and not cost-effective."
What is most valuable?
We use it to provide for back-end DB for many proprietary applications. The most valuable features are reliability, performance, and portability across different platforms.
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 our solution to provide for a scale-able, cost-effective and reliable DBMS solution on distributed platform.
The other advantage is we don't have to make lot of changes in the application DB2 access layer in order for it to work with IBM DB2 UDB. These applications have been originally designed to work with the host database (IBM DB2 zOS).
What needs improvement?
I would definitely like to see a better interface to interact with the database. Performance monitoring tools which come out of the box don't need to come along with all the bells and whistles. They need to be effective and intuitive. There are ways to do that out-of-box even today, but it can be improved
For how long have I used the solution?
We have used this solution for over 15 years.
What do I think about the stability of the solution?
There were no issues with stability.
What do I think about the scalability of the solution?
There were no issues with scalability.
How are customer service and technical support?
The IBM Technical Support model is satisfactory.
Which solution did I use previously and why did I switch?
We used XDB (Micro Focus RDBMS equivalent to DB2) which used to have scalability and reliability issues in our development environments. We switched to IBM UDB DB2 in our DEV environments on account of its reliability and scalability.
How was the initial setup?
The setup was straightforward. However, the Linux setup can be improved.
What's my experience with pricing, setup cost, and licensing?
I love the way the product is licensed on zOS and zLinux (core-based). However, IBM needs to improve their licensing for cloud environment, as we are planning to leverage that platform extensively in the future. Right now, the setup for AWS/Azure licensing is very confusing and not cost-effective.
Which other solutions did I evaluate?
We evaluated Oracle, but the ease of application re-hosting with IBM DB2, as well as its comparable reliability and scalability tilted it in favor of IBM DB2 UDB.
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 consider other options, as they usually require extensive changes in the application layer.
Disclosure: My company has a business relationship with this vendor other than being a customer. We are IBM's partner.
SAP Basis Administrator at a pharma/biotech company
HADR/TSAMP allows us to handle unplanned outages with very little user impact.
Pros and Cons
- "DB2's performance and stability has been a key factor in the success of the SAP rollout."
- "The diagnostic log (db2diag.log file) could be a little bit more user-friendly."
What is most valuable?
HADR/TSAMP: It makes planned downtime very manageable, and allows us to handle unplanned outages with very little user impact.
How has it helped my organization?
We use IBM DB2 as part of a SAP implementation. DB2's performance and stability has been a key factor in the success of the SAP rollout.
What needs improvement?
The diagnostic log (db2diag.log file) could be a little bit more user-friendly.
For how long have I used the solution?
I have used this solution for 16 years.
What do I think about the stability of the solution?
There were no stability issues.
What do I think about the scalability of the solution?
This is not relevant for me, we have rarely needed to build on the initial server footprint.
How is customer service and technical support?
Right now, I deal directly with SAP support for DB2 issues. But, when I previously worked for IBM, I found the DB2 support staff to be very helpful and knowledgeable. Due to the size of the company, there was a huge breadth of knowledge and experience.
How was the initial setup?
The installation process and setup is fairly straightforward (assuming that you have a good working knowledge of the underlying OS and basic DB2 concepts).
What other advice do I have?
Take advantage of the dedicated IBM teams that are in place to help with the migration process from other DBMS.
Disclosure: My company does not have a business relationship with this vendor other than being a customer.
Engineer at a tech services company
We replicate TSM servers' databases to the other sites with the HADR feature.
Pros and Cons
- "We use DB2 HADR to replicate data on LAN to another site, and it is easy to takeover to the other site with easy integration with TSM."
- "Automatic upgrade process (e.g., from v9.7 to v10.5) often fails."
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 (e.g., from v9.7 to v10.5) often fails.
- Error messages are rarely unusable (e.g., I/O error -> instance upgrade was unsuccessful. You must issue an instance upgrade manually).
- The same issue with the dialog messages, independent from LOGLEVEL.
- A lot of irrelevant information (hexdumps, etc.)
What do I think about the stability of the solution?
There were no issues with stability.
What do I think about the scalability of the solution?
There were no issues with scalability.
How is customer service and technical support?
Technical support, works, but they are slow to get to the real experts, Level-2, who can really help. Level-1 support often asks for irrelevant data.
How was the initial setup?
The initial setup was complex. There are InfoCenter Pages and TechNotes, but these only cover the "usual" cases. You need a lot of experience and/or support.
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, and it is hard to find DB2 DBAs, engineers, and experts.
Which other solutions did I evaluate?
We did not evaluate other options from a TSM server point of view, as there was no other way. From other way, we evaluated Oracle, which is cheaper and there are more people with Oracle-experience.
What other advice do I have?
Use InfoCenter, then DeveloperWorks, and the TechNotes. :) Do this in order to get experience.
Disclosure: My company has a business relationship with this vendor other than being a customer. Our company is an IBM Business Partner, first of all implementing and supporting Spectrum Protect environments.
Buyer's Guide
Download our free IBM Db2 Database Report and get advice and tips from experienced pros
sharing their opinions.
Updated: May 2026
Product Categories
Relational Databases ToolsPopular Comparisons
Teradata
SQL Server
Oracle Database
SAP HANA
MariaDB
VMware Tanzu Data Solutions
CockroachDB
Amazon Aurora
Oracle Database In-Memory
YugabyteDB
Heavy.AI
IBM Informix
Buyer's Guide
Download our free IBM Db2 Database Report and get advice and tips from experienced pros
sharing their opinions.
Quick Links
Learn More: Questions:
- When evaluating Relational Databases, what aspect do you think is the most important to look for?
- Do general purpose or OLTP Oracle databases really perform better on SPARC based servers?
- Microsoft sql2017 VS SAP Hana
- What is the best database choice for a long term plan?
- SQL Server 2005 vs. InfoBright - what are the pros and cons of these solutions?
- How does NuoDB compare to MySQL and SQL Server?
- Which RDBMS tool do you prefer and why?
- Did you switch from a different solution to MySQL? Can you list a few pros and cons for making the move?
- Why is Relational Databases Tools important for companies?













