ttStats

The ttStats utility monitors database metrics (statistics, states, and other information) or takes and compares snapshots of metrics for SQL statements.

The ttStatsConfig built-in procedure configures the collection of metrics for SQL statements. See ttStatsConfig.

This utility can be used in TimesTen Classic and TimesTen Scaleout, but supports different syntax and options. The following sections describe the ttStats utility for:

• ttStats in TimesTen Classic

• ttStats in TimesTen Scaleout

The table Differences between ttStats in TimesTen Classic and TimesTen Scaleout the main differences of how the ttStats utility works in TimesTen Classic and TimesTen Scaleout.

Differences between ttStats in TimesTen Classic and TimesTen Scaleout

Action	TimesTen Classic	TimesTen Scaleout
Create a snapshot	Run the ttStats -snapshot utility to create a snapshot. The -description option for -snapshot is optional	The ttStats daemon creates snapshots based on the pollSec parameter of the ttStatsConfig built-in procedure. If you run ttStats -snapshot -description description in TimesTen Scaleout, you can associate a description to the latest system generated snapshot.
Drop a snapshot	Run the ttStats -drop -begin_snap snapid1 -end_snap snapid2 utility to drop snapshots.	The ttStats daemon automatically drops snapshots based on the retentionDays parameter of the ttStatsConfig built-in procedure. The -drop option of the ttStats utility is not supported in TimesTen Scaleout.
View information about a snapshot	Run the ttStats -report utility without any arguments. The ttStats utility prints the snapshot ID, date, time, capture level, and the description of all snapshots.	Run the ttStats -snapshotInfo utility. The ttStats utility prints the snapshot ID, date, time, and the description of all snapshots.
Generate a report between two snapshots	Run the ttStats -report -snap1 snapid1 -snap2 snapid2 utility. The utility generates a report between two snapshot IDs.	Run the ttStats -report -snap1 snapid1 -snap2 snapid2 utility or the ttStats -report -timestamp1 ts1 -timestamp2 ts2 utility. The utility generates a report between two snapshot IDs or timestamps. You can only generate a text version of a report in TimesTen Scaleout.