The onstat -g env Option

The onstat -g env option displays the values of environment variables the database server currently uses. You can specify one of the following invocations.

Invocation	Explanation
onstat -g env	Displays the settings of variables when the database server was started Does not display variables that have not been set explicitly.
onstat -g env sessionid	Displays the settings that a specific session uses. This display includes the following values: Set in the environment of the session Assigned by the database server, as onstat -g env displays
onstat -g env all	Displays the settings used by all sessions This display is the same as the output of onstat -g env and onstat -g env sessionid iteratively on all current sessions.
onstat -g env variable	Displays the default value of the specified variable This variable argument eliminates the need to pipe the output to grep (or some other utility) to locate a variable among many that might be set.
onstat -g env sessionid variable	Displays the value of the specified variable that the specified session uses The sessionid and variable arguments eliminate the need to pipe the output to grep (or some other utility) to locate a variable among many that might be set.

Invocation

Explanation

onstat -g env

Displays the settings of variables when the database server was started

Does not display variables that have not been set explicitly.

onstat -g env sessionid

Displays the settings that a specific session uses. This display includes the following values:

Set in the environment of the session
Assigned by the database server, as onstat -g env displays

onstat -g env all

Displays the settings used by all sessions

This display is the same as the output of onstat -g env and onstat -g env sessionid iteratively on all current sessions.

onstat -g env variable

Displays the default value of the specified variable

This variable argument eliminates the need to pipe the output to grep (or some other utility) to locate a variable among many that might be set.

onstat -g env sessionid variable

Displays the value of the specified variable that the specified session uses

The sessionid and variable arguments eliminate the need to pipe the output to grep (or some other utility) to locate a variable among many that might be set.

You might want to display the values of environment variables in any of the following situations:

The onstat -g env option displays the current setting of a variable and the complete list of values each time the variable was set in the environment. For example, if PDQPRIORITY is set to 10 in the .informix.rc file and set to 55 in the shell environment, onstat -g env displays both values.

However, if you change the PDQPRIORITY with the onmode -q pdqpriority sessionid option, onstat -g env does not display the new value for the session. The onstat -g env option displays only the values of variables set in the environment. It does not display values modified while the session is running.

Figure 50. onstat -g env Output

# onstat -g env

IBM Informix Dynamic Server Version 9.40.UC1 -- On-Line -- Up 4 days 17:08:43 
-- 45056 Kbytes

Variable            Value [values-list]
DBDATE              DMY4/
DBDELIMITER         |
DBPATH              .
DBPRINT             lp -s
DBTEMP              /tmp
INFORMIXDIR         /build2/9.30/tristarm/sqldist
                    [/build2/9.30/tristarm/sqldist]
                    [/usr/informix]
INFORMIXSERVER      parata930
INFORMIXTERM        termcap
LANG                C
LC_COLLATE          C
LC_CTYPE            C
LC_MONETARY         C
LC_NUMERIC          C
LC_TIME             C
LD_LIBRARY_PATH     /usr/openwin/lib:/lib:/usr/lib
LKNOTIFY            yes
LOCKDOWN            no
NODEFDAC            no
NON_M6_ATTRS_OK     1
PATH                         /build2/9.30/tristarm/sqldist/bin:.:
                        /root/bin:/opt/SUNWspro/bin:/usr/ccs/bin:
                        /usr/openwin/bin:/usr/sbin:/usr/bin:/usr
                     /local/binSERVER_LOCALE       en_US.819
SHELL               /bin/ksh
SINGLELEVEL         no
SUBQCACHESZ         10
TBCONFIG            onconfig
TERM                xterm
                    [xterm]
                    [dumb]
TERMCAP             /etc/termcap
TZ                  GB