Chapter 14 System Procedures and Functions
965
♦ LastReqTime
♦ ProcessTime
♦ Port
♦ ReqType
♦ CommLink
♦ NodeAddr
♦ LastIdle
♦ CurrTaskSwitch
♦ BlockedOn
♦ UncmtOps.
♦ LockName
In a deadlock situation, the BlockedOn value returned by this procedure
allows you to check which users are blocked, and who they are blocked on.
The
sa_locks
procedure can be used to display the locks held by the blocking
connection; and if A holds locks on several tables you can match the
LockName value between
sa_locks
and
sa_conn_info
.
$ For information on these properties, see "Connection-level properties"
on page 1090.
sa_conn_properties system procedure
Reports connection property information
sa_conn_properties ( [
connection-id
] )
None.
None
"sa_conn_properties_by_conn system procedure" on page 966
"sa_conn_properties_by_name system procedure" on page 966
"System functions" on page 310
"Connection-level properties" on page 1090
Returns the connection id as Number, and the PropNum, PropName,
PropDescription, and Value for each available connection property.
If no connection-id is supplied, properties for all current connections to the
server are returned.
Function
Syntax
Permissions
Side effects
See also
Description
To Next Page
Loading...