SYSTEMPROVIDERSACTIVE: Data Dictionary Active System Providers |
All providers currently loaded in Invantive SQL.
Catalog: DataDictionary
Schema: Invantive
Alias: pae
Label: Active System Providers
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 SYSTEMPROVIDERSACTIVE are shown below. Each column has an SQL data type.
Name |
Data Type |
Label |
Required |
Documentation |
---|---|---|---|---|
ABBREVIATION |
string(30) |
Abbreviation |
☑ |
Abbreviation. |
BULK_INSERT_COUNT |
int32 |
Bulk Insert Count |
☑ |
Number of times a bulk insert was executed. |
BULK_INSERT_DURATION_MAX_MS |
int64 |
Bulk Insert Duration Maximum (ms) |
☑ |
Maximum time spent in ms during bulk insert. |
BULK_INSERT_DURATION_TOTAL_MS |
int64 |
Bulk Insert Duration Total (ms) |
☑ |
Total time spent in ms during bulk insert. |
BULK_INSERT_PAGE_COUNT |
int32 |
Bulk Insert Page Count |
☑ |
Number of times a bulk page insert was executed. |
BULK_INSERT_ROW_COUNT |
int64 |
Bulk Insert Row Count |
☑ |
Number of rows inserted in bulk. |
COMMERCIAL_NAME |
string(240) |
Commercial Name |
☑ |
Commercial name. |
COMMUNITY_EDITION |
boolean |
Is Community Edition |
☑ |
Is application software offered for free? |
CONNECTION_OPENED_AT_UTC |
datetime |
Connection Opened at (UTC) |
☐ |
Time the connection was opened (UTC). |
DATA_CONTAINER_ALIAS |
string(4000) |
Data Container Alias |
☐ |
Data container alias. |
DATA_CONTAINER_ID |
string(4000) |
Data Container ID |
☐ |
Data container ID. |
DATABASE_POOL_DESCRIPTION |
string(4000) |
Database Pool Description |
☐ |
Database pool description, in which multiple databases are pooled. |
DATABASE_PRICING_TIER |
string(240) |
Database Pricing Tier |
☐ |
Database pricing tier. |
DATABASE_SERVICE_TIER |
string(240) |
Database Service Tier |
☐ |
Database service tier. |
DATABASE_VERSION_NUMBER |
string(240) |
Database Version Number |
☐ |
Current database version number. |
DATABASE_VERSION |
string(240) |
Database Version |
☐ |
Current database version including platform, edition and version number. |
DEFAULT_CONNECTION_ID |
guid |
Default Connection ID |
☑ |
Default GUID for first discovered connection of this provider. |
DEFAULT_NUMBER_PARALLEL_REQUESTS |
int32 |
Default Number of Parallel Requests |
|
Default number of parallel requests. |
DEFAULT_SLOTBASED_RATE_LIMIT_LENGTH_MS |
int64 |
Default Slot-based Rate Limit Length (ms) |
☑ |
Default length in ms of a slot-based rate limit. |
DEFAULT_SLOTBASED_RATE_LIMIT_SLOTS |
int32 |
Default Slot-based Rate Limit Slots |
☐ |
Default number of slots of a slot-based rate limit. |
DESCRIPTION |
string(4000) |
Provider Description |
☑ |
Provider description. |
DISPLAY_NAME |
string(240) |
Display Name |
☑ |
Display name. |
DOCUMENTATION_URL |
string(4000) |
Documentation (URL) |
☐ |
Documentation URL. |
DOCUMENTATION |
string(32767) |
Documentation |
☐ |
Documentation. |
DOWNLOAD_IMPLEMENTATION_URL |
string(4000) |
Download Implementation URL |
☐ |
Download URL for implementation. |
HTTP_DISK_CACHE_HITS |
int32 |
HTTP Disk Cache Hits |
☑ |
Number of HTTP disk cache hits. |
HTTP_DISK_CACHE_INCORRECT_CONTENT_HITS |
int32 |
HTTP Disk Cache Incorrect Content Hits |
☑ |
HTTP disk cache number of incorrect content hits. |
HTTP_DISK_CACHE_MISSES |
int32 |
HTTP Disk Cache Misses |
☑ |
Number of HTTP disk cache misses. |
HTTP_DISK_CACHE_READ_BYTES |
int64 |
HTTP Disk Cache Read (byte) |
☑ |
Number of HTTP disk cache disk bytes. |
HTTP_DISK_CACHE_READ_DECOMPRESS_OPERATIONS |
int64 |
HTTP Disk Cache Read Decompress Operations |
☑ |
Number of HTTP disk cache decompress operations. |
HTTP_DISK_CACHE_READ_DECOMPRESSED_BYTES |
int64 |
HTTP Disk Cache Read Decompressed (byte) |
☑ |
Number of HTTP disk cache decompressed bytes. |
HTTP_DISK_CACHE_READ_DECRYPT_DURATION_MS |
int64 |
HTTP Disk Cache Read Decrypt Duration (ms) |
☑ |
Number of HTTP disk cache read decrypt duration (ms). |
HTTP_DISK_CACHE_READ_DECRYPT_OPERATIONS |
int64 |
HTTP Disk Cache Read Decrypt Operations |
☑ |
Number of HTTP disk cache decrypt operations. |
HTTP_DISK_CACHE_READ_DECRYPTED_BYTES |
int64 |
HTTP Disk Cache Read Decrypted (byte) |
☑ |
Number of HTTP disk cache decrypted bytes. |
HTTP_DISK_CACHE_READ_OPERATIONS |
int64 |
HTTP Disk Cache Read Operations |
☑ |
Number of HTTP disk cache operations. |
HTTP_DISK_CACHE_UNSUPPORTED_ENCRYPTION_HITS |
int32 |
HTTP Disk Cache Unsupported Encryption Hits |
☑ |
HTTP disk cache number of unsupported encryption hits. |
HTTP_DISK_CACHE_UNSUPPORTED_FORMAT_HITS |
int32 |
HTTP Disk Cache Unsupported Format Hits |
☑ |
HTTP disk cache number of unsupported format hits. |
HTTP_DISK_CACHE_WRITE_BYTES |
int64 |
HTTP Disk Cache Write (byte) |
☑ |
Number of HTTP disk cache disk cache write bytes. |
HTTP_DISK_CACHE_WRITE_COMPRESS_OPERATIONS |
int64 |
HTTP Disk Cache Write Compress Operations |
☑ |
Number of HTTP disk cache write compress operations. |
HTTP_DISK_CACHE_WRITE_COMPRESSED_BYTES |
int64 |
HTTP Disk Cache Write Compressed (byte) |
☑ |
Number of HTTP disk cache write compressed bytes. |
HTTP_DISK_CACHE_WRITE_ENCRYPT_DURATION_MS |
int64 |
HTTP Disk Cache Write Encrypt Duration (ms) |
☑ |
Number of HTTP disk cache write encrypt duration (ms). |
HTTP_DISK_CACHE_WRITE_ENCRYPT_OPERATIONS |
int64 |
HTTP Disk Cache Write Encrypt Operations |
☑ |
Number of HTTP disk cache write encrypt operations. |
HTTP_DISK_CACHE_WRITE_ENCRYPTED_BYTES |
int64 |
HTTP Disk Cache Write Encrypted (byte) |
☑ |
Number of HTTP disk cache write encrypted bytes. |
HTTP_DISK_CACHE_WRITE_OPERATIONS |
int64 |
HTTP Disk Cache Write Operations |
☑ |
Number of HTTP disk cache write operations. |
HTTP_MEMORY_CACHE_COUNT |
int32 |
HTTP Memory Cache Count |
☑ |
Number of entries in memory cache. |
HTTP_MEMORY_CACHE_HITS |
int32 |
HTTP Memory Cache Hits |
☑ |
Number of memory cache hits. |
HTTP_MEMORY_CACHE_INCORRECT_CONTENT_HITS |
int32 |
HTTP Memory Cache Incorrect Content Hits |
☑ |
Number of memory cache incorrect content hits. |
HTTP_MEMORY_CACHE_MISSES_FETCH_TIME_MS_MAX |
double |
HTTP Memory Cache Misses Fetch Time Maximum (ms) |
☑ |
Maximum original HTTP memory cache fetch time (ms). |
HTTP_MEMORY_CACHE_MISSES_FETCH_TIME_MS_MIN |
double |
HTTP Memory Cache Misses Fetch Time Minimum (ms) |
☑ |
Minimum original HTTP memory cache fetch time (ms). |
HTTP_MEMORY_CACHE_MISSES_FETCH_TIME_MS_TOTAL |
double |
HTTP Memory Cache Misses Fetch Time Total (ms) |
☑ |
Total original HTTP memory cache fetch time (ms). |
HTTP_MEMORY_CACHE_MISSES |
int32 |
HTTP Memory Cache Misses |
☑ |
Number of memory cache misses. |
HTTP_MEMORY_CACHE_SIZE |
int64 |
HTTP Memory Cache Cache Size |
☑ |
Estimated size of character of the memory cache. |
HTTP_MEMORY_CACHE_UNSUPPORTED_FORMAT_HITS |
int32 |
HTTP Memory Cache Unsupported Format Hits |
☑ |
Number of memory cache unsupported format hits. |
HTTP_REQUESTS_EXECUTED |
int32 |
HTTP Requests Executed |
☑ |
Number of HTTP requests made. |
ICON_RESOURCE_NAME_16 |
string(240) |
Icon Resource Name (16x16) |
☐ |
Name of file with 16x16 icon. |
INFLUENCES_MAXIMUM_NUMBER_JOINS |
boolean |
Influences Maximum Number of Joins |
☑ |
Influences maximum number of joins? |
IS_CATALOG_USED_IN_FULL_QUALIFIED_NAME |
boolean |
Is Catalog Used in Full Qualified Name |
☑ |
Whether the catalog name is used in constructing the full qualified name. |
IS_DEFAULT_FLAG |
boolean |
Is Default? |
☑ |
Is the default provider? |
IS_SCHEMA_USED_IN_FULL_QUALIFIED_NAME |
boolean |
Is Schema Used in Full Qualified Name |
☑ |
Whether the schema name is used in constructing the full qualified name. |
IS_SERVICE_PROVIDER_FLAG |
boolean |
Is Service Provider? |
☑ |
Is the provider a service provider? |
MAIN_CATEGORY |
string(240) |
Main Category |
☑ |
Main category. |
MAXIMUM_NUMBER_PARALLEL_REQUESTS |
int32 |
Maximum Number of Parallel Requests |
|
Maximum number of parallel requests. |
MAXIMUM_NUMBER_USABLE_PARTITIONS |
int32 |
Maximum Number of Usable Partitions |
|
Maximum number of usable partitions. |
NAME |
string(240) |
Provider Name |
☑ |
Name of the provider. |
PARTITION_CODE_COLUMN_NAME |
string(240) |
Partition Code Column Name |
☐ |
Name of the partition code column. |
PARTITION_LABEL_SINGULAR |
string(240) |
Partition Label Singular |
☐ |
Partition label in singular form. |
PRODUCTION_USE_ALLOWED |
boolean |
Production Use Allowed |
☑ |
Is production use allowed? |
PROVIDER_INSTANCE_UID |
guid |
Provider Instance UID |
☑ |
Unique ID of the provider instance. |
PUBLIC_DATA |
boolean |
Is Public Data? |
☑ |
Is the data offered publicly? |
SESSION_IO_BYTES_RECEIVED_OTHER |
int64 |
I/O Execution Bytes Received Other |
☑ |
Number of bytes sent (other). |
SESSION_IO_BYTES_RECEIVED_OVERALL |
int64 |
I/O Execution Bytes Received |
☑ |
Number of bytes sent overall. |
SESSION_IO_BYTES_RECEIVED_READ |
int64 |
I/O Execution Bytes Received Read |
☑ |
Number of bytes sent for read. |
SESSION_IO_BYTES_RECEIVED_WRITE |
int64 |
I/O Execution Bytes Received Write |
☑ |
Number of bytes sent for write. |
SESSION_IO_BYTES_SENT_OTHER |
int64 |
I/O Execution Bytes Sent Other |
☑ |
Number of bytes received (other). |
SESSION_IO_BYTES_SENT_OVERALL |
int64 |
I/O Execution Bytes Sent |
☑ |
Number of bytes received overall. |
SESSION_IO_BYTES_SENT_READ |
int64 |
I/O Execution Bytes Sent Read |
☑ |
Number of bytes received for read. |
SESSION_IO_BYTES_SENT_WRITE |
int64 |
I/O Execution Bytes Sent Write |
☑ |
Number of bytes received for write. |
SESSION_IO_DURATION_MS_OTHER |
int64 |
I/O Execution Duration Other (ms) |
☑ |
Total duration for other in milliseconds. |
SESSION_IO_DURATION_MS_OVERALL |
int64 |
I/O Execution Duration (ms) |
☑ |
Total duration overall in milliseconds. |
SESSION_IO_DURATION_MS_READ |
int64 |
I/O Execution Duration Read (ms) |
☑ |
Total duration for read in milliseconds. |
SESSION_IO_DURATION_MS_WRITE |
int64 |
I/O Execution Duration Write (ms) |
☑ |
Total duration for write in milliseconds. |
SESSION_IO_EXECUTION_COUNT_OTHER |
int64 |
I/O Execution Count Other |
☑ |
Number of I/Os executed (other). |
SESSION_IO_EXECUTION_COUNT_OVERALL |
int64 |
I/O Execution Count |
☑ |
Number of I/Os executed overall. |
SESSION_IO_EXECUTION_COUNT_READ |
int64 |
I/O Execution Count Read |
☑ |
Number of I/Os executed for read. |
SESSION_IO_EXECUTION_COUNT_WRITE |
int64 |
I/O Execution Count Write |
☑ |
Number of I/Os executed for write. |
SHORT_NAME |
string(240) |
Provider Short Name |
☑ |
Provider short name. |
SLOTBASED_RATE_LIMIT_LENGTH_MS |
int64 |
Slot-based Rate Limit Length (ms) |
☑ |
Length in ms of a slot-based rate limit. |
SLOTBASED_RATE_LIMIT_SLOTS |
int32 |
Slot-based Rate Limit Slots |
☐ |
Number of slots of a slot-based rate limit, null means no limit. |
SQL_PREFIX_PARAMETER |
string(30) |
SQL Prefix Parameter |
☐ |
SQL parameter prefix. |
STRING_COMPARISON_IS_CASE_SENSITIVE |
boolean |
String Comparison is Case-Sensitive |
☑ |
Whether the provider matches string case-sensitive. |
SUPPORTS_COLUMN_FILTERING |
boolean |
Supports Column Filtering |
☑ |
Whether column filtering is supported; if true, the provider can filter the resulting columns itself based on a select statement. |
SUPPORTS_NATIVE_SCALAR_REQUESTS |
boolean |
Supports Native Scalar Requests |
☑ |
Whether the platform supports native scalar requests. |
SUPPORTS_NATIVE_SQL |
boolean |
Supports Native SQL |
☑ |
Whether the platform supports native SQL. |
SUPPORTS_ORDERING |
boolean |
Supports Ordering |
☑ |
Whether the provider supports ordering. |
SUPPORTS_SIMPLE_FILTER_DELETE |
boolean |
Supports Simple Filter Delete |
☑ |
Whether the provider supports delete using simple filters. |
SUPPORTS_SIMPLE_FILTER_UPDATE |
boolean |
Supports Simple Filter Update |
☑ |
Whether the provider supports update using simple filters. |
TECHNICAL_DOCUMENTATION_URL |
string(4000) |
Technical Documentation (URL) |
☐ |
Technical documentation URL. |
TRY_ORDER |
int32 |
Try Order |
☑ |
Ascending order in which providers are tried. |
28-07-2024 17:46 Version 24.1.6-BETA+4856