Tech Topic: Sysmaster Database

Exploring the Sysmaster Database – My New Scripts from the IIUG World 2019 Conference

Presented by Lester Knutsen on September 24, 2019

Informix Best Practices – Using the Sysmaster database to perform an Informix Server Heath Check

By Lester Knutsen on October 7, 2017

This is the latest Webcast replay of Lester’s talk on Exploring the Sysmaster database. He presented cripts to monitor and tune your Informix Server and perform a system health check. Examples include how to tell what is the most expensive query running on your server now, what page size is best for your tables, what indexes are used and not used, how is memory used on your server, and much more…. These scripts will help you identify the performance bottlenecks on your Informix Server.

Informix Performance Tuning using the Sysmaster Database (Updated)

By Lester Knutsen on March 24, 2015

Lester again presented new scripts to monitor and tune your Informix Database server using the Sysmaster and Sysadmin Databases. This is major update to his most popular talk at the International Informix User Group (IIUG) conferences over many years – “Exploring the Sysmaster Database”.

Informix Performance Tuning using the Sysmaster Database

By Lester Knutsen on April 30, 2013

Lester presented new scripts for monitoring and tuning your Informix Database server using the Sysmaster and Sysadmin Database. This is an update of Lester’s most popular talk at Informix user conferences over the past several years, “Exploring the Sysmaster Database”, and will show what is new in Informix 12.10.

Exploring the Sysmaster Database

By Lester Knutsen on October 26, 2002

This post is the original article I wrote on Exploring the Sysmaster Database and has been reprinted in the Informix TechNotes, the Informix DBA Survival Guide, Second Edition by Joe Lumbley, the Informix Handbook by Ron Flannery, and many other places. Open the orginal PDF of this article: https://www.advancedatatools.com/Downloads/Symaster_articule.pdf When you list all the […]

Informix Tech Notes article on SMI and the Sysmaster Database (PDF)

By Lester Knutsen on September 8, 1999

First published in the Informix Tech Notes Magazine in 1999 When you list all of the databases on your Informix server, you will see one called “sysmaster”. This special database, which first appeared in Informix’s 6.x and 7.x servers, contains system monitoring interface (SMI) tables that can be used for monitoring your system. In […]