open tables

How can I get on readable form the results from onstat -g opn? How can identify all the open tables and involved sessions? Thanks for any help, SP

https://github.com/domusonline/InformixScripts/blob/master/scripts/ix/ixtableuse Hopefully soon we'll meet and I can provide more details. use "ixtableuse -h" to get you started. Regards. On Thu, May 4, 2017 at 10:40 AM, SERGIO PERES <sergio.peres@airc.pt> wrote: > How can I get on readable form the results from onstat -g opn? > How can identify all the open tables and involved sessions? > > Thanks for any help, > > SP > > > ************************************************************ > ******************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > -- Fernando Nunes Portugal http://informix-technology.blogspot.com My email works... but I don't check it frequently... --001a11453878150324054eb21067

Cool script Fernando! FYI, -a didn't work for me (12.10.FC8). It didn't find the open table that was reported by the default script path. Art Art S. Kagel, President and Principal Consultant ASK Database Management www.askdbmgt.com Blog: http://informix-myview.blogspot.com/ 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. On Thu, May 4, 2017 at 8:39 AM, Fernando Nunes <domusonline@gmail.com> wrote: > > https://github.com/domusonline/InformixScripts/blob/master/scripts/ix/ > ixtableuse > > Hopefully soon we'll meet and I can provide more details. > use "ixtableuse -h" to get you started. > Regards. > > On Thu, May 4, 2017 at 10:40 AM, SERGIO PERES <sergio.peres@airc.pt> > wrote: > > > How can I get on readable form the results from onstat -g opn? > > How can identify all the open tables and involved sessions? > > > > Thanks for any help, > > > > SP > > > > > > ************************************************************ > > ******************* > > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > > > -- > Fernando Nunes > Portugal > > http://informix-technology.blogspot.com > My email works... but I don't check it frequently... > > --001a11453878150324054eb21067 > > > ************************************************************ > ******************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --001a1147b198f6d238054eb2b08c

Thanks for reporting.... -a was an attempt to make it usable remotely.... will take a look.... eventually I messed up when adapting it to 12.10.... which changed the output format :/ Regards On May 4, 2017 14:24, "Art Kagel" <art.kagel@gmail.com> wrote: > Cool script Fernando! FYI, -a didn't work for me (12.10.FC8). It didn't > find the open table that was reported by the default script path. > > Art > > Art S. Kagel, President and Principal Consultant > ASK Database Management > www.askdbmgt.com > > Blog: http://informix-myview.blogspot.com/ > > 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. > > On Thu, May 4, 2017 at 8:39 AM, Fernando Nunes <domusonline@gmail.com> > wrote: > > > > > https://github.com/domusonline/InformixScripts/blob/master/scripts/ix/ > > ixtableuse > > > > Hopefully soon we'll meet and I can provide more details. > > use "ixtableuse -h" to get you started. > > Regards. > > > > On Thu, May 4, 2017 at 10:40 AM, SERGIO PERES <sergio.peres@airc.pt> > > wrote: > > > > > How can I get on readable form the results from onstat -g opn? > > > How can identify all the open tables and involved sessions? > > > > > > Thanks for any help, > > > > > > SP > > > > > > > > > ************************************************************ > > > ******************* > > > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > > > > > > > -- > > Fernando Nunes > > Portugal > > > > http://informix-technology.blogspot.com > > My email works... but I don't check it frequently... > > > > --001a11453878150324054eb21067 > > > > > > ************************************************************ > > ******************* > > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > > > --001a1147b198f6d238054eb2b08c > > > ************************************************************ > ******************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --001a11c15102ab9e49054eb2d025

Hi Fernando, Thanks for your help and reply. When we meet, I can give more details about the problems I am veryfing and trying to identify. Regards, SP