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

SQL Anywhere 12.0.1 » SQL Anywhere Server - Database Administration » Starting and connecting to your database » SQL Anywhere database connections


Temporary connections

The SQL Anywhere database server uses temporary connections to perform operations such as running backups or initializing databases. You can get information about temporary connections by using the sa_conn_info or sa_conn_list system procedure. The ParentConnection property returns the connection ID of the connection that spawned the temporary connection. See ParentConnection connection property.

Temporary connections have connection IDs that are larger than 1 billion (1000000000), and their names describe the function of the connection. For a list of temporary connection names, see Name connection property.

The following example uses the sa_conn_info system procedure to return a result set showing which connection created a temporary connection.

SELECT Number, Name, ParentConnection FROM sa_conn_info();

Connection 8 spawned the temporary connection that executed a CREATE DATABASE statement.

Number        Name               ParentConnection
1000000048    INT: CreateDB      8
9             SQL_DBC_14675af8   (NULL)
8             SQL_DBA_152d5ac0   (NULL)
 See also