sa_conn_info system procedure

Reports connection property information.

sa_conn_info ( [ connection-id ] )

None.

Returns a result set consisting of the following connection properties for the supplied connection. If no connection-id is supplied, information for all current connections to databases on the server is returned.

• Number

• Name

• Userid

• DBNumber

• LastReqTime

• ProcessTime

• Port

• ReqType

• CommLink

• NodeAddr

• LastIdle

• CurrTaskSwitch

• BlockedOn

• UncommitOp

sa_conn_info

569851433,'','DBA',0,'','0.0',1,
'CURSOR_OPEN','local','',6821,0,0,1008