STATOPTIONS

Valid for

Extract, Replicat

Description

Use STATOPTIONS to report zero counts for insert, update, and delete operations. For Replicat also use STATOPTIONS to report on the time spent creating a file, purging a file, or ending a transaction.

Default

ZEROSUPPRESS, no reporting on Replicat timings

Syntax

STATOPTIONS [ZEROSUPPRESS | NOZEROSUPPRESS}[, PROGSTATS]

ZEROSUPPRESS | NOZEROSUPPRESS

Use to suppress or display zero insert, update, and delete counts.

PROGSTATS

Valid for Replicat only. Reports on the time spent creating a file, purging a file, or ending a transaction.

Examples

Example 1

Sample results for STATOPTIONS NOZERSUPPRESS:

Total # records written to RFUNLDS 349
   \NY015.$DATA06.QABASE.BRANCH    # inserts: 100
                                   # updates: 0
                                   # deletes: 0
   \NY015.$DATA07.LQASRC.HISTORY   # inserts: 249
                                   # updates: 0
                                   # deletes: 0

Example 2

Sample results for STATOPTIONS ZEROSUPPRESS:

Total # records written to RFUNLDS 349
   \NY015.$DATA06.QABASE.BRANCH    # inserts: 100
   \NY015.$DATA07.LQASRC.HISTORY   # inserts: 249

Example 3

Sample results for STATOPTIONS PROGSTATS:

EndTransaction            7  elapsed 00:00:00.079211 PerOp 0
FileCreate                1  elapsed 00:00:00.021796 PerOp 0
FilePurge                 3  elapsed 00:00:00.011630 PerOp 0