invantive documentation
Invantive Support ForumsLog In / Sign Up

SYSTEMLOCKS: Data Dictionary Locks

read only

  • Catalog: DataDictionary
  • Schema: Invantive
  • Label: Locks

Locks.

Can only retrieve data.

Table Columns

The columns of the table SYSTEMLOCKS are shown below. Each column has an SQL data type. A new non-null value must be provided for every required column at all times during insert and update.

Name Data Type Label Required Marks Documentation
ACQUISITION_COUNT int64 Acquisition Count Number of acquisitions.
AVERAGE_ACTIVE number Average Active Average number of active slots.
BILLING_ID varchar2 Billing ID ID for billing.
BILLING_ID_LAST_ACQUISITION varchar2 Billing ID Last Acquisition ID for billing at last acquisition.
BILLING_ID_LAST_TIMEOUT varchar2 Billing ID Last Timeout ID for billing at last timeout.
CALLING_PROVIDER_ALIAS varchar2(240) Calling Provider Alias Calling provider alias.
CATEGORY_CODE varchar2 Category Code Category.
CONTEXT varchar2 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 varchar2(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 varchar2(240) GUI Action Action performed within the user interface.
GUI_IP_ADDRESS_EXTERNAL varchar2(240) GUI External IP Address External IP address of the GUI application.
GUI_IP_ADDRESS_EXTERNAL_LAST_ACQUISITION varchar2(240) GUI IP Address External Last Acquisition External IP address of the GUI application at last acquisition.
GUI_IP_ADDRESS_EXTERNAL_LAST_TIMEOUT varchar2(240) GUI IP Address External Last Timeout External IP address of the GUI application at last timeout.
GUI_IP_PORT uint16 GUI IP Port External IP port 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_MACHINE varchar2(240) GUI Machine Name of the machine running the GUI application.
GUI_MODULE_NAME varchar2(240) GUI Module Name Module within the GUI application currently running.
GUI_MODULE_VERSION varchar2(240) GUI Module Version Version of module within the GUI application currently running.
GUI_OS_USER varchar2(240) GUI OS User OS user.
GUI_USER varchar2(240) User Application user.
INITIAL_CAPACITY int32 Initial Capacity Initial capacity.
LAST_ACQUISITION_CATEGORY_CODE varchar(60) Acquisition Category Code Category code of last acquisition.
LAST_FULL_RELEASE_CATEGORY_CODE varchar(60) Full Release Category Code Category code of last full release.
LAST_OPERATION_CATEGORY_CODE varchar(60) Operation Category Code Category code of last operation.
LAST_RELEASE_CATEGORY_CODE varchar(60) Release Category Code Category code of last release.
LAST_TIMEOUT_CATEGORY_CODE varchar(60) Timeout Category Code Category code of last timeout.
LAST_WAIT_TIMEOUT_MS double Last Wait Timeout (ms) Time-out in milliseconds of last started and active wait.
MAXIMUM_CAPACITY int32 Maximum Capacity Maximum capacity.
PARTITION_CODE varchar2(240) Partition Code Unique code of the partition that created the lock.
POOL_IDENTITY varchar2(60) Pool Identity Pool identity.
POOL_IDENTITY_LAST_ACQUISITION varchar2(60) Pool Identity Last Acquisition Pool identity at last acquisition.
POOL_IDENTITY_LAST_TIMEOUT varchar2(60) Pool Identity Last Timeout Pool identity at last timeout.
PROCESS_ID uint32 Process ID Process ID.
PROVIDER_NAME varchar2(240) Provider Name Name of the provider that created the lock.
RELEASE_COUNT int64 Release Count Number of releases.
REQUEST_ID varchar2(240) Request ID Request ID.
REQUEST_ID_LAST_ACQUISITION varchar2(240) Request ID Last Acquisition Request ID at last acquisition.
REQUEST_ID_LAST_TIMEOUT varchar2(240) Request ID Last Timeout Request ID at last timeout.
SESSION_ID varchar2(240) Session ID ID of the session that created the lock.
SQL_STATEMENT varchar2 SQL Statement SQL statement that created the lock.
STDDEV_ACTIVE number Standard Deviation Active Standard deviation number of active slots.
STYLE varchar(60) Style Style.
TABLE_NAME varchar2 Table Name Name of the table that created the lock.
TIMEOUT_COUNT int64 Timeout Count Number of timeouts.
TYPE varchar2(30) Type Type of lock. One of: SEMAPHORE or RWLOCK.
UID guid UID Unique ID.
WAITS_COMPLETED int64 Waits Completed Number of waits completed.
WAIT_AVERAGE_DURATION_MS double Average Wait Duration (ms) Average duration of wait (ms)).
WAIT_STDDEV_DURATION_MS double Standard Deviation Wait Duration (ms) Standard deviation duration of wait (ms)).

Release Notes

What changed per release in the tables, columns, attributes and capabilities of the driver: