Changes for alter table add | drop partition

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.

enable utility lvl 0 scan wait

Default value 0
Range of values 0 (off), 1(on)
Status Dynamic
Display level Comprehensive
Required role System Administrator
Configuration group Application Functionality
The default value for enable utility lvl 0 scan wait depends on the value to which enable functionality group is set. If you set enable functionality group to:
  • 0 – the default value for enable utility lvl 0 scan wait is 0
  • 1 – the default value for enable utility lvl 0 scan wait is 1

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.