Phantom Users in ASA 11

We have some customers that have been reporting "phantom users". When they look at connected users they see people that have not only closed the software app, but have also shut down their computer.

We are using SQLA version 11.01 We start the ddsrv11.exe with the following parameters... -x tcpip -ti 0 -tl 0

Could these parameters cause connections to remain open even when people have shut down their computer?

TIA, Mike

connection

asked 04 Apr '13, 10:01

ksitech
16●1●1●2
accept rate: 0%

flat view

One Answer:

active answers oldest answers newest answers popular answers

Yes, I believe this is certainly a possibility. -ti 0 disables the Idle Timeout check (which normally engages after 240 minutes if we haven't heard from a client to automatically disconnect the client), and -tl 0 disables the Liveness check (which is the only mechanism available to the server to check the active client connectivity).

If you do not explicitly close the database connection (e.g. the network drops off, do not explicitly 'close' a connection in your program, etc.), then this could be the behaviour you're seeing.

You should be able to drop the connections using the DROP CONNECTION statement.

We have also had previous problems with "[Exchange]" workers, from intra-query parallelization queries and we left 'phantom' users connected that could not be dropped. This was fixed in a later patch (11.0.1.2786 and above).

permanent link

answered 04 Apr '13, 10:10

Jeff Albion
10.8k●1●71●175
accept rate: 25%

edited 05 Apr '13, 07:31

Ian McHardy
3.4k●2●35●57

Thanks for the reply. We will change these values.

(04 Apr '13, 10:20) ksitech

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:

connection ×159

question asked: 04 Apr '13, 10:01

question was seen: 1,379 times

last updated: 05 Apr '13, 07:31

SAP SQL Anywhere

Phantom Users in ASA 11

Follow this question

Related questions