Table of Contents
Informix Dynamic Server .Monitoring and Tuning
Goals of Performance Tuning
Monitoring Goals
PPT Slide
PPT Slide
PPT Slide
PPT Slide
PPT Slide
PPT Slide
PPT Slide
PPT Slide
PPT Slide
PPT Slide
PPT Slide
PPT Slide
PPT Slide
Key Tuning Parameters in the.ONCONFIG File
Key Tuning Parameters in the.ONCONFIG File
Key Tuning Parameters in the.ONCONFIG File
Key Tuning Parameters in the.ONCONFIG File
Key Tuning Parameters in the.ONCONFIG File
The IDS command line utilities
ONSTAT syntax
Key ONSTAT options
Key ONSTAT MT options
Current status of Server: onstat -
Server Profile - onstat -p
Key Elements of onstat -p
Display message log file: onstat -m
Using “tail -f” to continuously shown the end of message log file
User status: onstat -u.
User status: onstat -u Flags
User status: onstat -u Flags
Logical Logs status: onstat -l
Logical Logs status: onstat -l Flags
Display transactions: onstat -x
Display locks: onstat -k
Who owns a lock
What table is locked?
What table is locked?
Types of locks
Types of locks Flags
Dbspaces and chunks status: onstat -d.
onstat -d Flags
Disk I/O: onstat -D
Writing to Disk - onstat -F
Writing to Disk - onstat -F
List all threads: onstat -g ath
List Virtual Processor status: onstat -g sch
List SQL statement types: .onstat -g sql
List SQL statement for a user: onstat -g sql sid.
List users sessions: onstat -g ses
Other Onstat Options
ONCHECK - Check and display Disk Space
ONCHECK syntax
ONCHECK syntax
Checking Reserved Pages: oncheck -pr | oncheck -cr
Checking System Tables: oncheck -cc | oncheck -pc
Checking indexes: oncheck -cI database:table | oncheck -pI
Checking Data Pages: .oncheck -cD database:table | oncheck -pD
Checking Table space utilization: oncheck -pT database:table
Checking Table space utilization: oncheck -pT database:table
Checking Table space utilization: oncheck -pT database:table
Checking Table space utilization: oncheck -pT database:table
Dumping the contents of a page: oncheck -pp .| oncheck -pP | oncheck -pB
Checking and displaying extents: oncheck -pe
Key ONMODE syntax
Shell Script to Start a Server
Changing OnLine modes
Forcing a checkpoint
Forcing a switch in the current logical log
Free unused virtual memory segments
Killing users' database processes
Using ONMODE for configuration changes
ONLOG - debug the logical log
ONINIT - initialize and start-up functions
Starting the Server
Starting the Server
ONSPACES - Adding, deleting, and changing dbspaces
ONPARAMS - Change logical and physical log configuration
ONTAPE - the OnLine backup and restore utility
ONTAPE - the OnLine backup and restore utility
Limitations of ONTAPE
Backing up the OnLine server
ONTAPE backup
Script to backup the Server to disk
Script to backup the Server to disk
Performing an OnLine restore
Performing an OnLine restore
Backing up logical logs
Backing up logical logs
Issues with backup of logical logs
Changing logging mode for a database
Overview of PDQ
What is PDQ
How do you enable PDQ
How do you manage PDQ
PDQ Configuration Parameters
Configuration Parameters that effect PDQ
Changing PDQ Parameters when the System is OnLine
Memory Grant Manager (MGM)
How Memory is Granted
Scan Threads and Secondary Threads
Factors to Consider in Tuning PDQ
Contact information:
|
