Hi!

I have a problem. My informix server(Informix Dynamic Server Version 7.31) is installed on linux Red hat 8.0 (2.4.18-14). My application is running on SCO Unix(SCO_SV 3.2 2 i386).

If I set trace on in stored procedure, I get error in app.
"
Program stopped at "nad_zaj.4gl", line number 1718.,,,,,,,,,,,,,,,,,,,,,,,,,,,,
SQL statement error number -648.
Cannot open DEBUG file for stored procedure trace.
SYSTEM error number -2.
No such file or directory
"

Does anyone know how to solve this problem, becouse it is annoying to write stored procedures without trace.

Thanks.

-648 Cannot open DEBUG file for SPL routine trace.

An error occurred trying to open DEBUG trace file. This error can occur
when one of the directories in the specified debug file name does not
exist, or the directory is write protected. Check that the directory
path is valid and that group informix can write to the directory.


-2 No such file or directory.

An operating-system error code with the meaning shown was unexpectedly
returned to the database server. Look for other operating-system error
messages that might give more information.

Suggest you check the trace file path and use "informix" account access server.

Check the permisions on the file that the path is pointing to

Thank you for prompt reply!

But this is not the sollution. A have created directories on both server with all permisions, then set log file and path to this directory but it doesn work.

If I run application on linux, then trace works fine. It looks like there is some problem between linux-SCO

PS: Changing app. server is not an option

Use hosts.equiv in Linux machine

What do I do with it.

I have allready put the name of server in /etc/hosts.equiv on both servers (unix and linux).

Stored procedures are working fine, only trace doesn't work.

I use dbaccess tool test the trace between Linux's IDS7.31UD6 and Windows2000's IDS9.40TC2,no problem.
The procedure's trace file come into being $HOME of connect user.