stats_method 

This parameter defines the method to be applied to tables that are not specified in the DBSTATC control table for the BRCONNECT update statistics function.

Syntax: stats_method = E|EH|E|EI|EX|C|CH|CI|CX|E=|C=|=H|=I|=X|+H|+I

Default: Internal rules determine the update statistics method, as with stats_sample_size

• E : Estimate
• EH : Estimate with histograms
• EI : Estimate with index validation
• EX : Estimate with histograms and index validation
• C : Compute
• CH : Compute with histograms
• CI : Compute with index validation
• CX : Compute with histograms and index validation
• E= : Force estimate for all tables, including tables in DBSTATC control table (option -f method must be set)
• C= : Force compute for all tables, including tables in DBSTATC control table (option -f method must be set)
• =H : Force creation of histograms for all tables, including tables in DBSTATC control table (option -f method must be set)
• =I : Force index validation for all tables, including tables in DBSTATC control table (option -f method must be set)
• =X : Force creation of histograms and index validation for all tables, including tables in DBSTATC control table (option -f method must be set)
• +H : Force creation of histograms for all tables, including tables in DBSTATC control table in addition in addition to index validation, if defined there (option -f method must be set)
• +I : Force estimate with index validation for all tables, including tables in DBSTATC control table in addition to creating histograms, if defined there (option -f method must be set)