Replay Informix TechTalk: Informix Sysmaster Database Queries for monitoring and performance tuning by Lester Knutsen From: Thursday, February 2, 2023, 2:00 pm EST Download my latest Sysmaster Scripts for this presentation – Sysmaster2023.zip YouTube Replays: https://youtu.be/C9zk8FmuUFQ Download Slides: Informix-SYSMASTER-2023-LesterKnutsen.pdf Description: Lester Knutsen will present his favorite Informix Sysmaster Scripts for monitoring and performance tuning tips. This […]
Tag Archives: Informix Administration
Advanced DataTools Newsletter – October 2020
1. Are you planning to upgrade to Informix 14.10? Attend our Informix for Database Administrators Training Course. We have the Informix 14.10 training for you. Lester Knutsen will be teaching our next Informix DBA Class, Informix for Database Administrators updated for Informix version 14.10, on October 5-8, 2020. There is only one space left! More […]
Informix 14.10 Command Line Utilities Quick Reference Guide
I have updated our series of Informix Command Line Utilities Quick Reference Guides. Folks, you can download the Informix 14 Quick Reference Guide here. The Quick Reference Guide includes the following Informix commands: Oncheck Oninit Onmode Onparams Onspaces Onstat Ontape In 1995, after years of trying to find a manual to check the command line […]
Fastest Informix DBA Contest VI – September 2013
Fastest Informix DBA Contest VI winners – September 2013
Fastest Informix DBA VI – 2013 – How Did They Do It?
Article on the Fastest Informix DBA 2013 Contest and how the winners succeeded.
Fastest Informix DBA Contest V – April 2012
Fastest Informix DBA Contest V Winners – April 2012
Fastest Informix DBA Contest IV – May 2011
Fastest Informix DBA Contest IV Winners – May 2011
Fastest Informix DBA Contest III – April 2010
Fastest Informix DBA Contest 3 Winners – April 2010
Fastest Informix DBA Contest III – How did they do it?
Last year at the 2010 IIUG Informix User Conference in Kansas City we hosted a new “Fastest Informix DBA Contest”. This contest was different from the earlier ones, and focused on “How many transactions per minute” could the contestants tune an Informix database to achieve. The previous contests had focused on improving batch processing performance […]
Fastest Informix DBA Contest II – Fall 2009
Fastest Informix DBA Contest 2 Winners – Fall 2009
Fastest Informix DBA Contest I – April 2009
Fastest Informix DBA Contest 1 Winners – April 2009
Exploring the Sysmaster Database
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 […]
Exploring the Informix OnLine Utilities
This post is the original article I wrote on Exploring the Infomrix Utilities that has been reprinted in many other places. INFORMIX-OnLine DSA comes with a set of powerful command line utilities that enable you to monitor, tune, and configure your database server. This chapter will focus on eight of these utilities, and present […]
Informix Tech Notes article on SMI and the Sysmaster Database (PDF)
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 […]
Roles: A New Security Feature in INFORMIX-OnLine Dynamic Server
First published in the Informix Tech Notes Magazine in 1999 INFORMIX-OnLine Dynamic Server, version 7.10.UD1, introduced a new feature called “Roles.” Roles provide a way to grant and revoke privileges to a function, rather than to individual users. In addition, a user is granted the privilege to use one or more Roles. When a user […]
Informix Tech Notes article on Exploring the ONSTAT Utility
First published in the Informix Tech Notes Magazine in 1999 Provided with Informix Dynamic Server is a set of powerful command- line utilities that enable the monitoring, tuning, and configuring of the database server. This article focuses on one of these utilities, ONSTAT, and presents ways to use this utility for server performance optimization. ONSTAT […]
A Web/CGI Interface to the ONSTAT Utility
First published in the Washington Area Informix User Group Newsletter Volume 7, No. 2 – April 1997 This is one of the scripts I presented at the WAIUG Training Day. The purpose is to provide a web interface to the INFORMIX-OnLine ONSTAT Utility. There are two parts to this interface: the first is a […]
Informix Online 5.X TB Utilities Quick Reference Guide
First published in the Washington Area Informix User Group Newsletter Volume 5, No. 2 – May 1995 TBCHECK Usage: tbcheck [-clist] [-plist] [-qny] [ { database[:[owner.]table] | TBLSpace number | Chunk number} { rowid | page number […]