Debug a single connection

It is possible to restrict the debugging in Sybase Central to one user.

What I am looking for, to use it on a productive system, is to restrict the debugging just to one connection. Is that possible? I am looking for a way to debug only the procedures called by a single connection ignoring all calls to these procedures which come from other connections.

debugging

asked 20 Jun '12, 10:37

Martin
8.8k●126●163●250
accept rate: 14%

edited 21 Jun '12, 03:36

flat view

One Answer:

active answers oldest answers newest answers popular answers

To use the debugger requires either DBA privilege or SA_DEBUG authority, which is how you would restrict the set of users who can use the debugger.

There is no built-in mechanism to limit debugger connections that I am aware of. You could use the IsDebugger connection property to test to see if another connection is already using the debugger - for example, you could execute an event periodically to see if more than one such connection exists, and then report the existence of more than one connection as a message in the console window.

permanent link

answered 20 Jun '12, 15:46

Glenn Paulley
10.8k●5●76●106
accept rate: 43%

Thanks for the answer, but I haven't meant a way to prevent multiple debugger sessions. I am looking for a way to debug only the procedures called by a single connection ignoring all calls to these procedures which come from other connections. Sorry for that.

(21 Jun '12, 03:35) Martin

Replies hidden

Comment Text Removed

Can you set a breakpoint &&SPID = n where n is the connection number?

http://dcx.sybase.com/index.html#1201/en/dbusage/editing-breakpoints-procdebug.html

(21 Jun '12, 03:53) Breck Carter

flat view

Your answer

toggle preview

community wiki:

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

*italic* or _italic_
**bold** or __bold__
link:[text](http://url.com/ "title")
image?![alt text](/path/img.jpg "title")
numbered list: 1. Foo 2. Bar
to add a line break simply add two spaces to where you would like the new line to be.
basic HTML tags are also supported

learn more about Markdown

Question tags:

debugging ×105

question asked: 20 Jun '12, 10:37

question was seen: 1,386 times

last updated: 21 Jun '12, 03:53

SAP SQL Anywhere

Debug a single connection

Follow this question

Related questions