SYSTEMLOCKS: Data Dictionary Locks |
Locks.
Catalog: DataDictionary
Schema: Invantive
Alias: lck
Label: Locks
This is a read-only view. The Data Dictionary API may not support changing the data or the Invantive UniversalSQL driver for Data Dictionary does not cover it. In the latter case, please use the table NativePlatformScalarRequests to upload data to the Data Dictionary API.
View Columns
The columns of the view SYSTEMLOCKS are shown below. Each column has an SQL data type.
Name |
Data Type |
Label |
Required |
Documentation |
---|---|---|---|---|
ACQUISITION_COUNT |
int64 |
Acquisition Count |
☑ |
Number of acquisitions. |
AVERAGE_ACTIVE |
decimal |
Average Active |
☑ |
Average number of active slots. |
BILLING_ID_LAST_ACQUISITION |
string |
Billing ID Last Acquisition |
☐ |
ID for billing at last acquisition. |
BILLING_ID_LAST_TIMEOUT |
string |
Billing ID Last Timeout |
☐ |
ID for billing at last timeout. |
BILLING_ID |
string |
Billing ID |
☐ |
ID for billing. |
CALLING_PROVIDER_ALIAS |
string(240) |
Calling Provider Alias |
☐ |
Calling provider alias. |
CATEGORY_CODE |
string |
Category Code |
☐ |
Category. |
CONTEXT |
string |
Context |
☐ |
Context. |
CURRENT_FREE |
int32 |
Current Free |
☑ |
Current capacity free. |
CURRENT_READ_USED |
int32 |
Current Read |
☑ |
Current read capacity used. |
CURRENT_USED |
int32 |
Current Used |
☑ |
Current capacity used. |
CURRENT_WAITING_COUNT |
int32 |
Current Waiting |
☑ |
Current number of waiters. |
DATA_CONTAINER_ID |
string(4000) |
Data Container ID |
☐ |
Data container ID that created the lock. |
DATE_FIRST_ACQUISITION |
datetime |
First Acquisition |
☐ |
Time of first acquisition. |
DATE_FIRST_RELEASE |
datetime |
First Release |
☐ |
Time of first release. |
DATE_FIRST_TIMEOUT |
datetime |
First Timeout |
☐ |
Time of first time-out. |
DATE_LAST_ACQUISITION |
datetime |
Last Acquisition |
☐ |
Time of last acquisition. |
DATE_LAST_FULL_RELEASE |
datetime |
Last Full Release |
☐ |
Time of last full release. |
DATE_LAST_OPERATION |
datetime |
Last Operation |
☑ |
Time of last operation. |
DATE_LAST_RELEASE |
datetime |
Last Release |
☐ |
Time of last release. |
DATE_LAST_TIMEOUT |
datetime |
Last Timeout |
☐ |
Time of last time-out. |
DATE_REGISTERED |
datetime |
Registered |
☑ |
Time of registration. |
EXECUTION_STEP_ID |
int64 |
SQL Execution Step ID |
☐ |
ID of the SQL execution step that created the lock. |
GUI_ACTION |
string(240) |
GUI Action |
☐ |
Action performed within the user interface. |
GUI_IP_ADDRESS_EXTERNAL_LAST_ACQUISITION |
string(240) |
GUI IP Address External Last Acquisition |
☐ |
External IP address of the GUI application at last acquisition. |
GUI_IP_ADDRESS_EXTERNAL_LAST_TIMEOUT |
string(240) |
GUI IP Address External Last Timeout |
☐ |
External IP address of the GUI application at last timeout. |
GUI_IP_ADDRESS_EXTERNAL |
string(240) |
GUI External IP Address |
☐ |
External IP address of the GUI application. |
GUI_IP_PORT_LAST_ACQUISITION |
uint16 |
GUI IP Port Last Acquisition |
☐ |
External IP port of the GUI application at last acquisition. |
GUI_IP_PORT_LAST_TIMEOUT |
uint16 |
GUI IP Port Last Timeout |
☐ |
External IP port of the GUI application at last timeout. |
GUI_IP_PORT |
uint16 |
GUI IP Port |
☐ |
External IP port of the GUI application. |
GUI_MACHINE |
string(240) |
GUI Machine |
☐ |
Name of the machine running the GUI application. |
GUI_MODULE_NAME |
string(240) |
GUI Module Name |
☐ |
Module within the GUI application currently running. |
GUI_MODULE_VERSION |
string(240) |
GUI Module Version |
☐ |
Version of module within the GUI application currently running. |
GUI_OS_USER |
string(240) |
GUI OS User |
☐ |
OS user. |
GUI_USER |
string(240) |
User |
☐ |
Application user. |
INITIAL_CAPACITY |
int32 |
Initial Capacity |
☑ |
Initial capacity. |
LAST_WAIT_TIMEOUT_MS |
int64 |
Last Wait Timeout (ms) |
☐ |
Time-out in milliseconds of last started and active wait. |
MAXIMUM_CAPACITY |
int32 |
Maximum Capacity |
☑ |
Maximum capacity. |
PARTITION_CODE |
string(240) |
Partition Code |
☐ |
Unique code of the partition that created the lock. |
POOL_IDENTITY_LAST_ACQUISITION |
string(60) |
Pool Identity Last Acquisition |
☐ |
Pool identity at last acquisition. |
POOL_IDENTITY_LAST_TIMEOUT |
string(60) |
Pool Identity Last Timeout |
☐ |
Pool identity at last timeout. |
POOL_IDENTITY |
string(60) |
Pool Identity |
☐ |
Pool identity. |
PROCESS_ID |
uint32 |
Process ID |
☐ |
Process ID. |
PROVIDER_NAME |
string(240) |
Provider Name |
☐ |
Name of the provider that created the lock. |
RELEASE_COUNT |
int64 |
Release Count |
☑ |
Number of releases. |
REQUEST_ID_LAST_ACQUISITION |
string(240) |
Request ID Last Acquisition |
☐ |
Request ID at last acquisition. |
REQUEST_ID_LAST_TIMEOUT |
string(240) |
Request ID Last Timeout |
☐ |
Request ID at last timeout. |
REQUEST_ID |
string(240) |
Request ID |
☐ |
Request ID. |
SESSION_ID |
string(240) |
Session ID |
☐ |
ID of the session that created the lock. |
SQL_STATEMENT |
string |
SQL Statement |
☐ |
SQL statement that created the lock. |
STDDEV_ACTIVE |
decimal |
Standard Deviation Active |
☑ |
Standard deviation number of active slots. |
STYLE |
string(60) |
Style |
☑ |
Style. |
TABLE_NAME |
string |
Table Name |
☐ |
Name of the table that created the lock. |
TIMEOUT_COUNT |
int64 |
Timeout Count |
☑ |
Number of timeouts. |
TYPE |
string(30) |
Type |
☐ |
Type of lock. One of: SEMAPHORE or RWLOCK. |
UID |
guid |
UID |
☑ |
Unique ID. |
WAIT_AVERAGE_DURATION_MS |
decimal |
Average Wait Duration (ms) |
☑ |
Average duration of wait (ms)). |
WAIT_STDDEV_DURATION_MS |
decimal |
Standard Deviation Wait Duration (ms) |
☑ |
Standard deviation duration of wait (ms)). |
WAITS_COMPLETED |
int64 |
Waits Completed |
☑ |
Number of waits completed. |
23-06-2025 19:18 Version 24.1.116-BETA+5455