Viewing reports
The reporting process begins at the
Apptune
and Index Component Main Menu.
From the Apptune and Index Component Main Menu, invoke the SQL Workload Analysis Menu to specify data collection criteria.
Apptune and Index Component Main Menu
IODESELC/I APPTUNE and Index Component Main Menu 14:34:38
Command ====> ________________________________________________________________
Current Data Collector : NC1J Status : ACTIVE Data Collection : READY
Select one of the following options. Then press Enter.
_ 0. Statement Cache - Analyze SQL statement cache statistics
1. SQL Workload - Analyze current and historical SQL workloads
3. Explain Interface - Explain an SQL statement
4. Application Profiles - Create and maintain application groups
5. Command Interface - Issue commands, view responses
D. Archive Directory - View/manage the directory of trace archives
Z. About APPTUNE
Command ====> ________________________________________________________________
Current Data Collector : NC1J Status : ACTIVE Data Collection : READY
Select one of the following options. Then press Enter.
_ 0. Statement Cache - Analyze SQL statement cache statistics
1. SQL Workload - Analyze current and historical SQL workloads
3. Explain Interface - Explain an SQL statement
4. Application Profiles - Create and maintain application groups
5. Command Interface - Issue commands, view responses
D. Archive Directory - View/manage the directory of trace archives
Z. About APPTUNE
SQL Workload Analysis Menu
ASQEWAM1/I SQL Workload Analysis Menu 03:56:11
Command ====>___________________________________________________________
Report Criteria:
Source of data . . . : Subsystem MB2D
For DB2 SSIDs . . . . : *
Start time . . . . . : 02/08/2017 03:00:00
Duration . . . . . . : No time limit
Initial report . . . : PLAN ANALYSIS (DATA)
Application profile . : DEFAULT Owner :
Workload focus . . . : NONE Qualified: N
Select one of the following options.
_ 1. Workload analysis - Begin workload reporting
2. Initial report - Select the initial report to be viewed
3. Report type - Select the report type (data or graph)
4. Application profile - Select the profile for group reporting
5. Time interval - Specify the time frame for reporting
6. Data source, DB2(s) - Select data source and DB2 subsystems
7. Workload focus - Specify options for faster report access
Command ====>___________________________________________________________
Report Criteria:
Source of data . . . : Subsystem MB2D
For DB2 SSIDs . . . . : *
Start time . . . . . : 02/08/2017 03:00:00
Duration . . . . . . : No time limit
Initial report . . . : PLAN ANALYSIS (DATA)
Application profile . : DEFAULT Owner :
Workload focus . . . : NONE Qualified: N
Select one of the following options.
_ 1. Workload analysis - Begin workload reporting
2. Initial report - Select the initial report to be viewed
3. Report type - Select the report type (data or graph)
4. Application profile - Select the profile for group reporting
5. Time interval - Specify the time frame for reporting
6. Data source, DB2(s) - Select data source and DB2 subsystems
7. Workload focus - Specify options for faster report access
This section contains the following topics:
Related topic
Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*