The Status Script

In this chapter, we've seen a lot of individual scripts and programs that enable the DBA to deal with different parts of the database. Now, it's time to pull them together and create a "dashboard" for the OnLine system.

Of all the tools that come with OnLine, there is nothing that provides a quick, one-page peek into the engine. Various invocations of tbstat will allow you to look at individual items, but nothing gives you a quick status report. If the OnLine system is a database engine, certainly there should be a dashboard. Like a dashboard, the status script gives you or your users one place to look for indications of current problems or problems to come.

This script depends upon having other scripts located in your $INFORMIXDIR/local_bin ...

Get Informix DBA Survival Guide, Second Edition now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.