Valid For
Extract and Replicat
Description
Use the STATOPTIONS
parameter to specify the information that is to be included in statistical displays generated by the STATS EXTRACT
or STATS REPLICAT
command. These options also can be enabled as needed as arguments to those commands.
Default
See individual options.
Syntax
STATOPTIONS [, REPORTDETAIL | NOREPORTDETAIL] [, REPORTFETCH | NOREPORTFETCH] [, RESETREPORTSTATS | NORESETREPORTSTATS] [, THREADS (threadID[, threadID][, ...][, thread_range[, thread_range][, ...])]
REPORTDETAIL | NOREPORTDETAIL
Valid for Replicat. Controls the reporting of statistics for operations that were not applied to the target because they were discarded as the result of collision handling.
REPORTDETAIL
Returns statistics for the discarded operations. These operations are reported in the regular STATS REPLICAT
statistics (inserts, updates, and deletes performed) and as discard statistics if STATS REPLICAT
is issued with the DETAIL
option. For example, if 10 records were INSERT
operations and they were all ignored due to duplicate keys, the report would indicate that there were 10 inserts and also 10 discards due to collisions. REPORTDETAIL
is the default.
NOREPORTDETAIL
Turns off the reporting of statistics for discarded operations.
REPORTFETCH | NOREPORTFETCH
Valid for Extract. Controls the reporting of statistics for the amount of row fetching performed by Extract, such as the fetches that are triggered by a FETCHCOLS
clause or fetches that must be performed when not enough information is in the transaction record.
REPORTFETCH
Reports statistics for row fetching. The output is as follows:
row fetch attempts
: The number of times Extract attempted to fetch a column value from the database when it could not obtain the value from the transaction log.
fetch failed
: The number of row fetch attempts
that failed.
row fetch by key: (Valid for Oracle) The number of row fetch attempts that were made by using the primary key.
NOREPORTFETCH
Turns off the reporting of fetch statistics. NOREPORTFETCH
is the default.
RESETREPORTSTATS | NORESETREPORTSTATS
Valid for Extract and Replicat. Controls whether or not statistics generated by the REPORT
parameter are reset when a new report is created. RESETREPORTSTATS
resets the statistics from one report to the other. NORESETREPORTSTATS
continues the statistics from one report to another and is the default. See "REPORT". Report rollover is controlled by the REPORTROLLOVER
parameter. See "REPORTROLLOVER".
THREADS (
threadID
[,
threadID
][, ...][,
thread_range
[,
thread_range
][, ...]
)
Enables the selected STATOPTIONS
options for the specified threads of a coordinated Replicat.
threadID
[,
threadID
][, ...]
Specifies a thread ID or a comma-delimited list of threads in the format of threadID, threadID, threadID
.
[,
thread_range
[,
thread_range
][, ...]
Specifies a range of threads in the form of threadIDlow-threadIDhigh
or a comma-delimted list of ranges in the format of threadIDlow-threadIDhigh
, threadIDlow-threadIDhigh
.
A combination of these formats is permitted, such as threadID, threadID, threadIDlow-threadIDhigh
.