Performance Advisor tables
This topic lists the tables that Performance Advisor uses, the
Apptune
IFCIDs that each tables uses as its data source, and whether the tables can be partitioned.
Table | Description | IFCID | Partition-able |
|---|---|---|---|
OBJ_STATISTICS | Statistics per object per defined collection interval | 009 |
|
DAILY_OBJ_STATISTICS | Statistics per object per day | 009 | Yes |
WEEKLY_OBJ_STATISTICS | Statistics per object per week | 009 | Yes |
MONTHLY_OBJ_STATISTICS | Statistics per object per month | 009 | Yes |
BASELINE_OBJ_STATISTICS | Statistics per object representing acceptable performance | 009 |
|
STMT_STATISTICS | Statistics per statement per defined collection interval | 307 |
|
DAILY_STMT_STATISTICS | Statistics per statement per day | 307 | Yes |
WEEKLY_STMT_STATISTICS | Statistics per statement per week | 307 | Yes |
MONTHLY_STMT_STATISTICS | Statistics per statement per month | 307 | Yes |
BASELINE_STMT_STATISTICS | Statistics per statement representing acceptable performance | 307 |
|
WKLD_STATISTICS | Statement statistics aggregated by non-statement collection key (plan, program, user, and so on) per defined collection interval | 310 |
|
DAILY_WKLD_STATISTICS | Statement statistics aggregated by non-statement collection key (plan, program, user, and so on) per day | 310 | Yes |
WEEKLY_WKLD_STATISTICS | Statement statistics aggregated by non-statement collection key (plan, program, user, and so on) per week | 310 | Yes |
MONTHLY_WKLD_STATISTICS | Statement statistics aggregated by non-statement collection key (plan, program, user, and so on) per month | 310 | Yes |
BASELINE_WKLD_STATISTICS | Statement statistics aggregated by non-statement collection key (plan, program, user, and so on) representing acceptable performance | 310 |
|
STMT_STATISTICS_OB | Statistics per object per statement per defined collection interval | 008 |
|
STMT_TEXT | SQL statement text | 005 |
|
STMT_ERRORS | SQL executions finishing with SQLCODE < 0 | 007 |
|
STMT_EXCEPTIONS | SQL executions exceeding defined thresholds | 004 |
|
STMT_EXCEPTIONS_HV | Host variable values associated with statement exceptions | 010 |
|
STMT_EXCEPTIONS_OB | Object statistics associated with statement exceptions | 011 |
|
BMCTABLESPACESTATS1 | Table space real-time stats per day |
|
|
BMCINDEXSPACESTATS1 | Index space real-time stats per day |
|
|
BASIC_STMT_STATISTICS | Statistics per statement when Basic monitoring mode is activated | 507 | |
BASIC_WKLD_STATISTICS | Statement statistics aggregated by non-statement collection key (program, user, and so on) when Basic monitoring mode is activated | 510 | |
BASELINE_BASIC_STMT_STATISTICS | Statistics per statement representing acceptable performance when Basic monitoring mode is activated | 507 | |
BASELINE_BASIC_WKLD_STATISTICS | Statement statistics aggregated by non-statement collection key (program, user, and so on) representing acceptable performance when Basic monitoring mode is activated | 510 | |
DAILY_BASIC_STMT_STATISTICS | Statistics per statement per day when Basic monitoring mode is activated | 507 | |
DAILY_BASIC_WKLD_STATISTICS | Statement statistics aggregated by non-statement collection key (program, user, and so on) per day when Basic monitoring mode is activated | 510 | |
WEEKLY_BASIC_STMT_STATISTICS | Statistics per statement per week when Basic monitoring mode is activated | ||
WEEKLY_BASIC_WKLD_STATISTICS | Statement statistics aggregated by non-statement collection key (program, user, and so on) per week when Basic monitoring mode is activated | ||
MONTHLY_BASIC_STMT_STATISTICS | Statistics per statement per month when Basic monitoring mode is activated | 507 | |
MONTHLY_BASIC_WKLD_STATISTICS | Statement statistics aggregated by non-statement collection key (program, user, and so on) per month when Basic monitoring mode is activated | 510 |
1 The data source is Db2 real-time statistics.
Related topic