Table of Contents

• Title and Copyright Information
• About This Content
• What's New
  • New features in release 22.1.1.17.0
  • New features in release 22.1.1.9.0
  • New features in release 22.1.1.7.0
  • New Features in Release 22.1.1.3.0
  • New Features in Release 22.1.1.1.0
• 1 TimesTen Instance Configuration File
• 2 Connection Attributes
  • List of Connection Attributes
  • General Use Connection Attributes
    • Data Store Attributes
      • Data Source Name
      • DataStore
      • DatabaseCharacterSet
      • Description
      • Driver
      • Durability
      • GridLogRecoveryThreshold
      • LogDir
      • Preallocate
      • ReplicationApplyOrdering
      • ReplicationParallelism
    • First Connection Attributes
      • AutoCreate
      • BackupFailThreshold
      • CkptFrequency
      • CkptLogVolume
      • CkptRate
      • CkptReadThreads
      • Connections
      • EpochInterval
      • ForceConnect
      • ForceDisconnectEnabled
      • LogAutoTruncate
      • LogBufMB
      • LogBufParallelism
      • LogFileSize
      • LogFlushMethod
      • LogPurge
      • MemoryLock
      • Overwrite
      • PermSize
      • RecoveryThreads
      • TempSize
    • General Connection Attributes
      • ChannelCreateTimeout
      • CommitBufferSizeMax
      • ConnectionName
      • CreateEpochAtCommit
      • DDLReplicationAction
      • DDLReplicationLevel
      • Diagnostics
      • DurableCommits
      • IncludeInCore
      • Isolation
      • LockLevel
      • LockWait
      • OptimizerHint
      • PermWarnThreshold
      • PrivateCommands
      • PWDCrypt
      • PwdWallet
      • QueryThreshold
      • ReplicationTrack
      • SQLQueryTimeout
      • SQLQueryTimeoutMSec
      • TempWarnThreshold
      • TransactionTimeout
      • UID and PWD
      • WaitForConnect
  • Globalization Connection Attributes
    • NLS General Connection Attributes
      • ConnectionCharacterSet
      • NLS_LENGTH_SEMANTICS
      • NLS_NCHAR_CONV_EXCP
      • NLS_SORT
  • PL/SQL Connection Attributes
    • PL/SQL First Connection Attributes
      • PLSQL_MEMORY_ADDRESS
      • PLSQL_MEMORY_SIZE
      • PLSQL_OPEN_CURSORS
    • PL/SQL General Connection Attributes
      • PLSQL_CCFLAGS
      • PLSQL_CONN_MEM_LIMIT
      • PLSQL_OPTIMIZE_LEVEL
      • PLSQL_SESSION_CACHED_CURSORS
      • PLSQL_TIMEOUT
  • Cache Connection Attributes
    • Cache First Connection Attributes
      • CacheAdminWallet
      • CacheAWTMethod
    • Cache Database Attributes
      • CacheAWTParallelism
      • UseCacheConnPool
    • Cache General Connection Attributes
      • DynamicLoadEnable
      • DynamicLoadErrorMode
      • OracleNetServiceName
      • OraclePWD
      • PassThrough
      • RACCallback
      • StandbyNetServiceName
  • Client and Server Connection Attributes
    • Client General Connection Attributes
      • CipherSuites
      • ChildServer
      • Encryption
      • SSLClientAuthentication
      • TCP_Port
      • TCP_Port2, TCP_PortN
      • TTC_ConnectTimeout
      • TTC_FailoverPortRange
      • TTC_NetMsgMaxBytes
      • TTC_NetMsgMaxRows
      • TTC_NoReconnectOnFailover
      • TTC_Random_Selection
      • TTC_REDIRECT
      • TTC_Redirect_Limit
      • TTC_Server or TTC_Server1
      • TTC_Server2, TTC_ServerN
      • TTC_Server_DSN
      • TTC_Server_DSN2, TTC_Server_DSNn
      • TTC_SqlTimeoutMS
      • TTC_TCP_KEEPALIVE_INTVL_MS
      • TTC_TCP_KEEPALIVE_PROBES
      • TTC_TCP_KEEPALIVE_TIME_MS
      • TTC_Timeout
      • Wallet
    • Server First Connection Attributes
      • CipherSuites
      • Encryption
      • SSLClientAuthentication
      • MaxConnsPerServer
      • ServersPerDSN
      • ServerStackSize
      • SSLRenegotiationPeriod
      • SSLRenegotiationSize
      • Wallet
