Table of Contents
Informix User Group Forum 2000
Presented by...
What You’ll See
Troubleshooting DSA
Why Troubleshoot?
Primary tools
System knowledge
Operating System
Operating System
System hardware utilities
The System: CPU
The System: Tuning Informix for CPU Use
The System: Monitoring the CPU
The System: CPU - This is a REAL system output!
The System: Memory
The System: Checking Free Memory
The System: Checking Swap Activity
The System: Checking Paging Activity
The System: Memory Consumers
The System: Memory Rules of Thumb
The System: Memory - A Case Study
The System: Memory - A Case Study
The System: I/O
The System: Spreading the Load
The System: Testing I/O Yourself
Verify Disk
Caches, Caches, Everywhere
The System: Monitoring I/O
The System: Monitoring I/O
The System: I/O Sizes
The System: Hardware vs Software RAID
The System: Tuning I/O for Informix
Network and protocols
The Network
The Network
The Network
The Network: A Case Study
The Network: A Case Study
Troubleshooting DSA
Informix troubleshooting utilities
Utility: oncheck
Utility: onstat
Utility: system monitoring interface
Utility: finderr
Utility: archecker
Utility: archecker
Utility: archecker output
Utility: archecker output continued
Alarm Program
ALARMPROGRAM…suggestion
Event Notification
SYSALARMPROGRAM
Other Informix tools
Set explain on
Update statistics guidelines
Update statistics example
Troubleshooting update statistics
Troubleshooting DSA
Check IDS environment
Check message log
Check chunks
Check dbspaces
Check $ONCONFIG
ONCONFIG…What’s really there
Check disk structures
Tablespace (partnum) identifiers
Troubleshooting DSA
Problem reduction: The system
Problem reduction: The transaction
Define the problem
SQL problem isolation
Getting the SQL
SQL problem reproduction
SQL problem solution
Assertion failure problem isolation
Loss of IDS functionality
Working with tech support
Common sense
Troubleshooting a session
onstat -u
Userthread flags
onstat -k
Locks/Mutexes/Conditions .with waiters
Troubleshooting for performance
Un-balanced disk I/O
Balanced disk I/O
Monitoring Table Activity
Troubleshooting for performance
Troubleshooting extents
Troubleshooting problems
oninit -v
oninit -v
Troubleshooting problems
Case Study I
Case Study I (Cont.)
Case Study I (Cont.)
Case Study I Solution
Troubleshooting problems
Case Study II
Case Study II (Cont.)
Case Study II (Cont.)
Troubleshooting problems
Case study III: locking errors
Isolate the problem
What’s different
The solution
Troubleshooting problems
Case study IV: archive problems
Troubleshoot Informix
Troubleshoot the tape device
The solution
Summary
Appendix
Calc Data Extents
User Flags
User Flags
Tape max size program
Tape max size program
|