Check out the s
yssdblock table in sysmaster. The sdb_name column contains the cursor name which you should be able to relate back to the application:
> select * from syssdblock;
sdb_sessionid 71
sdb_sdbno 0
sdb_iscurrent Y
sdb_name slctcur
sdb_id 0
sdb_flags 65569
sdb_executions 0
sdb_cumtime 0.00
sdb_bufreads 0
sdb_pagereads 0
sdb_bufwrites 0
sdb_pagewrites 0
sdb_totsorts 0
sdb_dsksorts 0
sdb_sortspmax -1
sdb_cb 1184452664
sdb_cblist 1181604616
sdb_heap 1199567928
sdb_partnum -1
sdb_isfd 0
sdb_recnum 0
sdb_sqerrno 0
sdb_sqiserrno 0
sdb_sqoffset 0
sdb_errstr
sdb_ntables 3
sdb_sqttab 1200656936
sdb_asynch_sqerrno 0
sdb_asynch_sqiserr 0
sdb_pool 0
sdb_mutex 0
sdb_tgcblist 0
sdb_pdq_prio_req 0
sdb_pdq_priority 0
sdb_max_scans 0
Art S. Kagel, President and Principal Consultant
ASK Database Management
Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves.
------Original Message------
Hi,
I was investigating about how to get current opened (active) cursors in server. Preferably, getting a SQL query to sysmaster will be the best but also onstat command would work.
Reason for this question is to make a quality assurance of a program and we're not sure this program closes cursors after consuming.
I've been looking to onstat -g stm and also quering to syssqlcurses or sysconblock, but as this are undocumented tables I'm not sure if results I get are really "open cursors"
Thanks all comunity.
------------------------------
Sistemas Federacio Farmaceutica
------------------------------
#Informix