You can write a script that runs daily and will tell you. Here is some pseudo-code:
DECLARE AllProcs "SELECT procname FROM sysprocedures";
WHILE <AllProcs>
Dbschema -d database -f ProcName Procname.sql
For file in *.sql
If $(grep "^TRACE ON" $file)
Complain loudly!
Wow, I've mixed 4GL, Korn Shell, Perl and system commands!
Jay
-----Original Message-----
From: owner-informix-list@iiug.org [mailto:owner-informix-list@iiug.org] On Behalf Of David Reed
Sent: Thursday, August 04, 2005 2:13 AM
To: informix-list@iiug.org
Subject: How do I know if a TRACE is active in a SP?
Hi
How do I know if a TRACE in a Stored Procedure is already active? Can I
interrogate a system table for that information? I have some SP's that
goes about 10 levels deep and would like to know in the bottom ones if
the top SP's have already activated a trace, else if the bottom one
activates it again, it overwrite the existing one.
Regards
David
sending to informix-list
sending to informix-list