The feature that we find most useful is the consistent ability to create 'strategies’ across the products. These strategies allow consistent foundations for the business processes and provide the ability to repetitively use them by different resources. These 'strategies' allow the establishment of methods that fit directly into our business needs and prepare the DBAs how to best handle the situations.

The feature we find most useful is the consistent ability to create ‘strategies’ across the products that allow for consistent foundations for the business processes and the ability to repetitively use them by different resources. These strategies allow for the establishment of methods that fit directly into our business needs and preps the DBAs as we need to best handle situations.

The ability to do the CA utilities faster than IBM using less resources. I also like the RC/Migrator product that allows us to make changes quickly and efficiently using either the IBM utilities or the CA utilities.

• The RC/Migrator: Migrates tables between systems
• The Detector and Subsystem Analyzer: Monitors the system

Detector and Query. We use Detector for problem determination and Query, all day, to determine information about our tables and databases.

Also, it takes advantage of new features of DB2.

RC/Query is vital. It is my window to the catalog and helps me find what I need quickly and efficiently. I am in that tool all day long. Detector is my go-to product when something goes wrong. Never trust what someone tells you has happened with their query; let Detector show you. Insight and Detector both provide valuable insight (pun intended) into what is really going on in your subsystem, and has been invaluable in both problem solving and performance and tuning tasks.

There are many valuable features. I would say the most important 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.

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.

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

It tracks the activity at a detail level.

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

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