Show TOC

stats_limit_timeLocate this document in the navigation structure

This parameter defines the processing time limit in minutes for updating statistics with BRCONNECT update statistics.

You can use this parameter to terminate long-running update statistics jobs after a period of time. The processing terminates after statistics have been collected for the current table or index (this is the “soft limit”). However, if you set the option -f limit in BRCONNECT update statistics, processing terminates immediately (this is the “hard limit”).

stats_limit_time = <minutes>
         

Default: 0, that is, no limit