Skip Headers
Oracle® TimesTen In-Memory Database Reference
Release 11.2.1

Part Number E13069-03
Go to Documentation Home
Go to Book List
Book List
Go to Table of Contents
Go to Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Go to next page
View PDF



Displays a formatted dump of the contents of a TimesTen transaction log. It is designed to be used by TimesTen customer support to diagnose problems in the log or data store. A loss of data can occur with certain options such as -tr, therefore only use this tool if you have been asked to do so by a TimesTen customer support representative.

Required privilege

This utility requires the ADMIN privilege.


ttXactLog {-h | -help | -?}
ttXactLog {-V | -version}
ttXactLog [-v verbosity] [-m maxChars] [-s] [-t] [-b blkID]
[-l1 lfn.lfo [-l2 lfn.lfo]] [-r recType] [...] [-tr dir]
[-lb] [-headers recs] [-logdir dir]
{-connStr connection_string | DSN | dspath}


ttXactLog has the options:

Option Description
-b blkID Restricts log records to those accessing this block, plus any transaction records.
-connStr connectionString An ODBC connection string containing the name of the data store, the server name and DSN (if necessary) and any relevant connection attributes.
DSN The ODBC source name of the data store for which to display the transaction log.
dspath The fully qualified name of the data store. This is not the DSN associated with the connection but the fully qualified data store path name associated with the data store as specified in the DataStore= parameter of the data store's ODBC definition.

For example, for a data store consisting of files/home/payroll/1997.ds0, /home/payroll/1997.ds1 and several transaction log files /home/payroll/1997.logn,dspath is /home/payroll/1997.




Prints a usage message and exits.
-headers records Prints one header for every records records. A value of 0 disables headers entirely.
-lb Connects to the data store and prints out the log buffer. Contents of the transaction log files are not printed. Requires SELECT privileges or data store object ownership.
lfn.lfo Transaction log file number (lfn) and transaction log file offset (lfo) for a log record.
-l1 Considers this log record only (unless an -l2 argument is present).
-l2 Considers records between -l1 and -l2, inclusive.
-logdir dir Specifies the directory where the data store's transaction log files reside. If -logdir is not specified, ttXactLog uses the directory path portion of the value supplied in dspath.
-m maxChars Maximum number of characters printed for binary items (for -v 3) only (defaults to 1000).
-r recType Considers only records of the specified type. This option may be used more than once to specify a list of desired log record types. recType is case-sensitive.
-s Prints summary information. Requires SELECT privileges or data store object ownership.
-t Only reads transaction log file tail (from start of last checkpoint transaction log file or, if no checkpoint, the most recent transaction log file).
-tr dir Truncates all log records in the directory at the LWN boundary. The original transaction log files are moved to the directory dir.
-V | -version Prints the release number of ttXactLog and exits.
-v verbosity Specifies the verbosity level. One of:

0-print only summary log information (if -s specified).

1-(the default) print log record headers too.

2-print log record bodies too, except long data.

3-print full log records (see -m option).


ttXactLog -v 3 -m 100 /users/pat/TimesTen/Daily/F112697SS


This utility is supported only where the TimesTen Data Manager is installed.