CA Database Management for DB2 for zOS effectively addresses database performance monitoring and management needs for DB2 systems, offering tools for issue detection, resource optimization, and enhanced productivity.
| Product | Mindshare (%) |
|---|---|
| CA Database Management for DB2 for zOS | 1.3% |
| Redgate SQL Toolbelt Essentials | 4.2% |
| Oracle Enterprise Manager | 4.0% |
| Other | 90.5% |
CA Database Management for DB2 for zOS is a comprehensive system for managing and optimizing DB2 for zOS databases. Its suite includes tools like Detector for identifying database issues, RC/Query for efficient catalog access, and SYSVIEW for advanced monitoring and exception handling. The RC/Migrator facilitates system table migration, while its batch reporting and automated analysis enhance productivity. Despite its robust features, users seek improved stability, installation processes, expanded system support, and more intuitive functionalities. Enhancements in documentation, navigation, and tutorial availability are also requested to ensure better user experiences.
What are the key features?Organizations in sectors like finance and insurance implement CA Database Management for DB2 for zOS primarily for performance analysis and troubleshooting. Users leverage its monitoring tools to analyze test and production systems, managing database objects and communicating effectively with application teams to address performance exceptions. This has allowed them to optimize operations and enhance their database environments successfully.
CA Database Management for DB2 for zOS was previously known as CA Database Management Solutions for DB2 for z/OS.
| Author info | Rating | Review Summary |
|---|---|---|
| Technical Project Manager at Interra Information Technologies, Inc. | 5.0 | I use this solution for effective DB management and performance monitoring, especially enjoying the helpful reports. While it needs to pinpoint problematic SQL, the setup was straightforward, and Tim provides excellent service. I rate it 10/10. |
| Information Analyst at a financial services firm with 10,001+ employees | 4.5 | We use this DBA product for database insight; Detector and Query are invaluable. It's stable, scalable, and has excellent customer service. Overall, we find it a good product leveraging new DB2 features, although it is a bit cumbersome. |
| SOD Application DB2 DBA at a insurance company with 1,001-5,000 employees | 5.0 | I use this robust product to monitor DB2 performance. Its batch reporting and repository creation enable automated trend analysis. While stable, it needs improved repository maintenance, though the online tool is sufficient. |
| Mainframe DB2 Technical Specialist at a tech vendor with 10,001+ employees | 4.5 | I found this solution improved my monitoring and performance management, with excellent customer service and no scalability issues. However, I did experience minor stability issues. |
| Systems Programmer at a financial services firm with 10,001+ employees | 4.0 | I find Detector and RC/Query valuable, having used this solution for over five years with no stability or scalability issues. Setup was straightforward, and customer service is excellent. I suggest improving the installation process. |
| Staff Systems Engineer at a financial services firm with 10,001+ employees | 4.0 | We find this very stable tool helps us reduce hardware costs and optimize processing times for performance analysis. However, we wish the detailed activity tracking information was in a more usable format for trend analysis. |
| Systemsprogrammer and Administrator for DB2 at a insurance company | 4.5 | I find PDA and PPA easy to use, stable, and scalable. They automate housekeeping, prevent reorganizations, and I've used them 25 years with excellent support. I wish for better cross-platform integration. |
| DB2 consultant at a tech services company with 501-1,000 employees | 4.0 | I used this solution for four years, finding SYSVIEW for DB2's monitoring valuable. It improved our upgrade process, was stable, scalable, and the vendor responsive, despite a minor support hiccup. |
