sysha_lagtime Table

The sysha_lagtime table provides a history of the amount of time that it took to apply a log record on any of the secondary nodes.

The sysha_lagtime table contains a history of the last 20 samplings performed for a particular secondary server.
Table 1. sysha_lagtime table information
Column Type Description
lt_secondary CHAR(128) Name of secondary server
lt_time_last_update INTEGER Time at which log record was last updated
lt_lagtime_1 FLOAT Amount of time required to apply log record for the most recent five-second interval
lt_lagtime_2 FLOAT Amount of time required to apply log record for the second most recent five-second interval
lt_lagtime_3 FLOAT Amount of time required to apply log record for the third most recent five-second interval
lt_lagtime_4 FLOAT Amount of time required to apply log record for the fourth most recent five-second interval
lt_lagtime_5 FLOAT Amount of time required to apply log record for the fifth most recent five-second interval
lt_lagtime_6 FLOAT Amount of time required to apply log record for the sixth most recent five-second interval
lt_lagtime_7 FLOAT Amount of time required to apply log record for the seventh most recent five-second interval
lt_lagtime_8 FLOAT Amount of time required to apply log record for the eighth most recent five-second interval
lt_lagtime_9 FLOAT Amount of time required to apply log record for the ninth most recent five-second interval
lt_lagtime_10 FLOAT Amount of time required to apply log record for the tenth most recent five-second interval
lt_lagtime_11 FLOAT Amount of time required to apply log record for the eleventh most recent five-second interval
lt_lagtime_12 FLOAT Amount of time required to apply log record for the twelfth most recent five-second interval
lt_lagtime_13 FLOAT Amount of time required to apply log record for the thirteenth most recent five-second interval
lt_lagtime_14 FLOAT Amount of time required to apply log record for the fourteenth most recent five-second interval
lt_lagtime_15 FLOAT Amount of time required to apply log record for the fifteenth most recent five-second interval
lt_lagtime_16 FLOAT Amount of time required to apply log record for the sixteenth most recent five-second interval
lt_lagtime_17 FLOAT Amount of time required to apply log record for the seventeenth most recent five-second interval
lt_lagtime_18 FLOAT Amount of time required to apply log record for the eighteenth most recent five-second interval
lt_lagtime_19 FLOAT Amount of time required to apply log record for the nineteenth most recent five-second interval
lt_lagtime_20 FLOAT Amount of time required to apply log record for the twentieth most recent five-second interval

Copyright© 2019 HCL Technologies Limited