Data Dictionary Data ModelIndividual I/Os executed by the Invantive SQL engine on the data containers during the execution of SQL statements and their statistics.
Catalog: DataDictionary
Schema: Invantive
Alias: sio
Label: Session I/Os
This is a read-only view. The Data Dictionary API may not support changing the data or the Invantive SQL 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 SESSIONIOS are shown below. Each column has an SQL data type.
Name |
Data Type |
Label |
Required |
Documentation |
|---|---|---|---|---|
ACTION |
string |
Action |
|
Action, being either 'READ' or 'WRITE'. |
BYTES_RECEIVED |
int64 |
Bytes Received |
|
Number of bytes received. |
BYTES_SENT |
int64 |
Bytes Sent |
|
Number of bytes sent. |
CALL_SAFE_NAME |
string |
Call Safe Name |
|
Call safe name of the object. |
DATA_CONTAINER_ALIAS |
string(240) |
Data Container Alias |
☐ |
Alias of the data container. |
DATA_CONTAINER_ID |
string |
Data Container ID |
|
ID of the data container. |
DURATION_MS |
int32 |
Duration |
|
Duration in milliseconds of the I/O. |
ERROR_MESSAGE |
string |
Error Message |
|
Error message that occurred during executing the I/O. |
EXECUTION_END_DATE_UTC |
datetime |
Execution End Date |
|
Date at which the I/O was ended (UTC). |
EXECUTION_START_DATE_UTC |
datetime |
Execution Start Date |
|
Date at which the I/O was started (UTC). |
FORWARDED_CUSTOMER_SERVICE |
boolean |
Forwarded to Customer Service |
|
Indicator whether session I/O was forwarded. |
ID |
int64 |
ID |
☑ |
Unique ID of the property. |
LICENSE_CONTRACT_CODE |
string |
License Contract Code |
|
License contract code. |
LICENSE_KEY_IDENTIFIER |
string |
License Key Identifier |
|
License key identifier. |
MANAGED_THREAD_ID |
int32 |
Managed Thread ID |
☑ |
Managed thread ID. |
PARAMETER_LIST |
string |
Parameter List |
|
Parameters. |
PARTITION |
string |
Partition |
|
Specific partition on which the I/O was executed. |
PROVIDER_NAME |
string |
Provider |
|
Name of provider. |
PUBLIC_QUERY_PARAMETERS |
string |
|
|
Parameters added to the platform query. |
RECURSION_LEVEL |
int32 |
Recursion Level |
|
Recursion level. |
ROUND_TRIPS |
int32 |
Round Trips |
|
Number of round trips. |
ROW_COUNT |
int64 |
Rows |
|
Number of rows exchanged. |
SUCCESSFUL |
boolean |
Succesful |
|
Indicator whether the I/O completed successfully. |
UID |
guid |
|
☑ |
Unique ID of the property. |
URL |
string |
URL |
|
Address being accessed. |
17-05-2021 11:57 Version 20.1.419-BETA+3191
