Use the Unload utility (dbunload) to manually create a tracing database without a tracing session.
DBA or PROFILE authority.
Context and remarks
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.
If you want to store the tracing database on a separate computer, copy it to the new location.
Discuss this page in DocCommentXchange.
|Copyright © 2012, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.1|