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