Informix Hosting : Enabling trace through a datasource – HOWTO

Finding a good web host for your database sites is a big problem. Check our recommended host for database hosting or the datacenters with the most powerful and reliable dedicated servers suited for large databases.

This databases discussion was started by andrewhallam 0n 07 January 2009

Can someone please tell me how to enable an SQL trace via a datasource with Informix?
I’ve been searching all morning but no luck…

i.e. with DB2 you do:

jdbc:db2://testserver:50000/TEST:deferPrepares=0;traceFile=/tmp/DB2/trace.txt;traceLevel=3;

But how to do this in Informix?

Do you use TRACE ON or something? – but where do you specify the output file?

Learn more about Informix databases here. Should you need to go for trustworthy hosting services for all database related sites, we suggest this host for virtual database hosting and this one for dedicated databases hosting