Conclusion
The sysmaster database is a great tool for a DBA to monitor the Informix server. If you have any questions or suggestions please send me E-mail at [email protected]. Also, if you have any creative scripts for monitoring your server with the sysmaster database, please send them in and I may include them in the future publications.
Contact Information for Lester Knutsen
Lester Knutsen
Advanced DataTools Corporation
4216 Evergreen Lane, Suite 136,
Annandale, VA 22003
(703) 256-0267 or (800) 807-6732
http://www.advancedatatools.com
Notes
Lester does wonderful work. I thank him for his contribution to this book and suggest that if anyone in the vicinity of Washington, D.C. needs consulting or training services that they contact Lester. He is also very active in the Washington Area Informix Users' Group and has made many significant contributions to the body of Informix knowledge.
Thanks to his generosity, I have been able to include all of these scripts with the CD-ROM that comes with this book. I've left them totally unchanged, but I have one suggestion for those who may wish to use them in conjunction with the SQL-Editor front-ends from Informix. This front-end has an annoying habit in that every time you want to do a "database sysmaster" or choose the sysmaster database from the GUI, it will give you a pop-up screen warning you that you are working with the sysmaster database. To get around this behavior, take out all of the "database sysmaster;" commands and address include the "sysmaster" name in each table in the FROM statements, like this;
Change from:
DATABASE sysmaster; SELECT * from sysprofile;
Change to:
SELECT * from sysmaster:sysprofile;
This will also allow you to choose a user database from the GUI and keep using it while making these queries to the sysmaster database as needed. Informix probably wouldn't approve of this, but I keep Lester's scripts (and my own) in the $INFORMIXDIR/bin subdirectory on my Windows machines. This is the default place that the GUI looks for scripts, and it makes it very easy to use these and other scripts.