Solving Operational Business Intelligence with InfoSphere Warehouse Advanced Edition

Chapter 9. Managing data lifecyle with InfoSphere Warehouse 347

Execution Summary tab provides a summary of data for each unique query

issued for the time period selected, including:

򐂰 Number of executions

򐂰 CPU time

򐂰 Rows read

򐂰 FCM traffic metrics

Figure 9-8 shows the Execution Summary tab on the SQL Statements

dashboard. The Actions menu is also shown. From the Actions Menu you can

switch views to see individual executions of the selected SQL Statement.

Figure 9-8 Execution Summary tab with Actions menu options

You can add additional columns as needed to aid analysis and filter by columns

to analyze grouped data. Data on the grid can be exported to a spreadsheet by

right -licking the data grid and selecting Copy to clipboard. On the clipboard,

you can perform these tasks:

򐂰 Manipulate and perform further analysis by the FROM and WHERE clause to

get active data information by table or date

򐂰 Review total number of executions, CPU, and elapsed execution time by

query text

9.4 Optim High Performance Unload to archive or

migrate cold data

Chapter 8, “Building a corporate backup and recovery strategy” on page 289

demonstrates how IBM InfoSphere Optim High Performance Unload can be used

to meet your service level objectives for data recovery.