Displays information about all current users and connections, or about a particular user or connection.
Requires the DROP CONNECTION, MONITOR, and SERVER OPERATOR system privileges. Users without these system privileges must be granted EXECUTE permission to run the stored procedure.
The sp_iqwho stored procedure displays information about all current users and connections, or about a particular user or connection.
Column name |
Description |
|---|---|
ConnHandle |
The SA connection handle |
IQConnID |
The SAP Sybase IQ specific connection ID |
Userid |
The name of the user that opened the connection “ConnHandle” |
BlockedOn |
The connection on which a particular connection is blocked; 0 if not blocked on any connection |
BlockUserid |
The owner of the blocking connection; NULL if there is no blocking connection |
ReqType |
The type of the request made through the connection; DO_NOTHING if no command is issued |
IQCmdType |
The type of SAP Sybase IQ command issued from the connection; NONE if no command is issued |
IQIdle |
The time in seconds since the last SAP Sybase IQ command was issued through the connection; in case of no last SAP Sybase IQ command, the time since ‘01-01-2000’ is displayed |
SAIdle |
The time in seconds since the last SA request was issued through the connection; in case of no last SA command, the time since ‘01-01-2000’ is displayed |
IQCursors |
The number of active cursors in the connection; 0 if no cursors |
IQThreads |
The number of threads with the connection. At least one thread is started as soon as the connection is opened, so the minimum value for IQThreads is 1. |
TempTableSpaceKB |
The size of temporary table space in kilobytes; 0 if no temporary table space is used |
TempWorkSpaceKB |
The size of temporary workspace in kilobytes; 0 if no temporary workspace is used |
sp_who column |
sp_iqwho column |
|---|---|
fid |
Family to which a lock belongs; omitted, as not applicable to SAP Sybase IQ |
spid |
ConnHandle, IQConnID |
status |
IQIdle, SAIdle |
loginame |
Userid |
origname |
User alias; omitted, as not applicable to SAP Sybase IQ |
hostname |
Name of the host on which the server is running; currently not supported |
blk_spid |
BlockedOn |
dbname |
Omitted, as there is one server and one database for SAP Sybase IQ and they are the same for every connection |
cmd |
ReqType, IQCmdType |
block_xloid |
BlockUserid |
Parameter |
Description |
|---|---|
connhandle |
An integer representing the connection ID. If this parameter is specified, sp_iqwho returns information only about the specified connection. If the specified connection is not open, no rows are displayed in the output. |
user-name |
A char(255) parameter representing a user login name. If this parameter is specified, sp_iqwho returns information only about the specified user. If the specified user has not opened any connections, no rows are displayed in the output. If the specified user name does not exist in the database, sp_iqwho returns the error message ”User user-name does not exist” |
arg-type |
The arg-type parameter
is optional and can be specified only when the first parameter has
been specified. The only value for arg-type is “user”.
If the arg-type value is specified as “user”, sp_iqwho interprets
the first parameter as a user name, even if the first parameter
is numeric. If any value other than “user” is specified
for arg-type, sp_iqwho returns the
error
“Invalid parameter.” Enclose the arg-type value in double quotes. |
If no parameters are specified, sp_iqwho displays information about all currently active connections and users.
Either a connection handle or a user name can be specified as the first sp_iqwho parameter. The parameters connhandle and user-name are exclusive and optional. Only one of these parameters can be specified at a time. By default, if the first parameter is numeric, the parameter is assumed to be a connection handle. If the first parameter is not numeric, it is assumed to be a user name.
sp_iqwho 1, “user”When the arg-type “user” is specified, sp_iqwho interprets the first parameter 1as a user name, not as a connection ID. If a user named 1 exists in the database, sp_iqwho displays information about connections opened by user 1.
Syntax |
Output |
|---|---|
sp_iqwho |
Displays all active connections |
sp_iqwho 3 |
Displays information about connection 3 |
sp_iqwho “DBA” |
Displays connections opened by user DBA |
sp_iqwho 3, “user” |
Interprets 3 as a user name and displays connections opened by user 3. If user 3 does not exist, returns the error “User 3 does not exist” |
sp_iqwho non-existing-user |
Returns error “User non-existing-user does not exist” |
sp_iqwho 3, “xyz” |
Returns the error “Invalid parameter: xyz” |