Chat now with support
Chat with Support

Foglight for DB2 (Cartridge) 5.9.3.10 - User Guide

Introduction to Foglight for DB2 LUW Using Foglight for DB2 LUW Reference
Dashboards and Views Collections and Metrics
CF Locks Collection CF Memory Pools Collection CF Resource Usage Collection Current Agents Details Collection Agents Summary Collection Current Locks Wait Collection Database Bufferpools Summary PS Collection Database Configuration Collection Database Tablespaces Collection Database Tablespaces Summary Collection Database Usability Collection Database Parameters Collection Database Instance Parameters Collection Database Instance Registry Variables Collection Database Tablespaces BP Collection FCM Activity Collection FS DB Storage Collection FS DB Storage Summary Collection FS Instance Storage Collection FS Storage Collection FS Storage Summary Collection General Activity Collection HADR Activity Collection Host Properties Collection OS General Collection Instance Activity Collection Instance General Collection Instance Nodes Collection Instance Usability Collection IO Activity Collection License Details Collection Log Activity Collection Log File Collection Log Message Collection Messages Count Collection Monitor Switches Collection OS DB2 General Process Collection Partition Tablespaces Summary Collection Partition Usability Collection pureScale Alerts Collection Top SQLs Collection Top SQLs Full Text Collection Top SQLs Text Collection Query Agents Details Collection Database Partition Activity Collection DB2 Partition Subcategories Wait Collection History Locks Wait Collection History Locks Summary Collection Instance Memory Collection Instance Memory Pool Collection Instance Memory Summary Collection Instance Memory Total Collection Database Memory Collection Database Memory Pool Collection Database Memory Pool DB Collection Database Memory Summary Collection Database Memory Total Collection Database Buffer Pools Collection Database Tables Collection Database Partition Backup Collection Database Tables Global Collection Database Applications Collection

Database Tables Collection

The following table provides a list of the Database Tables metrics that are collected, and a description for each.

DBPARTITIONNUM

The database partition from which the data was retrieved.

INSTANCE_NAME

The name of the monitored instance.

DB_NAME

The name of the monitored database.

TABSCHEMA

The schema of the table.

Along with TABNAME this element can assist in determining the source of the contention for resources.

TABNAME

The name of the table.

TAB_TYPE

The type of table for which information is returned.

Types:

TBSP_ID

An integer that uniquely represents a tablespace used by the current database.

DATA_OBJECT_PAGES

The number of disk pages consumed by a table. This represents the base table size only. Space consumed by index objects, LOB data, and long data are reported by INDEX_OBJECT_PAGES, LOB_OBJECT_PAGES, and LONG_OBJECT_PAGES, respectively.

INDEX_OBJECT_PAGES

The number of disk pages consumed by all indices defined in a table.

LOB_OBJECT_PAGES

The number of disk pages consumed by LOB data.

LONG_OBJECT_PAGES

The number of disk pages consumed by long data in a table.

XDA_OBJECT_PAGES

The number of disk pages consumed by XML storage object (XDA) data.

ROWS_READ

The number of rows read from the table.

ROWS_WRITTEN

The number of rows changed (inserted, deleted, or updated) in the table.

OVERFLOW_ACCESSES

The number of reads and writes from/to overflowed rows of this table.

PAGE_REORGS

The number of page reorganizations executed for a table.

Database Partition Backup Collection

The following table provides a list of the Database Partition Backup Collection metrics that are collected, and a description for each.

DBPARTITIONNUM

The database partition number from which the data was retrieved for this row.

LAST_SUCCESSFUL_BACKUP_START

The start time of the last successful backup.

LAST_SUCCESSFUL_BACKUP_END

The end time of the last successful backup.

LAST_SUCCESSFUL_BACKUP_TYPE

The type of the last successful backup.

Values:

DAYS_SINCE_LAST_SUCCESSFUL

The number of days that have passed since the last successful backup.

LAST_BACKUP_START

The start time of the last backup.

LAST_BACKUP_END

The end time of the last backup.

LAST_BACKUP_TYPE

The type of the last backup.

Values:

LAST_BACKUP_STATUS

The sqlcode value returned for the most recent running backup.

Values:

For more detail, query dbadmin db_history.

