Try our new research platform with insights from 80,000+ expert users
CA Database Management for DB2 for zOS Logo

CA Database Management for DB2 for zOS Reviews

Vendor: Broadcom
4.4 out of 5
478 followers
Start review

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.
Get the Database Development and Management Buyer's Guide and find out what your peers are saying about CA Database Management for DB2 for zOS, CA Datacom and more!
CA Database Management for DB2 for zOS is the #19 ranked solution in top Database Development and Management solutions. PeerSpot users give CA Database Management for DB2 for zOS an average rating of 8.8 out of 10. CA Database Management for DB2 for zOS is most commonly compared to CA Datacom: CA Database Management for DB2 for zOS vs CA Datacom.
Buyer's Guide
Database Development and Management
May 2025
Get the category report
Helped 855,080 peers since 2012

Featured CA Database Management for DB2 for zOS reviews

Read more reviews

CA Database Management for DB2 for zOS mindshare

As of June 2025, the mindshare of CA Database Management for DB2 for zOS in the Database Development and Management category stands at 0.5%, down from 0.6% compared to the previous year, according to calculations based on PeerSpot user engagement data.
Database Development and Management
 
 
Key learnings from peers

Valuable Features

Valuable features of CA Database Management for DB2 for zOS include the consistent ability to create strategies across various tools enabling repetitive use by different resources, RC/Migrator for quick changes, Detector and Subsystem Analyzer for system monitoring, and RC/Query for efficient catalog insights. SYSVIEW and automated batch reporting aid in performance analysis and trend identification. PDA and PPA simplify housekeeping tasks, while report generation improvements in CADV2 are highly beneficial.
  • "The reports generated and the old statistics shown are really helpful."
  • "It takes advantage of new features of DB2."
  • "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."

Room for Improvement

Initial parameter setup is complex and time-consuming. Many users face difficulty navigating and wish for better documentation and tutorials. They express a desire for broader platform support and seek improved intuitiveness in task flows. Installation could be simplified, trend analysis better formatted, and performance repositories easier to manage. Some stability issues are noted, along with requests for faster problem pinpointing during SQL execution.
  • "In the case of any particular SQL which is executing for a longer time and causing issues with any particular store or DB2 programs, if it could pinpoint the problems like any other tool should do, that would be really helpful."
  • "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."
  • "Minor stability issues."

Pricing

Enterprise users highlight CA Database Management for DB2 for zOS as an integrated solution beneficial for business needs. While not all users are involved in pricing or licensing, they suggest evaluating costs over the entire license period and securing future agreements. Initial contracts might offer better terms than subsequent renewals. Competing product suites may offer similar functionalities, but the integration within CA's suite stands out for meeting organizational requirements effectively.

Popular Use Cases

CA Database Management for DB2 for zOS is primarily utilized for performance analysis and troubleshooting. Users engage it to monitor performance in both test and production DB2 systems, serving as a tool for comprehensive database management. It is employed to assess the performance of specific database objects, programs, and more, utilizing CSSZ for effective performance monitoring. During exceptions, users can inform application teams and determine issues at DB2 to enhance system functionality.

Service and Support

Customer service and support for CA Database Management for DB2 for zOS receive high marks. Responses are swift, resolving issues typically within a day. Consistency and responsiveness are highlighted across a wide range of products. Users frequently rate their support experience as excellent, often scoring it 8 or higher. Many issues are resolved promptly, with a small number unresolved due to lack of necessary data. Users appreciate the personal connection with tech support, praising their effectiveness.

Deployment

Users found the initial setup of CA Database Management for DB2 for zOS complex due to customization needs and numerous parameters. Documentation describes it as straightforward, but the variety of products adds complexity. Some users experienced a phased installation process. Others described setup as easy or straightforward once familiar with the procedure. Product comparisons during initial stages made whole replacements easier for some. Several were not involved in setup or lacked detailed opinions.

Scalability

CA Database Management for DB2 for zOS is noted for its scalability, with users describing stable z/Server environments. Some reported it effectively handles both small changes and larger system demands without issues. Feedback indicates its ability to perform well even with extensive systems, as referenced by a setup with over 80 LPARs. There is consistent affirmation regarding its capacity to manage significant workloads efficiently.

Stability

CA Database Management for DB2 for zOS is deemed stable by users who have employed it for years. Stability concerns were anticipated and addressed. While some mention occasional bugs and advise caution with new releases, most report no stability issues, especially with Versions 19 and after upgrades to DB2 v10 and v11. Users note that these tools maintain stability, despite a steep learning curve for traditional DBAs resistant to IBM alternatives.
These insights are based on the in-depth reviews provided by peers to help you make a better buying decision.
Download our Database Development and Management Buyer's Guide for additional reliable information.

Compare CA Database Management for DB2 for zOS with alternative products

Go!

Learn more about CA Database Management for DB2 for zOS

CA Database Management for DB2 for zOS was previously known as CA Database Management Solutions for DB2 for z/OS.

CA Database Management for DB2 for zOS customers

Blue Hill Data Services

Related questions

  • 28
What is the best GUI tool for development and management of a PostgreSQL database?
  • 228
What is the best backup solution for Sybase ASE 15.5?
  • 303
Which Database Activity Monitoring tool is best for cloud environments?
  • 26
What are your top recommended replacement solutions for Quest Foglight for Databases?
  • 68
Which low-code (no-code) database solution do you prefer?
  • 7
