Data Cache Attributes
Other
analysis-enforce-row-uniqueness
Enforce rows to be unique for software analysis. A fingerprint is calculated from the whole row of data when the primary key column is unknown.
- Default:
False - Set from: connection string, set statement, provider file
- Defined by: Shared
application-prefix-facts
A prefix applied after the environment prefix to every facts table, index and view.
- Default:
dcd_ - Set from: connection string
- Defined by: Data Cache
application-prefix-history
A prefix applied after the environment prefix to every history table, index and view.
- Default:
dcs_ - Set from: connection string
- Defined by: Data Cache
application-prefix-repository
A prefix applied after the environment prefix to every repository table, index and view.
- Default:
dc_ - Set from: connection string
- Defined by: Data Cache
backing-bulk-insert-page-size-bytes
Approximate maximum size in bytes of page when bulk inserting on backing database.
- Set from: connection string, set statement, provider file
- Defined by: Data Cache
backing-bulk-insert-page-size-rows
Number of rows to insert per page when bulk inserting on backing database.
- Set from: connection string, set statement, provider file
- Defined by: Data Cache
backing-bulk-insert-timeout-sec
Number of seconds after which a bulk insert on backing database times out.
- Default:
3600 - Set from: connection string, set statement, provider file
- Defined by: Data Cache
backing-command-timeout-sec
Number of seconds after which a command on backing database times out.
- Default:
3600 - Set from: connection string, set statement, provider file
- Defined by: Data Cache
backing-connection-string
The connection string for the backing database.
- Set from: connection string, provider file
- Defined by: Data Cache
backing-force-case-sensitive-identifiers
Consider identifiers on the backing database as case-sensitive independent of the platform capabilities.
- Default:
False - Set from: connection string, set statement, provider file
- Defined by: Data Cache
backing-forced-casing-identifiers
Forced casing of identifiers on the backing database. Choose from Unset, Lower, Upper and Mixed.
- Default:
Unset - Set from: connection string, set statement, provider file
- Defined by: Data Cache
backing-maximum-length-identifiers
Non-default maximum length on the backing database in characters of identifier names.
- Set from: connection string, set statement, provider file
- Defined by: Data Cache
backing-maximum-number-of-pooled-connections
Maximum number of concurrent pooled connections on backing database.
- Set from: connection string, set statement, provider file
- Defined by: Data Cache
backing-maximum-sleep-acquire-pooled-connection-ms
Maximum time in ms to wait for acquiring a free connection from a pool of connections on backing database.
- Default:
300000 - Set from: connection string, set statement, provider file
- Defined by: Data Cache
backing-maximum-sleep-acquire-unpooled-connection-ms
Maximum time in ms to wait for acquire a free connection when there is no connection pooling on backing database.
- Default:
600000 - Set from: connection string, set statement, provider file
- Defined by: Data Cache
backing-minimum-connection-timeout-sec
Minimum number of seconds after which a newly requested connection on backing database times out.
- Default:
300 - Set from: connection string, set statement, provider file
- Defined by: Data Cache
backing-preferred-number-of-pooled-connections
Preferred number of concurrent pooled connections on backing database.
- Set from: connection string, set statement, provider file
- Defined by: Data Cache
backing-provider
Name of the Invantive connector for the backing database.
- Set from: connection string, provider file
- Defined by: Data Cache
backing-sql-server-connect-retry-count
Number of connect retries on connection failed on the backing SQL Server database (SQL Server only).
- Default:
60 - Set from: connection string, set statement, provider file
- Defined by: Data Cache
backing-sql-server-connect-retry-interval-sec
Interval between connect retries on connection failed on the backing SQL Server database (SQL Server only).
- Default:
15 - Set from: connection string, set statement, provider file
- Defined by: Data Cache
backing-standardize-identifiers
Rewrite all identifiers on the backing database to the preferred standards as configured by standardize-identifiers-casing and maximum-length-identifiers.
- Default:
True - Set from: connection string, set statement, provider file
- Defined by: Data Cache
backing-standardize-identifiers-casing
Rewrite all identifiers on the backing database to the platform-specific recommended standard casing when changing a data model on a case-dependent platform.
- Default:
True - Set from: connection string, set statement, provider file
- Defined by: Data Cache
beta-compress-facts-on-disk
Whether to compress facts in the disk cache.
- Default:
True - Set from: connection string, set statement, provider file
- Defined by: Data Cache
beta-encrypt-facts-on-disk
Whether to encrypt facts in the disk cache.
- Default:
True - Set from: connection string, set statement, provider file
- Defined by: Data Cache
beta-store-facts-in-database
Whether to store facts in the database containing the repository.
- Default:
True - Set from: connection string, set statement, provider file
- Defined by: Data Cache
beta-store-facts-on-disk
Whether to store facts on the disk cache.
- Default:
False - Set from: connection string, set statement, provider file
- Defined by: Data Cache
beta-use-facts-in-database
Whether to use facts in the database cache.
- Default:
True - Set from: connection string, set statement, provider file
- Defined by: Data Cache
beta-use-facts-on-disk
Whether to use facts in the disk cache.
- Default:
False - Set from: connection string, set statement, provider file
- Defined by: Data Cache
bulk-delete-page-size-rows
Number of rows to delete per batch when bulk deleting.
- Default:
10000 - Set from: connection string, set statement, provider file
- Defined by: Shared
bulk-insert-page-size-bytes
Approximate maximum size in bytes of batch when bulk inserting.
- Default:
10000000 - Set from: connection string, set statement, provider file
- Defined by: Shared
bulk-insert-page-size-rows
Number of rows to insert per batch when bulk inserting.
- Default:
10000 - Set from: connection string, set statement, provider file
- Defined by: Shared
cache-folder
Folder to store Data Cache cache files in.
- Default:
C:\Users\gle3.WS212\Invantive\Cache\datacache - Set from: connection string, set statement, provider file
- Defined by: Data Cache
default-skip-client-side-cacheable
Whether to skip client-side cacheable tables by default.
- Default:
True - Set from: connection string, set statement, provider file
- Defined by: Data Cache
default-use-ods
Whether to use the Operational Data Store when no hint is specified.
- Default:
True - Set from: connection string, set statement, provider file
- Defined by: Data Cache
delete-number-table-partition-versions-per-group
Maximum number of table partition versions selected in the IN-clause for a delete of facts.
- Default:
50 - Set from: connection string, set statement, provider file
- Defined by: Data Cache
development-use-http-disk-cache
Whether to allow use of the disk cache for platform HTTP requests.
- Default:
False - Set from: connection string, set statement
- Defined by: Data Cache
drop-backlog-factor
Maximum ratio between number of versions dropped and new versions loaded on refresh.
- Set from: connection string, set statement, provider file
- Defined by: Data Cache
environment-prefix-all
A prefix applied to repository, facts and history database tables, indexes and views.
- Set from: connection string
- Defined by: Data Cache
environment-prefix-facts
A prefix applied to every facts table, index and view.
- Set from: connection string
- Defined by: Data Cache
environment-prefix-history
A prefix applied to every history table, index and view.
- Set from: connection string
- Defined by: Data Cache
environment-prefix-logical-view
A prefix applied to every logical view.
- Set from: connection string
- Defined by: Data Cache
environment-prefix-repository
A prefix applied to every repository table, index and view.
- Set from: connection string
- Defined by: Data Cache
event-log-entries-delete-page-size-rows
Number of rows to delete per batch on maintaining event log entries.
- Default:
1000 - Set from: connection string, set statement, provider file
- Defined by: Data Cache
event-log-memory-cache-flush-interval-sec
Maximum interval in seconds between flushes of in-memory cache of event log entries to database.
- Default:
15 - Set from: connection string
- Defined by: Data Cache
event-log-memory-cache-size
Size of in-memory cache of event log entries before they are written to the database.
- Default:
100 - Set from: connection string
- Defined by: Data Cache
facts-delete-page-size-characters
Number of characters to delete per batch on maintaining orphaned facts.
- Default:
10000000 - Set from: connection string, set statement, provider file
- Defined by: Data Cache
facts-delete-page-size-rows
Number of rows to delete per batch on purging orphaned facts during repository upgrade or maintenance.
- Set from: connection string, set statement, provider file
- Defined by: Data Cache
facts-insert-page-size-rows
Number of rows to insert per batch on maintaining facts.
- Set from: connection string, set statement, provider file
- Defined by: Data Cache
force-case-sensitive-identifiers
Consider identifiers as case-sensitive independent of the platform capabilities.
- Default:
False - Set from: connection string, set statement, provider file
- Defined by: Shared
forced-casing-identifiers
Forced casing of identifiers. Choose from: Unset, Lower, Upper and Mixed.
- Set from: connection string, set statement, provider file
- Defined by: Shared
forced-casing-logical-view-column-name
Forced casing of logical view column names. Choose from Unset, Lower, Upper and Mixed.
- Default:
Unset - Set from: connection string, set statement, provider file
- Defined by: Data Cache
forced-casing-logical-view-name
Forced casing of logical view names. Choose from Unset, Lower, Upper and Mixed.
- Default:
Unset - Set from: connection string, set statement, provider file
- Defined by: Data Cache
forwarded-incoming-messages-delete-max-runtime-sec
Maximum runtime of purge forwarded incoming messages in seconds.
- Default:
3600 - Set from: connection string, set statement, provider file
- Defined by: Data Cache
forwarded-incoming-messages-delete-page-size-rows
Number of rows to delete per batch on maintaining forwarded incoming messages.
- Default:
10000 - Set from: connection string, set statement, provider file
- Defined by: Data Cache
garbage-collection-physical-memory-load-threshold
Percentage of physical memory load above which a full garbage collection is run after replication.
- Default:
80 - Set from: connection string, set statement, provider file
- Defined by: Data Cache
garbage-collection-replication-interval-count
itgen_pae_garbage_collection_replication_minimum_interval_count_desc
- Default:
100 - Set from: connection string, set statement, provider file
- Defined by: Data Cache
garbage-collection-replication-minimum-interval-sec
- Default:
30 - Set from: connection string, set statement, provider file
- Defined by: Data Cache
invantive-sql-compress-sparse-arrays
Whether to compress sparse arrays in result sets during compression.
- Default:
True - Set from: connection string, set statement, provider file
- Defined by: SQL Engine V1
invantive-sql-correct-invalid-date
Whether to correct dates considered invalid since they are before 01-01-1753. When nullable, they are removed. Otherwise they are replaced by 01-01-1753.
- Default:
False - Set from: connection string, set statement, provider file
- Defined by: SQL Engine V1
invantive-sql-forward-filters-to-data-containers
Whether to forward filters to data containers.
- Default:
True - Set from: connection string, set statement, provider file
- Defined by: SQL Engine V1
invantive-sql-share-byte-arrays
Whether to share the memory used by identical byte arrays in result sets during compression.
- Default:
True - Set from: connection string, set statement, provider file
- Defined by: SQL Engine V1
invantive-sql-share-strings
Whether to share the memory used by identical strings in result sets during compression.
- Default:
True - Set from: connection string, set statement, provider file
- Defined by: SQL Engine V1
invantive-sql-shuffle-fetch-results-data-containers
Whether to shuffle results fetched from data containers.
- Default:
False - Set from: connection string, set statement, provider file
- Defined by: SQL Engine V1
invantive-use-cache
Whether to cache the results of a query.
- Default:
True - Set from: connection string, set statement, provider file
- Defined by: SQL Engine V1
log-native-calls-to-disk-max-events
Maximum number of call events to register from last activation.
- Set from: connection string, set statement, provider file
- Defined by: Shared
log-native-calls-to-disk-max-seconds
Maximum number of seconds to register calls from last activation.
- Set from: connection string, set statement, provider file
- Defined by: Shared
log-native-calls-to-disk-on-error
Registers native calls to data container backend as disk files when the call raised an error.
- Default:
False - Set from: connection string, set statement, provider file
- Defined by: Shared
log-native-calls-to-disk-on-success
Registers native calls to data container backend as disk files when the call raised no error.
- Default:
False - Set from: connection string, set statement, provider file
- Defined by: Shared
log-native-calls-to-trace
Log native calls to data container backend on the trace.
- Default:
False - Set from: connection string, set statement, provider file
- Defined by: Shared
max-delete-facts-parallel
Maximum number of parallel deletes on facts tables.
- Default:
8 - Set from: connection string, set statement, provider file
- Defined by: Data Cache
max-messages-per-customer-service-request
Maximum number of messages to download from Customer Service per request.
- Default:
10000 - Set from: connection string, set statement, provider file
- Defined by: Data Cache
max-percentage-trickle-loading
Maximum percentage of incoming messages versus known rows to use trickle loading with. When exceeded, reverts to copy approach.
- Default:
2,5 - Set from: connection string, set statement, provider file
- Defined by: Data Cache
max-refreshes-parallel
Maximum number of parallel refreshes.
- Default:
32 - Set from: connection string, set statement, provider file
- Defined by: Data Cache
max-url-length-accepted
The maximum accepted URL length before raising an error.
- Default:
8000 - Set from: connection string, set statement, provider file
- Defined by: Shared
max-url-length-desired
The maximum desired URL length.
- Default:
8000 - Set from: connection string, set statement, provider file
- Defined by: Shared
maximum-length-identifiers
Non-default maximum length in characters of identifier names.
- Set from: connection string, set statement, provider file
- Defined by: Shared
maximum-length-logical-view-column-name
Maximum length of logical view column names.
- Set from: connection string, set statement, provider file
- Defined by: Data Cache
maximum-length-logical-view-name
Maximum length of logical view names.
- Set from: connection string, set statement, provider file
- Defined by: Data Cache
orphaned-facts-delete-page-size-rows
Number of rows to delete per batch on maintaining orphaned facts.
- Default:
10000 - Set from: connection string, set statement, provider file
- Defined by: Data Cache
partition-slot-based-rate-limit-length-ms
Total length in milliseconds across all slots of a partition-based rate limit.
- Default:
60000 - Set from: connection string, provider file
- Defined by: Shared
partition-slot-based-rate-limit-slots
Number of slots per partition-based rate limit. Null means no slot-based rate limit.
- Set from: connection string, provider file
- Defined by: Shared
pre-request-delay-ms
Pre-request delay in milliseconds per request.
- Default:
0 - Set from: connection string, set statement, provider file
- Defined by: Shared
purge-interval-event-log-entries-minutes
Interval in minutes between completed purges of ancient event log entries.
- Default:
60 - Set from: connection string, set statement, provider file
- Defined by: Data Cache
requested-page-size
Preferred number of rows to exchange per round trip; only effective on limited platforms such as AFAS Online.
- Set from: connection string, set statement, provider file
- Defined by: Shared
requests-parallel-max
Maximum number of parallel data requests from individual partitions on the data container.
- Default:
32 - Set from: connection string, set statement, provider file
- Defined by: Shared
retention-event-log-entries-days
Retention of event log entries in days.
- Default:
35 - Set from: connection string, set statement, provider file
- Defined by: Data Cache
session-terminated-threshold-hours
Number of hours after start a session is considered terminated.
- Default:
168 - Set from: connection string, set statement, provider file
- Defined by: Data Cache
slot-based-rate-limit-length-ms
Total length in milliseconds across all slots of a slot-based rate limit.
- Default:
60000 - Set from: connection string, provider file
- Defined by: Shared
slot-based-rate-limit-slots
Number of slots of a slot-based rate limit. Null means no slot-based rate limit.
- Set from: connection string, provider file
- Defined by: Shared
standardize-identifiers
Rewrite all identifiers to the preferred standards as configured by standardize-identifiers-casing and maximum-length-identifiers.
- Default:
True - Set from: connection string, set statement, provider file
- Defined by: Shared
standardize-identifiers-casing
Rewrite all identifiers to the recommended standard platform-specific casing when changing a data model on a case-dependent platform.
- Default:
True - Set from: connection string, set statement, provider file
- Defined by: Shared
update-number-table-partition-versions-per-group
Maximum number of table partition versions selected in the IN-clause for an update of metadata.
- Default:
1000 - Set from: connection string, set statement, provider file
- Defined by: Data Cache
upgrade-force-execute
Whether to force execution of possible upgrade steps, even when there are no reasons to perform an upgrade.
- Default:
False - Set from: connection string
- Defined by: Data Cache
upgrade-force-repository-version-start
Specifies the repository version to start upgrade from when specified.
- Set from: connection string
- Defined by: Data Cache
upgrade-force-specials
Execute special operations before the repository is opened.
- Set from: connection string
- Defined by: Data Cache
Release Notes
What changed per release in the tables, columns, attributes and capabilities of the driver: