This section summarizes the new features of TimesTen In-Memory Database Release 18.1 that are documented in this guide and provides links to more information.
In TimesTen Classic, if you are using a read-only cache group and have created a second TimesTen instance, then the client can fail over to this TimesTen instance. The cached data can be reloaded directly from the Oracle database. See "TTC_Server or TTC_Server1", "TTC_Server2, TTC_ServerN", "TTC_Server_DSN", "TTC_Server_DSN2, TTC_Server_DSNn", "TCP_Port", and "TCP_Port2, TCP_PortN" for more details.
If any request to create a channel between elements hangs due to software issues or network failures, then all channel create requests could be blocked. You can set a timeout for how long to wait for a channel create request to a remote element. See "ChannelCreateTimeout" for more information.
To increase the performance of database import operations, the ttGridAdmin dbImport
command now enables you to use multiple threads to import database objects with the use of the -numThreads
option.
You can enable Transport Layer Security (TLS) to provide encrypted network communication for all replication agent communication and all client/server communication. "CipherSuites," "Encryption," "SSLClientAuthentication," "Wallet," "SSLRenegotiationPeriod," and "SSLRenegotiationSize."
This release of TimesTen Scaleout has a new type of backup: staged backups. This type of backup eliminates the overhead of creating local copies of the checkpoint and log files and reduces the network traffic of creating a remote copy in the repository. Staged backups are ideal for when you want to make regular backups on a second site that is independent to your main site. See "BackupFailThreshold" for more information.
You can now set a time interval for calculating the fragmentation percentage of the change log tables on the Oracle database. Use the ttCacheConfig
built-in procedure providing the AutorefreshLogMonitorInterval
as the value parameter.
The following features are documented for the new "forced disconnect" feature, which forces all user connections to the specified database to be disconnected. This is useful, for example, prior to maintenance operations. Closing connections is mandatory to ensure a smooth shutdown and no data loss.
ForceDisconnectEnabled
connection attribute (TimesTen Classic). See "ForceDisconnectEnabled" for details.
ttAdmin -disconnect
option (TimesTen Classic). See "Force disconnect" for details.
ttGridAdmin dbDisconnect
and dbDisconnectStatus
commands (TimesTen Scaleout). See "Force all connections to disconnect (dbDisconnect)" for details.
These additional new features are documented:
ttGridAdmin dbDistribute -resync
option attempts to resynchronize metadata in the user database with metadata in the active management instance in case the state of a dbDistribute -apply
command is unknown. "Set or modify the distribution scheme of a database (dbDistribute)" for details.
PLSQL_SESSION_CACHED_CURSORS
connection attribute specifies the number of session cursors to cache. A user may adjust the setting to free up space not currently needed in the cache. See "PLSQL_SESSION_CACHED_CURSORS" for details.
ttDBConfig
built-in procedure supports a new parameter, PLSQL_OPEN_CURSORS
, which specifies the maximum number of PL/SQL cursors that can be open in a session at one time. See "ttDBConfig" for details.
ttCkptHistory
built-in procedure returns new columns: reason
, logsPurged
, bookmarkName
, and additional_details
. See "ttCkptHistory" for details.
ttInstallDSN
utility, for TimesTen Scaleout, generates a Windows client DSN for each of one or more entries in the provided input file and installs them into the ODBC control panel as system DSNs. See "ttInstallDSN" for details.
This release of TimesTen contains a configuration file associated with each instance. See Chapter 1, "TimesTen Instance Configuration File" for details about this file.
The book contains descriptions of new and changed utilities:
ttGridAdmin
utility
ttGridRollout
utility
ttInstallationCheck
utility
ttInstallDSN
utility
ttInstanceCreate
utility
ttInstanceDelete
utility
ttInstanceModify
utility
Changes to ttXactAdmin
utility
Changes to ttBulkCp
utility
Changes to ttStats
utility
The book contains descriptions of new attributes:
TTC_TCP_KEEPALIVE_TIME_MS
, TTC_TCP_KEEPALIVE_INTVL_MS
, TTC_TCP_KEEPALIVE_PROBES
, TTC_Random_Selection
, TTC_REDIRECT
, TTC_Redirect_Limit
and TTC_RollbackRequiredOnFailover
connection attributes
Durability
connection attribute
EpochInterval
and CreateEpochAtCommit
connection attributes
IncludeInCore
connection attribute
OptimizerHint
connection attribute
Changes to ttStats
utility
The book contains descriptions of new built-in procedures:
ttCacheADGStandbyStateGet
ttCacheADGStandbyStateSet
ttCacheADGStandyTimeoutGet
ttCacheADGStandbyTimeoutSet
ttEpochCreate
ttEpochSessionGet
ttHeapinfo
ttLatchStatsGet