Foglight for DB2 (Cartridge) 5.9.2.1


Metric	Description
INSTANCE	The name of the monitored instance.
ID	The ID of the CF component.
HOST	The name of the machine that hosts the CF component.
CPU_USAGE_TOTAL	Percentage of overall CPU usage of the CF machine.
MEMORY_FREE	Amount of free physical memory (MB).
MEMORY_SWAP_FREE	Amount of free swap space (MB).
MEMORY_SWAP_TOTAL	Total amount of swap space (MB).
MEMORY_TOTAL	Total size of physical memory (MB).
MEMORY_UTILIZATION	The percentage of free memory out of the total memory assigned to the CF machine.
VIRTUAL_MEMORY_FREE	Amount of reserved virtual memory.
VIRTUAL_MEMORY_TOTAL	Total amount of virtual memory on the system (MB).

Current Agents Details Collection

The following table provides a list of the Current Agents Details metrics that are collected, and a description for each.


Metric	Description
DB_NAME	The name of the monitored database.
DBPARTITIONNUM	The database partition from which the data was retrieved for this row.
AGENT_ID	The unique ID for the application. On a single-partitioned database, this ID consists of a 16-bit counter. On a multi-partitioned database, this ID consists of the coordinating partition number concatenated with a 16-bit counter. In addition, this ID is the same on every partition where the application may make a secondary connection.
APPL_CON_TIME	The date and time that an application started a connection request.
APPL_NAME	The name of the application running at the client.
APPL_ID	This ID is generated when the application connects to the database. It is unique across the network. There are different formats for the application ID, which depend on the communication protocol between the client and the server machine on which the database manager resides.
APPL_STATUS	The status of the application. This element can help you diagnose potential application problems. Values: BACKUP COMMIT_ACT COMP CONNECTED CONNECTPEND CREATE_DB DECOUPLED DISCONNECTPEND INTR IOERROR_WAIT LOAD LOCKWAIT QUIESCE_TABLESPACE RECOMP REMOTE_RQST RESTART RESTORE ROLLBACK_ACT ROLLBACK_TO_SAVEPOINT TEND THABRT THCOMT TPREP UNLOAD UOWEXEC UOWWAIT WAITFOR_REMOTE
NUM_ASSOC_AGENTS	The number of subagents associated with an application.
COORD_NODE_NUM	In a multi-node system, the node number of the node where the application is connected or attached to the instance.
ACTIVE_TIME	The elapsed time (in seconds) spent processing an SQL request on a host database server.
EXECUTION_ID	The ID that the user specified when logging in to the operating system. This ID is distinct from AUTH_ID, which the user specifies when connecting to the database.
AUTHORITY_LVL	This interface returns a text identifier based on the database authorities defined in sql.h and their source. Possible “authority” values: BINDADD CONNECT CREATE_EXT_RT CREATE_NOT_FENC CREATETAB DBADM IMPLICIT_SCHEMA LOAD LIBADM QUIESCE_CONN SECADM SYSADM SYSCTRL SYSMAINT SYSMON SYSQUIESCE Possible “source” values: USER — authority granted to the user or to a role granted to the user GROUP — authority granted to a group to which the user belongs or to a role granted to the group to which the user belongs
CLIENT_PID	The process ID of the client application that made the connection to the database.
COORD_AGENT_PID	The ID of the coordinator agent for the application.
STATUS_CHANGE_TIME	The date and time the application entered its status.
CLIENT_PLATFORM	This interface returns a text identifier based on the client platform definition in sqlmon.h.
CLIENT_PROTOCOL	This interface returns a text identifier based on the definition in sqlmon.h. Values: CPIC LOCAL NETBIOS NPIPE TCPIP (for DB2® UDB) TCPIP4 TCPIP6
TERRITORY_CODE	The territory code of the database for which the monitor data is collected.
CODEPAGE_ID	The code page at the partition where the monitored application started.
PRIMARY_AUTH_ID	The authorization ID of the user who invoked the application that is being monitored.
SESSION_AUTH_ID	The current authorization ID for the session used by this application.
CLIENT_NNAME	Deprecated by IBM.
CLIENT_DB_ALIAS	The alias of the database, provided by the application, to connect to the database.
DB_PATH	The full path of the location where the database is stored on the monitored system.
STMT_TEXT	The SQL statement text.
FOREGROUND_BACKGROUND_ TYPE	The foreground or background status of the application.
ROWS_READ	This is 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 amount of time (in seconds) that has passed since an application has issued any requests to the server. Includes applications that have not terminated a transaction (for example, not issued a commit or rollback).
POOL_DATA_L_READS	The number of data pages that have been requested from the buffer pool (logical) for regular and large tablespaces.
POOL_INDEX_L_READS	The number of index pages that have been requested from the buffer pool (logical) for regular and large tablespaces.
POOL_INDEX_P_READS	The number of index pages read in from the tablespace containers (physical) for regular and large tablespaces.
POOL_TEMP_DATA_L_READS	The number of data pages that have been requested from the buffer pool (logical) for temporary tablespaces.
POOL_TEMP_DATA_P_READS	The number of data pages read in from the tablespace containers (physical) for temporary tablespaces.
POOL_TEMP_INDEX_L_READS	The number of index pages that have been requested from the buffer pool (logical) for temporary tablespaces.
POOL_TEMP_INDEX_P_READS	The number of index pages read in from the tablespace containers (physical) for temporary tablespaces.
LAST_RESET	The date and time when the monitoring counters were reset.
PACKAGE_CACHE_HIT_RATIO	A ratio that indicates how well the package cache is helping to avoid the reload of packages and sections for static SQL from the system catalogs and the recompilation of dynamic SQL statements. The indicator is calculated using the formula: (1-(db.pkg_cache_inserts/db.pkg_cache_lookups))*100

