Can I get the program name by the sysmaster

Hello everyone. Could I get the connect database program name user SMI query by sid. For example: 1. onstat -g sesI can get the session id. 2. database sysmaster; select sid, freprogram from syssessions where sid=.... but the column syssessions.freprogram is empty. I don't want to use ps -ef, because I will process lots of session. IDS 10.7 on HP-Unix Thanks

But onstat -g ses (or the sysmaster.syssessions table) will also give you the host machine name and the process pid. With the pid you can do 'ps -fp <pid>' and process only one session. Art On Tue, Jun 24, 2008 at 11:27 PM, SHAN SEAN <shanshl@qq.com> wrote: > Hello everyone. Could I get the connect database program name user SMI > query > by sid. > For example: > 1. > onstat -g ses> I can get the session id. > > 2. > database sysmaster; > select sid, freprogram > from syssessions > where sid=....> > but the column syssessions.freprogram is empty. > I don't want to use ps -ef, because I will process lots of session. > > IDS 10.7 on HP-Unix > > Thanks > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > -- Art S. Kagel Oninit (www.oninit.com) IIUG Board of Directors (art@iiug.org) Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Oninit, the IIUG, nor any other organization with which I am associated either explicitly or implicitly. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves.

Thanks for your reply. but I want obtain the program name use table join by SMI query, so that I can collect lots of information together by SMI.

You cannot, it is not there. Art On Wed, Jun 25, 2008 at 9:23 PM, SHAN SEAN <shanshl@qq.com> wrote: > Thanks for your reply. > > but I want obtain the program name use table join by SMI query, so that I > can > collect lots of information together by SMI. > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > -- Art S. Kagel Oninit (www.oninit.com) IIUG Board of Directors (art@iiug.org) Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Oninit, the IIUG, nor any other organization with which I am associated either explicitly or implicitly. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves.

thanks a lot, Art