Index

A B C D E F G I K L M N O P Q R S T U V W X

A

access control

connection attributes, 2.1.3

for connections, 2.1.4

impact on XLA, 5.1.6

overview of impact, 2.4

acknowledge records have been read, XLA, 9.2.4

AIX, linking considerations, 1.3.2

allocating memory, utility library environment handle, 8

application context, passing, XLA, 5.4.2

applying database updates, XLA, 9.2.4

array binds, OCI (not supported), 3.2.3.2

AUTOCOMMIT with XA, 6.2.5.1

automatic client failover, 2.6

B

backing up a database, 8

batch SQL operations, 7.2

binding parameters

array binds, OCI (not supported), 3.2.3.2

duplicate parameters in OCI, 3.4.3

duplicate parameters in PL/SQL, 2.2.6.7

duplicate parameters in SQL, 2.2.6.6

floating point data, 2.2.6.8

IN OUT parameters, 2.2.6.5

IN parameters, 2.2.6.3

OUT parameters, 2.2.6.4

parameter type assignments and conversions, 2.2.6.2

performance impact, 7.3

precision, 2.2.6.1

scale, 2.2.6.1

SQL_WCHAR and SQL_WVARCHAR with driver manager, 2.2.6.9

SQLBindParameter, 2.2.6.1

bookmarks--see XLA bookmarks

buildtms command, XA, 6.4.2

built-in procedures

calling TimesTen built-ins, 2.3.1

ttApplicationContext, 5.4.2, 9.2.4

ttXactIdGet, 8

bulk fetch, 2.2.5, 7.6

bulk insert, update, delete (batching), 7.2

C

C language functions--see Utility Library.

cache

cache groups, cache instances affected, OCI, 3.4.2.2

cache groups, cache instances affected, ODBC, 2.3.3.3

get passthrough status, 2.3.3.2

Oracle password, specifying, OCI, 3.4.2.1

Oracle password, specifying, Pro*C/C++, 4.3.2.3

set passthrough level, 2.3.3.1

CALL

PL/SQL procedures and functions, 2.3.1

TimesTen built-in procedures, 2.3.1

character set

conversion, 2.3.4

SQLGetInfo info type, 10.3

SQLGetInfo info type for size, 10.3

client failover

automatic client failover, 2.6

failover callback functions, 2.6.2

closing a transaction log API handle, XLA, 9.2.4

column data, inspecting, XLA, 5.2.6

committing a transaction

ODBC, 2.2.11

XLA, 9.2.4

compiling applications

OCI applications, 3.3.2

Pro*C/C++ applications, 4.3.1

UNIX, 1.3.2

Windows, 1.3.1

concurrency control, 10.2.1

connection attributes

first connection attributes, 2.1.3

general connection attributes, 2.1.3

connections

access control, 2.1.4

attributes, setting programmatically, 2.1.3

connecting to database, 2.1.2

disconnecting from database, 2.1.2

external user (OCI), 3.3.3.4

external user (Pro*C/C++), 4.3.2.4

managing, 2.1

OCI, connecting to database, 3.3.3

Pro*C/C++, connecting to database, 4.3.2

SQLConnect, SQLDriverConnect, SQLAllocConnect, SQLDisconnect, 2.1.1

SQLSetConnectOption and SQLGetConnectOption supported options, 10.2.1

cursors

REF CURSORs, 2.2.7

usage, 2.2.3

D

data structures, XLA

summary, 9.2.4

tt_LSN_t, 9.2.4

tt_XlaLsn_t, 9.2.4

ttXlaColDesc_t, 9.2.4

ttXlaNodeHdr_t, 9.2.4

ttXlaStatus_t, 9.2.4

ttXlaTblDesc_t, 9.2.4

ttXlaTblVerDesc_t, 9.2.4

ttXlaUpdateDesc_t, 9.2.4

ttXlaVersion_t, 9.2.4

data types

conversions and performance, 7.5

ODBC 2.0 versus ODBC 3.0 types, 2.3.6

type mapping/conversion for parameter binding, 2.2.6.2

XLA, 5.1.5

database

applying updates, XLA, 9.2.4

backing up, 8

connection handle, obtaining, XLA, 5.2.1

