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 11.0
IPM as a Troubleshooting Tool