The enable utility lvl 0 scan wait configuration parameter allows you to run alter table ... add | drop partition commands while the server runs isolation level 0 scans.
Default value | 0 |
Range of values | 0 (off), 1(on) |
Status | Dynamic |
Display level | Comprehensive |
Required role | System Administrator |
Configuration group | Application Functionality |
When setting enable utility lvl 0 scan wait to 1, it uses a value of 1 regardless of what you set enable functionality group to.