destroying, 8, 8

RAM usage, 8, 8, 8, 8

replicating, 8

restoring, 8

deadlock error, 5.3.3

deferred prepare

OCI, 3.4.1

ODBC, 2.2.4

demo applications, Quick Start, 1.4

destroying a database, 8, 8

diagnostic framework considerations (OCI), 3.3.5

disaster recovery, 8

distributed transaction processing (XA)

also see XA

overview, 6.1

resource manager, 6.1.1

transaction manager, 6.1.1

transaction recovery, 6.2.2

DML returning, 2.2.8

driver manager

linking with, 1.2.2

performance impact, 7.1

using SQL_WCHAR and SQL_WVARCHAR, 2.2.6.9

XA, support (Windows), 6.3

dropping a table with XLA bookmark, 5.2.8

duplicate parameter binding

in OCI, 3.4.3

Oracle vs. TimesTen modes, 2.2.6.6

DuplicateBindMode general connection attribute, 2.2.6.6

DurableCommit, XA, 6.2.1

E

easy connect

with OCI, 3.3.3.2

with Pro*C/C++, 4.3.2.2

environment variables

OCI, 3.3.1

TimesTen, 1.1

errors

error and warning levels, 2.5.2

error handling, 2.5

OCI error reporting, 3.3.4

Pro*C/C++ error reporting, 4.3.3

recovery, 2.5.3

transaction log API error handling, 5.2.7

utility library errors, count, 8

utility library errors, retrieving, 8

event management (XLA), 5

execution of SQL

executing the statement, 2.2.2.2

SQLExecDirect and SQLExecute, 2.2.2.1

external user, connecting

OCI, 3.3.3.4

Pro*C/C++, 4.3.2.4

F

failover, 2.6

fetching results

bulk fetch, prefetch, 2.2.5, 7.6

example, 2.2.3

first connection attributes, 2.1.3

floating point data, binding, 2.2.6.8

freeing memory, utility library environment handle, 8

G

general connection attributes, 2.1.3

globalization options

OCI, 3.2.2

ODBC, 2.3.4

I

-I flag (compiling), 1.3.1, 1.3.2

IMDB Cache--see cache

IN OUT parameters, 2.2.6.5

IN parameters, 2.2.6.3

