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