• Interactive Performance Monitor User Guide
•  1. Introducing Ingres Performance Monitoring
  • Interactive Performance Monitor
  • Terms Used in This Guide
  • System-specific Text in This Guide
  • Syntax Conventions Used in This Guide
•  2. Installation Considerations for IPM
  • Privileges and IPM
  • Requirements for Running IPM
  •  ipm Command—Start IPM
    • Resource Type—Display Specific Resource
  • IPM Release Compatibility
•  3. Understanding Forms and Menus
  • IPM Display Format Notes
  • Main Menu Map
  • Server List Menu Map
  • Lock Info Menu Map
  • Log Info Menu Map
  •  Main Menu Screen
    • Main-Menu Menu Items
  •  Option Selection Screen
    • Change Options on the Options Selection Screen
    • Option Selection Menu Items
•  4. Monitoring Server Information
  • Server Information
  •  Server List Screen
    • Server List Menu Items
  •  Server Detail Screen (More_Info)
    • Server Detail Menu Items
  •  Session List Screen
    • Session List Menu Items
  •  Session Detail Screen (More_Info)
    • Session Detail Menu Items
  •  Detailed Process Information Screen (VMS Only)
    • Display Detailed Process Information Screen
    • Detailed Process Information Screen Fields
    • Detailed Process Information Menu Items
•  5. Monitoring Lock Information
  • Lock Information
  •  Lock Info Menu Screen
    • Lock Info Selections
    • Lock Info Menu Items
  •  Locking System Summary Screen
    • Locking System Summary Fields
    • VMS Cluster Only Fields (VMS Only)
    • Locking System Summary Menu Items
    • Interval Option (Locking System Summary)
  • Display Locking System Summary
  •  Lock List Display Screen
    • Find Waiting Locks
    • Lock List Display Fields
    • Lock List Display Menu Items
    • Lock List Display More_Info Screen
  •  Lock Detail Display Screen
    • Lock Detail Display Menu Items
    • Lock Detail Display More_Info Screen
  •  Resource Lock Display Screen
    • Mode Values
    • Resource Lock Display Menu Items
  •  Blocking Lock Display Screen
    • Look for Concurrency Bottlenecks
    • Blocking Lock Display Fields
    • Scrolling Area (Blocking Lock Display)
    • Blocking Lock Display Menu Items
  •  Resource List Display Screen
    • Resource List Display Fields
    • Resource List Display Menu Items
    • Resource List Display More_Info Screen
  •  Resource Detail Display Screen
    • Resource Detail Display Fields
    • Resource Detail Display Menu Items
•  6. Monitoring Log Information
  • Log Information
  •  Log Info Menu Screen
    • Log Info Menu Items
  •  Logging System Summary Screen
    • Logging System Summary Fields
    • Logging System Summary Menu Items
    • Interval Option (Logging System Summary)
  •  Logging System Header Screen
    • Logging System Header Fields
    • Logging System Header Screen—Status Field Values
    • Logging System Header Menu Items
    • Logging System Header More_Info Screen
    •  Logging System Header Screen with Transaction Display
      • Examine a Particular Position in the Log File
    • Transaction Display Menu Items
    • More_Info Screen (Transaction Display)
  •  Log Process Display Screen
    • Log Process Display Menu Items
  •  Log Database Display Screen
    • Log Database Display Menu Items
    • Log Database Display More_Info Screen
  •  Log Transaction Display Screen
    • Log Transaction Display Fields
    • Log Transaction Display Menu Items
    • Log Transaction Display More_Info Screen
•  7. Using IPM to Monitor and Troubleshoot
  • View Running Servers
  • View Sessions
  • Monitor Resource Usage
  • Operate With an Unresponsive Server
  • Check for Logging Delays
  • Locate Concurrency Problems
  • Determine Group Commit Efficiency
  • Check Log File Capacity
  • Locate a Problem Transaction
  • IPM as a Troubleshooting Tool

Ingres 10S

IPM as a Troubleshooting Tool