SQL Anywhere and IQ

IQ is based on the SQL Anywhere (SA) server, and both use TDS to participate in a replication environment. The RMS uses jConnect to connect to the server. Neither the SA nor the IQ server contains internal RepAgent threads. The RMS tests the connection to the SA or IQ server to determine its availability.

Table C-4 describes the SQL Anywhere states.

Table C-4: SA and IQ server states

State type

Value

Meaning

Description

Normal

5

ACTIVE

Successfully connected to the SA or IQ server.

Warning

3

UNKNOWN

The initial value before the actual state has been determined. Also indicates that the server is not part of the replication environment.

Error

0

DOWN

The RMS cannot connect to the SA or IQ server. The server state is also set to DOWN if the user or password is incorrect.

1

TIMED OUT

The attempt to connect to the SA or IQ server timed out. Indicates that a server has stopped responding.