Re: Detecting cursors in OnLine 7.x

In article <01bd31cf$290dbf40$6fb698ce@kolaya>, Scott Kolaya <kolaya@acmenet.net> writes >Is there a way to see how many cursors a particular session id has open in >ODS 7.23? Nope, I talking with Informix Tech Support and was told to add something like SQLIDEBUG=2:<filename> in my informix.ini file (when using INET) you then send the file to a UNIX machine and run sqliprint to view it. I don't have sqliprint so I suspect it is an Informix internal tool. Sorrry. I'd like more options to onstat :- 1. Abiltity to enable set explain on for a running session and log to sqexplain.out in current directory. 2. Ability to see what prepared statements a session has and how memory is allocated for them. Something like mem /c under DOS but for a sesssion 3. Ability to see what temporary disk space a session has allocated sort pools, temporary table extents, how index builds are allocating disk space. Can any of the elders gods help. I tried to join the IIUG Engines mailing list but never received anything... -- David Williams Maintainer of the Informix FAQ Primary site (Beta Version) http://www.smooth1.demon.co.uk Official site http://www.iiug.org/techinfo/faq/faq_top.html I see you standin', Standin' on your own, It's such a lonely place for you, For you to be If you need a shoulder, Or if you need a friend, I'll be here standing, Until the bitter end... So don't chastise me Or think I, I mean you harm... All I ever wanted Was for you To know that I care