Translating with DrWatson… this can take a few seconds the first time.
This is a genuine, complex translation. DrWatson protects commands, error codes, and log output while naturally translating the surrounding text. It’s translated once and saved.
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.
We use strictly necessary cookies to make this site work. With your
consent we’d also use optional cookies for analytics and marketing. You can accept all,
reject all, or choose. Read our Cookie Policy.