Processing - Statistics
This page allows you to configure run time parameters that control the statistics that get written to the log file during process and clone commands.
Configuration file parameters are included below with the following_font.
Logging options
Show performance statistics
Parameter: show_perf_stats
When enabled, this option enables the logging of performance statistics at the end of the data extraction phase, after the processing of an audit file finishes (i.e. when audit file switch occurs) and at the end of the run.
Show statistics
Parameter: show_stats
When enabled, this option indicates that record count statistics will be displayed at intervals that you specify using the parameter Record count display intervals. This can be useful for monitoring the progress of lengthy operations.
Show table statistics
Parameter: show_table_stats
When enabled, this option indicates that table statistics will be displayed at the end of the data extraction phase and after an audit file switch. During update processing these statistics also include the average update times.
Audit file statistics
Write statistics into the relational database
Parameter: enable_af_stats
Enabling this option causes a process command to save the end of audit statistics in the AF_STATS Client control table, which was added in Databridge 7.0. This table can hold up to 9999 records, which corresponds to audit files 1 through 9999.
The AF_STATS tables contains the following columns
| Column Name | SQL Server data type | Oracle data type |
|---|---|---|
| data_source | char(30) | char(30) |
| audit_filenum | int | number(10) |
| no_stats_available | bit | number(1) |
| audit_start_time | datetime | date |
| client_start_time | datetime | date |
| client_end_time | datetime | date |
| n_threads, | int | number(10) |
| elapsed | int | number(10) |
| dms_rec_count | int | number(10) |
| sql_op_count | int | number(10) |
| sql_rb_op_count | int | number(10) |
| sql_suppressed | int | number(10) |
| sql_filtered | int | number(10) |
| recs_discarded | int | number(10) |
| recs_in_error | int | number(10) |
| bytes_received | bigint | number(15 ) |
| total_bytes_received | bigint | number(15) |
| bi_bytes_received | bigint | number(15) |
| create_count | int | number(10) |
| delete_count | int | number(10) |
| modify_count | int | number(10) |
| modify_bi_count | int | number(10) |
| modify_ai_count | int | number(10) |
| link_ai_count | int | number(10) |
| state_count | int | number(10) |
| doc_count | int | number(10) |
| commit_count | int | number(10) |
| rollback_count | int | number(10) |
For a description of these columns see the Databridge Client Administrator's Guide.
Record count display intervals
Data extraction (1 minimum to 10000000)
Parameter: statistics_increment
Specifies the frequency at which records counts are displayed during data extractions.
Update processing (1 minimum to 100000)
Parameter: statistics_increment
Specifies the frequency at which records counts are displayed during update processing.