Re: Onstat -g ses Output - Part Number and Precis of

Cheryl Regarding information on the meaning of the output from onstat -g ses <sessid>. I have posted this to the list in case others would like the info. The Part number for the manual that I have is: 502-5-227-1-999999-3 Version 01-95 Title: Upgrading to Informix Online Dynamic Server. There are probably later versions out now I would expect. pp 8-210/211 have the following info. tid = Thread id name = Thread name rstcb = The address of the RSAM task control block for the thread. flags = userthread flags (like onstat -u) curstk = size of stack for this thread. status = curent status of this thread. Memory Pools = Name free and used are a breakdown of the exact usage of the pools listed for the session. (Compare to onstat -g seg) Session ID. = Session ID of user executing the SQL Statement. Statement Type = Select, update, delete, or insert Current database = current database. Isolation level = CR/Committed read, RR/Repeatable read, CS/Cursor Stability, DR/Dirty Read, NL/No Logging. Lock mode = either 'not wait' or 'wait x' where x = NumOfSecondsToWait. SQL ERR = the LAST SQL err. ISAM ERR = likewise for ISAM err. F.E.Vers = The Informix version of the client Appl process EG. 4.11, 6.01 etc. Trust this has been of assistance. Regards -- -- Peter Tashkoff <tashkop@kiwi.co.nz> Project Consultant/DBA NZ Kiwifruit Marketing Board Usual Disclaimers Apply --------------------------------------------------------------------------- ALL RIGHTS RESERVED This posting is copyright and may be used only for the purposes of professional study. Use of this posting in any commercial environment is explicitly prohibited. This posting may only be reproduced for personal archival purposes. ----------------------------------------------------------------------------