Contents

Title and Copyright Information

Preface

• Audience
• Related documents
• Conventions
• Documentation Accessibility
• Technical support

What's New

• New features for Release 11.2.1

1 Data Store Attributes

• Required privileges for attributes
• List of Attributes
• Data store attributes
  • Data Source Name
  • DataStore
  • DatabaseCharacterSet
  • Description
  • LogDir
  • Preallocate
  • Temporary
  • TypeMode
• First connection attributes
  • AutoCreate
  • CkptFrequency
  • CkptLogVolume
  • CkptRate
  • Connections
  • ForceConnect
  • LogAutoTruncate
  • LogBufMB
  • LogBufParallelism
  • LogFileSize
  • LogFlushMethod
  • Logging
  • LogPurge
  • MemoryLock
  • Overwrite
  • PermSize
  • ReceiverThreads
  • RecoveryThreads
  • TempSize
• General connection attributes
  • ConnectionName
  • DDLCommitBehavior
  • Diagnostics
  • DuplicateBindMode
  • DurableCommits
  • Isolation
  • LockLevel
  • LockWait
  • MatchLogOpts
  • PermWarnThreshold
  • PrivateCommands
  • PWDCrypt
  • QueryThreshold
  • SqlQueryTimeout
  • TempWarnThreshold
  • UID and PWD
  • WaitForConnect
• NLS general connection attributes
  • ConnectionCharacterSet
  • NLS_LENGTH_SEMANTICS
  • NLS_NCHAR_CONV_EXCP
  • NLS_SORT
• PL/SQL first connection attributes
  • PLSQL
  • PLSQL_MEMORY_ADDRESS
  • PLSQL_MEMORY_SIZE
• PL/SQL general connection attributes
  • PLSCOPE_SETTINGS
  • PLSQL_CCFLAGS
  • PLSQL_CONN_MEM_LIMIT
  • PLSQL_OPTIMIZE_LEVEL
  • PLSQL_TIMEOUT
• TimesTen Client connection attributes
  • TCP_Port
  • TCP_Port2
  • TTC_FailoverPortRange
  • TTC_Server
  • TTC_Server2
  • TTC_Server_DSN
  • TTC_Server_DSN2
  • TTC_Timeout
• Server connection attributes
  • MaxConnsPerServer
  • ServersPerDSN
  • ServerStackSize
• IMDB Cache connection attributes
  • CacheGridEnable
  • CacheGridMsgWait
  • DynamicLoadEnable
  • DynamicLoadErrorMode
  • OracleNetServiceName
  • OraclePWD
  • PassThrough
  • RACCallback

2 Built-In Procedures

• ttAgingLRUConfig
• ttAgingScheduleNow
• ttApplicationContext
• ttBackupStatus
• ttBlockInfo
• ttBookmark
• ttCacheAutorefreshStatsGet
• ttCacheAwtMonitorConfig
• ttCacheAWTThresholdGet
• ttCacheAWTThresholdSet
• ttCacheConfig
• ttCacheDbCgStatus
• ttCacheDDLTrackingConfig
• ttCachePolicyGet
• ttCachePolicySet
• ttCachePropagateFlagSet
• ttCacheSqlGet
• ttCacheStart
• ttCacheStop
• ttCacheUidGet
• ttCacheUidPwdSet
• ttCkpt
• ttCkptBlocking
• ttCkptConfig
• ttCkptHistory
• ttCompact
• ttCompactTS
• ttConfiguration
• ttContext
• ttDataStoreStatus
• ttDurableCommit
• ttGridAttach
• ttGridCheckOwner
• ttGridCreate
• ttGridDestroy
• ttGridDetach
• ttGridDetachList
• ttGridInfo
• ttGridNameSet
• ttGridNodeStatus
• ttHostNameGet
• ttHostNameSet
• ttLockLevel
• ttLockWait
• ttLogHolds
• ttMonitorHighWaterReset
• ttOptClearStats
• ttOptEstimateStats
• ttOptGetColStats
• ttOptGetFlag
• ttOptGetMaxCmdFreeListCnt
• ttOptGetOrder
• ttOptSetColIntvlStats
• ttOptSetColStats
• ttOptSetFlag
• ttOptSetMaxCmdFreeListCnt
• ttOptSetMaxPriCmdFreeListCnt
• ttOptSetOrder
• ttOptSetTblStats
• ttOptShowJoinOrder
• ttOptUpdateStats
• ttOptUseIndex
• ttPLSQLMemoryStats
• 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
• ttVersion
• ttWarnOnLowMemory
• ttXactIdGet
• ttXlaBookmarkCreate
• ttXlaBookmarkDelete
• ttXlaSubscribe
• ttXlaUnsubscribe

3 Utilities

• Overview
• Required authentication and authorization for utilities
  • Required user authentication for utilities
  • Required privileges for executing utilities
• ttAdmin
• ttAdoptStores
• ttBackup
• ttBulkCp
• ttCapture
• ttCheck
• ttCWAdmin
• ttDaemonAdmin
• ttDaemonLog
  • ttDaemonLog for Windows
  • ttDaemonLog for UNIX
• ttDestroy
• ttIsql
• ttMigrate
• ttmodinstall
• ttRepAdmin
  • Help and version information
  • Data store information
  • Subscriber data store operations
  • Duplicate a data store
  • Wait for updates to complete
  • Replication status
• ttRestore
• ttSchema
• ttSize
• ttStatus
• ttSyslogCheck (UNIX)
• ttTail
• ttTraceMon
• ttuser
• ttVersion
• ttXactAdmin
• ttXactLog

4 System Limits

• System limits and defaults
• Limits on number of open files
• Path names

5 Clusterware Attributes for TimesTen

• List of attributes
• Required attributes
  • MasterHosts
  • ScriptInstallDir
• Conditionally required attributes
  • AppCheckCmd
  • AppName
  • AppStartCmd
  • AppStopCmd
  • AppType
  • CacheConnect
  • MasterVIP
  • RemoteSubscriberHosts
  • RepBackupDir
  • SubscriberHosts
  • SubscriberVIP
  • VIPInterface
  • VIPNetMask
• Optional attributes
  • AppFailoverDelay
  • AppFailureThreshold
  • AppScriptTimeout
  • AutoRecover
  • ClusterType
  • DatabaseFailoverDelay
  • FailureThreshold
  • MasterStoreAttribute
  • MonInterval
  • RepBackupPeriod
  • RepDDL
  • RepfullbackupCycle
  • ReturnServiceAttribute
  • SubscriberStoreAttribute
  • TimesTenScriptTimeout

Index