In Sybase Central, you can create a diagnostic tracing session to gather tracing data from your database.
Prerequisites
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.
You must have the DIAGNOSTICS system role, and the MANAGE PROFILING, SERVER OPERATOR, and SELECT ANY TABLE system privileges.
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.
TaskIn Sybase Central, use the SQL Anywhere 16 plug-in to connect to the database.
Right-click the database and click Tracing.
Click Next.
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, Server=Server47;DBN=TracingDB
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.
Click Finish.
When you are done gathering diagnostic tracing data, right-click the database and click Tracing » Stop Tracing With Save.
See also |
Discuss this page in DocCommentXchange.
|
Copyright © 2014, SAP AG or an SAP affiliate company. - SAP Sybase SQL Anywhere 16.0 |