Re: Q: SQLIDEBUG
Posted in 1996
Topics: Performance & Tuning, Connectivity: ESQL/C, 4GL & Embedded SQL
In article <2kqHBSA6V6fyEwNO@smooth1.demon.co.uk>, David Williams <djw@smooth1.demon.co.uk> writes: >> >>INFORMIX-OnLine v7.x : >>there is an environment variable, SQLIDEBUG >>that traces the interface app.-client <-> online-server >>...[del.] >>Now, I'm looking for a tool to process the output. >>(plattform : SINIX 5.42, RM600) >> > How do you get the file created?. It is not offically documented > anywhere and so not officially supported. It is a 'secret' internal > thing for Informix personnel use only to enable them do debug Online. ja, must be very secret I got the hint from a support engineer I sent him the output file and got back a processed file. But he refused to give me the tool .-) anyway, it seem to be quite usefull. background : performance problems we'd like to figure out, which are the "expensive" sql-operations in our application (based on esql/c) ---------------------------------------------------------------------- Werner Greiner email: Werner.Greiner@softcon.de ----------------------------------------------------------------------