Course Title DB2 performance monitoring for LUW Course Code

							Course Title:   DB2 performance monitoring for LUW

Course Code: DB2LPRF

Audience:       Database Administrators; developers, performance specialists.

Duration:       2 days


Abstract:       This course gives you details and understanding of what to
                achieve in monitoring your performance in DB2 for LUW.




Objectives:     This course will provide the attendee with a thorough
                understanding of how to monitor their DB2 for LUW systems.
                The attendee will be able to identify the key components of
                monitors and snapshots and to highlight the key performance
                issues.

Course Materials:
              • Comprehensive student handout
              • Access to the DOCE Centres of Excellence for support related
                 questions

Instructors:
                •   Internationally recognised DB2 specialists
                •   DB2 Specialists – working with DB2 since V1.2 (almost 20
                    years) and actively working at customer sites
                •   Regular speakers at IDUG and contributors to DB2
                    magazines
                •   IBM Certified
Course Details

        Performance measurement basics
           • What to measure
           • Performance objectives

        Configuration
          • Registry variables
          • DBM Configuration parameters
          • DB configuration parameters
          • Monitor switches
          • Initial configuration advisor settings

        Snapshot monitoring
          • snapshot for tablespaces, tables
          • snapshot for locks
          • snapshot for bufferpools
          • snapshot for database manager, database, remote databases
          • snapshot for dcs databases, dcs applications
          • snapshot for dynamic sql, remote applications
          • snapshot for fcm

        Event monitors
          • Database
          • Tablespaces
          • Tables
          • Bufferpools
          • Connections
          • Statements
          • Transactions
          • Event monitors in Tables

        List function
           • List applications
           • List DCS applications
           • List indoubt transactions

        DB2 connect monitoring
          • List DCS databases
          • List DCS applications
SQL functions for monitoring
  • Snapshot table functions
  • Events written to tables

db2pd

Key performance Indicators
  • Top 10 performance tips
  • Connection indicators
  • Locking indicators
  • Bufferpool indicators

SQL   performance case studies
  •    Connections
  •    Deadlocks
  •    Poor SQL
  •    Network issues
  •    Missing indexes

Performance tips
   • Key performance ratios
   • Design tips
   • SQL tips