6.154 STATOPTIONS

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.

Examples

Example 1   

This example resets the statistics from one report to another for thread 0 of a coordinated Replicat .

STATOPTIONS RESETREPORTSTATS THREADS 0
Example 2   

This example includes fetch details for thread 3 of a coordinated Replicat.

STATOPTIONS REPORTFETCH THREADS 3