IBM Support

How can I prevent client timeouts on a SQL Anywhere Database?

Troubleshooting


Problem

How can I prevent client timeouts on a SQL Anywhere Database?

Resolving The Problem

QUESTION:
How can I prevent client timeouts on a SQL Anywhere Database?

ANSWER:
Description of liveness timeout (-tl) for version 5.5.05 :
A liveness packet is sent periodically across a client/server TCP/IP, or SPX
communications protocol to confirm that a connection is intact.
If the client runs for the liveness timeout period without detecting a liveness
packet, the communication is severed.
Liveness packets are sent at an interval of one quarter of the LivenessTimeout
value when the connection is idle - that is, there has been no request or
response packets sent back and forth for at least one quarter of the
LivenessTimeout value.

Description of idle timeout (-ti):
Disconnect connections that have not submitted a request for minutes. The
default is 240 [minutes] (4 hours). A client machine in the middle of a database
transaction holds locks until the transaction is ended or the connection is
terminated. The -ti option is provided to disconnect inactive connections,
freeing their locks.

The -ti option does not disconnect clients that use the shared memory
communications link.

Setting the value to zero disables checking of inactive connections, so that
no connections are disconnected.

Refer also to Setting Timeout switches.



[{"Product":{"code":"SSSHTR","label":"Rational TeamTest"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Component":"--","Platform":[{"code":"PF033","label":"Windows"}],"Version":"2002.05.00.305.000","Edition":"","Line of Business":{"code":"","label":""}}]

Historical Number

123457006

Document Information

Modified date:
16 June 2018

UID

swg21121275