Activity Browser

The Activity Browser is a component in the CAE browser client that enables you to browse and work with Db2® Query Monitor data collected by one or more Query Monitor subsystems.

Controls and components
The Activity Browser offers these basic controls and components. The source, target, perspective, and intervals you select control the data that is displayed in the Activity Browser. You can further refine your view of data using filters and drill down commands.
Viewing and navigating activity
The Activity Browser provides several different ways for you to view and navigate your data about your site's SQL activity.
Workload comparison
When viewing summaries, you can specify one workload as a baseline workload and a second workload as comparison workload to view differences in metrics for the two workloads.
General tasks
You can perform general tasks to customize the way you work with the Activity Browser including sorting columns, moving columns, bookmarking, and exporting data.
Filters
You can use filters to define the display criteria that is used to show data in the Activity Browser data table.
Archive connections
You can use archive connections to connect to Db2 Query Monitor data that has been loaded to a performance history database. An archive connection is a connection between the CAE browser client and a performance history database. An archive connection can be either private or shared.
Custom views
You can use custom views to customize the presentation of data that you see in the Activity Browser data table. You can select, order, and specify the width of the columns you want to see for the various data tables in the Activity Browser. For some views, such as Operational Summaries, Structural Summaries, and SQL Codes, you can define custom views for one or more specific drill down paths.
Managing intervals
The Select Intervals option in the Application menu allows you to view, select, and create new intervals for viewing data in the CAE Activity Browser.
Refreshing navigation
Refreshing navigation refreshes the targets and intervals for the current source and all loaded configuration files (filters, archive connections, custom views, baselines, and tuning connections).
Toggle details
The Activity Browser provides you with the option to toggle the details pane in order to show or hide details for the activity you are browsing.
Preferred labels
Follow these steps to assign preferred labels. You can use preferred labels to limit the shared user configurations that you see.
Setting view preferences
You can choose the visualization tool (table or chart) that you want to use in the Activity Browser and select the elements (table, chart, details) that you want to show by default. Your view preferences are retained in future sessions.
Toggle compare
The Application menu provides you with the ability to toggle (show or hide) the compare workloads options (sources, targets, intervals, Db2® subsystems, baseline, and comparison type) in the Activity Browser.
Decache SQL codes
Follow these steps to clear the cache on the CAE server that contains SQLCODE detail information.
Show SQL
Follow these steps to show SQL for selected activity. The option to show SQL text is available for Summaries, Exceptions, Current® Activity, and SQL Code Details.
Query tuning
The CAE browser client integrates with IBM® Db2 Query Workload Tuner for z/OS® so you can tune single SQL queries or SQL workloads.

Parent topic: Using CAE components