2.213 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