onstat -g dis command: Print database server information
Use the onstat -g dis command to display a list of database servers, the status of each server, and information about each server, including the location of the ONEDB_HOME directory, sqlhosts file, and ONCONFIG file. You can use this command in any database server mode, including offline.
Example output
There are 2 servers found
Server : ol_tuxedo
Server Number : 53
Server Type : IDS
Server Status : Up
Server Version: IBM Informix Version 11.50.UC1
Shared Memory : 0xa000000
ONEDB_HOME : /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
ONEDB_HOME : /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
- ONEDB_HOME
- Location of the $ONEDB_HOME/ directory on UNIX™ and in the %ONEDB_HOME%\ directory on Windows™.
- ONCONFIG
- Location of the ONCONFIG file
- SQLHOSTS
- Location of the sqlhosts file
- Host
- Host name of the server