• 3 Built-In Procedures
  • List of Built-In Procedures
  • ttAgingLRUConfig
  • ttAgingTableLRUConfig
  • ttAgingScheduleNow
  • ttApplicationContext
  • ttBackupStatus
  • ttBlockInfo
  • ttBookmark
  • ttCacheADGStandbyStateGet
  • ttCacheADGStandbyStateSet
  • ttCacheADGStandbyTimeoutGet
  • ttCacheADGStandbyTimeoutSet
  • ttCacheAllowFlushAwtSet
  • ttCacheAutorefIntervalStatsGet
  • ttCacheAutorefresh
  • ttCacheAutorefreshLogDefrag
  • ttCacheAutorefreshStatsGet
  • ttCacheAutorefreshSelectLimit
  • ttCacheAutorefreshXactLimit
  • ttCacheAWTMonitorConfig
  • ttCacheAWTThresholdGet
  • ttCacheAWTThresholdSet
  • ttCacheCheck
  • ttCacheConfig
  • ttCacheConnPoolApply
  • ttCacheConnPoolGet
  • ttCacheConnPoolSet
  • ttCacheDbCgStatus
  • ttCacheDDLTrackingConfig
  • ttCachePolicyGet
  • ttCachePolicySet
  • ttCachePropagateFlagSet
  • ttCacheSqlGet
  • ttCacheStart
  • ttCacheStop
  • ttCacheUidGet
  • ttCacheUidPwdSet
  • ttCkpt
  • ttCkptBlocking
  • ttCkptConfig
  • ttCkptHistory
  • ttCommitBufferStats
  • ttCommitBufferStatsReset
  • ttCompact
  • ttComputeTabSizes
  • ttConfiguration
  • ttContext
  • ttDataStoreStatus
  • ttDBCompactConfig
  • ttDBConfig
  • ttDBWriteConcurrencyModeGet
  • ttDBWriteConcurrencyModeSet
  • ttDistributionProgress
  • ttDurableCommit
  • ttEpochCreate
  • ttEpochSessionGet
  • ttHeapInfo
  • ttHostNameGet
  • ttHostNameSet
  • ttIndexAdviceCaptureDrop
  • ttIndexAdviceCaptureEnd
  • ttIndexAdviceCaptureInfoGet
  • ttIndexAdviceCaptureOutput
  • ttIndexAdviceCaptureStart
  • ttLatchStatsGet
  • ttLoadFromOracle
  • ttLockLevel
  • ttLockWait
  • ttLogHolds
  • ttMonitorHighWaterReset
  • ttOptClearStats
  • ttOptCmdCacheInvalidate
  • ttOptEstimateStats
  • ttOptGetColStats
  • ttOptGetFlag
  • ttOptGetMaxCmdFreeListCnt
  • ttOptGetOrder
  • ttOptSetColIntvlStats
  • ttOptSetColStats
  • ttOptSetFlag
  • ttOptSetMaxCmdFreeListCnt
  • ttOptSetMaxPriCmdFreeListCnt
  • ttOptSetOrder
  • ttOptSetTblStats
  • ttOptShowJoinOrder
  • ttOptStatsExport
  • ttOptUpdateStats
  • ttOptUseIndex
  • ttPageLevelTableInfo
  • ttPLSQLMemoryStats
  • ttRamPolicyAutoReloadGet
  • ttRamPolicyAutoReloadSet
  • ttRamPolicyGet
  • ttRamPolicySet
  • ttRedundantIndexCheck
  • ttRepDeactivate
  • ttReplicationStatus
  • ttRepPolicyGet
  • ttRepPolicySet
  • ttRepQueryThresholdGet
  • ttRepQueryThresholdSet
  • ttRepStart
  • ttRepStateGet
  • ttRepStateSave
  • ttRepStateSet
  • ttRepStop
  • ttRepSubscriberStateSet
  • ttRepSubscriberWait
  • ttRepSyncGet
  • ttRepSyncSet
  • ttRepSyncSubscriberStatus
  • ttRepTransmitGet
  • ttRepTransmitSet
  • ttRepXactStatus
  • ttRepXactTokenGet
  • ttSetUserColumnID
  • ttSetUserTableID
  • ttSize
  • ttSQLCmdCacheInfo
  • ttSQLCmdCacheInfoGet
  • ttSQLCmdQueryPlan
  • ttSQLExecutionTimeHistogram
  • ttStatsConfig
  • ttStatsConfigGet
  • ttTableSchemaFromOraQueryGet
  • ttVersion
  • ttWarnOnLowMemory
  • ttXactIdGet
  • ttXlaBookmarkCreate
  • ttXlaBookmarkDelete
  • ttXlaSubscribe
  • ttXlaUnsubscribe
