CA Database Management for DB2 for zOS Overview

What is CA Database Management for DB2 for zOS?
Database Management for DB2 for z/OS solutions from CA Technologies provide a set of tools designed to ensure optimal database and SQL performance, efficient administration, and reliable backup and recovery of DB2 databases, systems and apps.

CA Database Management for DB2 for zOS is also known as CA Database Management Solutions for DB2 for z/OS.

Buyer's Guide

Download the Database Development and Management Buyer's Guide including reviews and more. Updated: May 2021

CA Database Management for DB2 for zOS Customers
Blue Hill Data Services
CA Database Management for DB2 for zOS Video

Filter Archived Reviews (More than two years old)

Filter by:
Filter Reviews
Industry
Loading...
Filter Unavailable
Company Size
Loading...
Filter Unavailable
Job Level
Loading...
Filter Unavailable
Rating
Loading...
Filter Unavailable
Considered
Loading...
Filter Unavailable
Order by:
Loading...
  • Date
  • Highest Rating
  • Lowest Rating
  • Review Length
Search:
Showingreviews based on the current filters. Reset all filters
Information Analyst at a financial services firm with 10,001+ employees
Real User
Provides us better insight into our tables and our databases

What is our primary use case?

It's our DBA product for our database.

Pros and Cons

  • "It takes advantage of new features of DB2."

    What other advice do I have?

    It's a good product. I would give it a nine out of 10, and the reason is, in general, it's a technical product so I think that it's a little cumbersome.
    SOD Application DB2 DBA at a insurance company with 1,001-5,000 employees
    Real User
    Provides accurate reports of components usage, helps tune performance

    What is our primary use case?

    Monitoring performance in test and production DB2 systems.

    Pros and Cons

    • "The most important features are batch reporting and the ability to create repositories, enabling automated analysis. These are valuable because they enable me to do automated analysis of trends over time and reduce the time for comparing performance between two periods to identify anomalies."
    • "They need to provide a way to create and maintain performance repositories. The online tool is not perfect, but it is giving me what I need."

    What other advice do I have?

    Very good and robust product.
    Find out what your peers are saying about Broadcom, DBmaestro, Quest Software and others in Database Development and Management. Updated: May 2021.
    502,104 professionals have used our research since 2012.
    Mainframe DB2 Technical Specialist at a tech vendor with 10,001+ employees
    MSP
    Streamlines our monitoring and performance management

    How has it helped my organization?

    Improved monitoring and performance management.

    What is most valuable?

    It depends on the environment. For some customers some products are more valuable than others. For sure SYSVIEW, CA Detector and RC/ products.

    What needs improvement?

    Minor stability issues.

    For how long have I used the solution?

    One to three years.

    What do I think about the scalability of the solution?

    No issues.

    How are customer service and technical support?

    Excellent.

    Which solution did I use previously and why did I switch?

    BMC and IBM tools for DB2.

    How was the initial setup?

    I don’t know.
    Systems Programmer at a financial services firm with 10,001+ employees
    Vendor
    Detector and RC/Query are valuable to us; we're able to research issues

    How has it helped my organization?

    Able to research issues.

    What is most valuable?

    I would say Detector and RC/Query.  The DBAs might say differently.  I use these the most.

    What needs improvement?

    They could work on the installation process main job that runs, maybe break it up into several jobs instead of one.

    For how long have I used the solution?

    More than five years.

    What do I think about the stability of the solution?

    No issues.

    What do I think about the scalability of the solution?

    No issues.

    How are customer service and technical support?

    Excellent.

    Which solution did I use previously and why did I switch?

    We switched to the IBM tools for a short time and switched back, due to contract pricing.

    How was the initial setup?

    Pretty straightforward. …
    Staff Systems Engineer at a financial services firm with 10,001+ employees
    Vendor
    It is a very useful tool for performance monitoring

    What is our primary use case?

    We use it for performance analysis and troubleshooting. 

    How has it helped my organization?

    It helps us to reduce hardware costs and to optimize processing times.

    What is most valuable?

    It tracks the activity at a detail level.

    What needs improvement?

    Trend analysis. All the information we need, we could use to have it in a more usable format.

    What do I think about the stability of the solution?

    It is very stable. We have had no issues.

    What do I think about the scalability of the solution?

    It is very scalable.

    How was the initial setup?

    I was not involved in the initial setup.

    What other advice do I have?

    It is a very useful tool for performance monitoring.
    Systemsprogrammer and Administrator for DB2 at a insurance company
    Real User
    PDA and PPA prevent unnecessary reorganizations.

    What other advice do I have?

    It is quick to install, easy to keep it up to date and easy to use.
    DB2 consultant at a tech services company with 501-1,000 employees
    Consultant
    The exceptions function checks for stopped databases.

    What other advice do I have?

    Check if you have any written procedures and how complicated they are. Our own written procedures delayed the whole project from six months to more than a year.
    Database Administrator at a tech services company with 10,001+ employees
    Consultant
    Insight and Detector show what is going on in your subsystem. They help in problem solving and in performance and tuning tasks.

    What other advice do I have?

    If you want your DBA and programming staff to be efficient and effective, I recommend these tools.
    BB
    Compliance Officer at a financial services firm with 1,001-5,000 employees
    Real User
    We use it to migrate tables between systems. The detector and subsystem analyzer are valuable features.

    What other advice do I have?

    It's a great tool. Take time to learn all the features that you need.
    Senior Database Administrator at a local government with 501-1,000 employees
    Real User
    The most useful feature is the ability to create strategies across the products.

    What other advice do I have?

    Utilize the CA resources at the conferences! They provide good access to their technical support and many times at their events as well. They even have a very good one-on-one discourse.
    Senior DB2 Database Specalist at HCSC
    Vendor
    CA utilities are faster and use fewer resources. RC/Migrator allows us to make changes quickly.

    What other advice do I have?

    I would give them some sample jobs to actually to run in scenarios to see how well CA does them compared to some of the other vendors.
    Senior Database Administrator at a local government with 501-1,000 employees
    Real User
    Using Detector, we can see what is consuming the DB2 resources and then analyze its specifics through the integration with the other products.

    What other advice do I have?

    Utilize the CA resources the conferences! They provide good access to their technical support at many events that allow very good one on one discourse.
    Buyer's Guide
    Download our free Database Development and Management Report and find out what your peers are saying about Broadcom, DBmaestro, Quest Software, and more!
    Quick Links