Re: informix - tool like SQL server profiler

Art, very useful but... I have just few user accounts (informix, one DBA user, etc.) explicitly created on the machine where Informix runs. All other users are users created on Active Directory and Informix (or better said, Solaris) authenticates those users using NIS connection to Active Directory. So where their sqlexplain.out files go? Nowhere, because they don't have their home directories on server. I tried to set explain on explicitly through SQL Editor but of course error arises explaining it's impossible to create sqexplain.file. Can you tell me how can I trace query plans of such users, please? Thanks. "Art S. Kagel" <kagel@bloomberg.net> wrote in message news:432ADCF1.7000000@bloomberg.net... > Yes, "onstat -g sql -r 5 >> file" will work. But that's not what I was > thinking of. You are running 9.40 so there is the onmode command: > > onmode -Y session_id 1> > This will turn on set explain processing for the named session logging > every SQL statement and it's query plan to the session owner's > sqexplain.out file. To disable it again: > > onmode -Y session_id 0> > Art S. Kagel

"Davorin Kremenjas" <davorin.kremenjas@srce.hr> schrieb: >All other users are users created on Active Directory and Informix (or >better said, Solaris) authenticates those users using NIS connection to >Active Directory. >So where their sqlexplain.out files go? Nowhere, because they don't have >their home directories on server. This is an OS problem and NOT an Informix problem. As you already noted, no home directory -> no sqexplain.out file. In the "UNIX properties" of an Active Directory user, you will have to define a home directory that is accessible from your Informix server. This home directory does not have to be accessible from Windows! We have a very similar scenario and have all NIS user's home directories on an NFS server which is mounted by all NIS client machines. HTH, Richard

Thank you Richard, this helped, under UNIX attributes I set /tmp for that users home directory beacuse I just needed it temporarily and it worked OK. "Richard Spitz" <Richard.Spitz@med.uni-muenchen.de> wrote in message news:dtgvi1h5tn1q9293jah4g3q7deifc9l88m@4ax.com... > "Davorin Kremenjas" <davorin.kremenjas@srce.hr> schrieb: > >>All other users are users created on Active Directory and Informix (or >>better said, Solaris) authenticates those users using NIS connection to >>Active Directory. >>So where their sqlexplain.out files go? Nowhere, because they don't have >>their home directories on server. > > This is an OS problem and NOT an Informix problem. As you already noted, > no home directory -> no sqexplain.out file. > > In the "UNIX properties" of an Active Directory user, you will have to > define a home directory that is accessible from your Informix server. > This home directory does not have to be accessible from Windows! We have > a very similar scenario and have all NIS user's home directories on an > NFS server which is mounted by all NIS client machines. > > HTH, Richard > > > >