You can start a tracing session by executing the ATTACH TRACING statement in Interactive SQL.
DBA or PROFILE authority.
Context and remarks
Starting a tracing session is also referred to as attaching tracing. Likewise, stopping a tracing session is referred to as detaching tracing. The SQL statements for starting and stopping tracing are, respectively, ATTACH TRACING and DETACH TRACING.
Connect to the database.
Use the sa_set_tracing_level system procedure to set the tracing levels.
Start tracing by executing an ATTACH TRACING statement.
Stop tracing by executing a DETACH TRACING statement.
This example shows how to start diagnostic tracing on the current database, store the tracing data in a separate database, and set a two hour limit on the amount of data to store. This example is all on one line:
ATTACH TRACING TO 'UID=DBA;PWD=sql;Server=server47;DBN=tracing;Host=myhost' LIMIT HISTORY 2 HOURS;
This example shows how to start diagnostic tracing on the current database, store the tracing data in the local database, and set a two megabyte limit on the amount of data to store:
ATTACH TRACING TO LOCAL DATABASE LIMIT SIZE 2 MB;
This example shows how to stop diagnostic tracing and save the diagnostic data that was captured during the tracing session:
DETACH TRACING WITH SAVE;
This example shows how to stop diagnostic tracing and not save the diagnostic data.
DETACH TRACING WITHOUT SAVE;
Discuss this page in DocCommentXchange.
|Copyright © 2012, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.1|