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.