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

SQL Anywhere 17 » SQL Anywhere Server - Database Administration » Database connections

Advanced topic: Temporary connections

The 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.

Temporary connections have connection IDs that are larger than 1 billion (1000000000), and their names describe the function of the connection.

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)