LogoLogo
  • Welcome
  • Overview
    • Architecture
      • API Server
      • Sizing
    • Dashboard Overview
    • Monitoring Concepts
      • Application Performance Management
        • Availability Monitoring
        • Performance Intelligence
        • Service Level Management
        • Synthetic Transaction Management
        • Alerts Management
        • Reporting & Analytics
      • Infrastructure Monitoring
      • Unified Monitoring
    • Automation Concepts
      • Definition of Terms
      • Infrastructure as Code
        • Project Structure and Organization
        • Setting Up IaC Environment
        • Infrastructure Provisioning
        • Configuration Management
      • SAP Basis Automation
      • Automated Migration
  • User Guide
    • Onboarding
    • Setup
      • Gateway Setup
        • Gateway Network Setup
        • IT-Conductor Gateway Setup on Windows
        • IT-Conductor Gateway Setup on Linux
        • IT-Conductor Gateway Setup on AWS
        • IT-Conductor Gateway Setup on Azure
        • IT-Conductor Gateway Setup for SAP Secure Network Communications (SNC)
      • API Server Setup
      • MSP Tenant Setup
      • SSO Setup
        • Azure ADFS Identity Provider
        • Azure Active Directory (AAD) App Gallery
    • Monitoring
      • General
        • Maintenance Mode
          • Manual Maintenance
          • Scheduled Maintenance
        • Central Syslog Server Monitoring
        • URL Monitoring Locations
      • Cloud Monitoring
        • AWS Monitoring
        • Microsoft Azure Monitoring
      • Database Monitoring
        • IBM DB2 Database Monitoring
        • Microsoft SQL Server Monitoring
        • Oracle Database Monitoring
        • SAP HANA System Monitoring
          • SAP HANA Scale-Out Monitoring
          • SAP HANA Overview Dashboard
          • SAP HANA Alert Management
        • SAP ASE Database Monitoring
        • SAP MaxDB Monitoring
        • HA/DR Monitoring
      • Infrastructure Monitoring
        • File Server Monitoring
          • File Watcher Monitoring
        • Git Server
        • OS Monitoring
          • Unix/Linux System Monitoring
            • Linux Network Interface Monitoring
            • OS Printer Monitoring
          • Windows System Monitoring
            • WinRM Adapter Configuration
              • WinRM Services Configuration
              • Domain User Access
              • WMI Namespace Access
              • Windows Service Configuration
        • VMWare vCenter Monitoring
      • SAP Monitoring
        • Business Process Monitoring
          • Business Process Composer
          • BDoc Monitoring
          • IDoc Monitoring
        • SAP BusinessObjects Monitoring
          • SAP BO Data Services Monitoring
        • SAP Cloud Connector Monitoring
        • SAP Host Agent Monitoring
        • SAP NetWeaver Monitoring
          • SAP ABAP System Monitoring
            • SAP Transports
            • Security Role Import
            • SAP ABAP Overview Dashboard
            • SAP CCMS Alert Monitoring
            • SAP Batch Jobs Monitoring
              • SAP Batch Job Monitoring for CCMS Alerts
              • Advanced SAP Batch Job Monitoring
            • SAP SLT & RFC Connection Monitoring
            • Print Spooler Monitoring
            • Workload Monitoring
              • Transaction Code Monitoring
              • SAP Workload Monitoring
          • SAP J2EE System Monitoring
            • SAP J2EE Monitoring Role
            • Keystore Views and Certificates Monitoring
            • SAP PO Application Monitoring
          • SAP Systems Administrator Panel
        • SAP Web Dispatcher Monitoring
        • LMDB Discovery
        • Team-Based Central SAP Download Manager
    • Automation
      • Migration
        • Oracle to AWS Migration
        • Oracle to ASE Migration
        • SAP on MSSQL to AWS Migration
        • S/4HANA to Cloud Migration
      • E2E System Refresh Automation
        • Frequently Asked Questions
      • Age-based HANA Backup Automation
      • Inbound/Outbound Queue Restart Automation
      • OS File System Cleanup Automation
      • OS Linux Pacemaker Cluster Error Management
      • OS Printer Queue Restart Automation
      • OS Linux Kernel Patching using ChAI
      • OS Linux System Reboot using ChAI
      • SAP Batch Job Restart on Error
      • SAP Kernel Update using ChAI
      • SAP HANA Account Activation using ChAI
      • SAP Transports using ChAI
        • Frequently Asked Questions
      • SAP User Unlock and Password Reset Automation
      • Start/Stop Automation
    • Reporting
      • Available Reports
      • Creating Reports
        • Service Health KPI Report
      • Scheduling Reports
        • Automated HANA Reports
      • Report Elements
      • Archived Alerts Reporting
    • Account Administration
      • Invite Users
      • Create Robot Users
      • Update Linux System Account Password After Expiration
    • Notifications
      • Alerts
      • Threshold Overrides
        • Threshold Overrides Variables
      • Notification Targets
      • Distribution Lists
      • Subscriptions
      • Custom SMTP Notification Providers
      • Integration Providers
        • Derdack EA Integration
        • ilert Integration
        • Jira Service Desk Integration
        • Microsoft Teams Integration
        • PagerDuty Integration
        • Slack Integration
      • On-Call Scheduling
      • Calendar Events
    • Diagnostics
      • Gateway Communication Dump Debug Mode
      • Running IT-Conductor Gateway from CLI
      • SAP CCMS Missing Data
    • IT-Conductor FLUX
    • SID-Refresh
      • Product Overview
      • Getting Started
      • Documentation
      • Release Notes
      • Frequently Asked Questions
      • Troubleshooting Guide
        • Component CRM_MIDDLEWA_CRM - CRM Middleware Configuration
        • Failure to Start the Java-based GUI
        • Inconsistencies found in the table TADIR
        • Java-based GUI Runs with Pixelated Fonts
        • No email message is created after sending an email in SO01
        • Program Run as root
        • SICF Wrong Credentials
        • SU01: Error in user management
        • External Resources
      • Pricing
  • Release Notes
    • Gateway
  • References
    • Open-Source Software
    • Support
