(DI-2305) Collector for Database monitoring
- SNP
The technical name of the Collector for Database monitoring is /DVD/MON_CL_COL_DB.
This collector collects information about the database, including also sizes for tables or indexes available on the database or configured tablespaces.
Monitoring of tablespaces for the database is available only for the system(s) with the Oracle or DB2/DB6 database.
Default KPIs delivered with this collector
The following default KPIs are delivered with this collector:
KPI name | Description | Unit | Detail table |
|---|---|---|---|
DB_CRIT_TAB_SP_P | Used space on the most critical data file (tablespace) | % | Yes |
DB_FREE | Free size of database | MB | Yes |
DB_INDEX_NUM | Total number of indexes | Count | Yes |
DB_INDEX_SIZE | Total size of indexes | MB | Yes |
DB_SIZE | Total size of database | MB | Yes |
DB_TAB_NUM | Total number of tables | Count | No |
DB_TAB_SIZE | Total size of tables | MB | No |
DB_TS_FREE | Free size of DB Tablespaces | MB | Yes |
DB_TS_TOTAL | Total size of DB Tablespaces | MB | Yes |
DB_TS_USED_P | Used percentage of DB tablespaces | % | Yes |
DB_USED | Used size of database | MB | Yes |
DB_USED_P | Used space on database | % | Yes |
Input table
This collector uses two input tables:
1. /DVD/MON_DBTS_I1 - Inputs for DB tablespaces monitoring setup
The rules define which tablespaces are included in the KPI value calculation. This input table provides the following fields:
Technical name | Column name | Description |
|---|---|---|
KPI | KPI name | Name of the KPI that rule applies to |
TABLE_SPACE_NAME | Tablespace name | Name of the tablespace that rule applies to |
VALUE_RESULT | Value result | Defines the function for requested KPI result value |
CHANGED_BY | Last changed by user [automatically filled] | User who last changed the specific record |
CHANGED_AT | Last changed time [automatically filled] | Time when the specific record was changed |
CREATED_BY | Created by user [automatically filled] | User who created the specific record |
CREATED_AT | Created at the time [automatically filled] | Time when the specific record was created |
2. /DVD/MON_DBTS_I2 - Inputs for index monitoring setup on DB tablespaces
This input table is relevant only the for the external Oracle database monitoring, so it does not make sense to configure it for other databases.
The rules define which indexes from the external database should be included in the monitoring. This input table provides the following fields:
Technical name | Column name | Description |
|---|---|---|
INDEX_NAME | Index name | Name of the index that rule applies to |
OWNER_NAME | Owner name | Name of the owner that rule applies to |
TABLE_SPACE_NAME | Tablespace name | Name of the tablespace that rule applies to |
CHANGED_BY | Last changed by user [automatically filled] | User who last changed the specific record |
CHANGED_AT | Last changed time [automatically filled] | Time when the specific record was changed |
CREATED_BY | Created by user [automatically filled] | User who created the specific record |
CREATED_AT | Created at the time [automatically filled] | Time when the specific record was created |
Detail table
The collector provides three detail tables that store additional information for monitored tablespace or indexes.
1. DB tablespace size statistics (all)
The technical name of the detail table for DB tablespace size statistics (all) is /DVD/MON_S_DB_TABLE_SPACE. It reports the size statistics for all tablespaces configured on the database in the following fields:
Technical name | Description |
|---|---|
TIMESTAMP | Time when the records are saved into the detail table [automatically added] |
SID | System ID [automatically added] |
TS_NAME | Tablespace name |
TS_SIZE | Total size in MB |
TS_FREE | Free size in MB |
TS_USED_P | Percentage of used size |
AUTO_EXTEND | Is tablespace auto-extended? |
2. DB tablespace size statistics (per KPI)
The technical name of the detail table for DB tablespace size statistics (per KPI) is /DVD/MON_S_DB_TS_DETAIL. It reports the size statistics only for tablespaces defined in the input table /DVD/MON_DBTS_I1 for specific KPI. Detail table contains the following fields:
Technical name | Description |
|---|---|
TIMESTAMP | Time when the records are saved into the detail table [automatically added] |
SID | System ID [automatically added] |
KPI | KPI name |
VALUE_RESULT | Defines the function for requested KPI value result |
TS_NAME | Tablespace name |
TS_SIZE | Total size in MB |
TS_FREE | Free size in MB |
TS_USED_P | Percentage of used size |
3. Database indexes
The technical name of the detail table for Database indexes is /DVD/MON_S_DB_INDEXES. It reports the index size only for indexes defined in the input table /DVD/MON_DBTS_I2 for specific owners and tablespace. This detail table contains the following fields:
Technical name | Description |
|---|---|
TIMESTAMP | Time when the records are saved into the detail table [automatically added] |
SID | System ID [automatically added] |
INDEX_NAME | Index name |
OWNER_NAME | Owner name |
TABLESPACE_NAME | Tablespace name |
Index size | Index size in bytes |