ttXactLog

Description

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.

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}

Options

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`.
`-h` `-help` `-?`	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).

Example

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

Note

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