2.136 LAGSTATS
Valid for
Extract, Replicat
Description
Use LAGSTATS
to periodically collect, and optionally report, lag and other performance-related statistics to the report file.
Syntax
LAGSTATS [, INTERVALunit
num_units
] [, THRESHOLDunit
num_units
] [, REPORT]
-
INTERVAL
unit
num_units
-
The interval for which data is collected and optionally reported. For example,
INTERVALSECONDS 30
collects statistics for the last thirty seconds; statistics related to peaks and averages are reset every thirty seconds.unit
can be one of:-
MSECS
(milliseconds) -
CSECS
(centiseconds) -
SECONDS
-
MINUTES
-
HOURS
-
DAYS
-
-
THRESHOLD
unit
num_units
-
Reports percentages of records processed above or below a time lag threshold. For example,
THRESHOLDMSECS 500
reports the percentage of records replicated on the target database within 500 milliseconds of entry into the source database. You can specify up to four thresholds. -
REPORT
-
Statistics are output to the report file whenever a reporting interval is passed. If
REPORT
is not specified, you can retrieve statistics with the GGSCISEND
command, using theLAGSNAPSHOT
option.
Note:
Lagstats will timeout after a period of execution, the higher the frequency the quicker this will happen. This is meant only for diagnostic info, and not intended for continuous use.