SQIO 1.0.0 is an intelligent performance dashboard for DB2. It can be used for real time monitoring of the database as well as benchmarking the existing database to see before and after improvements of performance tuning. This "dashboard" encapsulates many statistics and visual alerts when a threshold is reached. Produces a performance report in the end on the overall system behavior.

Feature SQIO Intelligent dashboard with color coding Realtime monitoring of the database Used for before and after benchmarking Visual alerts when thresholds are reached Overall performance report at the end Customizabe refresh frequency Near to zero impact on the system Tested on AIX and db2 8.x

Requires DB2 9.x client to be installed for SQIO to operate.

SQIO queries the snapshot functions provided by IBM and calculates the deltas based on the polling interval to monitor the DB2 system and display the information on the dashboard.

Statistics monitored and captured on the dashboad include Overall hit ratio, package cache hit ratio, catalog cache hit ratio, section cache hit ratio, sort overflow percentage, data prefetch efficiency, index prefetch efficiency, data cleaner efficiency, index cleaner efficiency, temp hit ratio, dirty page threshold cleaner trigger percentage, victim buffers, dirty page steals, index efficiency (%), logical reads per transactions, lock timeouts, lock escalations, deadlocks, dynamic sql, static sql, commits, rollbacks, inserts, updates, deletes, data sync and async physical reads, index sync and async physical reads, data physical reads, index physical reads, data temp physical reads, index temp physical reads, data logical reads, index logical reads, data temp logical reads, index temp logical reads, data writes, index writes, data async writes, data sync writes, index async writes, index sync writes, direct reads, direct writes, log reads, log writes.