How to: Quickly access Informix onstat and onconfig information

Do you frequently find yourself needing quick access to simple information about your Informix instance? Info such as onconfig variables or other parameters?

While you can create templates with infx to specify the information you need, that is overkill when you just want to know something simple, such as the instance server number.

To fill this need, the infx status service has a simple interface that allows ad hoc access to the full details of the onstat parser library.

Lets take the instance server number as an example:

demo1@bobii:/home/informix>infx status vars=onconfig_servernum
23

Inside infx: How the onstat parser works

The majority of information you see from infx has come from the output of the Informix onstat command. Only a small percentage (at this time anyway) comes from the sysmaster database.

There are two reasons for that:

1. onstat is available even when sysmaster isn't
2. onstat outputs loads of information and it's very fast