Agents Summary Collection

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


Metric	Description
ACTIVE	The number of active agents.
ACTIVE_Rate	The number of active agents per second (average active sessions).
BACKGROUND_PROCESSES	The sum of background application agents.
BACKUP_AGENTS	Indicates that the application is performing a backup of the database.
BALANCE_AVERAGE_ACTIVE_ SESSIONS	The balance of average active agents across the database partitions. If most of the activity is on one partition, for example, the activity is not balanced. If most of the activity is spread equally across the partitions, it is balanced.
COMMIT_ACT_AGENTS	Indicates that the unit of work is committing its database changes.
COMP_AGENTS	Indicates that the database manager is compiling an SQL statement or precompiling a plan on behalf of the application.
CONNECTPEND_AGENTS	Indicates that the application has initiated a database connection, but the request has not yet completed.
CREATE_DB_AGENTS	Indicates that the agent has initiated a request to create a database, but that request has not yet completed.
DB_NAME	The name of the monitored database.
DBPARTITIONNUM	The database partition from which the data was retrieved for this row.
DECOUPLED_AGENTS	Indicates that there are no agents currently associated with the application. This is a normal state. When the Connection Concentrator is enabled, there is no dedicated coordinator agent, so an application can be decoupled on the coordinator partition. In non-concentrator environments, an application cannot be decoupled on the coordinator partition, because there is always a dedicated coordinator agent.
DISCONNECTPEND_AGENTS	Indicates that the application has initiated disconnection from the database, but the command has not yet completed running. The application may not have explicitly run the database disconnect command. The database manager disconnects from a database if the application ends without disconnecting.
FOREGROUND_PROCESSES	The sum of foreground application agents.
INACTIVE	Indicates that the application is in one of three states: connected, uowwait, or decoupled.
INTR_AGENTS	Indicates that an interrupt of a request is in progress.
IOERROR_WAIT_AGENTS	Indicates that the application has detected an I/O error and is attempting to disable a particular tablespace. The application has to wait for all other active transactions on the tablespace to complete before it can disable the tablespace.
LOAD_AGENTS	Indicates that the application is performing a “fast load” of data into the database.
LOCKWAIT_AGENTS	Indicates that the unit of work is waiting for a lock. After the lock is granted, the status is restored to its previous value.
QUIESCE_TABLESPACE_AGENTS	Indicates that the application is performing a quiesce tablespace request.
RECOMP_AGENTS	Indicates that the database manager is recompiling (that is, rebinding) a plan on behalf of the application.
REMOTE_RQST_AGENTS	Indicates that the application is waiting for results from a federated data source.
RESTART_AGENTS	Indicates that the application is restarting a database in order to perform crash recovery.
RESTORE_AGENTS	Indicates that the application is restoring a backup image to the database.
ROLLBACK_ACT_AGENTS	Indicates that the unit of work is rolling back its database changes.
ROLLBACK_TO_SAVEPOINT_AGENTS	Indicates that the application is rolling back to a savepoint.
TEND_AGENTS	Indicates that the unit of work is part of a global transaction that has ended, but has not yet entered the prepared phase of the two-phase commit protocol.
THABRT_AGENTS	Indicates that the unit of work is part of a global transaction that has been heuristically rolled back.
THCOMT_AGENTS	Indicates that the unit of work is part of a global transaction that has been heuristically committed.
TOTAL_AGENTS	The total number of agents of all types.
TOTAL_AGENTS_Rate	The rate of total agents per second.
UNLOAD_AGENTS	Indicates that the application is performing a “fast unload” of data from the database.
UOWEXEC_AGENTS	Indicates that the database manager is running requests on behalf of the unit of work.
UOWWAIT_AGENTS	Indicates that the database manager is waiting on behalf of the unit of work in the application. This status typically means that the system is running in the application's code.
WAITFOR_REMOTE_AGENTS	Indicates that the application is waiting for a response from a remote partition in a partitioned database instance.
OTHER	The agents not identified by one of the agent types we show at the workload agents.