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 GGSCI SEND command, using the LAGSNAPSHOT option.