Icon ServerSessionLocks Table

Structure
CREATE TABLE "ServerSessionLocks"
(
"SessionID" INTEGER,
"SessionName" VARCHAR(40) COLLATE "ANSI_CI",
"DatabaseName" VARCHAR(40) COLLATE "ANSI_CI",
"ObjectName" VARCHAR(40) COLLATE "ANSI_CI",
"ObjectType" VARCHAR(15) COLLATE "ANSI_CI",
"LockType" VARCHAR(15) COLLATE "ANSI_CI",
"Number" INTEGER
)

CREATE INDEX "SessionID" ON "ServerSessionLocks"
("SessionID")
   
CREATE INDEX "SessionName" ON "ServerSessionLocks"
("SessionName")

CREATE INDEX "DatabaseName" ON "ServerSessionLocks"
("DatabaseName")

Description
This table reflects all locks currently acquired by all of the sessions that are present on the ElevateDB server that the current session is logged in to. The current user must be granted the system-defined Administrators role in order to view this table. Please see the User Security topic for more information.

The LockType column values are as follows:

LockTypeDescription
SharedThe lock is a shared table open lock
ExclusiveThe lock is an exclusive table open lock
ReadThe lock is a table read lock
WriteThe lock is a table write lock
TransactionThe lock is a transaction table lock
RowThe lock is a table row lock

Related DDL Statements
StatementDescription
DISCONNECT SERVER SESSIONDisconnects an existing server session
REMOVE SERVER SESSIONRemoves an existing server session
Image