• 4 TimesTen Scaleout Utilities
  • Overview
  • Utilities List
  • ttGridAdmin
    • Grid Model
    • Grid Objects and Object Naming
    • Address Formats
    • Database Management Operations
    • Command Timeouts and Waits
    • ttGridAdmin Operations
    • Help and General Options
    • Return Values
    • Backup and Restore Operations
      • Back Up a Database (dbBackup)
      • Delete a Database Backup (dbBackupDelete)
      • Display the Status of a Database Backup (dbBackupStatus)
      • Restore a Database (dbRestore)
      • Display the Status of a Database Restore (dbRestoreStatus)
    • Cache Operations
      • Set Credentials (dbCacheCredentialSet)
      • Start a Cache Agent (dbCacheStart)
      • Stop a Cache Agent (dbCacheStop)
    • Certificate Operations
      • Regenerate the Certificates (certificateRegen)
      • List the Certificates (certificateList)
    • Connectable Operations
      • Create a Connectable (connectableCreate)
      • Delete a Connectable (connectableDelete)
      • Export a Connectable (connectableExport)
      • List Connectables (connectableList)
      • Modify a Connectable (connectableModify)
    • Database Definition Operations
      • Create a Database Definition (dbdefCreate)
      • Delete a Database Definition (dbdefDelete)
      • Export a Database Definition (dbdefExport)
      • List Database Definitions (dbdefList)
      • Modify a Database Definition (dbdefModify)
    • Database Operations
      • Close a Database (dbClose)
      • Create a Database (dbCreate)
      • Destroy a Database (dbDestroy)
      • Force All Connections to Disconnect (dbDisconnect)
      • Check Status of Forced Disconnection (dbDisconnectStatus)
      • Set or Modify the Distribution Scheme of a Database (dbDistribute)
      • List Databases (dbList)
      • Load a Database into Memory (dbLoad)
      • Open a Database (dbOpen)
      • Monitor the Status of a Database (dbStatus)
      • Unload a Database (dbUnload)
    • Grid Operations
      • Export sys.odbc.ini for Client/Server Connections outside Grid (gridClientExport)
      • Export sys.odbc.ini and Certificates for Encrypted Client/Server Connections (gridClientExportAll)
      • Create a Grid (gridCreate)
      • Display Information about the Grid (gridDisplay)
      • Get Diagnostic Information about the Grid (gridDump)
      • Collect Log Information about the Grid (gridLogCollect)
      • Modify Grid Settings (gridModify)
      • Configure SSH (gridSshConfig)
      • Upgrade a Grid (gridUpgrade)
    • Host Operations
      • Create a Host (hostCreate)
      • Delete a Host (hostDelete)
      • Execute a Command or Script on Grid Hosts (hostExec)
      • List All Hosts in the Model (hostList)
      • Modify a Host (hostModify)
    • Import and Export Operations
      • Export a Database (dbExport)
      • Delete a Database Export (dbExportDelete)
      • Display the Status of a Database Export (dbExportStatus)
      • Import a Database (dbImport)
      • Display the Status of a Database Import (dbImportStatus)
    • Installation Operations
      • Create an Installation (installationCreate)
      • Delete an Installation (installationDelete)
      • Execute a Command or Script on Grid Installations (installationExec)
      • List Installations (installationList)
      • Display Status of Installations (installationStatus)
    • Instance Operations
      • Export Instance Configuration Attributes (instanceConfigExport)
      • Import Instance Configuration Attributes (instanceConfigImport)
      • Create an Instance (instanceCreate)
      • Delete an Instance (instanceDelete)
      • Execute a Command or Script on Grid Instances (instanceExec)
      • List Instances (instanceList)
      • Modify an Instance (instanceModify)
      • Display Status of Instances (instanceStatus)
    • Management Instance Operations
      • Start the Active Management Instance (mgmtActiveStart)
      • Stop the active management instance (mgmtActiveStop)
      • Switch the Active Management Instance (mgmtActiveSwitch)
      • Examine Management Instances (mgmtExamine)
      • Start the Standby Management Instance (mgmtStandbyStart)
      • Stop the Standby Management Instance (mgmtStandbyStop)
      • Display Status of Management Instances (mgmtStatus)
    • Membership Operations
      • Export the Membership Configuration File (membershipConfigExport)
      • Import the Membership Configuration File (membershipConfigImport)
    • Model Operations
      • Apply the Latest Version of the Model (modelApply)
      • Compare Models (modelCompare)
      • Export a Version of a Model (modelExport)
      • Import a Version of the Model (modelImport)
      • List Model Versions (modelList)
    • Oracle Database Operations
      • Export a sqlnet file (SQLNetExport)
      • Import a Sqlnet File (SQLNetImport)
      • Export TNS Names (TNSNamesExport)
      • Import TNS Names (TNSNamesImport)
    • Repository Operations
      • Attach a Repository (repositoryAttach)
      • Create a Repository (repositoryCreate)
      • Detach a Repository (repositoryDetach)
      • List Repositories (repositoryList)
  • ttGridRollout
