The best example is the day-to-day performance monitoring with the CA Detector product.

By using CA Detector, we can see what is consuming the IBM DB2 resources. We can then analyze its specifics and address distinct actions, through the integration with the other products.

This has improved our overall business goals, because we were able to address the most impactful business processes, so as to mitigate their impact on the others.

The best example is the day to day performance monitoring with the Detector product. Using Detector, we can see what is consuming the DB2 resources and then analyze its specifics through the integration with the other products. This improved our business processing because we were able to address the most impactful ones to mitigate their impact on the others.

The benefits is repeatability of use. I can do a change in one environment and use that same change to do it to another environment. It allows reliable changes.

We have more control over our DB2 systems and can do our everyday DBA work faster and easier.

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.

We use the Display Impact report in RC/Query as part of our database development life cycle process to make sure that we account for all items that might be affected by any particular change. We have used Detector in countless situations to pinpoint performance issues quickly. We have used Insight to identify the users of particular items and to identify hot spots on our systems. We have used Log Analyzer to recover data lost in errant production jobs. We use the DDL function of RC/Query to give us our baseline and backout text for all database changes. Those are just a few of the tasks that we use these tools for.

Provides accurate reports of components usage; helps tune performance.

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.

Able to research issues.

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

It allowed us to automate all of our housekeeping.

Improved monitoring and performance management.