The onstat -g env command displays the starting environment for engine, and
the command onstat -g env sid displays the environment for the session
Server start-up environment: Variable Value [values-list] CLIENT_LOCALE en_US.8859-1 DBDATE DMY4 DBDELIMITER | DBPATH . DBPRINT lp -s DBTEMP /tmp INFORMIXDIR /usr/local/informix [/usr/local/informix] [/usr/informix] INFORMIXSERVER oninit_net INFORMIXTERM termcap LC_COLLATE en_US.819 LC_CTYPE en_US.819 LC_MONETARY en_US.819 LC_NUMERIC en_US.819 LC_TIME en_US.819 LD_LIBRARY_PATH :/usr/local/informix/lib:/usr/local/informix/lib/esql:/usr/ local/informix/lib/tools LKNOTIFY yes LOCKDOWN no NODEFDAC no ONCONFIG onconfig.strider PATH /usr/sbin:/usr/bin:/usr/local/bin:/usr/ccs/bin:/usr/local/i nformix/bin SERVER_LOCALE en_US.819 SHELL /bin/ksh TERM vt100 [vt100] [dumb] TERMCAP /etc/termcap TZ GB
Option | Description |
---|---|
onstat -g env | Displays the settings of environment variables when the database server was started Does not display environment variables that have not been set explicitly. |
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 envsessionid iteratively on all current sessions. |
onstat -g env variable | Displays the default value of the specified environment variable |
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 sessionid variable | Displays the value of the specified environment 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 an environment variable among many that might be set. |
To discuss how Oninit ® can assist please call on +1-913-674-0360 or alternatively just send an email specifying your requirements.