Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 10.0.1 » SQL Anywhere Server - SQL Usage » Accessing Remote Data » Troubleshooting remote data access

Connectivity tests Next Page

General problems with queries

If SQL Anywhere is having difficulty handling a query against a remote table, it is usually helpful to understand how SQL Anywhere is executing the query. You can display remote tracing, as well as a description of the query execution plan:

SET OPTION cis_option = 7

Once you have turned on remote tracing, the tracing information appears in the Server Messages window. You can log this output to a file by specifying the -o server option when you start the database server.

For more information about using the cis_option option for debugging queries when using remote data access, see cis_option option [database].

For more information about the -o server option, see -o server option.