Chat now with support

Get Live Help
Complete Registration

Sign In

Request Pricing

Contact Sales

Foglight for DB2 (Cartridge) 5.9.5.20 - User Guide

Table of Contents

Introduction to Foglight for DB2 LUW

Upgrading to the Current Version Overview Running the Upgrade Wizard

Using Foglight for DB2 LUW

Viewing the Databases Dashboard

Assigning Instances to Users Selecting an Instance to Monitor

Filtering the Display by Severity Creating User-defined Database Groups Components Shared by All Foglight for DB2 LUW Screens Using the Currently Selected Database Group Table

Adding and Configuring Agents

Understanding the Foglight for DB2 LUW Architecture Configuring the On Demand Port on the Agent Manager Concentrator Configuring Foglight for DB2 LUW Monitoring Agents

Administering Foglight for DB2 LUW

Opening the Databases Administration Dashboard Reviewing the Administration Settings Adding or Editing OS Credentials

Using Existing Host Credentials as OS Credentials Creating or Editing OS Credentials

Defining Data Collection Options Customizing Alarms for Foglight for DB2 LUW Rules

Introducing the Alarms View Setting and Modifying Alarm Sensitivity Levels Modifying Alarm Settings Configuring Email Notifications Cloning Agent Settings Reviewing Rule Definitions

Adding User-defined Collections On-demand Data Port Database Connection Details

Setting credentials and instance properties

Exploring DB2 Database Performance Metrics

Instance Homepage Database Homepage

Using the Database Homepage Toolbar Activity Panel Memory Panel Storage Panel Diagnostic Log Panel Initialization Parameters Panel

Member Overview Homepage Member (Real Time) Homepage

Reporting on Your DB2 Environment

About the Foglight for DB2 LUW Reports

Dashboards and Views

Databases Dashboard

Database Alarms Database Environment Tiles Databases Instances View Database Cue Card

Instance home page

How to Get Here Summary Memory Drill-down

Database home page

How to Get Here Summary SQL Performance Activity Drill-downs Memory Drill-downs Storage Drill-downs Tablespaces Tablespaces Buffer Pool Activities Log Drill-down Configuration Drill-down

Member Overview home page

How to Get Here Summary

Member (Real Time) home page

How to Get Here Summary

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 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 Applications Collection

The following table provides a list of the Database Applications 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.
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

© ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center