The onstat -g dis Option

Prints a list of database servers and their status, and information about each database server, INFORMIXDIR, sqlhosts file, ONCONFIG file, and hostname. You can use this option with the database server in any mode, including offline.

Example Output

Figure 44. onstat -g dis Output

IBM Informix Dynamic Server Version 10.00.UC1   -- On-Line -- Up 18:47:42 
-- 101376 Kbytes

There are 2 servers found
Server        : ol_tuxedo
Server Number : 53
Server Type   : IDS
Server Status : Up
Server Version: IBM Informix Dynamic Server Version 10.00.UC1
Shared Memory : 0xa000000
INFORMIXDIR   : /local1/engines/ol_tuxedo/dist
ONCONFIG      : /local1/engines/ol_tuxedo/dist/etc/onconfig.ol_tuxedo
SQLHOSTS      : /local1/engines/ol_tuxedo/dist/etc/sqlhosts
Host          : avocet

Server        : ol_9next
Server Number : 0
Server Type   : IDS
Server Status : Down
Server Version: 
Shared Memory : 0
INFORMIXDIR   : /local1/engines/ol_9next/dist
ONCONFIG      : 
SQLHOSTS      :
Host          :

Output Description

Server: Server name
Server Number: Number of the server.
Server Type: Type of server
Server Status: Up means that the server is online, Down means that the server is offline
Server Version: Version of the server
Shared Memory: Location of the shared memory address
INFORMIXDIR: Location of the the $INFORMIXDIR/ directory on UNIX and in the %INFORMIXDIR%\ directory on Windows.
ONCONFIG: Location of the ONCONFIG file
SQLHOSTS: Location of the sqlhosts file
Host: Host name of the server