Oninit® Archive
Results for “onstat -g ssc”
SQL statement equivalent TO onstat -g ssc
Informix version 11:70 / 12.10 Platform : Linux / Unix Hi all I am looking for SQL statement which equivalent TO command : onstat -g ssc Anyone have any idea which tables that I should "reference to" in sysmaster DB ? Thanks…
Statement Cache
IDS 9.40.FC8 Solaris 9 When I do onstat -g ssc I get lines as follows lru hash ref_cnt hits flag heap_ptr database user -------------------------------------------------------------------------------- 37 152 11 6549 DF 3c3d7e438......... 38 254 571 730…
onstat -g sql
Jonathan Actually the manual has both documented. Please explain how these work. I have tried the SECURESTATG and as indicated by the manual this should allow users that have DBA to run onstat. However this is not the case. I have tried with both set and SECURESTATG has no effec…
Re: ONLINE 7.2 tuned to simulate SE x.x
--0__=MWXdqK17S4lXPm6Boa5ZQi892ZYLpinD57lvkEjrgSjesbnTIR0Zkf0D Content-type: text/plain; charset=US-ASCII Are the OLTP from this environment? Setting PDQpriority to 50 makes EVERYTHING done by this server lower priority than the fortune cookie program. Recommend you set that to…
Re: Online Performance Tuning Question ??
--0__=CQNLSAopMAYotwufGnXR0QUl8Vh2LxD5j3KZwfTS9kAfLWIEJOo7CpHz Content-type: text/plain; charset=us-ascii Make your initial virtual shared memory piece larger. When this starts acting badly, do an onstat -g seg and count the number of V shared memory segments ("class").…
Re: How to increase userthread in Informix 7.11
Kate, Tomchik/IS/SSC/THD@emory.mathcs.emory.edu wrote: > > 128 is the number of threads, which doesn't really mean 128 active users > because we get error messages long before we reach that number on our systems. > You need to change the NETTYPE variable as follows: > > NETTYPE …
Re: Total users
Actualy, in our experience the 128 is meaningless. As soon as you reach 99 users your system will no longer allow any further attachments, it WON'T allocate more shared memory for more users, and it WON'T give you any meaningful message about what is going on. The number of use…