• 5 Utilities
  • Overview
  • Utilities List
  • ttAdmin
    • Help, Version, and Query Options
    • Perform RAM Operations
    • Open or Close a Database
    • Transport Layer Security
    • Force Disconnect
    • Set Cache Policies
    • Set Replication Policies
  • ttAdoptStores
  • ttBackup
  • ttBulkCp
  • ttCapture
  • ttCheck
  • ttClientImport
  • ttCreateCerts
  • ttCacheInfo
  • ttCWAdmin
  • ttDaemonAdmin
  • ttDaemonLog
  • ttDestroy
  • ttExporter
  • ttInstallationCheck
  • ttInstallDSN
  • ttInstanceCreate
  • ttInstanceDestroy
  • ttInstanceModify
  • ttIsql
    • Commands
    • Syntax for the IF-THEN-ELSE Command Construct
    • Syntax for the WHENEVER SQLERROR Command
    • Set/Show Attributes
    • Comment Syntax
    • Command Shortcuts
    • Parameters
    • Examples
  • ttMigrate
  • ttRepAdmin
    • Help and Version Information
    • Database Information
    • Subscriber Database Operations
    • Duplicate a Database
    • Wait for Updates to Complete
    • Replication Status
  • ttRestore
  • ttSchema
  • ttShmSize
  • ttSize
  • ttStats
    • ttStats in TimesTen Classic
    • ttStats in TimesTen Scaleout
  • ttStatus
  • ttTail
  • ttTraceMon
  • ttUser
  • ttVersion
  • ttXactAdmin
  • ttXactLog
• 6 System Limits
  • System Limits and Defaults
  • Limits on Number of Open Files
  • Path Names