The View From Outside – Unix utilities give a different look at database server performance

Published on January 1, 2005 by Lester Knutsen

First Published in IBM DB2 Magazine Issue 2005 Quarter 1

It's not hard to find information on using Informix ONSTAT or other database utilities to monitor and tune IBM Informix Dynamic Server (IDS) databases. I've written several articles on that topic myself. (You can find them on my Web site, listed in the resources at the end of this column, if you're interested.) But the Informix utilities only tell part of the story. In order to effectively monitor and tune your database server, you need to know what the IDS server tells you about its performance and what the Unix operating system tells you about the whole server's performance.

View PDF of full article:  Db2mag_2005_q1-The_View_From_Outside