include files, TimesTen (#include), 2.2.1

info types supported, SQLGetInfo, 10.3

initializing a database handle, XLA, 9.2.4

isolation level, 10.2.1

K

key not found error, 5.3.3

L

-L flag (compiling), 1.3.2

linking applications

AIX considerations, 1.3.2

OCI applications, 3.3.2

Pro*C/C++ applications, 4.3.1

Solaris considerations, 1.3.2

testing whether directly linked, 1.2.3

UNIX, 1.3.2

Windows, 1.3.1

with driver manager, 1.2.2

with TimesTen driver, 1.2.1

-lodbc flag (compiling), 1.3.2

log record identifier, 5.1.4

M

materialized views with XLA, 5.1.3

N

non-persistent mode, XLA, 5.4.3

NVARCHAR type, 5.2.6.3

O

OCI

architecture in TimesTen, 3.2.1

call support, 3.5

compiling and linking applications, 3.3.2

connecting as external user, 3.3.3.4

connecting to a TimesTen database, 3.3.3

deferred prepare, 3.4.1

demo applications, 3.3.6

descriptor support, 3.5

diagnostic framework considerations, 3.3.5

easy connect, using, 3.3.3.2

environment variables, 3.3.1

error reporting, 3.3.4

external user connection, 3.3.3.4

handle support, 3.5

Oracle password, specifying for cache, 3.4.2.1

overview, 3.1

parameter attribute support, 3.5

restrictions in TimesTen, 3.2.3

signal handling considerations, 3.3.5

SQL data type support, 3.5

statement caching, 3.1, 3.5

TimesTen support, 3.2

tnsnames, using, 3.3.3.1

OCIBindByPos, 3.4.3

ODBC functions, supported in TimesTen, 10.1

Oracle Call Interface support, 3

OUT parameters, 2.2.6.4

P

parallel replication, setup and ODBC support, 2.3.5

parameter binding

duplicate parameters in OCI, 3.4.3

duplicate parameters in PL/SQL, 2.2.6.7

duplicate parameters in SQL, 2.2.6.6

floating point data, 2.2.6.8

IN OUT parameters, 2.2.6.5

IN parameters, 2.2.6.3

OUT parameters, 2.2.6.4

parameter type assignments and conversions, 2.2.6.2

SQL_WCHAR and SQL_WVARCHAR with driver manager, 2.2.6.9

SQLBindParameter, 2.2.6.1

passthrough

get status with TT_STMT_PASSTHROUGH_TYPE ODBC option, 2.3.3.2, 10.2.2

set level with ttOptSetFlag, 2.3.3.1

performance

batch SQL operations, 7.2

binding parameters, 7.3

bulk fetch, prefetch, 7.6

data type conversions, 7.5

SQLGetData, 7.4

persistent mode, XLA, 5.1.1

PL/SQL procedures and functions, calling, 2.3.1

precision, 2.2.6.1

prefetch multiple rows, 2.2.5, 7.6

preparation of SQL

deferred prepare, 2.2.4

preparing the statement, 2.2.3

privileges--see access control

Pro*C/C++ Precompiler

architecture in TimesTen, 3.2.1

building an application, 4.3.1, 4.3.1

commands and clauses, unsupported or restricted (summary), 4.2.7

connecting as external user, 4.3.2.4

connecting to a TimesTen database, 4.3.2

connection restrictions, 4.2.6, 4.2.6

demo applications, 4.3.4

easy connect, using, 4.3.2.2

embedded PL/SQL restrictions, 4.2.4

embedded SQL restrictions, 4.2.2, 4.2.2

error reporting, 4.3.3

external user connection, 4.3.2.4

getting started, 4.3

option setting, 4.4.2

option support, 4.4.1, 4.4.1

Oracle password, specifying for cache, 4.3.2.3

overview, 4.1

semantic checking restrictions, 4.2.3

SQLLIB support, 4.2.2

TimesTen support, 4.2

tnsnames, using, 4.3.2.2

transaction restrictions, 4.2.5

Q

query results, working with cursors, 2.2.3

query threshold (or for any statement), 2.3.2.2

query timeout (or for any statement), 2.3.2.1

Quick Start, demo applications, 1.4

R

RAM usage

ttRamGrace, 8

ttRamLoad, 8

ttRamPolicy, 8

ttRamUnload, 8

record headers, inspecting, XLA, 5.2.5

REF CURSORs, 2.2.7

replicating a database

utility function, 8

XLA, using for replication, 5.3

replication invalid, SQLGetInfo info type, 10.3

resource manager, XA, 6.1.1

restoring a database, 8

RETURNING INTO clause, 2.2.8

rolling back a transaction

utility function, 8

XLA, 9.2.4

rowid

convert ROWID to string, XLA, 9.2.4

using rowids, ROWID type, 2.2.9

S

sb_ErrXlaTupleMismatch error, 5.3.4, 9.2.4, 9.2.4

scale, 2.2.6.1

security--see access control

signal handling considerations (OCI), 3.3.5

Solaris, linking considerations, 1.3.2

SQL_QUERY_TIMEOUT option, 2.3.2.1

SQL_WCHAR and SQL_WVARCHAR with driver manager, 2.2.6.9

SQLAllocConnect, 2.1.1

SQLBindCol, performance, 7.3

SQLBindParameter

arguments, usage, 2.2.6.1

performance, 7.3

SQLColAttributes TimesTen descriptors

TT_COLUMN_INLINE, 10.4

TT_COLUMN_LENGTH_SEMANTICS, 10.4

SQLConnect, 2.1.1

SQLDisconnect, 2.1.1

SQLDriverConnect, 2.1.1, 2.1.3

SQLExecDirect, 2.2.2.1

SQLExecute, 2.2.2.1

SQLGetConnectOption, supported options, 10.2.1

SQLGetData and performance, 7.4

SQLGetInfo TimesTen info types

TT_DATA_STORE_INVALID, 10.3

TT_DATABASE_CHARACTER_SET, 10.3

TT_DATABASE_CHARACTER_SET_SIZE, 10.3

TT_DATABASE_TYPE_MODE, 10.3

TT_PLATFORM_INFO, 10.3

TT_REPLICATION_INVALID, 10.3

SQLGetInfo, supported info types, 10.3

SQLGetStmtOption() ODBC function

TT_STMT_PASSTHROUGH_TYPE option, 2.3.3.2

SQLGetStmtOption, supported options, 10.2.2

SQLLIB support (Pro*C/C++), 4.2.2

SQLParamOptions function, 7.2

SQLRowCount, 2.2.11, 2.3.3.3

SQLSetConnectOption, supported options, 10.2.1

SQLSetStmtOption, supported options, 10.2.2

statement caching, OCI, 3.1, 3.5

statement execution (SQL)

executing the statement, 2.2.2.2

SQLExecDirect and SQLExecute, 2.2.2.1

statement options, SQLSetStmtOption and SQLGetStmtOption, supported options, 10.2.2

statement preparation (SQL)

deferred prepare, 2.2.4

preparing the statement, 2.2.3

synonyms, 2.2.10

T

tables to monitor, XLA, 5.2.3

threshold for SQL statements, 2.3.2.2

timeout

for SQL statements, 2.3.2.1

handing timeout errors, 5.3.3

timesten.h

brief description, 2.2.1

globalization options, 2.3.4

ttFailoverCallback_t structure, 2.6.2

tnsnames

with OCI, 3.3.3.1

with Pro*C/C++, 4.3.2.2

transaction log API

also see XLA

bookmarks, 5.1.4

closing handle, 9.2.4

data structures, 9.2.4

demos, 5.1.7

error handling, 5.2.7

functions, overview, 9.1

functions, summary, 9.2

overview, 5

replication, 5.3

tt_LSN_t data structure, 9.2.4

tt_XlaLsn_t data structure, 9.2.4

ttXlaAcknowledge, 9.2.4

ttXlaApply, 9.2.4

ttXlaClose, 9.2.4

ttXlaColDesc_t data structure, 9.2.4

ttXlaCommit, 9.2.4

ttXlaConfigBuffer, 9.2.4

ttXlaConvertType, 9.2.4

ttXlaDateToODBCCType, 9.2.4

ttXlaDecimalToCString, 9.2.4

ttXlaDeleteBookmark, 9.2.4

ttXlaError, 9.2.4

ttXlaErrorRestart, 9.2.4

ttXlaGenerateSQL, 9.2.4

ttXlaGetColumnInfo, 9.2.4

ttXlaGetLSN, 9.2.4

ttXlaGetTableInfo, 9.2.4

ttXlaGetVersion, 9.2.4

ttXlaLookup, 9.2.4

ttXlaNextUpdate, 9.2.4

ttXlaNextUpdateWait, 9.2.4

ttXlaNodeHdr_t data structure, 9.2.4

ttXlaNumberToBigInt, 9.2.4

ttXlaNumberToCString, 9.2.4

ttXlaNumberToDouble, 9.2.4

ttXlaNumberToInt, 9.2.4

ttXlaNumberToSmallInt, 9.2.4

ttXlaNumberToTinyInt, 9.2.4

ttXlaNumberToUInt, 9.2.4

ttXlaOpenTimesTen, 9.2.4

ttXlaOraDateToODBCTimeStamp, 9.2.4

ttXlaOraTimeStampToODBCTimeStamp, 9.2.4

ttXlaPersistOpen, 9.2.4

ttXlaResetStatus, 9.2.4

ttXlaRollback, 9.2.4

ttXlaRowdToCString, 9.2.4

ttXlaSetLSN, 9.2.4

ttXlaSetVersion, 9.2.4

ttXlaStatus, 9.2.4

ttXlaStatus_t data structure, 9.2.4

ttXlaTableByName, 9.2.4

ttXlaTableCheck, 9.2.4

ttXlaTableStatus, 9.2.4

ttXlaTableVersionVerify, 9.2.4

ttXlaTblDesc_t data structure, 9.2.4

ttXlaTblVerDesc_t data structure, 9.2.4

ttXlaTimeStampToODBCCType, 9.2.4

ttXlaTimeToODBCCType, 9.2.4

ttXlaUpdateDesc_t data structure, 9.2.4

ttXlaVersion_t data structure, 9.2.4

ttXlaVersionColumnInfo, 9.2.4

ttXlaVersionCompare, 9.2.4

ttXlaVersionTableInfo, 9.2.4

transaction manager, XA, 6.1.1

TT_COLUMN_INLINE SQLColAttributes descriptor, 10.4

TT_COLUMN_LENGTH_SEMANTICS SQLColAttributes descriptor, 10.4

TT_DATA_STORE_INVALID SQLGetInfo info type, 10.3

TT_DATABASE_CHARACTER_SET SQLGetInfo info type, 10.3

TT_DATABASE_CHARACTER_SET_SIZE SQLGetInfo info type, 10.3

TT_DATABASE_TYPE_MODE SQLGetInfo info type, 10.3

tt_ErrBadXlaRecord, 5.2.7

tt_ErrCondLockConflict, 5.2.7

tt_ErrDbAllocFailed, 5.2.7

tt_ErrDeadlockVictim, 5.2.7

tt_ErrDeadlockVictim error, 5.3.3

tt_ErrPermSpaceExhausted, 5.2.7

tt_ErrTempSpaceExhausted, 5.2.7

tt_ErrTimeoutVictim, 5.2.7

tt_ErrTimeoutVictim error, 5.3.3

tt_ErrXlaBookmarkUsed, 5.2.7

tt_ErrXlaDedicatedConnection, 5.2.7

tt_ErrXlaLsnBad, 5.2.7

tt_ErrXlaNoLogging, 5.2.7

tt_ErrXlaNoSQL, 5.2.7

tt_ErrXlaParameter, 5.2.7

tt_ErrXlaTableDiff, 5.2.7

tt_ErrXlaTableSystem, 5.2.7

tt_ErrXlaTupleMismatch, 5.2.7

tt_LSN_t data structure, XLA, 9.2.4

TT_NLS_LENGTH_SEMANTICS ODBC option, 2.3.4.2

TT_NLS_NCHAR_CONV_EXCP ODBC option, 2.3.4.3

TT_NLS_SORT ODBC option, 2.3.4.1

TT_PLATFORM_INFO SQLGetInfo info type, 10.3

TT_PREFETCH_CLOSE connection option, 1.2.2

TT_PREFETCH_COUNT, 2.2.5, 7.6

TT_QUERY_THRESHOLD, 2.3.2.2

TT_REPLICATION_INVALID SQLGetInfo info type, 10.3

TT_STMT_PASSTHROUGH_TYPE ODBC option, 10.2.2

tt_xa_context() function, XA, 6.2.4

tt_xa_switch, XA, 6.2.6.2

tt_xla.h #include file, 5.2

tt_XlaLsn_t data structure, XLA, 9.2.4

ttApplicationContext, 5.4.2, 5.4.2, 9.2.4

ttBackup, 8

ttCkpt built-in procedure, 5.2.9

ttCkptBlocking built-in procedure, 5.2.9

ttDestroyDataStore, 8

ttDestroyDataStoreForce, 8

ttDurableCommit, XA, 6.2.1

ttRamGrace, 8

ttRamLoad, 8

ttRamPolicy, 8

ttRamUnload, 8

ttRepDuplicateEx, 8

ttRestore, 8

ttSrcScan utility, 3.2.4, 4.2.8

ttUtilAllocEnv, 8

ttUtilFreeEnv, 8

ttUtilGetError, 8

ttUtilGetErrorCount, 8

ttXactIdGet built-in procedure, 8

ttXactIdRollback, 8

ttxadm43.dll library, XA, 6.3.2

ttXlaAcknowledge, 5.2.4, 9.2.4

ttXlaApply, 5.3.2, 9.2.4

ttXlaBookmarkDelete built-in procedure, 5.2.9

ttXlaClose, 5.2.10, 9.2.4

ttXlaColDesc_t, 5.2.6.1

ttXlaColDesc_t data structure, XLA, 9.2.4

ttXlaCommit, 5.3.3, 5.3.3, 9.2.4

ttXlaConfigBuffer, 5.4.3.3, 9.2.4

ttXlaConvertCharType, 9.2.4

ttXlaDateToODBCCType, 5.2.6.5, 5.2.6.5, 9.2.4

ttXlaDecimalToCString, 5.2.6.5, 5.2.6.5, 9.2.4

ttXlaDeleteBookmark, 5.2.9, 9.2.4

ttXlaError, 5.2.7, 9.2.4

ttXlaErrorRestart, 5.2.7, 9.2.4

ttXlaGenerateSQL, 5.3.5, 9.2.4

ttXlaGetColumnInfo, 5.2.6.1, 9.2.4

ttXlaGetLSN, 5.3.3, 9.2.4

ttXlaGetTableInfo, 5.2.6.1, 9.2.4

ttXlaGetVersion, 5.2.2, 9.2.4

ttXlaHandle_h XLA handle, 5.2.2, 5.4.3.2

ttXlaLookup, 9.2.4

ttXlaNextUpdate, 5.2.4, 9.2.4

ttXlaNextUpdateWait, 5.2.4, 9.2.4

ttXlaNodeHdr_t, 9.2.4

ttXlaNodeHdr_t data structure, XLA, 9.2.4

ttXlaNumberToBigInt, 5.2.6.5, 9.2.4

ttXlaNumberToCString, 5.2.6.5, 9.2.4

ttXlaNumberToDouble, 5.2.6.5, 9.2.4

ttXlaNumberToInt, 5.2.6.5, 9.2.4

ttXlaNumberToSmallInt, 5.2.6.5, 9.2.4

ttXlaNumberToTinyInt, 5.2.6.5, 9.2.4

ttXlaNumberToUInt, 5.2.6.5, 9.2.4

ttXlaOpenTimesTen, 5.4.3.2, 9.2.4

ttXlaOraDateToODBCTimeStamp, 5.2.6.5, 9.2.4

ttXlaOraTimeStampToODBCTimeStamp, 5.2.6.5, 9.2.4

ttXlaPersistOpen, 5.2.2, 9.2.4

ttXlaResetStatus, 9.2.4

ttXlaRollback, 5.3.3, 9.2.4

ttXlaRowdToCString, 9.2.4

ttXlaSetLSN, 5.3.3, 9.2.4

ttXlaSetVersion, 5.2.2, 9.2.4

ttXlaStatus, 5.4.3.4, 9.2.4

ttXlaStatus_t data structure, XLA, 9.2.4

ttXlaTableByName, 5.2.3, 9.2.4

ttXlaTableCheck, 9.2.4

ttXlaTableStatus, 5.2.3, 9.2.4

ttXlaTableVersionVerify, 9.2.4

ttXlaTblDesc_t data structure, XLA, 9.2.4

ttXlaTblVerDesc_t data structure, XLA, 9.2.4

ttXlaTimeStampToODBCCType, 5.2.6.5, 5.2.6.5, 9.2.4

ttXlaTimeToODBCCType, 5.2.6.5, 5.2.6.5, 9.2.4

ttXlaUnsubscribe built-in procedure, 5.2.8

ttXlaUpdateDesc_t

description, usage, 9.2.4

rows of data following in update record, 5.2.6

TT_AGING flag, 9.2.4

TT_CASCDEL flag, 9.2.4

TT_UPDCOLS flag, 9.2.4

TT_UPDCOMMIT flag, 9.2.4

TT_UPDDEFAULT flag, 9.2.4

TT_UPDFIRST flag, 9.2.4

TT_UPDREPL flag, 9.2.4

ttXlaAddColumnTup_t, 9.2.4

ttXlaCreateIndexTup_t, 9.2.4

ttXlaCreateSeqTup_t, 9.2.4

ttXlaCreateSynTup_t, 9.2.4

ttXlaDropColumnTup_t, 9.2.4

ttXlaDropindexTup_t, 9.2.4

ttXlaDropSeqTup_t, 9.2.4

ttXlaDropSynTup_t, 9.2.4

ttXlaDropTableTup_t, 9.2.4

ttXlaDropViewTup_t, 9.2.4

ttXlaSetColumnTup_t, 9.2.4

ttXlaSetStatusTup_t, 9.2.4

ttXlaSetTableTup_t, 9.2.4

ttXlaTruncateTableTup_t, 9.2.4

ttXlaViewDesc_t, 9.2.4

update header, described, 5.2.4

what it describes, 5.2.5

ttXlaVersion_t data structure, XLA, 9.2.4

ttXlaVersionColumnInfo, 9.2.4

ttXlaVersionCompare, 9.2.4

ttXlaVersionTableInfo, 9.2.4

Tuxedo, configuration for XA, 6.4

two-phase commit protocol, XA, 6.1.2

type mapping/conversion for parameter binding, 2.2.6.2

U

UBBCONFIG file, XA, 6.4.3

UNIX, compiling and linking applications, 1.3.2

update conflicts, XLA, 5.3.4

update records, retrieving, XLA, 5.2.4

Utility Library

described, overview, 8

ttBackup, back up database, 8

ttDestroyDataStore, destroy database, 8

ttDestroyDataStoreForce, destroy database, 8

ttRamGrace, RAM usage, 8

ttRamLoad, RAM usage, 8

ttRamPolicy, RAM usage, 8

ttRamUnload, RAM usage, 8

ttRepDuplicateEx, replicate database, 8

ttRestore, restore database, 8

ttUtilAllocEnv, allocate library environment handle, 8

ttUtilFreeEnv, free library environment handle, 8

ttUtilGetError, utility library errors, 8

ttUtilGetErrorCount, utility library error count, 8

ttXactIdRollback, roll back transaction, 8

V

VARBINARY type, 5.2.6.3

VARCHAR type, 5.2.6.3

W

Windows, compiling and linking applications, 1.3.1

X

AUTOCOMMIT with XA, 6.2.5.1

driver manager support (Windows), 6.3

DurableCommit, 6.2.1

resource manager, 6.1.1

transaction manager, 6.1.1

transaction recovery, 6.2.2

tt_xa_context() function, 6.2.4

tt_xa_switch, 6.2.6.2

ttDurableCommit, 6.2.1

Tuxedo configuration, 6.4

two-phase commit, 6.1.2

XID parameter, 6.2.3.3

xa_close() function, 6.2.3.2

xa_open() function, 6.2.3.1

xa_switch_t, 6.2.6.1

XID parameter, XA, 6.2.3.3

XLA

access control, 5.1.6

acknowledge records have been read, 9.2.4

also see transaction log API

also see XLA bookmarks

application context, passing, 5.4.2

applying database updates, 9.2.4

closing a transaction log API handle, XLA, 9.2.4

column data, inspecting, 5.2.6

column information, retrieving, 9.2.4

committing a transaction, 9.2.4

concepts, 5.1

counters, resetting Transaction Log counters, 9.2.4

data structures, 9.2.4

data types, 5.1.5

database connection handle, obtaining, 5.2.1

dropping a table with bookmark, 5.2.8

errors, reading transaction log errors, 9.2.4

errors, resetting the transaction log error stack, 9.2.4

event-handler application, 5.2

functions, overview, 9.1

functions, summary, 9.2

initializing a database handle, 9.2.4

materialized views, using, 5.1.3

non-persistent mode, 5.4.3

persistent mode, 5.1.1

record headers, inspecting, 5.2.5

record, looking up, 9.2.4

replication using XLA, 5.3

rolling back a transaction, 9.2.4

status, retrieving Transaction Log API status, 9.2.4

table compatibility, verifying, 9.2.4

table information, retrieving, 9.2.4, 9.2.4

table status, 9.2.4

tables to monitor, specifying, 5.2.3

terminating XLA application, 5.2.10

update buffer configuration, 9.2.4

update conflicts, 5.3.4

update data, retrieving, 9.2.4

update records, retrieving, 5.2.4

version, retrieving the Transaction Log API version, 9.2.4

version, setting the Transaction Log API version, 9.2.4

XLA handle, initializing, 5.2.2

XLA bookmarks

creating or reusing, 5.1.4.1

deleting, 5.2.9, 9.2.4

determining tables subscribed to, 5.2.3

how they work, 5.1.4.2

location, changing, 5.4.1

overview, 5.1.4

replicated bookmarks, 5.1.4.3

reporting DDL events, 5.2.3

X/Open DTP model, 6.1.1