ttXactLog

It is designed to be used by TimesTen customer support to diagnose problems in the log or database.

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.

Usage in TimesTen Scaleout and TimesTen Classic

This utility is supported in both TimesTen Classic and TimesTen Scaleout; however, in TimesTen Scaleout, the utility is limited to diagnosing issues only on single elements.

Syntax

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 [-v verbosity] -logAnalyze 
[-s subscriberName -host hostname]]
[-xid xid] {-connStr connection_string | DSN | dspath}

Options

ttXactLog has the options:

Option	Description
`-b` `blkID`	Restricts log records to those accessing this block, plus any transaction records.
`-connStr` `connection_string`	An ODBC connection string that specifies a database location, driver, and optionally other connection attribute settings.
`DSN`	The ODBC source name of the database for which to display the transaction log.
`dspath`	The fully qualified name of the database. This is not the DSN associated with the connection but the fully qualified database path name associated with the database as specified in the `DataStore=` `parameter` of the database's ODBC definition. For example, for a database consisting of files`/home/payroll/2011.ds0, /home/payroll/2011.ds1` and several transaction log files `/home/payroll/2011.logn`,`dspath` is `/home/payroll/2011`.
`-h` `-help` `-?`	Prints a usage message and exits.
-`headers` `records`	Prints one header for every `records` records. A value of `0` disables headers.
`-host` `hostName`	Specifies the name of the host on which the subscriber resides. Use this option with the `-subscriber` option, if the name of the subscriber is ambiguous.
-`lb`	Connects to the database and prints out the log buffer. Contents of the transaction log files are not printed. Requires `SELECT` privileges or database 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.
`-logAnalyze`	Determines the remaining amount of a database to be replicated for one or all of the subscribers.Use with the `-v` option to print: `1` - A summary for every track (default). `2` - Level `1` plus a track analysis.3 - Level `2` plus an in-depth transaction analysis.Use with `-subscriber` and `-host` to get information for a specific subscriber. Use with `-xid` to look for a specific transaction ID.
`-logdir` `dir`	Specifies the directory where the database'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 4000).
`-r` `recType`	Considers only records of the specified type. This option may be used multiple times to specify a list of desired log record types. `recType` is case-sensitive.
`-s`	Prints summary information. Requires `SELECT` privileges or database object ownership.
`-subscriber` `subscriberName`	Specifies the name of the subscriber. To qualify the name of the subscriber, use `-host` `hostname`.
`-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` (default) - Print log record headers too. `2` - Print log record bodies too, except long data. `3` - Print full log records (see `-m` option).
`-x` `xid`	Specifies the transaction ID.

Examples

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