Re: informix - tool like SQL server profiler

Davorin Kremenjas wrote: > 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. SOrry, yes every Informix user needs a home directory defined on the server. I have the DBAS do this for us as a matter of course. We defined a user profile template for DB access users of production servers. They have a home dir but no shell. This way there is a place for the sqexplain.out file to go. Art S. Kagel > 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 > > >