Use the Unload utility (dbunload) to manually create a tracing database without a tracing session.
You must have the DIAGNOSTICS system role, and the MANAGE PROFILING system privilege.
Connect to the database.
Run a dbunload command to unload the schema from the production database into the new tracing database:
dbunload -c "UID=DBA;PWD=sql;Server=demo;DBN=demo" -an tracing.db -n -k -kd
This example creates a new database with the name supplied by the -an option (tracing.db). The -n option unloads the schema from the database being profiled (in this case, the SQL Anywhere sample database, demo.db) into the new tracing database. The -k option populates the tracing database with information that the application profiling tool uses to analyze the tracing data. The -kd option places all the dbspaces in a single dbspace file.
To store the tracing database on a separate computer, copy it to the new location.
Discuss this page in DocCommentXchange.
|Copyright © 2014, SAP AG or an SAP affiliate company. - SAP Sybase SQL Anywhere 16.0|