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 |
string |
Billing ID |
☐ |
ID for billing. |
CALLING_PROVIDER_ALIAS |
string(240) |
|
☐ |
Calling provider alias. |
CATEGORY_CODE |
string |
Category Code |
☐ |
Category. |
CONTEXT |
string |
Context |
☐ |
Context. |
CURRENT_FREE |
int32 |
Current Free |
☑ |
Current capacity free. |
CURRENT_USED |
int32 |
Current Used |
☑ |
Current capacity used. |
CURRENT_WAITING_COUNT |
int32 |
|
☑ |
Current number of waiters. |
DATE_FIRST_ACQUISITION |
datetime |
|
☐ |
Time of first acquisition. |
DATE_FIRST_RELEASE |
datetime |
|
☐ |
Time of first release. |
DATE_FIRST_TIMEOUT |
datetime |
|
☐ |
Time of first time-out. |
DATE_LAST_ACQUISITION |
datetime |
|
☐ |
Time of last acquisition. |
DATE_LAST_FULL_RELEASE |
datetime |
|
☐ |
Time of last full release. |
DATE_LAST_OPERATION |
datetime |
|
☑ |
Time of last operation. |
DATE_LAST_RELEASE |
datetime |
|
☐ |
Time of last release. |
DATE_LAST_TIMEOUT |
datetime |
|
☐ |
Time of last time-out. |
DATE_REGISTERED |
datetime |
Registered |
☑ |
Time of registration. |
GUI_ACTION |
string(240) |
GUI Action |
☐ |
Action performed within the user interface. |
GUI_IP_ADDRESS_EXTERNAL |
string(240) |
GUI External IP Address |
☐ |
External IP address 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 |
|
☐ |
Time-out in milliseconds of last started and active wait. |
MAXIMUM_CAPACITY |
int32 |
Maximum Capacity |
☑ |
Maximum capacity. |
POOL_IDENTITY |
string(60) |
Pool Identity |
☐ |
Pool identity. |
PROCESS_ID |
uint32 |
Process ID |
☐ |
Process ID. |
RELEASE_COUNT |
int64 |
Release Count |
☑ |
Number of releases. |
REQUEST_ID |
string(240) |
Request ID |
☐ |
Request ID. |
SESSION_ID |
string(240) |
Session ID |
☐ |
ID of the session. |
STDDEV_ACTIVE |
decimal |
Standard Deviation Active |
☑ |
Standard deviation number of active slots. |
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 duration of wait (ms)). |
WAIT_STDDEV_DURATION_MS |
decimal |
|
☑ |
Standard deviation duration of wait (ms)). |
WAITS_COMPLETED |
int64 |
Waits Completed |
☑ |
Number of waits completed. |
18-10-2024 06:49 Version 24.0.345-PROD+4945