Use sp_helpapptrace to determine which sessions Adaptive Server is tracing. sp_helpapptrace returns the server process IDs (spids) for all the sessions Adaptive Server is tracing, the spids of the sessions tracing them, and the name of the tracefile.
The syntax for sp_helpapptrace is:
sp_helpapptrace
sp_helpapptrace returns these columns:
traced_spid – spid of the session you are tracing.
tracer_spid – spid of the session that traced_spid is tracing. Prints “exited” if the tracer_spid session has exited.
trace_file – full path to the tracefile.
For example:
sp_helpapptrace
traced_spid tracer_spid trace_file -------------- ------------- ---------- 11 exited /tmp/myfile1 13 14 /tpcc/sybase.15_0/myfile2
