ttCkptHistory

Description

Returns information about the last eight checkpoints of any type taken by any agent.

Required privilege

This procedure requires no privilege.

Syntax

ttCkptHistory( )

Parameters

ttCkptHistory has no parameters.

Result set

ttCkptHistory returns the result set:

Column	Type	Description
`startTime`	TT_TIMESTAMP NOT NULL	Time when the checkpoint was begun.
`endTime`	TT_TIMESTAMP	Time when the checkpoint completed.
`type`	TT_CHAR (16) NOT NULL	The type of checkpoint taken. Value is one of: Static - Automatically taken at data store creation and at last disconnect. Blocking - Transaction-consistent checkpoint. Fuzzy - Non-blocking checkpoint. The background checkpointer performs this type if possible. None - For Temporary data stores, which have no checkpoint files.
`status`	TT_CHAR (16) NOT NULL	Result status of the checkpoint operation. Value is one of: In Progress - The checkpoint is currently in progress. Only the most recent result row can have this status. Completed - The checkpoint completed successfully. Failed - The checkpoint failed. Only the most recent result row can have this status. In this case the error column indicates the reason for the failure.
`initiator`	TT_CHAR (16) NOT NULL	The source of the checkpoint request. Value is one of: User - A user-level application. This includes TimesTen utilities such as ttIsql. Checkpointer - The background checkpointer. Subdaemon - The managing subdaemon of the data store. For a shared data store, the final disconnect checkpoint is taken by the subdaemon.
`error`	TT_INTEGER	In the case of a Failed checkpoint, this column indicates the reason for the failure. The value is one of the TimesTen error numbers.
`ckptFileNum`	TT_INTEGER NOT NULL	The data store file number used by the checkpoint. This corresponds to the number in the checkpoint file extension `datastore.ds0` or `datastore.ds1.`
`ckptLFN`	TT_INTEGER	The transaction log file number of the checkpoint log record.
`ckptLFO`	TT_INTEGER	The transaction log file offset of the checkpoint log record.
`blksTotal`	TT_BIGINT	The number of permanent blocks currently allocated in the data store. These blocks are subject to consideration for checkpointing.
`bytesTotal`	TT_BIGINT	The number of bytes occupied by `blksTotal`.
`blksInUse`	TT_BIGINT	Of `blksTotal`, the number of blocks currently in use.
`bytesInUse`	TT_BIGINT	The number of bytes occupied by `blksInUse`.
`blksDirty`	TT_BIGINT	The number of dirty blocks written by this checkpoint.
`bytesDirty`	TT_BIGINT	The number of bytes occupied by `blksDirty`.
`bytesWritten`	TT_BIGINT	The total number of bytes written by this checkpoint.
`Percent_Complete`	TT_INTEGER	If there is an in-progress checkpoint, indicates the percentage of the checkpoint that has been completed. If no checkpoint is in-progress, the value is NULL. The returned value is calculated by comparing the block ID of the last-written block against the data store's PermSize. The value does not necessarily indicate the precise time remaining to complete the checkpoint, although it does give some indication of the remaining time needed to complete the disk write. The field shows only the progress of the writing of dirty blocks and does not include additional bookkeeping at the end of the checkpoint.

Examples

CALL ttCkptHistory;
< 2005-03-15 16:15:36.000000, 1753-01-01 00:00:00.000000, Fuzzy, In Progress, Checkpointer, 0, 0, -1, -1, 0, 0, 0, 0, 0, 0, 0 >

< 2005-03-15 16:14:36.000000, 2005-03-15 16:14:37.000000, Fuzzy, Completed, Checkpointer, 0, 1, 0, 357768, 22, 2097152, 21, 980720, 11, 748960, 822496 >

< 2005-03-15 16:13:36.000000, 2005-03-15 16:13:38.000000, Blocking, Completed, User, 0, 0, 0, 357712, 22, 2097152, 21, 980720, 10, 683800, 1506296 >

< 2005-03-15 16:13:00.000000, 2005-03-15 16:13:01.000000, Static, Completed, Subdaemon, 0, 1, 0, 357616, 22, 2097152, 21, 980720, 10, 683800, 683800 >

< 2005-03-15 16:12:56.000000, 2005-03-15 16:12:57.000000, Fuzzy, Completed, User, 0, 0, 0, 357520, 22, 2097152, 21, 980720, 2, 92736, 
134368 >

< 2005-03-15 16:12:36.000000, 2005-03-15 16:12:38.000000, Fuzzy, Completed, Checkpointer, 0, 1, 0, 357424, 22, 2097152, 21, 980720, 10, 683800, 789728 >

< 2005-03-15 16:11:36.000000, 2005-03-15 16:11:39.000000, Static, Completed, User, 0, 0, 0, 357368, 22, 2097152, 21, 980720, 22, 2097152, 
980864 >

< 2005-03-15 16:11:31.000000, 2005-03-15 16:11:36.000000, Static, Completed, User, 0, 1, 0, 357312, 22, 2097152, 21, 980720, 22, 2097152, 980864 >

CALL ttCkptHistory;

< 2005-03-15 17:03:43.000000, 2005-03-15 17:03:43.000000, Fuzzy, Failed, Checkpointer, 847, 1, -1, -1, 0, 0, 0, 0, 0, 0, 0 >

< 2005-03-15 17:02:43.000000, 2005-03-15 17:02:44.000000, Static, Completed, Subdaemon, 0, 0, 0, 362704, 22, 2097152, 21, 980720, 10, 683800, 683800 >

Notes

Results are ordered by start time, with the most recent first.

A failed row is overwritten by the next checkpoint attempt.