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.
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.
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.
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.
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.
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".
Enables the selected
STATOPTIONS options for the specified threads of a coordinated Replicat.
Specifies a thread ID or a comma-delimited list of threads in the format of
threadID, threadID, threadID.
Specifies a range of threads in the form of
threadIDlow-threadIDhigh or a comma-delimted list of ranges in the format of
A combination of these formats is permitted, such as threadID, threadID,