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.

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 (AT) arz-emmendingen (DOT) de> wrote:

And it is in user u1's home directory, Art J. Found the error minutes
ago: User name of u1 is 01020304. Write permission to /home/01020304 was
set to 1020204 (see the missing "0"). Setting the write permission to
01020304 (only possible via uid 123 of that user) and it goes
swimmingly.



Thanks all and sorry to bother you.





From: Art Kagel [mailto:art.kagel (AT) gmail (DOT) com]
Sent: Wednesday, April 13, 2011 1:22 PM
To: Habichtsberg, Reinhard
Cc: informix-list (AT) iiug (DOT) org
Subject: 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 (AT) arz-emmendingen (DOT) 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 (AT) iiug (DOT) org
http://www.iiug.org/mailman/listinfo/informix-list