Why is Database Development and Management important for companies?

Product Categories

Product Categories
Database Development and Management

Popular Comparisons

Popular Comparisons
CA Datacom vs CA Database Management for DB2 for zOS Logo
CA Datacom vs CA Database Management for DB2 for zOS
See all alternatives
 

CA Database Management for DB2 for zOS reviews

Sort by:
JG
Technical Project Manager at Interra Information Technologies, Inc.
Verified user of CA Database Management for DB2 for zOS
Jan 10, 2025
Report generation offers invaluable insights into database performance

Pros

"The reports generated and the old statistics shown are really helpful."

Cons

"In the case of any particular SQL which is executing for a longer time and causing issues with any particular store or DB2 programs, if it could pinpoint the problems like any other tool should do, that would be really helpful."

What is our primary use case?

I basically use the solution for database management and to view the performance of a particular database object, any specific program, batch program, or online programs. Using the CSSZ tool, I can effectively monitor performance. In case of an exception, I can inform the application team. At DB2, I can also determine what's going on and what the exact issue is. Based on that, I can make conclusions to improve my personal system.

What is most valuable?

In CADV2, the most improved feature is report generation. The reports generated and the old statistics shown are really helpful.

*Disclosure: My company does not have a business relationship with this vendor other than being a customer.
Read full review (252 words)
PeerSpot user
Information Analyst at a financial services firm with 10,001+ employees
Verified user of CA Database Management for DB2 for zOS
Apr 8, 2018
Provides us better insight into our tables and our databases

Pros

"It takes advantage of new features of DB2."

What is our primary use case?

It's our DBA product for our database.

How has it helped my organization?

It gives us better insight into our tables and our databases. It pulls all of the information from different directions back together, I think that's how it helps us.

*Disclosure: PeerSpot contacted the reviewer to collect the review and to validate authenticity. The reviewer was referred by the vendor, but the review is not subject to editing or approval by the vendor.
Read full review (222 words)
Buyer's Guide
Database Development and Management
Download free report
Find out what your peers are saying about Database Development and Management. Updated May 2025
855,080 professionals have used our research since 2012.
PeerSpot user
SOD Application DB2 DBA at a insurance company with 1,001-5,000 employees
Verified user of CA Database Management for DB2 for zOS
Feb 12, 2018
Provides accurate reports of components usage, helps tune performance

Pros

"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."

Cons

"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 is our primary use case?

Monitoring performance in test and production DB2 systems.

How has it helped my organization?

Provides accurate reports of components usage; helps tune performance.

*Disclosure: PeerSpot contacted the reviewer to collect the review and to validate authenticity. The reviewer was referred by the vendor, but the review is not subject to editing or approval by the vendor.
Read full review (217 words)
PeerSpot user
Mainframe DB2 Technical Specialist at a tech vendor with 10,001+ employees
Verified user of CA Database Management for DB2 for zOS
Dec 24, 2017
Product version discussed: Release 20
Streamlines our monitoring and performance management

Pros

"Improved monitoring and performance management."

Cons

"Minor stability issues."

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.

*Disclosure: PeerSpot contacted the reviewer to collect the review and to validate authenticity. The reviewer was referred by the vendor, but the review is not subject to editing or approval by the vendor.
Read full review (108 words)
PeerSpot user
Systems Programmer at a financial services firm with 10,001+ employees
Verified user of CA Database Management for DB2 for zOS
Dec 19, 2017
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.

*Disclosure: PeerSpot contacted the reviewer to collect the review and to validate authenticity. The reviewer was referred by the vendor, but the review is not subject to editing or approval by the vendor.
Read full review (175 words)
PeerSpot user
Staff Systems Engineer at a financial services firm with 10,001+ employees
Verified user of CA Database Management for DB2 for zOS
Dec 13, 2017
It is a very useful tool for performance monitoring

Pros

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

Cons

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

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.

*Disclosure: My company does not have a business relationship with this vendor other than being a customer.
Read full review (135 words)
PeerSpot user
Systemsprogrammer and Administrator for DB2 at a insurance company
Verified user of CA Database Management for DB2 for zOS
Sep 5, 2017
Product version discussed: R20
PDA and PPA prevent unnecessary reorganizations.

What is most valuable?

PDA and PPA make our daily housekeeping easier and prevents us from unnecessary reorganizations. It is a tool that can also be used by those that don’t have much knowledge

How has it helped my organization?

It allowed us to automate all of our housekeeping.

*Disclosure: PeerSpot contacted the reviewer to collect the review and to validate authenticity. The reviewer was referred by the vendor, but the review is not subject to editing or approval by the vendor.
Read full review (281 words)
PeerSpot user
DB2 consultant at a tech services company with 501-1,000 employees
Verified user of CA Database Management for DB2 for zOS
May 14, 2017
Product version discussed: 19
The exceptions function checks for stopped databases.

What is most valuable?

The biggest functionality for me was with SYSVIEW for DB2. I used all the functions but exceptions and possible monitoring related to it.

I left the company when we started implementing v19 and I know from my colleague that in v19, they implement the exceptions function I asked for, which checks for stopped databases.

How has it helped my organization?

It improved the DB2 v11 upgrade process, so I was able to check more and react faster to problems we observed such as required rebinds.

*Disclosure: PeerSpot contacted the reviewer to collect the review and to validate authenticity. The reviewer was referred by the vendor, but the review is not subject to editing or approval by the vendor.
Read full review (409 words)