Skip to main content

INFORMATION.SCHEMA.CURRENTCONNECTIONS

Class INFORMATION.SCHEMA.CURRENTCONNECTIONS [ ClassType = view, CompileAfter = %SYS.ProcessQuery, Final, Owner = {_PUBLIC}, SqlTableName = CURRENT_CONNECTIONS, System = 4, ViewQuery = {

Returns one row for each xDBC server process currently running on this instance

Column Descriptions:

Pid - Process ID. Process ID ($J) given to the process by the O/S, decimal form on all platforms.

Username - $Username of process.

Roles - Roles a process currently has.

LoginRoles - Roles a process has when it initially logs in.

Routine - Name of the routine which the process is currently executing.

InTransaction - In a transaction. If 0, the process is not in a transaction. If >0, the process has executed a tstart command, is in a transaction, and the value is the offset in the journal file where the transaction has started.

ClientNodeName - Node name of the client which initiated the connection. It is passed down to the process as part of the initial connection message. This property may be set by the end-user if they are managing their own connections.

ClientIPAddress - IP address of the client which initiated the connection. It is passed down to the process as part of the initial connection message. This property may be set by the end-user if they are managing their own connections.

ClientExecutableName - The name of the Executable or DLL on the client which initiated the connection. It is passed down to the process as part of the initial connection message. This property may be set by the end-user if they are managing their own connections.

MemoryAllocated - Maximum amount of memory in KB that the process is allowed to use. This property requires a mailbox message to be sent to the process being examined.

MemoryUsed - Memory used in KB (Current $s). Current amount of memory the process has used in KB. This property requires a mailbox message to be sent to the process being examined.

MemoryPeak - Peak memory allocated in KB. This property requires a mailbox message to be sent to the process being examined.

StatementId - Statement hash ID from the SQL Statement Index (if the process is currently executing an SQL Statement)

Statement - SQL Statement Text currently being executed (if the caller has permission for this statement).

Parameters​

READONLY​

Parameter READONLY = 1;

Methods​

GetStatement​

ClassMethod GetStatement(statementHash As %String, namespace As %String) As %String(MAXLEN=262144) [ Internal, SqlName = GetStatement, SqlProc ]

Given an SQL Statement Hash and a namespace, return the SQL Statement Text