Adaptive Server 15.0.2 introduces new set commands that
collect information about slow-running queries.
These parameters for the
set command enable you to collect diagnostic information about poorly running
queries without having to previously enable
showplan or
other investigatory parameters:
-
tracefile – saves diagnostics
to a trace file
-
show_sqltext – displays
SQL text
-
export_options – retains
session settings