Powered by GitBook
On this page
  1. User Guide
  2. Monitoring
  3. Database Monitoring

IBM DB2 Database Monitoring

PreviousDatabase MonitoringNextMicrosoft SQL Server Monitoring

Last updated 7 months ago

IBM DB2 is a robust relational database management system designed to handle large volumes of data with high performance and reliability. It supports various workloads, from transactional processing to analytics, making it a versatile solution for organizations across industries. With advanced features like data compression and workload management, IBM DB2 is trusted to handle mission-critical applications.

Monitoring IBM DB2 enables database administrators to maintain optimal performance by tracking key metrics such as lock waits, timeouts, and resource utilization. This facilitates the prevention of potential issues before they escalate, reducing downtime and improving overall stability.

Note: IBM DB2 metric collection is integrated with SAP systems and falls under the scope of . This ensures seamless integration and alignment with SAP performance management, covering DB2 health, resource utilization, and operational efficiency.

Monitor IBM DB2 Database in IT-Conductor

To view the availability and performance metrics of an IBM DB2 database, locate and expand the SAP systems node until you find the DB2 Universal Database node in the service grid.

IBM DB2 Database Key Metrics

  • Overall Buffer Quality - refers to the effectiveness of the buffer pool in reducing disk I/O by keeping frequently accessed data in memory.

  • Catalog Cache Quality - refers to the efficiency of the catalog cache, which stores metadata about database objects like tables and indexes.

  • Deadlocks - occur when two or more transactions are waiting on each other to release locks, resulting in a standoff where none can proceed. When a deadlock is detected, one of the transactions must be rolled back to resolve the issue.

  • Exclusive Lock Escalations - occur when a large number of row-level locks held by a transaction are escalated to a table-level exclusive lock.

  • Lock Escalations - refer to the process of converting multiple fine-grained locks into a higher-level lock to conserve system resources.

  • Lock Timeouts - occur when a transaction waits for a lock for too long and is forced to stop waiting.

  • Package Cache Quality - refers to the effectiveness of the package cache in reducing the need for recompilation and improving query performance by storing frequently executed SQL statements.

  • Backup Errors - refer to any issues that occur during the process of backing up the database.

Note: All metrics will not show data when a server is unavailable.

Tablespaces

To view the Tablespaces metrics, expand the Tablespaces node and locate the specific tablespace.

To view an overview chart of the used space of all tablespaces, click Used Space Overview.

Server Metrics

To view the server metrics where the database is hosted, locate and expand the server node.

To access a historical view of each of these metrics, click and a pop-up chart will be displayed.

Click to view the historical chart for Used Space and Status.

Click to view the tablespace attributes.

See for more details.

OS Monitoring
SAP Monitoring
Figure 1: DB2 Universal Database Node View in Service Grid
Figure 2: Overall Buffer Quality Chart in Service Grid
Figure 3: Tablespaces Node View in Service Grid
Figure 4: Used Space Overview Chart
Figure 5: Server Node in Service Grid