Oninit Logo
The Down System Specialists
+1-913-732-8892
+44-2081-337529
Introduction Health Check Standby Admin Remote Admin Remote Monitoring Backup and Restore Custom Support Down Systems
Unix SQL Advanced SQL 4GL Applications Advanced 4GL IDS Admin Migrating to V14 IDS Performance Managing & Optimising SPL and Triggers IDS V14 Upgrading Very Old Versions Custom Training
Onstat Guide Error Code Guide Reference Datablades The Dumb DBA Sysmaster Fault Finder
Co-Location Web Hosting Managed Servers Web Development
BenchMark Tookkit RegExp Datablade
Partnerships Contact
Onstat
-g act -g afr -g all -g amx -g aqt -g arc -g ath -g btc -g buf -g cac -g cdr -g cluster -g cdr config -g cfg -g cmsm -g con -g cpu -g dbc -g ddr -g dic -g dis -g dll -g dmp -g dri -g dsc -g dsk -g dss
-g env -g ffr -g glo -g grp -g imc -g ioa -g iob -g iof -g iog -g ioq -g iov -g ipl -g lap -g laq -g lmm -g lmx -g lsc -g mem -g mgm -g nbm -g nif -g nsc -g nsd -g nss -g nta -g ntd -g ntm -g ntt -g ntu
-g opn -g osi -g pgp -g pos -g ppd -g ppf -g pqs -g prc -g proxy -g qst -g rah -g ras -g rbm -g rcv -g rep -g rea -g rss -g sch -g scn -g sds -g seg -g ses -g sle -g smb -g smx -g spi -g sql -g src -g ssc -g stk -g stm -g stq -g sts -g sym -g sync
-g rwm -g tgp -g tpf -g ufr -g wai -g vpcache -g wmx -g wst
-b/-B -F -g cac -g dic -g dsc -g prc -g ssc -g vpcache -h -p -X
-t/-T -g buf -g lap -g opn -g ppf -g scn
-g cat -g cdr -g cdrconfig -g ddr -g dss -g dtc -g grp -g nif -g que -g rcv -g rep -g rqm -g sync
-g cluster -g cmsm -g dri -g ipl -g laq -g proxy -g rss -g sds -g smx
-R -g afr -g ffr -g lmm -g lsc -g mem -g mgm -g nbm -g rbm -g seg -g ses -g stm -g stq -g ufr
-g imc -g nsc -g nsd -g nss -g nta -g ntd -g ntm -g ntt -g ntu
-G -u -x -g env -g his -g pqs -g ses -g sql
-g act -g ath -g cpu -g rea -g sle -g stk -g sts -g tpf -g wai -g wst
-a -b/-B -C -c -d/-D -F -f -G -h -i -j -k/-K -L -l -m -o -P -p -R -r -s -t/-T -u -X -x -z

onstat -g env Show Environment

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.

Notes

    The onstat -g env command displays the current setting of an environment 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 command displays both values.

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

    The information can be accessed via sysmaster:sysenv, but only the environment variables that are directly related to Informix so if export MYENV_VAL=1 would not be available. However, the following UDR will access any enviroment variable
/*@unused@*/static char WhatStr[] = "@(#)oninit.1.0/getenv.c(2015/04/16 08:57)"; #ifdef __cplusplus extern "C" { #endif /* Standard library includes. */ #include <ctype.h> #include <stdio.h> #include <string.h> #include <stddef.h> /* Used by Informix GLS routines. */ #include <ifxgls.h> #include <mi.h> UDREXPORT mi_lvarchar *oni_getenv ( mi_lvarchar *lv, MI_FPARAM *fparam ) { char *s; char *s1=NULL; mi_lvarchar *lv1=NULL; s=mi_lvarchar_to_string(lv); if(s==NULL) mi_db_error_raise(NULL, MI_EXCEPTION, "Invalid request"); s1=getenv(s); if(s1==NULL) mi_fp_setreturnisnull(fparam, 0, (mi_integer)MI_TRUE ); else lv1=mi_string_to_lvarchar(s1); mi_free(s); return(lv1); } #ifdef __cplusplus } #endif

To discuss how Oninit ® can assist please call on +1-913-674-0360 or alternatively just send an email specifying your requirements.