doubt in onstat -g ses
Posted in 1997
Could anyone please explain me the meaning of the following state of
the informix session. This the out put of
One of the client application is connecting through ESQL/C program and
this application is will not close the informix session , it runs 7 x
365
days. This application reads SQL from user and submits it informix
through the existing session that it had already open
Thia is snapshot of onstat -g ses 1123 when there is no SQL is running
Thanks in advance for your help
PEDDI
bala.peddi@fmr.com
INFORMIX-OnLine Version 7.23.UC2 -- On-Line -- Up 11 days 19:10:45 --
416472 Kbytes
session #RSAM total used
id user tty pid hostname threads memory memory
689 navuser console 1894 cali.fmr 1 286720 134584
tid name rstcb flags curstk status
16573 sqlexec c042a18 Y--P--- 1872 c042a18 cond wait(netnorm)
Memory pools count 3
name class addr totalsize freesize #allocfrag #freefrag
689 V c46e018 221184 104208 391 49
689_SORT_0 V c3de018 32768 15904 7 2
689_SORT_1 V cb8e018 32768 32024 12 3
name free used name free used
overhead 0 360 scb 0 96
opentable 0 7624 filetable 0 912
ru 0 224 log 0 2136
temprec 0 3144 ralloc 0 68952
gentcb 0 8472 ostcb 0 2016
sort 0 17520 sqscb 0 8288
srtmembuf 0 144 rdahead 0 448
hashfiletab 0 280 osenv 0 2280
buft_buffer 0 8544 sqtcb 0 2344
fragman 0 448 shmblklist 0 352
Sess SQL Current Iso Lock SQL ISAM F.E.
Id Stmt type Database Lvl Mode ERR ERR Vers
689 - nav30prod NL Not Wait 0 0 7.20
Last parsed SQL statement :
select * from xxx;