The sa_diagnostic_connection table is owned by the dbo user, and has one row for every database connection that is active during the logging session. Connect and disconnect times, if they occur within the logging session, can be derived from the sa_diagnostic_request table.
Most of the values in this table mirror values of connection properties.
There are two versions of this table: sa_diagnostic_connection, and sa_tmp_diagnostic_connection.
Columns| Column name | Column type | Description |
|---|---|---|
| logging_session_id | UNSIGNED INT |
A number uniquely identifying the logging session during which the diagnostic information was gathered. |
| connection_number | UNSIGNED INT |
A number assigned by the database server to identify the user's connection to the database. This value reflects the value of the Number connection property. |
| connection_name | LONG VARCHAR |
Optional name property for the connection. This value reflects the value of the Name connection property. |
| user_name | LONG VARCHAR |
The name of the user connected to the database. |
| comm_link | CHAR(40) |
Specifies the client-side network protocol options. This value reflects the value of the CommLinks connection property. |
| node_address | LONG VARCHAR |
The node for the client in a client/server connection. This value reflects the value of the NodeAddress connection property. |
| appinfo | LONG VARCHAR |
Information about the client process, such as the IP address of the client computer, the operating system it is running on, and so on. This value reflects the value of the AppInfo connection property. |
See also |
Discuss this page in DocCommentXchange.
|
Copyright © 2010, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.0 |