Determines 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.
sp_helpapptrace
sp_helpapptrace
traced_spid tracer_spid trace_file ------------- ------------ ---------- 11 exited /tmp/myfile1 13 14 /tpcc/sybase.15_0/myfile2
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.
If a session is tracing another session, but quits without disabling the tracing, Adaptive Server allows a new session to rebind with the earlier trace. This means that a sa or sso is not required to finish every trace they start, but can start a trace session, quit, and then rebind to this trace session
