Limited supportBMC provides limited support for this version of the product. As a result, BMC no longer accepts comments in this space. If you encounter problems with the product version or the space, contact BMC Support.BMC recommends upgrading to the latest version of the product. To see documentation for that version, see DASD MANAGER PLUS for DB2 13.1.

Specifying statistics-related and miscellaneous override exceptions

This topic describes the statistics-related and miscellaneous override exceptions options.

The panel below displays the Statistics-Related and Miscellaneous Override Exceptions options. For descriptions of the exceptions, see the link below. For formulas for the exceptions, see Statistics and miscellaneous related exceptions.

Related topic

Statistics-and-miscellaneous-related-exceptions


Important

If you are using system triggers, override exceptions are not required. When system triggers are defined, the exceptions that you specify on this panel override the system trigger definitions.

Statistics-Related and Miscellaneous Exceptions options

------------------------ Statistics-Related and Misc. Override Exceptions ---
DB2 RTS Specific Statistics/Miscellaneous Exceptions:                  
 Shared Tablespace/Index Exceptions:                                   
  Reorg after stat N        (Y/N - Reorg since last stats)             
  Load after stats N        (Y/N - Load after last stats)              
  Mods since stats          (1-100 % rows modified since stats)        
  Mass del stats   N        (Y/N - Mass delete since last stats)       
  NO RTS stats dat N        (Y/N No statistics data in the RTS tables)
 DB2 RTS Index Exceptions:                                             
  Rebd after stats N        (Y/N - Rebuild after last stats)           
DB2 RTS or BMCSTATS Statistics/Miscellaneous Exceptions:               
 Shared Tablespace/Index Exceptions:                                   
  Catalog Upd Age           (1-32767 Days since last catalog update)   
  CHKP pending . . N        (Y/N - Restrict CHECK pending)             
 Tablespace Exceptions:                                                
  ACHKP pending    N        (Y/N - Restrict Auxiliary CHECK pending)   
 Index Exceptions:                                                     
  RBDP pending . . N        (Y/N - Restrict REBUILD pending)           
BMCSTATS Specific Statistics/Miscellaneous Exceptions:                 
 Shared Tablespace/Index Exceptions:                                   
  NOSTATS  . . . . N        (Y/N BMCSTATS do not exist)                
  BMCSTATS Age . .          (1-32767 Days since last BMCSTATS)         
 Index Exceptions:                                                     
  NONUNIFORM . . .          (0-99% Non Uniformity of Index)            
  ROWS/KEY . . . .          (1-99999999 number of rows per key)


 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*