Washington Area Informix Users Group

Informix User Group Forum 2000

3/25/00


Click here to start


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

Author: Daniel A. Geoppo & Lin Cepele

Email: rayc@informix.com