sp_iqwho: Displays information current user(s) and connection(s)



Share this article :

The command sp_iqwho in Sybase IQ is use to display information on all current users and connections. You must have EXECUTE privilege on the system procedure and DROP CONNECTION, MONITOR, SERVER OPERATOR for system privileges.

sp_iqwho

Syntax

sp_iqwho [ { connhandle | user-name } [, arg-type ] ]
ParametersDescription
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 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 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.

Remarks

Column nameDescription
ConnHandleThe SA connection handle.
IQConnIDThe SAP Sybase IQ specific connection ID.
UseridThe name of the user that opened the connection “ConnHandle”.
BlockedOnThe connection on which a particular connection is blocked; 0 if not blocked on any connection.
BlockUseridThe owner of the blocking connection; NULL if there is no blocking connection.
ReqTypeThe type of the request made through the connection; DO_NOTHING if no command is issued.
IQCmdTypeThe type of SAP Sybase IQ command issued from the connection; NONE if no command is issued.
IQIdleThe 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.
SAIdleThe 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.
IQCursorsThe number of active cursors in the connection; 0 if no cursors.
IQThreadsThe 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.
TempTableSpaceKBThe size of temporary table space in kilobytes; 0 if no temporary table space is used.
TempWorkSpaceKBThe size of temporary workspace in kilobytes; 0 if no temporary workspace is used.

Reference

Sybase Infocenter

Tags:

Related posts

How to Create Technical User in SAP IQ Cockpit
How to Get Table Size in Sybase IQ
sp_iqlmconfig: Sybase IQ License Management
How to Find Sybase IQ Startup Date/Time
© 2018 ITsiti. All Rights Reserved
Powered by KEEM