Re: who to check onstat -g ses "session-id" output (What is osenv)

Could you include the output of 'env' of the user that is associated with the session? Osenv memory is used to make a copy of some of the user environmental variables that are connecting to the engine. M.P. "sharad" <sha_pawar@hotmail.com> wrote in message news:bgnuse$k9i$1@news.btv.ibm.com... > Hi, > I am quite new to informix I am unable to understand the output of onstat -g> ses "sessionid" command .I am surprised to see that the osenv is very high > compared to other process. did anybody has idea what is osenv is stands for > ? > ======================================================== > IBM Informix Dynamic Server Version 9.40.UC2 -- On-Line -- Up 02:56:16 --> 61840 Kbytes > session #RSAM total used dynamic > id user tty pid hostname threads memory memory explain > 15 informix - 20308 adolphus 1 6373376 6366912 off > tid name rstcb flags curstk status > 39 sqlexec 401d9e68 G-XPX-- 2840 cond wait(logbf1) > Memory pools count 1 > name class addr totalsize freesize #allocfrag #freefrag > 15 V 40955020 6373376 6464 131497 14 > name free used name free used > overhead 0 1648 scb 0 96 > opentable 0 4440 filetable 0 776 > log 0 4208 temprec 0 1608 > keys 0 160 gentcb 0 1224 > ostcb 0 2728 sqscb 0 13776 > sql 0 40 rdahead 0 120 > hashfiletab 0 280 osenv 0 6333576 > sqtcb 0 2024 fragman 0 208 > sqscb info > scb sqscb optofc pdqpriority sqlstats optcompind directives > 40941088 40956018 0 0 0 2 1 > Sess SQL Current Iso Lock SQL ISAM F.E. > Id Stmt type Database Lvl Mode ERR ERR Vers Explain > 15 - fpt CR Not Wait 0 0 9.03 Off > ================================================================== > >

Hi Madison Pruet, Thanks for reply .... Here is info of env of user attached to the seesion. ===================================== _=/usr/bin/env LANG=en_US LOGIN=informix PATH=/usr/vac/bin:/dbms/informix/bin:/usr/bin:/etc:/usr/sbin:/usr/ucb:/dbms/i nformix/bin:/usr/bin/X11:/sbin:.:/usr/local/bin LC__FASTMSG=true LOGNAME=informix MAIL=/usr/spool/mail/informix LOCPATH=/usr/lib/nls/loc TERMCAP=/dbms/informix/etc/termcap DOCUMENT_SERVER_MACHINE_NAME=localhost USER=informix AUTHSTATE=files DCE_USE_WCHAR_NAMES=1 DEFAULT_BROWSER=netscape DISPLAY=9.182.18.123:0.0 SHELL=/usr/bin/ksh ODMDIR=/etc/objrepos DOCUMENT_SERVER_PORT=49213 HOME=/dbms/informix INFORMIXDIR=/dbms/informixTERM=vt100 MAILMSG=[YOU HAVE NEW MAIL] ONCONFIG=onconfig.fileITECONFIGSRV=/etc/IMNSearch PWD=/dbms/informix/sharad DOCUMENT_DIRECTORY=/usr/docsearch/html TZ=PAKST-5 TRY_PE_SITE=1 ITECONFIGCL=/etc/IMNSearch/clients ITE_DOC_SEARCH_INSTANCE=search INFORMIXSERVER=fpt_serverA__z=! LOGNAME LIBPATH=/dbms/informix/lib:/dbms/informix/lib/esql NLSPATH=/usr/lib/nls/msg/%L/%/N:/usr/lib/nls/msg/%/ N.cat ===================================== thanks with regards - Sharad "Madison Pruet" <mpruet@comcast.net> wrote in message news:QZRXa.72513$YN5.54264@sccrnsc01... > Could you include the output of 'env' of the user that is associated with > the session? > > Osenv memory is used to make a copy of some of the user environmental > variables that are connecting to the engine. > > M.P. > > "sharad" <sha_pawar@hotmail.com> wrote in message > news:bgnuse$k9i$1@news.btv.ibm.com... > > Hi, > > I am quite new to informix I am unable to understand the output of > onstat -g> > ses "sessionid" command .I am surprised to see that the osenv is very high > > compared to other process. did anybody has idea what is osenv is stands > for > > ? > > ======================================================== > > IBM Informix Dynamic Server Version 9.40.UC2 -- On-Line -- Up 02:56:16 --> > 61840 Kbytes > > session #RSAM total used dynamic > > id user tty pid hostname threads memory memory explain > > 15 informix - 20308 adolphus 1 6373376 6366912 off > > tid name rstcb flags curstk status > > 39 sqlexec 401d9e68 G-XPX-- 2840 cond wait(logbf1) > > Memory pools count 1 > > name class addr totalsize freesize #allocfrag #freefrag > > 15 V 40955020 6373376 6464 131497 14 > > name free used name free used > > overhead 0 1648 scb 0 96 > > opentable 0 4440 filetable 0 776 > > log 0 4208 temprec 0 1608 > > keys 0 160 gentcb 0 1224 > > ostcb 0 2728 sqscb 0 13776 > > sql 0 40 rdahead 0 120 > > hashfiletab 0 280 osenv 0 6333576 > > sqtcb 0 2024 fragman 0 208 > > sqscb info > > scb sqscb optofc pdqpriority sqlstats optcompind directives > > 40941088 40956018 0 0 0 2 1 > > Sess SQL Current Iso Lock SQL ISAM F.E. > > Id Stmt type Database Lvl Mode ERR ERR Vers Explain > > 15 - fpt CR Not Wait 0 0 9.03 Off > > ================================================================== > > > > > >