Chat now with support

Get Live Help
Complete Registration

Sign In

Request Pricing

Contact Sales

Foglight for DB2 (Cartridge) 5.9.5.10 - 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

Collections and Metrics

The Foglight for DB2 LUW agents collect metrics and store them in the Foglight topology model as topology objects.

CF Locks Collection

Tracks how database members use DB2 pureScale cluster caching facility (CF) locks.


Metric	Description
DATABASE	The name of the monitored database.
MEMBER	The name of the member.
CF_RESPONSE_TIME	Average interconnect network time per CF call calculated over all CF calls.
CF_WAIT_TIME	Time (in milliseconds) spent communicating with the cluster caching facility. Both network time and processing time. This time does not include time spent on granting locks or performing page reclaims.
CF_WAITS	Number of times the database system waited while communicating with the cluster caching facility. This is approximately the number of CF calls.
LOCK_ESCALS	Number of times that locks were escalated from several row locks to a table lock.
LOCK_ESCALS_GLOBAL	Number of lock escalations on a global lock due to global lock memory usage reaching the limit specified in the cf_lock_sz database configuration parameter.
LOCK_TIMEOUTS	Total number of lock timeouts.
LOCK_TIMEOUTS_GLOBAL	Number of lock timeouts where the application holding the lock was on a remote member
LOCK_WAIT_TIME	Total time spent waiting for locks.
LOCK_WAIT_TIME_GLOBAL	Time spent waiting for global locks in milliseconds.
LOCK_WAITS	Total number of locks waits.
LOCK_WAITS_GLOBAL	Number of locks waits due to the application holding the lock on a remote member.
GLOBAL_ESCALS_PERCENTAGE	= LOCK_ESCALS_GLOBAL / LOCK_ESCALS
GLOBAL_LOCK_TIMEOUT_PERCENTAGE	= LOCK_TIMEOUTS_GLOBAL / LOCK_TIMEOUTS
GLOBAL_LOCK_WAIT_TIME_PERCENTAGE	= LOCK_WAIT_TIME_GLOBAL / LOCK_WAIT_TIME
GLOBAL_LOCKS_PERCENTAGE	= LOCK_WAITS_GLOBAL / LOCK_WAITS.

CF Memory Pools Collection

Tracks how hosts use DB2 pureScale cluster caching facility (CF) memory pools.


Metric	Description
HOST_NAME	The name of the monitored host.
HOSTID	The ID of the CF component.
CF_LOCK_MEM_UTILIZATION	CF Lock Pool Utilization
CF_MEM_UTILIZATION	CF Memory Utilization
CF_SCA_MEM_UTILIZATION	CF SCA Pool Utilization
CONFIGURED_CF_GBP_SIZE	Configured Global Buffer Pool Size
CONFIGURED_CF_LOCK_SIZE	Configured Lock Memory Size
CONFIGURED_CF_MEM_SIZE	Configured CF Memory Size
CONFIGURED_CF_SCA_SIZE	Configured SCA Memory Size
CURRENT_CF_GBP_SIZE	Current Global Buffer Pool Size
CURRENT_CF_LOCK_SIZE	Current Lock Memory Size
CURRENT_CF_MEM_SIZE	Current Total CF Memory Size
CURRENT_CF_NONALLOCATED_SIZE	Current amount of memory allocated for the CF but not used for the GBP, LOCK, or SCA pools.
CURRENT_CF_SCA_SIZE	Current SCA Memory Size
GBP_UTILIZATION	Global Buffer Pool Utilization

CF Resource Usage Collection

Tracks how instances use DB2 pureScale cluster caching facility (CF) resources.


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).

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating

© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center