In Sybase Central, you can create a diagnostic tracing session to gather tracing data from your database.
DBA or PROFILE authority.
To start a tracing session, TCP/IP must be running on the database server(s) on which the tracing database and production database are running.
Context and remarks
When you start a diagnostic tracing session, you also configure the type of tracing you want to perform, and specify where you want the tracing data to be stored. Your tracing session continues until you explicitly request that it stops.
Use the SQL Anywhere 12 plug-in to connect to the database.
Right-click the database and click Tracing.
On the Tracing Detail Level page, select the level of tracing.
On the Edit Tracing Levels page, customize the diagnostic tracing settings.
On the Create External Database page:
Click Create A New Tracing Database.
Select a location to save the database.
Complete the User Name and Password fields.
Click Start Database On The Current Server.
Click Create Database.
On the Start Tracing page:
Click Save Tracing Data In An External Database.
Complete the User Name and Password fields. Specify the user name and password used to connect to the production database.
In the Other Connection Parameters field, type the database server and database name in the form of a partial connection string. For example,
Only DBN, DBF, Server, DBKEY, HOST, and LINKS (CommLinks) are supported in the connection string for an external database.
In the Do You Want To Limit The Volume Of Trace Data That Is Stored list, select an option.
When you are done gathering diagnostic tracing data, right-click the database and click Tracing » Stop Tracing With Save.
Discuss this page in DocCommentXchange.
|Copyright © 2012, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.1|