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

SQL Anywhere 12.0.0 » SQL Anywhere Server - SQL Usage » Stored procedures and triggers » Debugging procedures, functions, triggers, and events » Introduction to the SQL Anywhere debugger

 

Requirements for using the debugger

To use the debugger, you must either have DBA authority or be granted permissions in the SA_DEBUG group. This group is added to all databases when they are created. Only one user can debug a database at a time.

When using the debugger over HTTP/SOAP connections, you should change the port timeout options on the server. For example, -xs http{to=600;kto=0;port=8081) sets the timeout to 6 minutes and turns off keep-alive timeout for port 8081. Note that timeout (to) is the period of time between received packets. Keep-alive timeout (kto) is the total time that the connection is allowed to run. When you set kto to 0, it is equivalent to setting it to never time out. See -xs dbeng12/dbsrv12 server option.

If using a SQL Anywhere HTTP/SOAP client procedure to call into the SQL Anywhere HTTP/SOAP service you are debugging, you should set the client's remote_idle_timeout database option to a large value such as 150 (the default is 15 seconds) to avoid timing out during the debugging session. See remote_idle_timeout option.