Database Tables Global Collection

The following table provides a list of the Database Tables Global metrics that are collected, and a description for each.

INSTANCE_NAME

The name of the monitored instance.

DB_NAME

The name of the monitored database.

TABSCHEMA

The schema of the table.

Along with TABNAME, this element can assist in determining the source of the contention for resources.

TABNAME

The name of the table.

TAB_TYPE

The type of table for which information is returned.

Types:

TBSP_ID

An integer that uniquely represents a tablespace used by the current database.

DATA_OBJECT_PAGES

The number of disk pages consumed by a table. This represents the base table size only. Space consumed by index objects, LOB data, and long data are reported by INDEX_OBJECT_PAGES, LOB_OBJECT_PAGES, and LONG_OBJECT_PAGES, respectively.

INDEX_OBJECT_PAGES

The number of disk pages consumed by all indices defined in a table.

LOB_OBJECT_PAGES

The number of disk pages consumed by LOB data.

LONG_OBJECT_PAGES

The number of disk pages consumed by long data in a table.

XDA_OBJECT_PAGES

The number of disk pages consumed by XML storage object (XDA) data.

ROWS_READ

The number of rows read from the table.

ROWS_WRITTEN

The number of rows changed (inserted, deleted, or updated) in the table.

OVERFLOW_ACCESSES

The number of read and write operations from/to overflowed rows of this table.

PAGE_REORGS

The number of page reorganizations executed for a table.

Database Applications Collection

The following table provides a list of the Database Applications metrics that are collected, and a description for each.

DB_NAME

The name of the monitored database.

DBPARTITIONNUM

The database partition from which the data was retrieved for this row.

APPL_NAME

The name of the application running on the client.

ACTIVE_TIME

The elapsed time (in seconds) spent processing an SQL request on a host database server.

FOREGROUND_BACKGROUND_TYPE

The foreground or background status of the application.

ROWS_READ

The number of rows read from the table.

ROWS_WRITTEN

The number of rows changed (inserted, deleted, or updated) in the table.

APPL_IDLE_TIME

The number of seconds since an application issued any requests to the server. This includes applications that have not terminated a transaction (for example, not issued a commit or rollback).

TOTAL_CPU

The total CPU time (in seconds) used by the application.

AGENT_USR_CPU_TIME_S

The user CPU time (in seconds) used by the application.

AGENT_SYS_CPU_TIME_S

The system CPU time (in seconds) used by the application.

DIRECT_READS

The number of direct reads by the application.

DIRECT_WRITES

The number of direct writes by the application.

DIRECT_READ_TIME

The direct read time by the application.

DIRECT_WRITE_TIME

The direct write time by the application.

LOCKS_HELD

The locks held by the application.

LOCK_WAITS

The number of lock waits related to the application.

LOCK_WAIT_TIME

The lock wait time of the application.

LOCK_ESCALS

The number of lock escalations.

X_LOCK_ESCALS

The number of exclusive lock escalations.

TOTAL_SORTS

The total sorts related to the application.

TOTAL_SORT_TIME

The total sort time.

SORT_OVERFLOWS

The sort overflows of the application.

COMMIT_SQL_STMTS

The commit SQL statements related to the application.

ROLLBACK_SQL_STMTS

The rollback SQL statements related to the application.

PERCENT_SORT_OVERFLOWS

The percentage of sort operations, out of the total sort operations, that ran out of sort heap and may have required disk space for temporary storage.

FAILED_SQL_STMTS

The number of failed SQL statements.

DYNAMIC_SQL_STMTS

The number of dynamic SQL statements.

STATIC_SQL_STMTS

The number of static SQL statements.

SELECT_SQL_STMTS

The number of select SQL statements.

DDL_SQL_STMTS

The number of DDL SQL statements.

UID_SQL_STMTS

The number of DML SQL statements (UID).

ROWS_DELETED

The rows deleted by the application.

ROWS_INSERTED

The rows inserted by the application.

ROWS_UPDATED

The rows updated by the application.

ROWS_SELECTED

The rows selected by the application.

HASH_JOIN_OVERFLOWS

The hash join overflows of the application.

LOCKS_WAITING

The locks waiting related to the application.

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating