Re: Monitoring Queryplan onmode -Y

It should be in user u1's home directory on the server host A Art Art S. Kagel Advanced DataTools (www.advancedatatools.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 my employer, Advanced DataTools, 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 Wed, Apr 13, 2011 at 6:49 AM, Habichtsberg, Reinhard < RHabichtsberg@arz-emmendingen.de> wrote: > Hi all > > I am trying to monitor the optimizer query plan of a session with onmode –Y > sid 1. > > With onstat –g sql I can see that the session changes the queries > frequently. So I assume that each new query of the session will generate a > query plan. This is what I want to see. > > Manuals say that the query plan is written to a file sqlexplain.out.sid. > Unfortunatly I cannot find any sqexplain.out file which matches with that > sid. > > Informix Version is IDS 11.50.FC7W3, OS is Solaris for the database server > host and Reliant Unix for the remote 4ge application host. > > The session resides on host A with Informixserver A_tli. User informix on > this host started onmode –Y sid 1. > > The program that started the session runs on host B started from user u1. > The pid is found on host B. It is a 4ge program. The user u1 has an > account and home-dirs /home/u1 on host A and host B. > > As I mentioned above: I cannot find a file sqexplain.out or > sqexplain.out.sid anywhere. > > I did following test: > > User u2 on the same host as the Informixserver. Starts dbaccess session. > User informix starts onmode –Y sid_of_dbaccess_session_if_u2 1. Now I > found /home/u2/ sqexplain.out.sid_of_dbaccess_session_if_u2. Each > sql-Statement of that session where monitored in that file. > > The same I wanted to achieve for the running 4ge session from that remote > host. > > Any ideas? > > Reinhard. > > > _______________________________________________ > Informix-list mailing list > Informix-list@iiug.org > http://www.iiug.org/mailman/listinfo/informix-list > >